SQL Backup running Blocked

62 views
Skip to first unread message

Brintel Tecnologia

unread,
Feb 19, 2017, 4:29:18 PM2/19/17
to Google Cloud SQL discuss
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?

Adam (Cloud Platform Support)

unread,
Feb 20, 2017, 3:36:33 PM2/20/17
to Google Cloud SQL discuss
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?

Brintel Tecnologia

unread,
Feb 21, 2017, 9:02:16 AM2/21/17
to Google Cloud SQL discuss
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

Adam (Cloud Platform Support)

unread,
Feb 24, 2017, 1:06:07 PM2/24/17
to Google Cloud SQL discuss
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.
Reply all
Reply to author
Forward
0 new messages