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!

Error when updating MySQL

Discussion in 'Database Discussion' started by eashop, May 9, 2016.

  1. eashop

    eashop Registered

    Jun 18, 2011
    Likes Received:
    Trophy Points:
    # mysql_upgrade

    Phase 1/6: Checking and upgrading mysql database
    Processing databases
    mysql.column_stats                                 OK
    mysql.columns_priv                                 OK
    mysql.db                                           OK
    mysql.event                                        OK
    mysql.func                                         OK
    mysql.help_category                                OK
    mysql.help_keyword                                 OK
    mysql.help_relation                                OK
    mysql.help_topic                                   OK                                         OK
    mysql.index_stats                                  OK
    mysql.ndb_binlog_index                             OK
    mysql.plugin                                       OK
    mysql.proc                                         OK
    mysql.procs_priv                                   OK
    mysql.proxies_priv                                 OK
    mysql.roles_mapping                                OK
    mysql.servers                                      OK
    mysql.table_stats                                  OK
    mysql.tables_priv                                  OK
    mysql.time_zone                                    OK
    mysql.time_zone_leap_second                        OK
    mysql.time_zone_name                               OK
    mysql.time_zone_transition                         OK
    mysql.time_zone_transition_type                    OK
    mysql.user                                         OK
    Phase 2/6: Fixing views
    Phase 3/6: Running 'mysql_fix_privilege_tables'
    ERROR 1005 (HY000) at line 64: Can't create table `mysql`.`innodb_table_stats` (errno: 165 "Table is read only")
    ERROR 1005 (HY000) at line 68: Can't create table `mysql`.`innodb_index_stats` (errno: 165 "Table is read only")
    ERROR 1005 (HY000) at line 136: Can't create table `mysql`.`gtid_slave_pos` (errno: 165 "Table is read only")
    ERROR 1146 (42S02) at line 581: Table 'mysql.innodb_index_stats' doesn't exist
    ERROR 1146 (42S02) at line 584: Table 'mysql.innodb_table_stats' doesn't exist
    FATAL ERROR: Upgrade failed
    Use :
    cloudlunux 7
    MySQL Governor and mariadb101
    #1 eashop, May 9, 2016
    Last edited by a moderator: May 9, 2016
  2. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Apr 11, 2011
    Likes Received:
    Trophy Points:
    cPanel Access Level:
    Root Administrator

    The output suggests InnoDB corruption. You can follow this guide to help when attempting to repair InnoDB on your system:

    InnoDB Corruption Repair Guide

    Thank you.
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...

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