Google Cloud SQL import unknown error

2019-07-18 20:59发布

问题:

Instance: db-n1-standard-1 - 200gig - us-central - Second Generation

I have a mysql database on an external production server I'm trying to get into Google Cloud SQL. It's approx 130 gigs (uncompressed).

I dumped the file - moved to google storage - ran the import. I got a notification during the import with a "unknown error". I was watching the storage meter, and it kept increasing so it appeared as though it was still processing.

It apparently picked itself back up and completed successfully.

If I go into the "Operations" tab for the instance, it makes no mention of the "error" notification (that is still available with a "RETRY" option from the notifications area at the top of the page), but instead says "Import from gs://[bucket_name]/mysqld.sql.gz succeeded."

I exported the binlog changes and ran it in the same fashion. Another error in notification but it appeared to continue. Operations tab again has a successful message with no mention of any errors.

This is a large dataset. Not sure how to validate that all is well, or which notification I should trust..

Any suggestions?

回答1:

Sorry :(

There's a known issue with the status timing out in the notification panel and showing an error. You can trust the status in the operation list.