Zimbra offers Open Source email server software and shared calendar for Linux and the Mac
Go Back   Zimbra :: Forums > Zimbra Collaboration Suite > Administrators

Welcome to the Zimbra :: Forums!
Welcome, if you would like to post a comment please register. We also encourage you to explore all things Zimbra with our team and members of the community.

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 08-04-2010, 04:17 AM
Intermediate Member
 
Posts: 19
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
Reply With Quote
  #2 (permalink)  
Old 08-04-2010, 10:07 AM
Partner (VAR/HSP)
 
Posts: 425
Default

Sounds like MySQL should be fixed. Hope you have a backup...
Reply With Quote
  #3 (permalink)  
Old 08-05-2010, 07:01 AM
Intermediate Member
 
Posts: 19
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
Reply With Quote
  #4 (permalink)  
Old 08-05-2010, 07:05 AM
Zimbra Consultant & Moderator
 
Posts: 20,313
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
Reply With Quote
  #5 (permalink)  
Old 08-10-2010, 02:13 AM
Intermediate Member
 
Posts: 19
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..
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes


Similar Threads

Why Join?

Registering let's you ask questions, makes it easier to search, displays any files attached to posts, and notifies you about replies.

blog.zimbra.com




 

SEO by vBSEO ©2011, Crawlability, Inc.