How to check the database operation that is running since a long time in cloud spanner database?

0 votes
I have created a cloud spanner database along with a VM instance that cloud spanner provides. I want to check on an operation that is running since long. What's the way to know this?
Nov 14 in GCP by anonymous
• 6,670 points
24 views

1 answer to this question.

0 votes

To get the status of the long-running database operation:

  1. Click projects.instances.databases.operations.get.

  2. For name, enter the long-running database operation name as shown in the response to projects.instances.databases.create or projects.instances.databases.updateDdl. For example:

    projects/[PROJECT_ID]/instances/test-instance/databases/example-db/operations/_auto_1492721321097206

    (Use the operation name you received instead of this value.) You can also retrieve the database operation name by listing long-running database operations.

  3. Click Execute and view the response. When an operation is done, the done field will be set to true.

To poll a long-running database operation, repeatedly invoke the projects.instances.databases.operations.get method until the operation is done. Use a backoff between each poll request. For example, poll every 10 seconds.

answered Nov 14 by Sirajul
• 40,990 points
Cancel a long running database operation.

Related Questions In GCP

0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

Cancel a long running database operation.

Use projects.instances.databases.operations.cancel to cancel a long-running instance operation. Click projects.instances.databases.operations.cancel. For name, enter ...READ MORE

answered Nov 14 in GCP by anonymous
• 40,990 points
27 views
0 votes
1 answer

How to delete a long running instance operation?

Use projects.instances.operations.delete to delete a long-running instance operation. Click projects.instances.operations.delete. For name, enter ...READ MORE

answered Nov 14 in GCP by Sirajul
• 40,990 points
24 views
0 votes
1 answer

Cloud spanner instance auto-scaling

As the instance's workload changes, Cloud Spanner ...READ MORE

answered Nov 14 in GCP by Sirajul
• 40,990 points
33 views