Get the most out of your Centmin Mod LEMP stack
Become a Member

MariaDB InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name.

Discussion in 'Nginx, PHP-FPM & MariaDB MySQL' started by pamamolf, Sep 27, 2018.

  1. pamamolf

    pamamolf Well-Known Member

    3,117
    295
    83
    May 31, 2014
    Ratings:
    +530
    Local Time:
    8:19 AM
    Nginx-1.13.x
    MariaDB 10.1.x
    Please fill in any relevant information that applies to you:
    • CentOS Version: CentOS 7 64bit
    • Centmin Mod Version Installed: 123.09beta01
    • Nginx Version Installed: i.e. 1.15.3
    • PHP Version Installed: i.e. 5.6.37, 7.0.31, 7.1.21, 7.2.9
    • MariaDB MySQL Version Installed: 10.2.xx
    • When was last time updated Centmin Mod code base ? : now
    Hello

    I just check the /var/log/messages and i found that message repeated every x seconds...

    Code:
    Sep 26 20:49:01 server mysqld: 2018-09-26 20:49:01 139910485485312 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name.  Please run mysql_upgrade
    As a new version was out i thought to upgrade to it and that should solve the issue....

    So i upgrade to latest 10.2.x and then check after a few minutes and i am still getting this message :(

    Any ideas?

    Thank you
     
  2. eva2000

    eva2000 Administrator Staff Member

    36,333
    7,979
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +12,287
    Local Time:
    3:19 PM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    were you running mysql 10.2.x before the upgrade ? what version prior to upgrade were you on before yum update ?

    tried doing command
    Code (Text):
    mysql_upgrade
    
     
  3. pamamolf

    pamamolf Well-Known Member

    3,117
    295
    83
    May 31, 2014
    Ratings:
    +530
    Local Time:
    8:19 AM
    Nginx-1.13.x
    MariaDB 10.1.x
    I was on latest 10.1.x and then i upgrade to 10.2.16 and then to 10.2.17 and then i notice that issue.....so i upgrade to latest 10.2.18...
     
  4. eva2000

    eva2000 Administrator Staff Member

    36,333
    7,979
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +12,287
    Local Time:
    3:19 PM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    centmin mod mariadb 10.1 to 10.2 upgrade menu usually takes care of mysql_upgrade command - you can check the upgrade logs which you should be able to find
    Code (Text):
    ls -lahrt /root/centminlogs | grep mysql
    
     
    • Like Like x 1
..