Results 1 to 7 of 7

Thread: Best course of action for missing/corrupted tables?

  1. #1
    jimbo is offline Special Member
    Join Date
    Nov 2005
    Posts
    108
    Rep Power
    9

    Default Best course of action for missing/corrupted tables?

    Running Zimbra OSE 5.11 on RedHat EL 5.3

    The system is sending and receiving mail fine, however changes to preferences etc do not persist after nightly shutdown for backup.

    Need some advice on the best way of repairing some mysql tables. After a hard server crash some odd behavior I checked for corrupted disk and a few other things. Ran a check on the database after receiving an error during an attempt to upgrade to 6.x. Restored from backup and ran the following:

    Code:
    /opt/zimbra/mysql/bin/mysqlcheck --defaults-file=/opt/zimbra/conf -S /opt/zimbra/db/mysql.sock -A -C -s -u root --password --all-databases --auto-repair
    which output the following:
    Code:
    mboxgroup25.appointment
    Error    : Table 'mboxgroup25.appointment' doesn't exist
    error    : Corrupt
    mboxgroup25.data_source_item
    Error    : Table 'mboxgroup25.data_source_item' doesn't exist
    error    : Corrupt
    mboxgroup25.imap_folder
    Error    : Table 'mboxgroup25.imap_folder' doesn't exist
    error    : Corrupt
    mboxgroup25.imap_message
    Error    : Table 'mboxgroup25.imap_message' doesn't exist
    error    : Corrupt
    mboxgroup25.mail_item
    Error    : Table 'mboxgroup25.mail_item' doesn't exist
    error    : Corrupt
    mboxgroup25.open_conversation
    Error    : Table 'mboxgroup25.open_conversation' doesn't exist
    error    : Corrupt
    mboxgroup25.pop3_message
    Error    : Table 'mboxgroup25.pop3_message' doesn't exist
    error    : Corrupt
    mboxgroup25.revision
    Error    : Table 'mboxgroup25.revision' doesn't exist
    error    : Corrupt
    mboxgroup25.tombstone
    Error    : Table 'mboxgroup25.tombstone' doesn't exist
    error    : Corrupt
    zimbra.mobile_devices
    Error    : Table 'zimbra.mobile_devices' doesn't exist
    error    : Corrupt
    mboxgroup25.appointment
    Error    : Table 'mboxgroup25.appointment' doesn't exist
    error    : Corrupt
    mboxgroup25.data_source_item
    Error    : Table 'mboxgroup25.data_source_item' doesn't exist
    error    : Corrupt
    mboxgroup25.imap_folder
    Error    : Table 'mboxgroup25.imap_folder' doesn't exist
    error    : Corrupt
    mboxgroup25.imap_message
    Error    : Table 'mboxgroup25.imap_message' doesn't exist
    error    : Corrupt
    mboxgroup25.mail_item
    Error    : Table 'mboxgroup25.mail_item' doesn't exist
    error    : Corrupt
    mboxgroup25.open_conversation
    Error    : Table 'mboxgroup25.open_conversation' doesn't exist
    error    : Corrupt
    mboxgroup25.pop3_message
    Error    : Table 'mboxgroup25.pop3_message' doesn't exist
    error    : Corrupt
    mboxgroup25.revision
    Error    : Table 'mboxgroup25.revision' doesn't exist
    error    : Corrupt
    mboxgroup25.tombstone
    Error    : Table 'mboxgroup25.tombstone' doesn't exist
    error    : Corrupt
    zimbra.mobile_devices
    Error    : Table 'zimbra.mobile_devices' doesn't exist
    error    : Corrupt
    What's the best method of fixing this?

    Thanks!

    jimbo
    Last edited by jimbo; 10-26-2009 at 09:09 PM.

  2. #2
    dcampbell is offline Member
    Join Date
    Jun 2009
    Posts
    10
    Rep Power
    6

    Default

    Ever figure this out?

  3. #3
    RaNd is offline Active Member
    Join Date
    Feb 2007
    Location
    Greece
    Posts
    27
    Rep Power
    8

    Default

    Same errors here, while upgrading from 4.5.11 to 5.0.21 on Ubuntu 6.06

  4. #4
    uxbod's Avatar
    uxbod is offline Moderator
    Join Date
    Nov 2006
    Location
    UK
    Posts
    8,017
    Rep Power
    24

    Default

    Have you tried performing a mysql table repair ?

  5. #5
    RaNd is offline Active Member
    Join Date
    Feb 2007
    Location
    Greece
    Posts
    27
    Rep Power
    8

    Default

    In my case all tables are ok.
    And when i tried to repair "Table 'mboxgroup25.pop3_message" returned table not found...

  6. #6
    RaNd is offline Active Member
    Join Date
    Feb 2007
    Location
    Greece
    Posts
    27
    Rep Power
    8

    Default

    Also tried 5.0.20 and problem persists...

    Any ideas about how to remove/repair these tables ??

  7. #7
    jimbo is offline Special Member
    Join Date
    Nov 2005
    Posts
    108
    Rep Power
    9

    Default

    In my case I had gotten the mboxgroupXX.pop3_message table not found as well.
    I think what had happened in my case was that an upgrade had failed and instead of blowing away the entire /opt/zimbra directory structure I just restored from backup over the existing data. This left some mysql file directories that did not appear in the original schema and hence the errors.

    Procede at your own risk!!! Make sure you have a good backup!!!

    I cannot stress that enough!!

    So the fix for me was (having a GOOD BACKUP) deleting the table diretories that are missing in /opt/zimbra/db/data/ such as mboxgroup25/pop3_message.*

    Then run the repair on the database and when you have no errors you should be able to upgrade successfully.

    Hope this helps.

    jimbo

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Errors installing Outlook Connector
    By Tim G in forum Zimbra Connector for Outlook
    Replies: 57
    Last Post: 05-05-2011, 02:27 PM
  2. Problems installing ZCS connector for Outlook
    By Millburn357 in forum Zimbra Connector for Outlook
    Replies: 18
    Last Post: 11-25-2009, 10:07 AM
  3. Outlook 03 - Connector Issue
    By Sonny Ali in forum Zimbra Connector for Outlook
    Replies: 9
    Last Post: 09-06-2007, 10:35 AM
  4. Error Installing Outlook Connector
    By DanO in forum Zimbra Connector for Outlook
    Replies: 17
    Last Post: 08-28-2007, 09:35 AM
  5. Can't uninstall or reinstall Outlook Connector
    By Kavey1978 in forum Zimbra Connector for Outlook
    Replies: 5
    Last Post: 08-16-2007, 10:19 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
  •