database corruption?

[Richelieu]

Hi,

After migrating to Zimbra 7, though I don't think the problems are related,

one of my users can't access his mailbox, with the mailbox.log showing :

com.zimbra.common.service.ServiceException: system failure: fetching folder data
for mailbox 30
ExceptionId:LmtpServer-138:1300090797408:aca9bef55084d6b1
Code:service.FAILURE
at com.zimbra.common.service.ServiceException.FAILURE (ServiceException.j
ava:248)
at com.zimbra.cs.db.DbMailItem.getFoldersAndTags(DbMa ilItem.java:2095)
at com.zimbra.cs.mailbox.Mailbox.loadFoldersAndTags(M ailbox.java:1525)
at com.zimbra.cs.mailbox.Mailbox.beginTransaction(Mai lbox.java:1230)
at com.zimbra.cs.mailbox.Mailbox.beginTransaction(Mai lbox.java:1177)
at com.zimbra.cs.mailbox.Mailbox.getItemById(Mailbox. java:2044)
at com.zimbra.cs.mailbox.Mailbox.getFolderById(Mailbo x.java:2935)
at com.zimbra.cs.filter.IncomingMessageHandler.getDef aultFolderPath(IncomingMessageHandler.java:76)
at com.zimbra.cs.filter.RuleManager.applyRulesToIncom ingMessage(RuleManager.java:406)
at com.zimbra.cs.filter.RuleManager.applyRulesToIncom ingMessage(RuleManager.java:363)
at com.zimbra.cs.lmtpserver.ZimbraLmtpBackend.deliver MessageToLocalMailb
oxes(ZimbraLmtpBackend.java:524)
at com.zimbra.cs.lmtpserver.ZimbraLmtpBackend.deliver (ZimbraLmtpBackend.java:336)
at com.zimbra.cs.lmtpserver.LmtpHandler.processMessag eData(LmtpHandler.java:371)
at com.zimbra.cs.lmtpserver.TcpLmtpHandler.continueDA TA(TcpLmtpHandler.java:74)
at com.zimbra.cs.lmtpserver.LmtpHandler.doDATA(LmtpHa ndler.java:356)
at com.zimbra.cs.lmtpserver.LmtpHandler.processComman d(LmtpHandler.java:172)
at com.zimbra.cs.lmtpserver.TcpLmtpHandler.processCom mand(TcpLmtpHandler.java:66)
at com.zimbra.cs.tcpserver.ProtocolHandler.processCon nection(ProtocolHandler.java:196)
at com.zimbra.cs.tcpserver.ProtocolHandler.run(Protoc olHandler.java:139)
at java.util.concurrent.ThreadPoolExecutor$Worker.run Task(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run (ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorEx ception: Table 'mboxgroup30.revision' doesn't exist

Query being executed when exception was thrown:
SELECT mi.folder_id, SUM(rev.size) FROM mboxgroup30.mail_item AS mi, mboxgroup30.revision AS rev WHERE mi.id = rev.item_id AND rev.mailbox_id = 30 AND mi.mailbox_id = rev.mailbox_id GROUP BY folder_id

Any hint on how I should fix the problem ?

[Richelieu]

I 'd add that a zmdbintegrityreport mentions the REPAIR table error for mailboxgroup30, 31... 35 even though I did follow the db upgrade procedure (it's not possible the problem predates the upgrade).

[Richelieu]

I did a show tables in mysql for a normal account and the problem account.

Normal one :

| Tables_in_mboxgroup29 |
+-----------------------+
| appointment |
| appointment_dumpster |
| data_source_item |
| imap_folder |
| imap_message |
| mail_item |
| mail_item_dumpster |
| open_conversation |
| pop3_message |
| revision |
| revision_dumpster |
| tombstone |
+-----------------------+

Problem one :

+-----------------------+
| Tables_in_mboxgroup30 |
+-----------------------+
| appointment |
| appointment_dumpster |
| data_source_item |
| imap_folder |
| imap_message |
| mail_item |
| mail_item_dumpster |
| open_conversation |
| revision_dumpster |
+-----------------------+

Any idea on how to recreate the missing tables (if this will be enough to restore part of the account functionnality) ? What could have caused the disappearance of pop3_message revision and tombstone tables ?