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
Functioning Database Needs Repair
Discuss your pilot or production implementation with other Zimbra admins or our engineers.
Jump to
- Zimbra Collaboration Server
- ↳ Administrators
- ↳ Installation and Upgrade
- ↳ Migration
- ↳ Virtualization
- ↳ Developers
- ↳ Zimlets
- ↳ Users
- ↳ Zimbra Connector for Outlook
- ↳ Zimbra Connector for Blackberry
- ↳ CalDAV / CardDAV / iSync
- ↳ Zimbra Collaboration 8.8 Beta
- ↳ Mobility
- ↳ Zimbra Talk
- ↳ Universal UI
- ↳ Zimbra Chat
- ↳ Zimbra Drive
- Zimbra Suite Plus
- ↳ Installation and Upgrade
- ↳ Zimbra Admin Plus
- ↳ Zimbra Backup Plus
- ↳ Zimbra HSM Plus
- ↳ Zimbra Mobile Plus
- Zimbra Desktop
- ↳ General Questions
- ↳ Error Reports
- ↳ Installation Help
- ↳ Zimbra Desktop Beta/RC
- General Zimbra
- ↳ General Zimbra Feedback
- ↳ Announcements
- ↳ Community News
- ↳ Zimbra Success Stories
- Portability
- ↳ BSD
- Other
- ↳ /etc
- ↳ International
- ↳ I18N/L10N - Translations
- ↳ Русский язык-фор
- ↳ French
- ↳ Italian
- ↳ German
- ↳ Spanish
- ↳ Scandinavian
- ↳ Portuguese