Mysql instance in google cloud console (Appengine) crashed

Question

I have a sql database on google cloud console it stopped working suddenly. I am not able to start, stop or restart my instance. I could not restore backup from the instance. My crash log says

insertId: "s=xxxxxx"  
 logName: "projects/xxxxxxxx/logs/cloudsql.googleapis.com%2Fmysql.err"  
 receiveTimestamp: "2019-11-19T09:45:40.414048508Z"  
 resource: {
  labels: {
   database_id: "xxxxxxxxxx"    
   project_id: "xxxxx"    
   region: "xxxxxx"    
  }
  type: "cloudsql_database"   
 }
 severity: "ERROR"  
 textPayload: "InnoDB: Progress in percent: 0 1 2 3 4 5 6 7 8 9 10 11 2019-11-19T09:45:39.080501Z 0 [ERROR] InnoDB: Trying to access page number 11 in space 5412, space name billing/with_state_1, which is outside the tablespace bounds. Byte offset 0, len 16384, i/o type read. If you get this error at mysqld startup, please check that your my.cnf matches the ibdata files that you have in the MySQL server."  
 timestamp: "2019-11-19T09:45:39.080618Z"

How could I get the mysql dump file or how to restart the instance. Please give me solution. Thanks in advance.

Chris32 Chris32 · Accepted Answer · 2019-11-20T08:35:09

In order to have proper help with this kind of issue please open an issue with the Google Cloud Platform team with the title "Cloud SQL instance hangs and won't restart". After creating the issue in the platform a Google Engineer will help you.

Add in the body of the issue your project Id and the name of the Cloud SQL instance.

Mysql instance in google cloud console (Appengine) crashed

1 Answers