[google-cloud-sql-discuss] Re: SQL Backup running Blocked

If you send me a private message with your project id I will look into the stuck operation. There is no user-facing way to cancel an operation in progress short of deleting the instance.

On Tuesday, February 21, 2017 at 9:02:16 AM UTC-5, Brintel Tecnologia wrote:

Yes, I have full permission. How do I change the status of an SQL operation?

It seems that when there is a running operation, I can not make any changes.

Ex:

"name": "127ad01f-f33a-4b97-9c9e-1079ddef47ae",

"operationType": "BACKUP_VOLUME",

"status": "RUNNING",

"insertTime": "2017-02-11T04:46:59.646Z",

"startTime": "2017-02-11T04:46:59.856Z

Em segunda-feira, 20 de fevereiro de 2017 17:36:33 UTC-3, Adam (Cloud Platform Support) escreveu:

You need to have at least the cloudsql.editor role or project editor permissions in order to perform this operation. Are you able to confirm your level of access in the project?

On Sunday, February 19, 2017 at 4:29:18 PM UTC-5, Brintel Tecnologia wrote:

I'm trying to change the MySQL timezone and I can not. 

MSG:

ERROR: (gcloud.sql.instances.patch) You do not have permission to access instance [bd-brintel-soft-01] (or it may not exist): Operation failed because another operation was already in progress.

COMMAND USED:

gcloud sql instances patch bd-brintel-soft-01 --database-flags default_time_zone=-03:00

LIST OF OPERATIONS OF THE INSTANCE:

gcloud sql operations list --instance=bd-brintel-soft-01, -i bd-brintel-soft-01OPERATION TYPE START END ERROR STATUS4d9862a0-42af-4316-9690-ad8a834118aa DELETE_BACKUP 2017-02-19T20:24:43.750+00:00 2017-02-19T20:24:56.432+00:00 - DONE582679fe-b3c7-4227-9adc-6b3affa58475 RESTART 2017-02-19T18:19:48.617+00:00 2017-02-19T18:20:00.677+00:00 - DONEbd10103e-6d5d-44ee-be96-3eaad8d18079 RESTART 2017-02-19T18:15:59.247+00:00 2017-02-19T18:16:27.811+00:00 - DONE127ad01f-f33a-4b97-9c9e-1079ddef47ae BACKUP_VOLUME 2017-02-11T04:46:59.856+00:00 T - RUNNING

This operation "127ad01f-f33a-4b97-9c9e-1079ddef47ae" Type "BACKUP_VOLUME" It has been running since 11/02/2017.

How to kill or remove this operation?

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/0beb1901-b6fc-4878-9e9e-ea4886b0054a%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.