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-16-2011, 12:59 AM
Intermediate Member
 
Posts: 24
Default [SOLVED] Zimbra 7.0.1 Database Issue after upgrade

We recently updated few of our servers to 7.0.1 ( OS ) and we got warnings about database errors. Running the upgrade script again ( 7.0.1 -> 7.0.1 ), shows the following :


Code:
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.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!
 mboxgroup1.appointment
 note     : The storage engine for the table doesn't support repair
 mboxgroup1.data_source_item
 note     : The storage engine for the table doesn't support repair
 mboxgroup1.imap_folder
 note     : The storage engine for the table doesn't support repair
 mboxgroup1.mail_item
 note     : The storage engine for the table doesn't support repair
 mboxgroup1.pop3_message
 note     : The storage engine for the table doesn't support repair
 mboxgroup10.appointment
 note     : The storage engine for the table doesn't support repair
 mboxgroup10.data_source_item
 note     : The storage engine for the table doesn't support repair
 mboxgroup10.imap_folder
 note     : The storage engine for the table doesn't support repair
 mboxgroup10.mail_item
 note     : The storage engine for the table doesn't support repair
 mboxgroup10.pop3_message
 note     : The storage engine for the table doesn't support repair
 mboxgroup11.appointment
 note     : The storage engine for the table doesn't support repair
 mboxgroup11.data_source_item
 note     : The storage engine for the table doesn't support repair
 mboxgroup11.imap_folder
 note     : The storage engine for the table doesn't support repair
 mboxgroup11.mail_item
 note     : The storage engine for the table doesn't support repair
 mboxgroup11.pop3_message
 note     : The storage engine for the table doesn't support repair
 mboxgroup12.appointment
 note     : The storage engine for the table doesn't support repair
 mboxgroup12.data_source_item
 note     : The storage engine for the table doesn't support repair
 mboxgroup12.imap_folder
 note     : The storage engine for the table doesn't support repair
 mboxgroup12.mail_item
 note     : The storage engine for the table doesn't support repair
 mboxgroup12.pop3_message
 note     : The storage engine for the table doesn't support repair
 mboxgroup13.appointment
 note     : The storage engine for the table doesn't support repair
 mboxgroup13.data_source_item
 note     : The storage engine for the table doesn't support repair
 mboxgroup13.imap_folder
 note     : The storage engine for the table doesn't support repair
 mboxgroup13.mail_item
 note     : The storage engine for the table doesn't support repair
 mboxgroup13.pop3_message
 note     : The storage engine for the table doesn't support repair
 mboxgroup14.appointment
 note     : The storage engine for the table doesn't support repair
 mboxgroup14.data_source_item
 note     : The storage engine for the table doesn't support repair
 mboxgroup14.imap_folder
 note     : The storage engine for the table doesn't support repair
 mboxgroup14.mail_item
 note     : The storage engine for the table doesn't support repair
 mboxgroup14.pop3_message
 note     : The storage engine for the table doesn't support repair
 mboxgroup15.appointment
 note     : The storage engine for the table doesn't support repair
 mboxgroup15.data_source_item
 note     : The storage engine for the table doesn't support repair
 mboxgroup15.imap_folder
 note     : The storage engine for the table doesn't support repair
 mboxgroup15.mail_item
 note     : The storage engine for the table doesn't support repair
 mboxgroup15.pop3_message
 note     : The storage engine for the table doesn't support repair
 mboxgroup16.appointment
 note     : The storage engine for the table doesn't support repair
 mboxgroup16.data_source_item
 note     : The storage engine for the table doesn't support repair
 mboxgroup16.imap_folder
 note     : The storage engine for the table doesn't support repair
 mboxgroup16.mail_item
 note     : The storage engine for the table doesn't support repair
 mboxgroup16.pop3_message
 note     : The storage engine for the table doesn't support repair
 mboxgroup17.appointment
 note     : The storage engine for the table doesn't support repair
 mboxgroup17.data_source_item
 note     : The storage engine for the table doesn't support repair
 mboxgroup17.imap_folder
 note     : The storage engine for the table doesn't support repair
 mboxgroup17.mail_item
 note     : The storage engine for the table doesn't support repair
 mboxgroup17.pop3_message
 note     : The storage engine for the table doesn't support repair
 mboxgroup18.appointment
 note     : The storage engine for the table doesn't support repair
 mboxgroup18.data_source_item
 note     : The storage engine for the table doesn't support repair
 mboxgroup18.imap_folder
 note     : The storage engine for the table doesn't support repair
 mboxgroup18.mail_item
 note     : The storage engine for the table doesn't support repair
 mboxgroup18.pop3_message
 note     : The storage engine for the table doesn't support repair
 mboxgroup19.appointment
 note     : The storage engine for the table doesn't support repair
 mboxgroup19.data_source_item
 note     : The storage engine for the table doesn't support repair
 mboxgroup19.imap_folder
 note     : The storage engine for the table doesn't support repair
 mboxgroup19.mail_item
 note     : The storage engine for the table doesn't support repair
 mboxgroup19.pop3_message
 note     : The storage engine for the table doesn't support repair
 mboxgroup2.appointment
 note     : The storage engine for the table doesn't support repair
 mboxgroup2.data_source_item
 note     : The storage engine for the table doesn't support repair
 mboxgroup2.imap_folder
 note     : The storage engine for the table doesn't support repair
 mboxgroup2.mail_item
 note     : The storage engine for the table doesn't support repair
 mboxgroup2.pop3_message
 note     : The storage engine for the table doesn't support repair
 mboxgroup3.appointment
 note     : The storage engine for the table doesn't support repair
 mboxgroup3.data_source_item
 note     : The storage engine for the table doesn't support repair
 mboxgroup3.imap_folder
 note     : The storage engine for the table doesn't support repair
 mboxgroup3.mail_item
 note     : The storage engine for the table doesn't support repair
 mboxgroup3.pop3_message
 note     : The storage engine for the table doesn't support repair
 mboxgroup4.appointment
 note     : The storage engine for the table doesn't support repair
 mboxgroup4.data_source_item
 note     : The storage engine for the table doesn't support repair
 mboxgroup4.imap_folder
 note     : The storage engine for the table doesn't support repair
 mboxgroup4.mail_item
 note     : The storage engine for the table doesn't support repair
 mboxgroup4.pop3_message
 note     : The storage engine for the table doesn't support repair
 mboxgroup5.appointment
 note     : The storage engine for the table doesn't support repair
 mboxgroup5.data_source_item
 note     : The storage engine for the table doesn't support repair
 mboxgroup5.imap_folder
 note     : The storage engine for the table doesn't support repair
 mboxgroup5.mail_item
 note     : The storage engine for the table doesn't support repair
 mboxgroup5.pop3_message
 note     : The storage engine for the table doesn't support repair
 mboxgroup6.appointment
 note     : The storage engine for the table doesn't support repair
 mboxgroup6.data_source_item
 note     : The storage engine for the table doesn't support repair
 mboxgroup6.imap_folder
 note     : The storage engine for the table doesn't support repair
 mboxgroup6.mail_item
 note     : The storage engine for the table doesn't support repair
 mboxgroup6.pop3_message
 note     : The storage engine for the table doesn't support repair
 mboxgroup7.appointment
 note     : The storage engine for the table doesn't support repair
 mboxgroup7.data_source_item
 note     : The storage engine for the table doesn't support repair
 mboxgroup7.imap_folder
 note     : The storage engine for the table doesn't support repair
 mboxgroup7.mail_item
 note     : The storage engine for the table doesn't support repair
 mboxgroup7.pop3_message
 note     : The storage engine for the table doesn't support repair
 mboxgroup8.appointment
 note     : The storage engine for the table doesn't support repair
 mboxgroup8.data_source_item
 note     : The storage engine for the table doesn't support repair
 mboxgroup8.imap_folder
 note     : The storage engine for the table doesn't support repair
 mboxgroup8.mail_item
 note     : The storage engine for the table doesn't support repair
 mboxgroup8.pop3_message
 note     : The storage engine for the table doesn't support repair
 mboxgroup9.appointment
 note     : The storage engine for the table doesn't support repair
 mboxgroup9.data_source_item
 note     : The storage engine for the table doesn't support repair
 mboxgroup9.imap_folder
 note     : The storage engine for the table doesn't support repair
 mboxgroup9.mail_item
 note     : The storage engine for the table doesn't support repair
 mboxgroup9.pop3_message
 note     : The storage engine for the table doesn't support repair
 zimbra.config
 note     : The storage engine for the table doesn't support repair
 zimbra.deleted_account
 note     : The storage engine for the table doesn't support repair
 zimbra.mailbox
 note     : The storage engine for the table doesn't support repair
 zimbra.mailbox_metadata
 note     : The storage engine for the table doesn't support repair
 zimbra.mobile_devices
 note     : The storage engine for the table doesn't support repair
 zimbra.out_of_office
 note     : The storage engine for the table doesn't support repair
 zimbra.scheduled_task
 note     : The storage engine for the table doesn't support repair
 zimbra.table_maintenance
 note     : The storage engine for the table doesn't support repair
 zimbra.volume
 note     : The storage engine for the table doesn't support repair
The errors persist after the upgrade. This is on ubuntu 10.04 x64 .
Any clues ?
Reply With Quote
  #2 (permalink)  
Old 03-16-2011, 01:00 AM
Intermediate Member
 
Posts: 24
Default

The strange thing is a clean install of 7.0.1 does not have this issue. All of the installations that show those errors, are in fact upgraded from 6.x versions to 7.x .
Reply With Quote
  #3 (permalink)  
Old 03-16-2011, 01:02 AM
Zimbra Consultant & Moderator
 
Posts: 20,313
Default

Quote:
Originally Posted by n.bochev View Post
We recently updated few of our servers to 7.0.1 ( OS ) and we got warnings about database errors. Running the upgrade script again ( 7.0.1 -> 7.0.1 ), shows the following :
Why did you you do that? Read the Release Notes (you should always do this before an upgrade) or search the forums for what you should do next.
__________________
Regards


Bill
Reply With Quote
  #4 (permalink)  
Old 03-16-2011, 01:07 AM
Intermediate Member
 
Posts: 24
Default

Quote:
Originally Posted by phoenix View Post
Why did you you do that? Read the Release Notes (you should always do this before an upgrade) or search the forums for what you should do next.

Gotcha. I thought it would be upgraded automatically.
Thanks.
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.