Monday, May 16, 2016

[google-cloud-sql-discuss] Re: Could SQL instance hung at backup

I have the same problem with a Cloud SQL database in us-central (advertopia-mysql-2). The control panel first indicated "Running Backup..." and blocked all other options (import, export, restart, stop, delete). Now, that message is no longer appearing and the database is dead. I am not able to SSH into it to restart (connection eventually times out) and I am completely stuck. My Website is dead. I think somthing went wrong in the datacenter during the backup and the instance still thinks (incorrectly) that the backup is in progress.

I am trying without much luck to force a restart from curl with this command:

curl -X POST -d "" https://www.googleapis.com/sql/v1beta4/projects/Advertopia/instances/advertopia-mysql-2/restart


...but now I'm struggling with authorization...


{

 "error": {

  "errors": [

   {

    "domain": "global",

    "reason": "required",

    "message": "Login Required",

    "locationType": "header",

    "location": "Authorization"

   }

  ],

  "code": 401,

  "message": "Login Required"

 }

}


Any ideas or advice is greatly appreciated.

John K.

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/fce129a5-159b-4cd4-a4ff-3852011d0806%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment