Bug #110991 After server upgrade it does not start
Submitted: 11 May 2023 10:23 Modified: 11 May 2023 12:41
Reporter: Tauras Paliulis Email Updates:
Status: Can't repeat Impact on me:
Category:MySQL Server Severity:S2 (Serious)
Version:8.0.33 OS:Ubuntu (20.04.1)
Assigned to: CPU Architecture:x86

[11 May 2023 10:23] Tauras Paliulis
Ubuntu upgrade also upgraded Mysql from 5.7. From upgrade logs:
mysql-server:amd64 < 5.7.41-0ubuntu0.18.04.1 -> 8.0.32-0ubuntu0.20.04.2

After that when starting mysql getting errors. Excerpt from error.log

2023-05-11T10:00:42.914483Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.33-0ubuntu0.20.04.1) starting as process 531416
2023-05-11T10:00:42.974585Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-05-11T10:00:44.445266Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-05-11T10:00:45.463819Z 1 [ERROR] [MY-013379] [Server] Server upgrade started with version 80033, but server upgrade of version 50700 is still pending.
2023-05-11T10:00:45.464061Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2023-05-11T10:00:45.464088Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-05-11T10:00:46.113285Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.33-0ubuntu0.20.04.1)  (Ubuntu).

How to repeat:
have no clue

Suggested fix:
sequence of actions to start the server properly
[11 May 2023 12:41] MySQL Verification Team
Hi Mr. Paliulis,

Thank you for your bug report.

However, we can not repeat it. We have done many upgrades from 5.7 to 8.0 without any problems.

We can easily conclude that it seems that you have started two upgrades in parallel. This can not work and will not work.

It is possible that you have corrupted your datadir, so you might revert to a completely new datadir and restore your data from the backup.

Please follow strictly our instructions in the Reference Manual.

Can't repeat.