Monday, November 13, 2017

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

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/24619037-c9dc-40bb-b8eb-69672796c14f%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment