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

[kernow]

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]

You won't hurt anything by re-running mysql_upgrade, though its always wisest to take backups before you do something like that.

 

[kernow]

its always wisest to take backups before you do something like that.

Yes full backup of course. But I was hoping there might be another option to re-running the upgrade script, like getting MySQL to fix the problem table_name

 

[GOT]

More info here. I don't know how to manually fix it.

How to fix innodb_table_stats and innodb_index_stats has length mismatch – Blog | Unix

 

[cPanelMichael]

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:

mysql_upgrade

Thank you.

 

[kernow]

Thanks for the replies, that command fixed it!