[google-cloud-sql-discuss] Re: Hanging Cloud SQL 2nd generation instance

Hi Samuel

My understanding is that you already tried to increase the disk space [0][1][2][3] in the instance and you do not have access at all.

Please sent me via a private message your Project ID and your instance name, as well as any error you are receiving.

[0] https://cloud.google.com/sql/docs/mysql/edit-instance

[1] https://cloud.google.com/sql/faq#storage_limits

[2] https://cloud.google.com/sql/docs/mysql/diagnose-issues#disk-space

[3] https://cloud.google.com/sdk/gcloud/reference/sql/instances/patch

On Thursday, May 25, 2017 at 10:19:21 PM UTC-4, Samuel Woo wrote:

Hi I am experiencing the same issue with a Cloud SQL instance becoming stuck after the disk space is filled when attempting to perform an import. Who can I contact to get the instance back into a state that allows me to fix the instance?

On Wednesday, January 20, 2016 at 7:20:43 AM UTC-8, Herman Tai wrote:

Please email your instance name to clou...@google.com with a reference to your post here.

On Wednesday, January 20, 2016 at 6:49:28 AM UTC-8, Lennert Kuijpers wrote:

Hi,

I created a 2nd generation SQL instance with 200gb disk space and tried to import a 120gb dump file. After several hours the import seems to be hanging with the disk 93% full. 

In the logging I can see the message [Warning] Disk is full writing '/mysql/binlog/mysql-bin.000003' (Errcode: 28 - No space left on device). Waiting for someone to free space...

So I tried to drop the database or some tables but this all fails.

I already created a new 2nd generation SQL instance and successfully imported the dump file but I am stuck with the first one. I cannot delete it because the import is already running more then 24 hours and you cannot do any operations while the import is running.

Any tips on how can I delete this SQL instance?

thanks,

Lennert  

--
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/16305943-5466-4b94-a0af-0d769b3a84b1%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.