Functioning Database Needs Repair
Posted: Tue Jun 25, 2019 8:36 pm
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
/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