Google Cloud SQL Instance does not start

Question

I've stopped my Google Cloud SQL 2nd generation instance on 02 Jan this year.

Today I'm trying to start it again but just receives an error:

"Could not complete the operation"

This is the only info in the logs:

{ protoPayload: {…}
insertId: "54775E151DAA9.A2E1542.960A7970"
resource: {…}
timestamp: "2017-02-01T10:55:00.523Z"
severity: "ERROR"
logName: "projects/hti-info-center/logs/cloudaudit.googleapis.com%2Factivity"
}

All functions including restoring of backups are disabled as the instance is stopped.

Is there anywhere I can get more information about the instance's current state in order to try and resolve this issue, without having to sign up for a Google Support package?

We have exactly the same error and question. W Kok, have you managed to resolve the issue without having to sign up for a support package? — s3ncha
No not at all. I'm still at a loss. I will definitely post here if it gets resolved, hoping you'd do the same? — W Kok
i have the same problem. so i'm paying for an instance that i can't start, and i can't retrieve a backup to use on another instance. — Ian Weatherhogg

Ian Weatherhogg Ian Weatherhogg · Accepted Answer · 2017-02-16T07:44:40

This was suggested by Google support, and worked for me:

try to start your service via gcloud by running the following command:

gcloud sql instances patch [INSTANCE_NAME] --activation-policy=[ACTIVATION_POLICY]

and set the activation policy to "ALWAYS" or "ON_DEMAND".

Google Cloud SQL Instance does not start

2 Answers