Results 1 to 3 of 3

Thread: database corruption?

  1. #1
    Join Date
    Oct 2009
    Posts
    22
    Rep Power
    5

    Default database corruption?

    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 ?

  2. #2
    Join Date
    Oct 2009
    Posts
    22
    Rep Power
    5

    Default

    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).

  3. #3
    Join Date
    Oct 2009
    Posts
    22
    Rep Power
    5

    Default

    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 ?

Similar Threads

  1. Replies: 23
    Last Post: 01-24-2013, 02:44 PM
  2. [SOLVED] Database corruption after rsync
    By beta13 in forum Administrators
    Replies: 3
    Last Post: 12-06-2010, 09:28 AM
  3. change ldap database
    By Grejao in forum Administrators
    Replies: 1
    Last Post: 12-07-2007, 07:39 AM
  4. Database corruption after restore
    By NightTwix in forum Administrators
    Replies: 1
    Last Post: 07-06-2007, 04:01 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •