Results 1 to 5 of 5

Thread: Database Integrity check report command failed

  1. #1
    pingwin is offline Intermediate Member
    Join Date
    Dec 2009
    Posts
    22
    Rep Power
    5

    Default Database Integrity check report command failed

    I have been receiving database Integrity check report with text "command failed" for few weeks, i found these lines in mysql_error.log:

    InnoDB: Database page corruption on disk or a failed
    InnoDB: file read of page 131.

    Zimbra server still works but with some weird thing can happen like user cannot delete message or one message can be received several times or shared folder is unavailable to imap client.

    My zimbra version is zcs-6.0.6_GA_2324 and i wonder if instructions of Mysql Crash Recovery - Zimbra :: Wiki page are applicable in my case

  2. #2
    iway is offline Partner (VAR/HSP)
    Join Date
    May 2008
    Posts
    432
    Rep Power
    7

    Default

    Sounds like MySQL should be fixed. Hope you have a backup...

  3. #3
    pingwin is offline Intermediate Member
    Join Date
    Dec 2009
    Posts
    22
    Rep Power
    5

    Default

    Got dumps of dbs with recovery level 1 but then couldn't drop mboxgroup6 database - got error

    ERROR 2013 (HY000) at line 1: Lost connection to MySQL server during query

  4. #4
    phoenix is offline Zimbra Consultant & Moderator
    Join Date
    Sep 2005
    Location
    Vannes, France
    Posts
    23,490
    Rep Power
    56

    Default

    Quote Originally Posted by pingwin View Post
    Got dumps of dbs with recovery level 1 but then couldn't drop mboxgroup6 database - got error

    ERROR 2013 (HY000) at line 1: Lost connection to MySQL server during query
    Before going any further I'd suggest you shutdown your server and take a backup of the /opt/zimbra directory structure (details of backup in the wiki) and when you done that have a look at some of these threads: site:zimbra.com "Database page corruption on disk or a failed" - Yahoo! Search Results
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  5. #5
    pingwin is offline Intermediate Member
    Join Date
    Dec 2009
    Posts
    22
    Rep Power
    5

    Default

    I still cannot drop table revisions of mboxgroup6 rest of them a deleted. I got the same error when I try to run drop table or any other command to it. Is there any way of reinstalling ZCS with importing mysql data? There isn't mentioning of dumps in the following manual Backing up and restoring Zimbra (Open Source Version) - Zimbra :: Wiki
    Last edited by pingwin; 08-10-2010 at 03:07 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 09-16-2009, 05:13 AM
  2. Database Integrity Check Report error in Admin account.
    By nishith in forum Administrators
    Replies: 2
    Last Post: 06-08-2009, 01:37 AM
  3. [SOLVED] Mailserver down when send file attach of 50Mb
    By ZMilton in forum Administrators
    Replies: 20
    Last Post: 04-10-2008, 11:44 AM
  4. [SOLVED] Database Integrity check report
    By cedbl in forum Administrators
    Replies: 9
    Last Post: 02-06-2008, 02:11 PM
  5. Database Integrity check report: Errors found
    By mcevoys in forum Administrators
    Replies: 8
    Last Post: 12-07-2007, 08:26 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
  •