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

Hi Peter

Yes thanks but this did happen today earlier to the outstage i think. 

CET Time / Berlin

2 Fails:

Started on Dec 14, 2020, 7:46:57 AM

Started on Dec 14, 2020, 8:40:35 AM

1 Success:

Started on Dec 14, 2020, 10:30:30 AM

I did only detect oustage trying to access Youtube at 2020-12-14 at 12.03.50 CET .. but downdetector was reporting it at around 11:30 https://downdetector.com/status/google/

Maybe something was already going on at that time .. idk. 

Anyways will keep an eye on this and thanks a lot for your reply.

Hugo

On Mon, Dec 14, 2020 at 5:31 PM Peter Kok <peter@flowms.ai> wrote:

Hi Hugo, the global Google outage earlier today impacted authentication services - I was not able to access the Cloud Console during this time. Is the problem persisting for you after Google restored services?

Peter

On Mon, Dec 14, 2020 at 12:18 PM Hugo Flambó <hflambo@trifacta.com> wrote:

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.

--
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/CAC%2B%3DFfaSQQVa_JAu2i8sRC3QObOcRfe5FBQZOnrASYpU0ZXqpg%40mail.gmail.com.

--
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/CABa0oKWOWcPKQuDza1NcBricqeHdyoQsAXfrShsJ6UPsUTq0jg%40mail.gmail.com.