Re: [google-cloud-sql-discuss] Cannot connect to Cloud SQL 2nd generation - from web interface and via Cloud SQL Proxy

Hi Jumpei,

There was sharp growth in storage starting a few days ago when the general query log was enabled.

This caused your instance to quickly run out of space. 

If you increase your storage size a little bit, you should be able to connect and export your data.

Be sure to disable the general query log to stop the storage growth.

On Sat, Jun 11, 2016 at 12:55 PM 小川純平 <ogawa@growaspeople.org> wrote:

Hi,

I think Google Cloud SQL 2nd generation is inaccessible now.

I tried to connect from GCE instances to Cloud SQL via Cloud SQL Proxy, but I cannot connect.
This happened when I restarted Cloud SQL instance (with changing instance spec) at about June 11, 15:00 UTC (June 12, 00:00 JST).

I updated my.cnf variables and machine specs for several times, and just restarted instance for several times.
It takes so long (5 - 10 mins) to complete restart. I viewed Stackdriver logging page [ https://console.cloud.google.com/logs ] and saw ton of warnings.
In the operations tab [ https://console.cloud.google.com/sql/instances/INSTANCE_NAME/operations ], there are several "An unknown error occurred" logs on restart and update.


Next, I gave up to continue with Google Cloud SQL and get back to our old server instance which is hosted by another cloud vendor.
To keep data, I tried to export current data with export button in the overview page of Cloud SQL instance [ https://console.cloud.google.com/sql/instances/INSTANCE_NAME/overview ]

I saved it in SQL format, but the file is 0 byte and empty.

In the operation page, I found following error message:
mysqldump: Got error: 2002: Can't connect to local MySQL server through socket '/mysql/mysql.sock' (111) when trying to connect


Thanks in advance.

Jumpei

--
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/b3082e79-daaa-4c9b-bfc1-e17e04095db3%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
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/CABDU3p1MzfRFjLxWqQgn60pz1Dx0C3voA8CnZkDeC5U2A2HfTg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.