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 03-22-2011, 11:11 PM
Active Member
 
Posts: 49
Default Database Errors

I recently upgraded the open-source version of Zimbra to the latest and noticed some database errors. Is there a script which can be run to do the "repair table" on the database or is there something else possibly wrong?

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=TGZN.IVQeLBcyqjxM34Tl5Cp.2es
mboxgroup1.appointment
error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
mboxgroup1.data_source_item
error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
mboxgroup1.imap_folder
error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
mboxgroup1.mail_item
error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
mboxgroup1.pop3_message
error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
mboxgroup10.appointment
error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
mboxgroup10.data_source_item
error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
mboxgroup10.imap_folder
error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
mboxgroup10.mail_item
error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
mboxgroup10.pop3_message
error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
mboxgroup11.appointment
error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
mboxgroup11.data_source_item
error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
mboxgroup11.imap_folder
error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
mboxgroup11.mail_item
error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
mboxgroup11.pop3_message
error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
mboxgroup12.appointment
error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
mboxgroup12.data_source_item
error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
mboxgroup12.imap_folder
error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
mboxgroup12.mail_item
error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
mboxgroup12.pop3_message
error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
mboxgroup2.appointment
error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
mboxgroup2.data_source_item
error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
mboxgroup2.imap_folder
error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
mboxgroup2.mail_item
error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
mboxgroup2.pop3_message
error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
mboxgroup3.appointment
error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
mboxgroup3.data_source_item
error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
mboxgroup3.imap_folder
error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
mboxgroup3.mail_item
error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
mboxgroup3.pop3_message
error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
mboxgroup4.appointment
error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
mboxgroup4.data_source_item
error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
mboxgroup4.imap_folder
error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
mboxgroup4.mail_item
error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
mboxgroup4.pop3_message
error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
mboxgroup5.appointment
error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
mboxgroup5.data_source_item
error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
mboxgroup5.imap_folder
error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
mboxgroup5.mail_item
error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
mboxgroup5.pop3_message
error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
mboxgroup6.appointment
error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
mboxgroup6.data_source_item
error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
mboxgroup6.imap_folder
error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
mboxgroup6.mail_item
error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
mboxgroup6.pop3_message
error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
mboxgroup7.appointment
error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
mboxgroup7.data_source_item
error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
mboxgroup7.imap_folder
error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
mboxgroup7.mail_item
error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
mboxgroup7.pop3_message
error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
mboxgroup8.appointment
error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
mboxgroup8.data_source_item
error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
mboxgroup8.imap_folder
error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
mboxgroup8.mail_item
error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
mboxgroup8.pop3_message
error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
mboxgroup9.appointment
error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
mboxgroup9.data_source_item
error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
mboxgroup9.imap_folder
error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
mboxgroup9.mail_item
error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
mboxgroup9.pop3_message
error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
mysql.general_log
Error : You can't use locks with log tables.
mysql.slow_log
Error : You can't use locks with log tables.
zimbra.config
error : Table upgrade required. Please do "REPAIR TABLE `config`" or dump/reload to fix it!
zimbra.deleted_account
error : Table upgrade required. Please do "REPAIR TABLE `deleted_account`" or dump/reload to fix it!
zimbra.jiveUserProp
warning : 1 client is using or hasn't closed the table properly
zimbra.mailbox
error : Table upgrade required. Please do "REPAIR TABLE `mailbox`" or dump/reload to fix it!
zimbra.mailbox_metadata
error : Table upgrade required. Please do "REPAIR TABLE `mailbox_metadata`" or dump/reload to fix it!
zimbra.mobile_devices
error : Table upgrade required. Please do "REPAIR TABLE `mobile_devices`" or dump/reload to fix it!
zimbra.out_of_office
error : Table upgrade required. Please do "REPAIR TABLE `out_of_office`" or dump/reload to fix it!
zimbra.scheduled_task
error : Table upgrade required. Please do "REPAIR TABLE `scheduled_task`" or dump/reload to fix it!
zimbra.table_maintenance
error : Table upgrade required. Please do "REPAIR TABLE `table_maintenance`" or dump/reload to fix it!
zimbra.volume
error : Table upgrade required. Please do "REPAIR TABLE `volume`" or dump/reload to fix it!
__________________
Johnny Stork
Linux & Open-Source Consultant

