title: Google cloud sql instance unknown error
body: <p>I have an Cloud-SQL instance restarted by itself for no reason.  In any case, the restart failed with the following error:</p>
  
  <p><code>
  2018-02-08 16:33:22.552 CST
  + exec /usr/sbin/mysqld --defaults-file=/mysql/my.cnf
  Expand all | Collapse all {
   insertId:  "s=1eb5f90cdd6e4332b0bfd1260e067581;i=21ee;b=4ff35c4064f348848019b0498c04fcfd;m=50ef121;t=564baffd724ea;x=3528d562989af59-0@b1a"<br>
   logName:  "projects/xxxxxxx/logs/cloudsql.googleapis.com%2Fmysql.err"<br>
   receiveTimestamp:  "2018-02-08T22:33:31.058969560Z"<br>
   resource: {
    labels: {
     database_id:  "xxxxxx:yyyyyyyy"<br>
     project_id:  "yyyyyyy"<br>
     region:  "us-central"<br>
    }
    type:  "cloudsql_database"<br>
   }
   severity:  "ERROR"<br>
   textPayload:  "+ exec /usr/sbin/mysqld --defaults-file=/mysql/my.cnf"<br>
   timestamp:  "2018-02-08T22:33:22.552734Z"<br>
  }
  </code></p>
  
  <p>Looking at Cloud-SQL instance console, all action links were greyed out and my instance is showing a yellow warning sign. The operation and logs on the console displayed:</p>
  
  <p><code>
  Feb 8, 2018, 3:50:48 PM Restart  An unknown error occurred.
  </code></p>
  
  <p>Click on users and database tab, I've got this:</p>
  
  <p><code>
  Users/Database cannot be loaded from MySQL at this time. Make sure your instance is runnable.
  </code></p>
  
  <p>I am unable to restart the instance via console or gcloud cl:</p>
  
  <p><code>
  $ gcloud sql instances restart xxxxxxxx
  </code>
  <code>
  The instance will shut down and start up again immediately if its
  activation policy is "always." If "on demand," the instance will start
   up again when a new connection request is made.
  Do you want to continue (Y/n)?  y
  ERROR: (gcloud.sql.instances.restart) HTTPError 409: The instance or operation is not in an appropriate state to handle the request.
  </code></p>
  
  <p>Query using MySQL workbench via ip is still working but my Firebase Cloud Function was not able to access the MySQL DB via socket path. </p>
  
  <p>Not sure what to do to get back my instance, shall I just create another instance and try to restore?</p>