SOLVED [CPANEL-22320] Table mysql/innodb_index_stats has length mismatch

kernow

Well-Known Member
Jul 23, 2004
1,015
61
178
cPanel Access Level
Root Administrator
Hello, Were getting the MySQL error log filling up with:
[Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade
Installed is 10.2.18-MariaDB and recommended is MariaDB 10.2 so I presume no real upgrade is possible. Can we safely re run the upgrade procedure to fix the error?
 

GOT

Get Proactive!
PartnerNOC
Apr 8, 2003
1,761
318
363
Chesapeake, VA
cPanel Access Level
DataCenter Provider
You won't hurt anything by re-running mysql_upgrade, though its always wisest to take backups before you do something like that.
 
  • Like
Reactions: kernow

GOT

Get Proactive!
PartnerNOC
Apr 8, 2003
1,761
318
363
Chesapeake, VA
cPanel Access Level
DataCenter Provider

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,904
2,226
463
Hello @kernow,

Internal case CPANEL-22320 is planned for inclusion with cPanel & WHM version 78 to address an issue where MySQL and MariaDB minor version updates performed with YUM were not executing the mysql_upgrade command. In the meantime, the workaround is to manually run the command below:

Code:
mysql_upgrade
Thank you.