Cannot connect to Google Cloud SQL (MySQL) - No settings changed

[Francis Austria]

Hi,

Has anyone already experienced same issue as ours?

No setting has been changed but suddenly everything in the Google Cloud SQL was not working.


It says the instance is "runnable".




Cannot retrieve and create new User Accounts


Also with the databases


No detailed info about the errors are shown in the logs.



Anyone who experienced the same issue and solved it?

Hoping for a swift response. Thanks!

[Dinesh (Google Platform Support)]

Hello Francis,

Currently we do not have any reported issue for the cloud SQL and are able to extract user and database information from SQL instance.

Can you please execute gcloud sql instance describe command [1] and verify instance state?

Instance could be in following six state:-

RUNNABLE: The instance is running, or is ready to run when accessed.

SUSPENDED: The instance is not available, for example due to problems with billing.

PENDING_CREATE: The instance is being created.

MAINTENANCE: The instance is down for maintenance.

FAILED: The instance creation failed.

UNKNOWN_STATE: The state of the instance is unknown.

You can send me o/p of this command in a private message.

Meanwhile, you can restart your instance to see if this behavior changed. 

[1]: https://cloud.google.com/sdk/gcloud/reference/sql/instances/describe

[Francis Austria]

Hi Dinesh,

I reported this to the Support team and it is already fixed now.


On Thursday, November 16, 2017 at 4:41:17 AM UTC+8, Dinesh (Google Platform Support) wrote:

Hello Francis,

Current we do not have any reported issue for cloud SQL and are able to extract user and database informations from SQL instance.

[Allan Porras]

I have the same issue. From localhost using Client Proxy works fine.  Any ideas?

[Dinesh (Google Platform Support)]

Hi Allan,

I will need some sensitive information from your side. Please provide me following detail in a private message.

1. Please let me know the output of gcloud sql instance describe command as mentioned in my initial post.

2. Please give me your project number and instance name that is having issue.

3. When you observed this issue first time? Did you install some application that need frequent DB access?