Bug #89372 Using --no-dd-upgrade seems to have no effect
Submitted: 24 Jan 8:45 Modified: 4 Apr 23:31
Reporter: Geert Vanderkelen Email Updates:
Status: Analyzing Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:8.0.4 OS:Debian (9.3)
Assigned to: Bogdan Kecman CPU Architecture:Any
Tags: upgrade

[24 Jan 8:45] Geert Vanderkelen
Description:
Upgrade RC is not supported, but the change log of 8.0.4 mentions the new option --no-dd-upgrade which would indicate that MySQL Team considered this issue:

2018-01-24T08:43:07.474046Z 0 [System] [MY-010116] /usr/sbin/mysqld (mysqld 8.0.4-rc-log) starting as process 24392 ...
2018-01-24T08:43:07.573125Z 1 [ERROR] [MY-011096] No data dictionary version number found.
2018-01-24T08:43:07.573787Z 0 [ERROR] [MY-010020] Data Dictionary initialization failed.
2018-01-24T08:43:07.573831Z 0 [ERROR] [MY-010119] Aborting

How to repeat:

When upgrading MySQL 8.0.3-rc to 8.0.4-rc, it fails with:
  [ERROR] [MY-010020] Data Dictionary initialization failed.

Using the new option --no-dd-upgrade (in systemd or outside):

# su - mysql -c "/usr/sbin/mysqld --pid-file=/var/run/mysqld/mysqld.pid --no-dd-upgrade"

Error MY-011096 is still reported, and we can not upgrade.
[5 Mar 15:19] Bogdan Kecman
Hey Geert,

What version are you upgrading from?

all best
Bogdan
[4 Apr 19:16] Geert Vanderkelen
(Oops, email got spammed out :( )

Hi Bogdan,

Like mentioned in 'How to Repeat': MySQL 8.0.3-rc to 8.0.4-rc
[4 Apr 23:31] Bogdan Kecman
Sorry Geert kill me if I can explain how I did not see that :(

testing now :D

all best
b.