Bug #114629 partially upgraded DD
Submitted: 12 Apr 8:43 Modified: 12 Apr 10:32
Reporter: nycle chen Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:8.0.34 OS:Any
Assigned to: CPU Architecture:Any
Tags: upgraded DD tables

[12 Apr 8:43] nycle chen 
Description:
Hello:

  When mysql5.7.34 is upgraded to mysql8.0.34, the mysqlsh check result has no error message. But when mysql8.0.34 starts for the upgrade, the error log file of mysql, which has no error message, but the startup is abnormal.
  The mysql8 process is exists, but no listening port.
  At this time, kill the mysql8 process , and then start mysql8 again, then there is error information in the error log file, as follows:
[ERROR] [MY-011014] [Server] Found partially upgraded DD. Aborting upgrade and deleting all DD tables. Start the upgrade process again.

  Thank you.

How to repeat:
  From the previous MySQL5.7.34 backup, restore another MySQL5.7.34 instance, upgrade to mysql8.0.34 again, and it will appear.
  But only my original MySQL5.7.34 instance will appear, which is not happen if a new MySQL5.7.34 instance is completely created.
[12 Apr 10:32] MySQL Verification Team 
Hi Mr. chen,

Thank you for your bug report.

However, we are unable to repeat it.

We got several bug reports each week on the problems of upgrading from 5.7 -> 8.0.

We were able to repeat those that came with a completely repeatable test case. Users that reported the problems that were repeatable also supplied the configuration file for both 5.7 and 8.0.

The users that provided repeatable reports were able to pinpoint to the problem.

We have, never ever , so far got a report that TCP port of the mysqld process was not accepting connections. Do note that you have to use 8.0 client with 8.0 server and that you have to use SSL encrypted passwords with 8.0 !!!

Hence, try to establish connection through localhost and create new user, with a password, and grant that user necessary privileges. This is all described in 8.0 Reference Manual.

Do note that those configuration files have to differ, due to the changes in 8.0.

We are, therefore, waiting on the fully repeatable test case from you.

Can't repeat.