Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Cannot Upgrade Google Cloud SQL to Second Generation

I cannot upgrade the First generation Google Cloud Instance to Second generation instance using MySQL Second Generation upgrade wizard in console. During the check configuration screen, I get Tables that use the MEMORY storage engine found error due to which I cannot proceed further as shown in screenshot Error in Console According to documentation at Upgrading a First Generation instance to Second Generation, I have verified using the query mentioned in documentation.

Documentation

SELECT table_schema, table_name, table_type
   FROM information_schema.tables
   WHERE engine = 'MEMORY' AND
   table_schema NOT IN
   ('mysql','information_schema','performance_schema');

but found no tables using a MEMORY storage engine as shown below.

enter image description here

like image 647
skyrideraj Avatar asked May 25 '26 13:05

skyrideraj


1 Answers

I managed to resolve the error and proceeded with upgrade. I had a to remove a table from the performance_schema database that did not use the PERFORMANCE_SCHEMA storage engine before starting the upgrade process. Seems Google Cloud console threw in an irrelevant error!

like image 153
skyrideraj Avatar answered May 27 '26 11:05

skyrideraj



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!