Results 1 to 5 of 5

Thread: Database integrity check

  1. #1
    mludwig is offline Senior Member
    Join Date
    Mar 2008
    Posts
    52
    Rep Power
    7

    Default Database integrity check

    Hi,

    with every db integrity check I get these errors. Maybe somebody knows how this problem can be solved?

    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=123
    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!
     mboxgroup13.appointment
     error    : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
     mboxgroup13.data_source_item
     error    : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
     mboxgroup13.imap_folder
     error    : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
     mboxgroup13.mail_item
     error    : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
     mboxgroup13.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.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!
    Regards,
    Michael

  2. #2
    phoenix is offline Zimbra Consultant & Moderator
    Join Date
    Sep 2005
    Location
    Vannes, France
    Posts
    23,201
    Rep Power
    56

    Default

    Quote Originally Posted by mludwig View Post
    with every db integrity check I get these errors. Maybe somebody knows how this problem can be solved?
    Did you follow the instructions in the Release Notes (you did read them didn't you?) on what you need to do post-upgrade or perhaps search the forums for an answer (it has been answered and involves running a script)?
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  3. #3
    mludwig is offline Senior Member
    Join Date
    Mar 2008
    Posts
    52
    Rep Power
    7

    Default

    Hello phoenix,

    thank you for your tip.
    After executing "/opt/zimbra/libexec/scripts/migrate20100913-Mysql51.pl" it said "Altered 15 mailbox groups in 140 seconds".
    Then I ran the mysql check command "/opt/zimbra/mysql/bin/mysqlcheck --defaults-file=/opt/zimbra/conf/my.cnf -S /opt/zimbra/db/mysql.sock -A -C -s -u root --password=****" and it said

    Code:
    mysql.general_log
    Error    : You can't use locks with log tables.
    mysql.slow_log
    Error    : You can't use locks with log tables.
    Is this okay?

  4. #4
    phoenix is offline Zimbra Consultant & Moderator
    Join Date
    Sep 2005
    Location
    Vannes, France
    Posts
    23,201
    Rep Power
    56

    Default

    That's also been covered in the forums, it's a MySQL bug and it effectively harmless.
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  5. #5
    mludwig is offline Senior Member
    Join Date
    Mar 2008
    Posts
    52
    Rep Power
    7

    Default

    Thank you very much phoenix! ;-)

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Database integrity Check email insecurity?
    By pmavrovic in forum Administrators
    Replies: 7
    Last Post: 02-26-2012, 04:03 PM
  2. Database integrity check error
    By plastilin in forum Administrators
    Replies: 1
    Last Post: 06-29-2011, 02:04 PM
  3. [SOLVED] Database Integrity check report
    By cedbl in forum Administrators
    Replies: 9
    Last Post: 02-06-2008, 02:11 PM
  4. Run Database Integrity Check or Skip during Upgrade?
    By soxfan in forum Administrators
    Replies: 8
    Last Post: 01-26-2008, 12:37 AM
  5. Database Integrity check report: Errors found
    By mcevoys in forum Administrators
    Replies: 8
    Last Post: 12-07-2007, 08:26 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
  •