Functioning Database Needs Repair

Discuss your pilot or production implementation with other Zimbra admins or our engineers.
tgrzelak
Posts: 3
Joined: Mon Jun 24, 2019 8:14 pm

Functioning Database Needs Repair

Postby tgrzelak » 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


Return to “Administrators”

Who is online

Users browsing this forum: mmgomess and 10 guests