[google-cloud-sql-discuss] Re: Instance operations stuck in pending

I noticed my instance and failover came back as running, but they aren't operational. Any command fails due to ongoing operations still even though it's showing memory and storage usage again. The primary is unable to show users/databases from the gcp portal. Restarts/failovers don't work and I can't change locations on it, delete the replica, or even connect to mysql via the google shell due to the ongoing operations error still.

I see how to list operations, but there's no way to cancel or kill them.

On Friday, June 28, 2019 at 7:02:26 PM UTC-5, Geoffrey Arnold wrote:

Hello,

Around 6:37PM CT today our primary (us-central-b) and and failover (us-central-a) databases are stuck with pending operations. The primary is lists the following operations:

Delete backup Operation is pending

Backup Operation is pending

Jun 28, 2019, 6:29:37 PM Failover Failover operation in progress

The failover lists the following operations:

Recreate replica Operation is pending

I am unable to connect either the primary or failover databases.

Any help would be greatly appreciated,

Geoff. 

 

--
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/b4b2bd96-0470-47ce-acb7-1b091cb5389d%40googlegroups.com.