Page 1 of 1

Functioning Database Needs Repair

Posted: Tue Jun 25, 2019 8:36 pm
by tgrzelak
Zimbra is Release 8.7.0.GA.1659.UBUNTU14.64 UBUNTU14_64 FOSS edition.

/opt/zimbra/libexec/zmdbintegrityreport -m

results in

Database errors found.
/opt/zimbra/common/bin/mysqlcheck --defaults-file=/opt/zimbra/conf/my.cnf -S /opt/zimbra/data/tmp/mysql/mysql.sock -A -C -s -u root --password=XXXXXXXX
mboxgroup70.mail_item
Warning : InnoDB: Index 'i_name_folder_id' contains 34070 entries, should be 34069.
Warning : InnoDB: Index 'i_type' contains 34070 entries, should be 34069.
Warning : InnoDB: Index 'i_folder_id_date' contains 34070 entries, should be 34069.
Warning : InnoDB: Index 'i_mod_metadata' contains 34070 entries, should be 34069.
error : Corrupt

Can this be fixed without dropping and rebuilding the entire database as suggested in https://wiki.zimbra.com/wiki/Mysql_Crash_Recovery?

Thanks!
Tom