Upgrade to 8.7.7 abort due mysql errros

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

Upgrade to 8.7.7 abort due mysql errros

Postby maumar » Tue Apr 25, 2017 6:10 pm

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
Zimbra Employee
Zimbra Employee
Posts: 75
Joined: Thu Mar 24, 2016 1:22 pm

Re: Upgrade to 8.7.7 abort due mysql errros

Postby Raun » Sun May 07, 2017 4:45 am

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 .

Return to “Installation and Upgrade”

Who is online

Users browsing this forum: No registered users and 7 guests