Results 1 to 4 of 4

Thread: Corrupted database cause mailbox to halt

  1. #1
    Join Date
    Jul 2006
    Posts
    10
    Rep Power
    9

    Default Corrupted database cause mailbox to halt

    We are running version 7.1 code and the system started recieving the following error at a power failure. The system runs but fails occasionally. I have determined that the database is corrupted but have been unable to repair using the repair feature of zmdbintegrityreport command. I am seeking assistance in how the db may be repaired.

    /opt/zimbra/mysql/bin/mysqlcheck: Got error: 2013: Lost connection to MySQL server during query when executing 'CHECK TABLE ... CHANGED'
    Database errors found.
    /opt/zimbra/mysql/bin/mysqlcheck --defaults-file=/opt/zimbra/conf/my.cnf -S /opt/zimbra/db/mysql.sock -A -C -s -u root --password=XXXXXXXX
    mboxgroup10.mail_item
    Warning : InnoDB: Index 'i_name_folder_id' contains 242 entries, should be 243.
    Warning : InnoDB: Index 'i_type' contains 242 entries, should be 243.
    Warning : InnoDB: Index 'i_parent_id' contains 242 entries, should be 243.
    Warning : InnoDB: Index 'i_folder_id_date' contains 242 entries, should be 243.
    Warning : InnoDB: Index 'i_index_id' contains 242 entries, should be 243.
    Warning : InnoDB: Index 'i_unread' contains 242 entries, should be 243.
    Warning : InnoDB: Index 'i_date' contains 242 entries, should be 243.
    Warning : InnoDB: Index 'i_mod_metadata' contains 242 entries, should be 243.
    Warning : InnoDB: Index 'i_tags_date' contains 242 entries, should be 243.
    Warning : InnoDB: Index 'i_flags_date' contains 242 entries, should be 243.
    Warning : InnoDB: Index 'i_volume_id' contains 242 entries, should be 243.
    Warning : InnoDB: Index 'fk_mail_item_volume_id' contains 242 entries, should be 243.
    error : Corrupt
    mboxgroup11.mail_item
    Warning : InnoDB: Index 'i_name_folder_id' contains 9365 entries, should be 9366.
    Warning : InnoDB: Index 'i_type' contains 9365 entries, should be 9366.
    Warning : InnoDB: Index 'i_index_id' contains 9365 entries, should be 9366.
    Warning : InnoDB: Index 'i_unread' contains 9365 entries, should be 9366.
    Warning : InnoDB: Index 'i_flags_date' contains 9365 entries, should be 9366.
    Warning : InnoDB: Index 'i_volume_id' contains 9365 entries, should be 9366.
    error : Corrupt
    mboxgroup12.mail_item
    Warning : InnoDB: Index 'i_name_folder_id' contains 27109 entries, should be 27108.
    Warning : InnoDB: Index 'i_tags_date' contains 27112 entries, should be 27108.
    Warning : InnoDB: Index 'i_flags_date' contains 27112 entries, should be 27108.
    error : Corrupt
    mboxgroup12.open_conversation
    Warning : InnoDB: Index 'i_conv_id' contains 872 entries, should be 871.
    error : Corrupt
    command failed

  2. #2
    Join Date
    Apr 2012
    Posts
    3
    Rep Power
    3

    Default same here !!!

    Bump !

    Does anyone fixed it ?


    Thx

  3. #3
    Join Date
    Jul 2006
    Posts
    10
    Rep Power
    9

    Default

    I managed this process by migrating the non corrupted accounts to my backup server. This was a very serious issue and I did not get any reponses. i lost minimal data because most of the accounts were utilizing outlook. It only affect the web clients..

    Thanks,

  4. #4
    Join Date
    Apr 2012
    Posts
    3
    Rep Power
    3

    Default Found this:

    Quote Originally Posted by simba5140 View Post
    I managed this process by migrating the non corrupted accounts to my backup server. This was a very serious issue and I did not get any reponses. i lost minimal data because most of the accounts were utilizing outlook. It only affect the web clients..

    Thanks,
    After a long time looking at the forum I found this solution. Worked for me, is a little disruptive but...works.

    Mysql Crash Recovery - Zimbra :: Wiki

    Regards
    HD

Similar Threads

  1. Replies: 23
    Last Post: 01-24-2013, 03:44 PM
  2. Database corruption in mailbox.
    By Stromos in forum Administrators
    Replies: 0
    Last Post: 06-27-2011, 02:25 PM
  3. Send Database Records to IMAP Mailbox?
    By zmonster in forum General Questions
    Replies: 1
    Last Post: 04-09-2008, 12:50 AM
  4. can't you help me
    By iwan siahaan in forum Administrators
    Replies: 6
    Last Post: 12-17-2007, 06:53 PM
  5. Replies: 11
    Last Post: 06-22-2007, 02:32 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
  •