Bug #93476 InnoDB start failure after upgrade to MySQL 8.0.11
Submitted: 4 Dec 2018 21:53 Modified: 13 Dec 2018 3:16
Reporter: KORBULY Francois Email Updates:
Status: Not a Bug Impact on me:
Category:MySQL Server: InnoDB storage engine Severity:S3 (Non-critical)
Version:5.7.19 / 8.0.11 OS:CentOS (6 (x86_64))
Assigned to: Bogdan Kecman CPU Architecture:Any
Tags: upgrade;data dictionnary;innodb_dynamic_metadata;

[4 Dec 2018 21:53] KORBULY Francois

On our DEV environnment, we performed an upgrade from Mysql 5.7.19 to 8.0.11.
We installed the packages using 'yum', made all necessary checks provided in the 'upgrade' documentation.

But, we can't start the service, here is the error we have (using --log_error_verbosity=3) on the 'Data dictionnary initialization' (see the error_log_file.txt).

Attaching also our 'my.cnf' file.

Any way we can fix this one ?

Thanks for you help,

How to repeat:
- Stop Mysql 5.7.19 service
- Upgrade Mysql Server to 8.0.11 using 'yum'
- Restart the service
[4 Dec 2018 21:55] KORBULY Francois
Error log of mysqld daemon

Attachment: error_log_file.txt (text/plain), 7.39 KiB.

[4 Dec 2018 21:55] KORBULY Francois
Configuration file

Attachment: my.cnf (application/octet-stream, text), 2.02 KiB.

[13 Dec 2018 3:16] Bogdan Kecman

You had to fist upgrade to the latest 5.7 before you were upgrading to latest 8.0 as documented https://dev.mysql.com/doc/refman/8.0/en/upgrade-paths.html