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, 2019 in GCP by anonymous
• 19,610 points
770 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, 2019 by Sirajul
• 59,230 points
Cancel a long running database operation.

Related Questions In GCP

0 votes
1 answer

Delete a cloud storage object that is in the locked, retention-enabled bucket.

No, you can't delete a cloud storage object ...READ MORE

answered Nov 18, 2019 in GCP by Sirajul
• 59,230 points

edited Sep 21, 2021 by Sarfaraz 2,933 views
0 votes
1 answer
0 votes
1 answer

How to check the status of logging in Google Cloud Storage?

Using gsutil, you can check logging by ...READ MORE

answered Nov 22, 2019 in GCP by Sirajul
• 59,230 points
1,234 views
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, 2019 in GCP by anonymous
• 59,230 points
798 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, 2019 in GCP by Sirajul
• 59,230 points
505 views
0 votes
1 answer

Cloud spanner instance auto-scaling

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

answered Nov 14, 2019 in GCP by Sirajul
• 59,230 points
1,622 views
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP