Upgrade to 8.7.7 abort due mysql errros

Ask questions about your setup or get help installing ZCS server (ZD section below).
Post Reply
User avatar
maumar
Outstanding Member
Outstanding Member
Posts: 390
Joined: Fri Sep 12, 2014 10:28 pm

Upgrade to 8.7.7 abort due mysql errros

Post by maumar »

Code: Select all

ZCS upgrade from 8.6.0 to 8.7.7 will be performed.
Checking for existing proxy service in your environment
Checking for existing memcached service in your environment
Validating ldap configuration
LDAP validation succeeded.  Continuing.
  
Checking current number of databases...

Do you want to verify message store database integrity? [Y]
Verifying integrity of message store databases.  This may take a while.
mysqld is alive
Database errors found.
/opt/zimbra/mysql/bin/mysqlcheck --defaults-file=/opt/zimbra/conf/my.cnf -S /opt/zimbra/db/mysql.sock -A -C -s -u root --auto-repair --password=XXXXXXXX
mysql.gtid_slave_pos
 Error    : Table 'mysql.gtid_slave_pos' doesn't exist in engine
 mysql.innodb_index_stats
 Error    : Table 'mysql.innodb_index_stats' doesn't exist in engine
 mysql.innodb_table_stats
 Error    : Table 'mysql.innodb_table_stats' doesn't exist in engine
 mysql.gtid_slave_pos
 Error    : Table 'mysql.gtid_slave_pos' doesn't exist in engine
 mysql.innodb_index_stats
 Error    : Table 'mysql.innodb_index_stats' doesn't exist in engine
 mysql.innodb_table_stats
 Error    : Table 'mysql.innodb_table_stats' doesn't exist in engine
User avatar
Raun
Advanced member
Advanced member
Posts: 75
Joined: Thu Mar 24, 2016 1:22 pm

Re: Upgrade to 8.7.7 abort due mysql errros

Post by Raun »

It seems there is some corruption in your mysql db . Try https://wiki.zimbra.com/wiki/Mysql_Crash_Recovery and run db integrity check before performing the upgrade .
Post Reply