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

kernow

• November 11, 2018 11:58

Hello, Were getting the MySQL error log filling up with: [QUOTE][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

  • November 11, 2018 17:00

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

  0
• 

  kernow

  • November 11, 2018 17:08

  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

  0
• 

  GOT

  • November 11, 2018 17:15

  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

  0
• 

  cPanelMichael

  • November 12, 2018 17:34

  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.

  0
• 

  kernow

  • November 13, 2018 07:13

  Thanks for the replies, that command fixed it!

  0

Please sign in to leave a comment.