Results 1 to 4 of 4

Thread: Corrupted database cause mailbox to halt

Hybrid View

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

    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
    4

    Default same here !!!

    Bump !

    Does anyone fixed it ?


    Thx

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

    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
    4

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