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 10-24-2011, 03:30 AM
Starter Member
 
Posts: 2
Default Upgrade database error

I am trying to upgrade our existing zimbra installation (ZCS 6.0.9) to ZCS 7.1.3 which is running on Ubuntu 8.04.3, however during the upgrade procedure it runs a database integrity check and I receive the following error:

Code:
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 --auto-repair
mboxgroup79.mail_item
 error    : Corrupt
 mboxgroup79.mail_item
 note     : The storage engine for the table doesn't support repair
I have tried running through a procedure on the wiki Mysql Crash Recovery (alternate method) - Zimbra :: Wiki however when it gets to the section where you dump the individual errors out to /tmp/XX all the files are 0 size, so there doesn't appear to be anything for me to fix.
Reply With Quote
  #2 (permalink)  
Old 10-26-2011, 01:53 AM
Starter Member
 
Posts: 2
Default

Anyone have any ideas? Can't seem to repair it but I don't know if it will cause nay problems if I just ignore it and carry on with the update.
Reply With Quote
  #3 (permalink)  
Old 11-23-2011, 10:53 PM
Loyal Member
 
Posts: 93
Default

login to mysql, use the db with the issue and try running: OPTIMIZE TABLE mail_item;
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.