Monday, December 14, 2020

[google-cloud-sql-discuss] CloudSQL Backup Restore into different project

Hi there,

Have been using CloudSQL restore backup into different project for a while with great success. 
For reference docs can be found here
https://cloud.google.com/sql/docs/mysql/backup-recovery/restoring

What brings me here is that suddenly since tonight started to see a different behaviour on the results returned by the REST http call via curl what results in a 503 error message instead of SQL Operation json message

e.g:

Excepted:

{
  "kind": "sql#operation",
  "targetLink": "https://www.googleapis.com/sql/v1beta4/projects/projectId/instances/instanceId",
  "status": "PENDING",
  "user": "some-allowed-iam-service-account",
  "insertTime": "2020-12-08T23:02:07.502Z",
  "operationType": "RESTORE_VOLUME",
  "name": "some-identifier",
  "targetId": "targetInstanceId",
  "selfLink": "https://www.googleapis.com/sql/v1beta4/projects/targetProjectId/operations/some-identifier",
  "targetProject": "targetProjectId"
}


NOT Expected (Two different types of 503 results)
{
  "error": {
    "code": 503,
    "message": "The service is currently unavailable.",
    "errors": [
      {
        "message": "The service is currently unavailable.",
        "domain": "global",
        "reason": "backendError"
      }
    ],
    "status": "UNAVAILABLE"
  }
}

or 

{
  "error": {
    "code": 503,
    "message": "Service temporarily unavailable.",
    "errors": [
      {
        "message": "Service temporarily unavailable.",
        "domain": "global",
        "reason": "serverException"
      }
    ]
  }
}

This seems to be happening randomly and independent of SQL Instance.

Please help on debug this issue.

Thanks in advance and regards.
Hugo




--
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/60a91c10-dc9c-4bd3-91b2-aaeaae0dffe5n%40googlegroups.com.

No comments:

Post a Comment