Error when updating MySQL

eashop

Registered
Jun 18, 2011
1
0
51
# mysql_upgrade

Code:
Phase 1/6: Checking and upgrading mysql database

Processing databases

mysql

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

mysql.host                                         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
 
Last edited by a moderator:

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,909
2,227
463
Hello,

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.