Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

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

Discussion in 'Database Discussion' started by kernow, Nov 11, 2018.

  1. kernow

    kernow Well-Known Member

    Joined:
    Jul 23, 2004
    Messages:
    937
    Likes Received:
    18
    Trophy Points:
    168
    cPanel Access Level:
    Root Administrator
    Hello, Were getting the MySQL error log filling up with:
    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?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  2. GOT

    GOT Get Proactive! PartnerNOC

    Joined:
    Apr 8, 2003
    Messages:
    1,367
    Likes Received:
    152
    Trophy Points:
    193
    Location:
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    kernow likes this.
  3. kernow

    kernow Well-Known Member

    Joined:
    Jul 23, 2004
    Messages:
    937
    Likes Received:
    18
    Trophy Points:
    168
    cPanel Access Level:
    Root Administrator
    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
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  4. GOT

    GOT Get Proactive! PartnerNOC

    Joined:
    Apr 8, 2003
    Messages:
    1,367
    Likes Received:
    152
    Trophy Points:
    193
    Location:
    Chesapeake, VA
    cPanel Access Level:
    DataCenter Provider
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,009
    Likes Received:
    2,123
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  6. kernow

    kernow Well-Known Member

    Joined:
    Jul 23, 2004
    Messages:
    937
    Likes Received:
    18
    Trophy Points:
    168
    cPanel Access Level:
    Root Administrator
    Thanks for the replies, that command fixed it!
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    cPanelMichael likes this.
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice