Cancel a long running database operation

Question

I have used a cloud spanner database in my project and have identified certain operations that are running since long. How do I cancel such database operations?

Answer 1

Use projects.instances.databases.operations.cancel to cancel a long-running instance operation.

1. Click projects.instances.databases.operations.cancel.

2. For name, enter the long-running database operation name as shown in the long-running database operation response. 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.

This should do!