After update to 7.3.2, mySQL does not come up

[necrevistonnezr]

After the update to 7.3.2, mySQL does not come up

MySQL on the host runs fine.

MySQL (addon) displays the following error:

2022-10-17T15:47:50.522815Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
2022-10-17T15:47:50.522854Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.30-0ubuntu0.20.04.2) starting as process 11
2022-10-17T15:47:50.545100Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-10-17T15:47:50.846784Z 1 [ERROR] [MY-012526] [InnoDB] Upgrade is not supported after a crash or shutdown with innodb_fast_shutdown = 2. This redo log was created with MySQL 8.0.28, and it appears logically non empty. Please follow the instructions at http://dev.mysql.com/doc/refman/8.0/en/upgrading.html
2022-10-17T15:47:50.846868Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2022-10-17T15:47:51.175047Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2022-10-17T15:47:51.175383Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2022-10-17T15:47:51.175427Z 0 [ERROR] [MY-010119] [Server] Aborting
2022-10-17T15:47:51.176673Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.30-0ubuntu0.20.04.2)  (Ubuntu).

What to do?

[robi]

@necrevistonnezr See the bottom of https://dev.mysql.com/doc/refman/8.0/en/upgrade-troubleshooting.html

[necrevistonnezr]

@robi thanks, I followed the instructions at https://docs.cloudron.io/troubleshooting/#mysql-addon and it worked…

[robi]

@necrevistonnezr cool, so a clean shutdown and start resolved it?

[necrevistonnezr]

@robi No, I was referring to stopping mysql, moving the folder, restarting mysql and then restoring app backups...

In case of disk corruption errors, it's best to just start afresh if you have uptodate backups.

docker stop mysql
mv /home/yellowtent/platformdata/mysql /home/yellowtent/platformdata/mysql-copy
mkdir /home/yellowtent/platformdata/mysql
docker restart mysql

Then, just restore the apps one by one from the latest backup.

@girish You might want to check if

 innodb_fast_shutdown=2

is a good setting (see https://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html)

[girish]

@necrevistonnezr I wasn't aware of the setting, good to know.