Monday, November 20, 2017

[google-cloud-sql-discuss] Re: SQL stuck "operation failed because another operation was already in progress"

I can see you have raised a PIT bug for this same issue and engineering team is already working on that case. 
I'll close this issue as a duplicate case. You can follow and update the other case for further assistance.

On Monday, November 20, 2017 at 9:05:11 AM UTC-5, WebByte Media wrote:
no, you cant. Every command throws back. ERROR: (gcloud.sql.instances.patch) HTTPError 403: Operation failed because another operation was already in progress.. I submitted a bug report and your back-end team is supposed to be reviewing, over a week still no solution. This is horrible service. 

On Monday, November 13, 2017 at 2:21:37 PM UTC-5, Dinesh (Google Platform Support) wrote:

Hello


As I understand here, you are trying to stop master DB instance? Please note that you must delete the master DB's replicas first in order to stop master DB.


Moreover, If you are trying to add a user, create database etc. please note that such operations are not allowed from a read replica (failover instance). You can perform such operations from master DB. Though you can add authorisation IP from replica instance independently.


Please send me the text of message along with screenshots of failed operations as I believe you are trying to perform such operations from cloud console?


You can add a user, add authorisation IP from gcloud command as well.


On Monday, November 13, 2017 at 8:44:26 AM UTC-5, WebByte Media wrote:
Can't add users, DB, authorization IPs or delete backup instance to stop primary...not too sure what to do here. 

--
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/ff908286-3804-407b-9cfa-984208964828%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment