SQL Instance stuck at restart due to lack of available space.

[Mirek Sawicz]

Hi,

My SQL instance on project ipassport-215314 with IP

[Harmit Rishi (Cloud Platform Support)]

You should be able to increase the amount of storage available to your instance at any time without experiencing any downtime.

For clarification purposes, have you tried doing increasing storage size by navigating to Google Cloud Platform console > SQL >  Instance > Edit: Configure machine type and storage >  Storage capacity ? Also, would you be able to provide any sort of error message that you encountered when attempting to do this? This information will help me address your issue appropriately as I wasn't able to find the instance that you are referring to in my investigation.

As a preventative measure, you may turn on automatic storage increase in order to avoid incidents related to lack of storage for your Cloud SQL instance. You may do this by simply checking the box called “Enable automatic storage increases” on the same path mentioned above.

Side-note: you cannot decrease the size of storage and all storage increases are permanent for the life of the instance. You can find more information about this on the FAQ for Cloud SQL here.

[Mirek Sawicz]

Thanks for your reply. I have resolved the issue since then. The problem was that I couldn't increase the storage, because the machine was not running or shut down, it was stuck in the restart and the edit button is disabled then.