Database errors in ZCS 8.6

The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

Database errors in ZCS 8.6



Problem:

Found database errors "tables doesn't exist".

/opt/zimbra/mysql/bin/mysqlcheck --defaults-file=/opt/zimbra/conf/my.cnf -S /opt/zimbra/db/mysql.sock -A -C -s -u root --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

Solution:

Drop and reload the MySQL database to fix the problem :

1. zmcontrol stop

2. source ~/bin/zmshutil ; zmsetvars

3. mysql.server start

4. mysql --batch --skip-column-names -e "show databases" | grep -e mbox -e zimbra > /tmp/mysql.db.list; mkdir /tmp/mysql.sql/

5. for db in `cat /tmp/mysql.db.list`; do ~/mysql/bin/mysqldump $db -S $mysql_socket -u root --password=$mysql_root_password  >  /tmp/mysql.sql/$db.sql; echo "Dumped $db"; sleep 10; done 

6. mysql.server stop

7. mv /opt/zimba/db/data/ /opt/zimbra/db/dataORIG/

8. /opt/zimbra/libexec/zmmyinit --sql_root_pw $mysql_root_password

9. mysql.server status   **If needed mysql.server start**

10. mysql -e "drop database zimbra"

11. for db in `cat /tmp/mysql.db.list`; do mysql -e "create database $db character set utf8"; echo "Created $db"; done

12. mysql zimbra < /tmp/mysql.sql/zimbra.sql

13. for sql in /tmp/mysql.sql/mbox*; do mysql `basename $sql .sql` < $sql; echo -e "Updated `basename $sql .sql` \n"; done 

14. zmcontrol start



Submitted by: Aarti Shah

Jump to: navigation, search