Monday, November 9, 2020

[google-cloud-sql-discuss] unknown error and invalid argument when importing .bak backup

Hi there

I'm getting an error when trying to import a database from a Linux SQL machine into a Cloud SQL instance

The database name does not already exist.  The compatibility level is 100.  The Cloud SQL is 2017.  The cloud sql service account has permissions on the storage bucket the backup is in.  The backup is full and uncompressed.  

I'm out of ideas as to what is causing this and the error message isn't very helpful.  Does anyone have any suggestions?

Importing data into Cloud SQL instance...failed.
DEBUG: (gcloud.sql.import.bak) [INVALID_ARGUMENT]
Traceback (most recent call last):
  File "/usr/lib/google-cloud-sdk/lib/googlecloudsdk/calliope/cli.py", line 983, in Execute
    resources = calliope_command.Run(cli=self, args=args)
  File "/usr/lib/google-cloud-sdk/lib/googlecloudsdk/calliope/backend.py", line 808, in Run
    resources = command_instance.Run(args)
  File "/usr/lib/google-cloud-sdk/lib/surface/sql/import/bak.py", line 87, in Run
    return import_util.RunBakImportCommand(args, client)
  File "/usr/lib/google-cloud-sdk/lib/googlecloudsdk/command_lib/sql/import_util.py", line 173, in RunBakImportCommand
    return RunImportCommand(args, client, sql_import_context)
  File "/usr/lib/google-cloud-sdk/lib/googlecloudsdk/command_lib/sql/import_util.py", line 111, in RunImportCommand
    sql_client, operation_ref, 'Importing data into Cloud SQL instance')
  File "/usr/lib/google-cloud-sdk/lib/googlecloudsdk/api_lib/sql/operations.py", line 100, in WaitForOperation
    sleep_ms=_BaseOperations._INITIAL_SLEEP_MS)
  File "/usr/lib/google-cloud-sdk/lib/googlecloudsdk/core/util/retry.py", line 229, in RetryOnResult
    if not should_retry(result, state):
  File "/usr/lib/google-cloud-sdk/lib/googlecloudsdk/api_lib/sql/operations.py", line 80, in ShouldRetryFunc
    raise result
googlecloudsdk.api_lib.sql.exceptions.OperationError: [INVALID_ARGUMENT]

--
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/cd472a4b-fb62-4b17-9139-fb2d353c5f1dn%40googlegroups.com.

No comments:

Post a Comment