We are trying to upgrade our MySQL 1st Generation instances to the 2nd Generation ahead of the forced upgrade next year. We created a clone of the original to test the process out.
-- The database is about 121GB on a D4 instance with all preconditions met.
After the upgrade runs for about 8 hours, it fails with an error
Timed out while running mysql upgrade. Please try increasing instance to a larger tier and retry.
It then lists a number of our tables, indicating "Failed to ALTER TABLE" and that it "Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)".
It concludes with the message
Failed to run mysql_upgrade, please refer to the documentation.
As it suggested, we increased it to a D8 instance, and tried it again, to the same result. We then increased it to a D32 instance, with the same result.
There is nothing we can find in the documentation about upgrading to the 2nd generation or mysql_upgrade to suggest how we should proceed.
Does anyone have any suggestions about how we can go about debugging and correcting this problem so we can upgrade?
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/f91b9ce5-20c4-45c4-b9da-c626520cf5b2%40googlegroups.com.
No comments:
Post a Comment