Results 1 to 9 of 9

Thread: Database Integrity check report: Errors found

  1. #1
    mcevoys is offline Special Member
    Join Date
    Apr 2006
    Location
    Ridgefield, CT
    Posts
    152
    Rep Power
    9

    Default Database Integrity check report: Errors found

    Last week, I started getting the following email error report.

    From: admin@domain.com [mailto:admin@domain.com]
    Sent: Sunday, December 02, 2007 11:01 PM
    To: admin@domain.com
    Subject: Database Integrity check report

    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=password
    mboxgroup4.open_conversation
    error : Corrupt


    When I run /opt/zimbra/mysql/bin/mysqlcheck --defaults-file=/opt/zimbra/conf/my.cnf -S /opt/zimbra/db/mysql.sock -A -C -s -u root --password=password, all I get back is:

    mboxgroup4.open_conversation
    error : Corrupt


    Anyone have any ideas here? I want to have a clean database prior to the forthcoming Zimbra5 migration.

  2. #2
    mcevoys is offline Special Member
    Join Date
    Apr 2006
    Location
    Ridgefield, CT
    Posts
    152
    Rep Power
    9

    Default

    I think I found the related account. When they try to empty the trash, they get a network error:

    msg - system failure: deleting contents for folder 3
    code - service.FAILURE
    method - ZmCsfeCommand.prototype.invoke
    detail - soap:Receiver


    I tried reindexing the mailbox, but it didn't correct the condition.

    Still not sure how to correct this though...anyone?

  3. #3
    mcevoys is offline Special Member
    Join Date
    Apr 2006
    Location
    Ridgefield, CT
    Posts
    152
    Rep Power
    9

    Default

    Anyone have any suggestions?

  4. #4
    mcevoys is offline Special Member
    Join Date
    Apr 2006
    Location
    Ridgefield, CT
    Posts
    152
    Rep Power
    9

    Default

    Still requesting help here

  5. #5
    mcevoys is offline Special Member
    Join Date
    Apr 2006
    Location
    Ridgefield, CT
    Posts
    152
    Rep Power
    9

    Default

    Ping for help

  6. #6
    jholder's Avatar
    jholder is offline Former Zimbran
    Join Date
    Oct 2005
    Location
    Thatcher, AZ
    Posts
    5,606
    Rep Power
    20

    Default

    Hey Sean-
    Looks like you've got some bad issues going on. Did you have a power failure or something?

    You can't repair those because they're innodb databases.

    The only option you really have is to do a total dump. Here's the wiki article on disaster recovery:
    Mysql Crash Recovery - Zimbra :: Wiki

    Make sure you backup first. That should fix it.

  7. #7
    bhickey's Avatar
    bhickey is offline Advanced Member
    Join Date
    Feb 2006
    Posts
    177
    Rep Power
    9

    Default

    I take it they're not InnoDB for performance reasons?

  8. #8
    phoenix is online now Zimbra Consultant & Moderator
    Join Date
    Sep 2005
    Location
    Vannes, France
    Posts
    23,492
    Rep Power
    56

    Default

    Quote Originally Posted by bhickey View Post
    I take it they're not InnoDB for performance reasons?
    I believe he said they are innodb databases.
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  9. #9
    bhickey's Avatar
    bhickey is offline Advanced Member
    Join Date
    Feb 2006
    Posts
    177
    Rep Power
    9

    Default

    I misread the eariler post... InnoDB is usually more reliable than some of the other table types.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 7
    Last Post: 10-05-2007, 03:14 PM
  2. Replies: 2
    Last Post: 10-04-2007, 03:20 PM
  3. Replies: 5
    Last Post: 03-01-2007, 03:20 AM
  4. Replies: 16
    Last Post: 11-29-2006, 10:36 AM

Posting Permissions

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