After further troubleshooting, it looks like there are some problems in the database. The user's account that I'm having difficulty with is in mailbox group 43. Based on some information I found in /opt/zimbra/log/mailbox.log and /opt/zimbra/log/mysql_error.log, I tried the following:
Code:
mysql> use mboxgroup43;
mysql> select * from mail_item where mailbox_id=243;
MySQL crashed when I attempted this query. It appears the table is corrupt, even though zmdbintegrityreport (calling mysqlcheck) reports no problems:
Code:
[zimbra@mailhost libexec]$ /opt/zimbra/mysql/bin/mysqlcheck --defaults-file=/opt/zimbra/conf/my.cnf -S /opt/zimbra/db/mysql.sock -c -e -u root --password=fubar mboxgroup43
mboxgroup43.appointment OK
mboxgroup43.data_source_item OK
mboxgroup43.imap_folder OK
mboxgroup43.imap_message OK
mboxgroup43.mail_item OK
mboxgroup43.open_conversation OK
mboxgroup43.pop3_message OK
mboxgroup43.revision OK
mboxgroup43.tombstone OK
I tried to delete the offending item - this failed as well:
Code:
[zimbra@mailhost log]$ mysql mboxgroup43;
mysql> select CONCAT(id, '-', mod_content) as itemId from mail_item where id = 18011;
+--------------+
| itemId |
+--------------+
| 18011-106100 |
+--------------+
1 row in set (0.02 sec)
[zimbra@mailhost log]$ zmmailbox -z
mbox> selectMailbox user@example.com
mailbox: user@example.com, size: 2.22 GB, messages: 16493, unread: 174
mbox user@example.com> deleteItem 18011-106100
ERROR: service.FAILURE (system failure: fetching item 18011)
Do I have any options besides database recovery to resolve this?