In Progress MySQL upgrade to 5.7 ok but some errors

Scott Galambos

Well-Known Member
Jul 13, 2016
93
3
8
Canada
cPanel Access Level
Root Administrator
I upgraded from MySQL 5.6 to 5.7 and things seem ok. But I noticed in my update log these errors. Were these fixed my the upgrade? Am I suppose to run mysql_upgrade now?

Code:
Startup Log
Nov 15 08:47:10 core.extremehosting.ca mysqld[18603]: 2020-11-15T13:47:10.746868Z 0 [ERROR] Incorrect definition of table performance_schema.events_waits_summary_by_account_by_event_name: expected column 'USER' at position 0 to have type char(32), found type char(16).
Nov 15 08:47:10 core.extremehosting.ca mysqld[18603]: 2020-11-15T13:47:10.747285Z 0 [ERROR] Column count of performance_schema.setup_actors is wrong. Expected 5, found 3. Created with MySQL 50649, now running 50732. Please use mysql_upgrade to fix this error.
Nov 15 08:47:10 core.extremehosting.ca mysqld[18603]: 2020-11-15T13:47:10.747392Z 0 [ERROR] Incorrect definition of table performance_schema.setup_objects: expected column 'OBJECT_TYPE' at position 0 to have type enum('EVENT','FUNCTION','PROCEDURE','TABLE','TRIGGER', found type enum('TABLE').
Nov 15 08:47:10 core.extremehosting.ca mysqld[18603]: 2020-11-15T13:47:10.747762Z 0 [ERROR] Column count of performance_schema.table_lock_waits_summary_by_table is wrong. Expected 68, found 73. Created with MySQL 50649, now running 50732. Please use mysql_upgrade to fix this error.
Nov 15 08:47:10 core.extremehosting.ca mysqld[18603]: 2020-11-15T13:47:10.747816Z 0 [ERROR] Column count of performance_schema.threads is wrong. Expected 17, found 14. Created with MySQL 50649, now running 50732. Please use mysql_upgrade to fix this error.
Nov 15 08:47:10 core.extremehosting.ca mysqld[18603]: 2020-11-15T13:47:10.747864Z 0 [ERROR] Column count of performance_schema.events_stages_current is wrong. Expected 12, found 10. Created with MySQL 50649, now running 50732. Please use mysql_upgrade to fix this error.
Nov 15 08:47:10 core.extremehosting.ca mysqld[18603]: 2020-11-15T13:47:10.747912Z 0 [ERROR] Column count of performance_schema.events_stages_history is wrong. Expected 12, found 10. Created with MySQL 50649, now running 50732. Please use mysql_upgrade to fix this error.
Nov 15 08:47:10 core.extremehosting.ca mysqld[18603]: 2020-11-15T13:47:10.747967Z 0 [ERROR] Column count of performance_schema.events_stages_history_long is wrong. Expected 12, found 10. Created with MySQL 50649, now running 50732. Please use mysql_upgrade to fix this error.
Nov 15 08:47:10 core.extremehosting.ca mysqld[18603]: 2020-11-15T13:47:10.748074Z 0 [ERROR] Incorrect definition of table performance_schema.events_stages_summary_by_account_by_event_name: expected column 'USER' at position 0 to have type char(32), found type char(16).
Nov 15 08:47:10 core.extremehosting.ca systemd[1]: Started MySQL Server.

Log Messages
...
2020-11-14 08:48:12 26493 [Note] /usr/sbin/mysqld: Shutdown complete
Nov 15 08:47:12 core mysqld: 2020-11-15T13:47:12.907417Z 4 [Note] Access denied for user 'Cpanel::MysqlUtils::Unprivileged'@'localhost' (using password: NO)
Nov 15 08:47:11 core mysqld: 2020-11-15T13:47:11.717647Z 3 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade
Nov 15 08:47:11 core mysqld: 2020-11-15T13:47:11.717594Z 3 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade