Bug #106732 Table missing after upgrade mysql 5.6 to 5.7

• Submitted: 15 Mar 2022 8:47
• Modified: 15 Mar 2022 14:41
• Reporter: Noor Ilham Che Mat
• Status: Unsupported
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 5.7
• OS: Windows (Windows Server 2016)
• CPU Architecture: x86
• Tags: missing tables

[15 Mar 2022 8:47] Noor Ilham Che Mat

Description:
Running queries to upgrade MySQL server.
mysql_upgrade: [ERROR] 1146: Table 'mysql.gtid_executed' doesn't exist
mysql_upgrade: [ERROR] 1243: Unknown prepared statement handler (stmt) given to EXECUTE
mysql_upgrade: [ERROR] 1243: Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE
mysql_upgrade: [ERROR] 1146: Table 'mysql.server_cost' doesn't exist
mysql_upgrade: [ERROR] 1146: Table 'mysql.server_cost' doesn't exist
mysql_upgrade: [ERROR] 1146: Table 'mysql.engine_cost' doesn't exist
mysql_upgrade: [ERROR] 1146: Table 'mysql.engine_cost' doesn't exist
mysql_upgrade: [ERROR] 1146: Table 'mysql.gtid_executed' doesn't exist
mysql_upgrade: [ERROR] 1025: Error on rename of '.\mysql\#sql-1fec_8' to '.\mysql\help_topic' (errno: 184 - Tablespace already exists)
mysql_upgrade: [ERROR] 1025: Error on rename of '.\mysql\#sql-1fec_8' to '.\mysql\help_category' (errno: 184 - Tablespace already exists)
mysql_upgrade: [ERROR] 1025: Error on rename of '.\mysql\#sql-1fec_8' to '.\mysql\help_relation' (errno: 184 - Tablespace already exists)
mysql_upgrade: [ERROR] 1025: Error on rename of '.\mysql\#sql-1fec_8' to '.\mysql\help_keyword' (errno: 184 - Tablespace already exists)
mysql_upgrade: [ERROR] 1025: Error on rename of '.\mysql\#sql-1fec_8' to '.\mysql\plugin' (errno: 184 - Tablespace already exists)
mysql_upgrade: [ERROR] 1025: Error on rename of '.\mysql\#sql-1fec_8' to '.\mysql\servers' (errno: 184 - Tablespace already exists)
mysql_upgrade: [ERROR] 1025: Error on rename of '.\mysql\#sql-1fec_8' to '.\mysql\time_zone' (errno: 184 - Tablespace already exists)
mysql_upgrade: [ERROR] 1025: Error on rename of '.\mysql\#sql-1fec_8' to '.\mysql\time_zone_leap_second' (errno: 184 - Tablespace already exists)
mysql_upgrade: [ERROR] 1025: Error on rename of '.\mysql\#sql-1fec_8' to '.\mysql\time_zone_name' (errno: 184 - Tablespace already exists)
mysql_upgrade: [ERROR] 1025: Error on rename of '.\mysql\#sql-1fec_8' to '.\mysql\time_zone_transition' (errno: 184 - Tablespace already exists)
mysql_upgrade: [ERROR] 1025: Error on rename of '.\mysql\#sql-1fec_8' to '.\mysql\time_zone_transition_type' (errno: 184 - Tablespace already exists)

How to repeat:
 run mysql_upgrade after upgrade from 5.6 to 5.7

[15 Mar 2022 14:41] MySQL Verification Team

Hi Mr. Mat,

Thank you for your bug report.

However, we do not support 5.6 for a very long time now.

Also, when you report a potential bug, you should supply a complete test case, so that we can repeat a problem.

However, in this case we can not further process your report since we do not use nor support 5.6 for quite some time.

Unsupported.