Bug #93147 Upgrade to 8.0.13 from 8.0.11 fails

• Submitted: 9 Nov 2018 21:54
• Modified: 10 May 2019 5:08
• Reporter: Vlad Safronov
• Status: Duplicate
• Category: MySQL Server: Data Dictionary
• Severity: S3 (Non-critical)
• Version: 8.0.13
• OS: Oracle Linux (7)
• CPU Architecture: x86

[9 Nov 2018 21:54] Vlad Safronov

Description:
In-place upgrade from 8.0.11 to 8.013 fails:

2018-11-08T21:49:50.864498Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.13) starting as process 2290
2018-11-08T21:49:53.083559Z 1 [ERROR] [MY-013178] [Server] Execution of server-side SQL statement 'INSERT INTO tables SELECT *, 0 FROM mysql.tables' failed w
ith error code = 1292, error message = 'Incorrect datetime value: '0000-00-00 00:00:00' for column 'created' at row 74'.
2018-11-08T21:49:53.111560Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2018-11-08T21:49:53.111662Z 0 [ERROR] [MY-010119] [Server] Aborting
2018-11-08T21:49:54.447945Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.13)  MySQL Community Server - GPL.

How to repeat:
Do in-place upgrade to 8.0.13 from 8.0.11 skipping 8.0.12

Suggested fix:
Downgrading with 'yum downgrade' to 8.0.12 and then upgrade to 8.0.13
or better do sequential GA upgrades 8.0.11 -> 8.0.12 -> 8.0.13.

[12 Nov 2018 6:21] MySQL Verification Team

Hello Vlad,

Thank you for the report and feedback.

regards,
Umesh

[10 May 2019 5:08] Erlend Dahl

Duplicate of

Bug#91323 SQL layer must check/set server version number in DD tablespace