______________________
Open Enterprise Solutions
"Open Solutions for an Open World"

Web: www.openenterprise.ca
Email: stork@openenterprise.ca
LinkedIn: www.linkedin.com/in/johnnystork
Reply With Quote
  #2 (permalink)  
Old 03-22-2011, 11:50 PM
Zimbra Consultant & Moderator
 
Posts: 20,313
Default

Quote:
Originally Posted by BigBirdy View Post
I recently upgraded the open-source version of Zimbra to the latest and noticed some database errors. Is there a script which can be run to do the "repair table" on the database or is there something else possibly wrong?
Details are in the Release Notes or search the forums for the error.
__________________
Regards


Bill
Reply With Quote
  #3 (permalink)  
Old 03-23-2011, 08:26 AM
Active Member
 
Posts: 49
Default

Well that was no help at all. Nothing in the release notes for 7, not a search for "database errors" returned anything that would help. Ran zmdbintegrityreport again, same errors. Below is whats in the release notes

The following may need to be done before you upgrade.
Zimbra Database Integrity Check
Some customers have had corrupted databases prior to upgrade, and the
upgrade has in some of those cases exacerbated the problem. In order to
detect any corrupted databases as early as possible, we have added an
optional step to check the MySQL database with zmdbintegrityreport prior to
making any system changes. You are prompted to decide if you would like to
run the zmdbintegrityreport.
The zmdbintegrityreport can take minutes to an hour to run, depending on
your system size and disk bandwidth. .
Note: The zmdbintegrityreport is run on a weekly basis from cron on all
zimbra-store nodes. Large sites can opt to disable this by setting
zmlocalconfig -e zmdbintegrityreport_disabled=TRUE. If customers choose to
disable this, it is recommended that the integrity reports be run by hand during
the customer’s normal maintenance windows and prior to running any ZCS
upgrades
__________________
Johnny Stork
Linux & Open-Source Consultant

______________________
Open Enterprise Solutions
"Open Solutions for an Open World"

Web: www.openenterprise.ca
Email: stork@openenterprise.ca
LinkedIn: www.linkedin.com/in/johnnystork
Reply With Quote
  #4 (permalink)  
Old 03-23-2011, 10:22 AM
Zimbra Consultant & Moderator
 
Posts: 20,313
Default

Quote:
Originally Posted by BigBirdy View Post
Well that was no help at all. Nothing in the release notes for 7, not a search for "database errors" returned anything that would help.
Really, you do surprise me. I guess you read the Release Notes (you should do that before every upgrade) about upgrading and specifically the section on: "After the Upgrade is Complete"

Then there's these threads: site:zimbra.com +"error : Table upgrade required." - Yahoo! Search Results
__________________
Regards


Bill
Reply With Quote
  #5 (permalink)  
Old 03-23-2011, 10:56 AM
Active Member
 
Posts: 49
Default

Thanks, found it EVENTUALLY. Since this was such an important and potentially damaging issue, post-upgrade, it certainly could have been more prominent, and even mentioned or scripted into the end of the upgrade script. Also, although I and others are certainly grateful for any help we can get, one simple pragmatic suggestion. If someone can take the time to post "go read the docs", they can also cut/post the actual section of the docs which details the solutions. The "helper" is actually providing a solution and the "helpee" gets the solution right away. Far more efficient for everyone involved.

But still, thanks for the help.
__________________
Johnny Stork
Linux & Open-Source Consultant

______________________
Open Enterprise Solutions
"Open Solutions for an Open World"

Web: www.openenterprise.ca
Email: stork@openenterprise.ca
LinkedIn: www.linkedin.com/in/johnnystork
Reply With Quote
  #6 (permalink)  
Old 03-24-2011, 12:41 PM
Member
 
Posts: 10
Default

[SOLVED] Database Integrity Check Report

wo
Reply With Quote
  #7 (permalink)  
Old 03-24-2011, 01:06 PM
Active Member
 
Posts: 49
Default

Thank you and grateful for your help.
__________________
Johnny Stork
Linux & Open-Source Consultant

______________________
Open Enterprise Solutions
"Open Solutions for an Open World"

Web: www.openenterprise.ca
Email: stork@openenterprise.ca
LinkedIn: www.linkedin.com/in/johnnystork
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.