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

Question

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?

Answer 1

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.