Unable to connect to cloud sql instance. Cloud Console errors when clicking on Users-Databases. Need access to instance.

[Robert Lister]

Hi All, I have a cloud sql instance that is no longer responsive. Unable to connect, restart, backup. I have stopped/started the instance, upgraded the instance, restarted the instance. Even connecting from Cloud Shell does not work.

Primarily I need to connect to this instance to get a dump of the the table structures, functions, procedures and triggers. From there I can create a new instance from scratch. What can I do?

Client Connection Error

There was a massive unknown spike in storage and it is constantly increasing. 

Read write operations

 

Users not accessible.

All instances are Runnable - See below

Configuration

[Aref Amiri (Cloud Platform Support)]

Hi Robert,

You can certainly create a SQL dump file which can then be used to import your data into Cloud SQL, however, it is important to keep in mind that the instructions provided exclude all triggers,stored procedures, views, and functions from the export.

In your case, I would suggest to create a private issue on Google Issue Tracker and provide us with the Project Id and the Instance Id so that we can investigate the issue further.

[Robert Lister]

Hi All, After over a week of not being able to connect to the instance something happened at around 9 am (perhaps through one of the Google staff that I raised the ticket/private issue with) I'm not exactly sure but whoever made the change Thank You it is now working. 

On Tuesday, January 22, 2019 at 1:58:27 AM UTC+11, Robert Lister wrote:

Hi All, I have a cloud sql instance that is no longer responsive. Unable to connect, restart, backup. I have stopped/started the instance, upgraded the instance, restarted the instance. Even connecting from Cloud Shell does not work.

Primarily I need to connect to this instance to get a dump of the the table structures, functions, procedures and triggers. From there I can create a new instance from scratch. What can I do?