Db instance takes too long to restart

[Jeffrey Wong]

The db instance is restarted. As shown in the screenshot, it mentioned a few mins but it had been hours. 

May I know how to get about fixing this? 

Thanks. 

[sami...@google.com]

Are you using the 1st Generation or the 2nd Generation Cloud SQL? The Activation Policy of a 2nd Generation Cloud SQL instance is normally set to “ALWAYS” upon being started from a stopped state or upon creation. Alternatively, you can make sure of this by calling [gcloud sql instances patch [INSTANCE_NAME] --activation-policy ALWAYS] command (more information can be found on this link gcloud sql instances patch). Usually instances with an activation policy of ‘Always’ restart are ready to accept new connections right away but on the other hand Instances with an activation policy of ‘On Demand’ remain shut down until there is a new connection request for instance, at which time the instance is activated and accepted the request. You can find more details regarding this on Restarting an Instance Guide.

Please note that Google Group is intended for Google Cloud general product discussion purposes only, not for troubleshooting issues. If you think this issue could be caused by a possible bug you can report it in Public Issue Tracker. Issue Tracker is a tool used internally at Google to track bugs and feature requests during product development. So this way we would be able to get a deeper understanding of your issue.