Page 1 of 3 123 LastLast
Results 1 to 10 of 21

Thread: [SOLVED] Database Integrity Check Report

  1. #1
    sdrury is offline Special Member
    Join Date
    Aug 2008
    Location
    Brisbane, Australia
    Posts
    168
    Rep Power
    6

    Exclamation [SOLVED] Database Integrity Check Report

    This is for my home ZCS 7.0.0 FOSS system which was upgraded from 6.0.10 last week.

    This morning my admin account received this database report which I have seen before but this time it contains (this is just a sample of the email):

    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=xxxxxxxxxxxx
    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

    and more.....

    What is this about? The upgrade ran fine with no errors as far as I know.
    Is there something that needs to be run to fix this?

    Regards,
    Sean.

  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 sdrury View Post
    What is this about?
    It's about the fact your tables need to be upgraded.

    Quote Originally Posted by sdrury View Post
    The upgrade ran fine with no errors as far as I know.
    Is there something that needs to be run to fix this?
    You need to run an update script, full details of the script and it's location are in the Release Notes.
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  3. #3
    sdrury is offline Special Member
    Join Date
    Aug 2008
    Location
    Brisbane, Australia
    Posts
    168
    Rep Power
    6

    Default

    Thanks Bill - I didn't see that section as it is located straight after the multi-server upgrade section (which doesn't apply to me).

    Regards,
    Sean.

  4. #4
    mmorse's Avatar
    mmorse is offline Moderator
    Join Date
    May 2006
    Location
    USA
    Posts
    6,242
    Rep Power
    20

    Default

    Marking solved.

    MySQL table upgrade is required after upgrading to ZCS 7.0. MySQL table upgrades are not automatically run during the upgrade to 7.0 based on time that it takes this process to run. There are no known performance impacts of running in production without doing this MySQL table upgrade.

    Customers can avoid these errors in the zmdbintegrityreport output by executing /opt/zimbra/libexec/scripts/migrate20100913-Mysql51.pl 

    For a 4000 mailbox, 250 MB mailbox size, the script could take about 70 minutes to run. Customers should schedule their maintenance window accordingly. (Bug 24329, 50557)

  5. #5
    sdrury is offline Special Member
    Join Date
    Aug 2008
    Location
    Brisbane, Australia
    Posts
    168
    Rep Power
    6

    Default

    Database integrity report from last night shows the following - what does this mean?

    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=*********
    mysql.general_log
    Error : You can't use locks with log tables.
    mysql.slow_log
    Error : You can't use locks with log tables.

  6. #6
    d2globalinc's Avatar
    d2globalinc is offline Special Member
    Join Date
    May 2008
    Location
    Nebraska, USA
    Posts
    100
    Rep Power
    6

    Thumbs down

    Yeah - I ALSO did not see this anywhere, this should be alerted too when doing the upgrade from the install script itself.. If it is it sure wasn't noticeable by me.

    Then the fact the server has been up and running for a week and I just get notified of it today..

    Is it OK to let this go until I can schedule downtime afterhours - or is this something that I need to take the server down during normal operations for?
    - SLM -

  7. #7
    borngunners is offline Advanced Member
    Join Date
    Jun 2009
    Posts
    195
    Rep Power
    5

    Default

    Just had the same message after a week of upgrade... What are the consequences if I don't run the command mentioned above during normal operations today? Also, do you have to run the command as root or as zimbra user?

  8. #8
    Dirk's Avatar
    Dirk is offline Moderator
    Join Date
    May 2006
    Location
    England.
    Posts
    927
    Rep Power
    9

    Default

    It's not just me then?
    I got this same email from the system last night at 11pm so I logged a support call regarding it as it looked kinda serious.

    I've not heared a whisper from support yet but looking at this thread it seems to be a known issue, my obvious question then would be why didnt the installer take care of this during the upgrade? I appreciate Mike's comment above that it may take a while to run, but our server only has ~50 accounts on it, not 4000 and if it needs doing, I'd expect the server to run the script as part of the update.

    My own fault for not reading the documentation before doing the upgrade I guess, but I thought I knew how these worked by now!

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

    Default

    Quote Originally Posted by borngunners View Post
    Just had the same message after a week of upgrade... What are the consequences if I don't run the command mentioned above during normal operations today? Also, do you have to run the command as root or as zimbra user?
    The error messages in post #5 are not a consequence of running, or not running, the upgrade script. If you mean the messages in post #1 they are also harmless. Both sets of messages can be ignored but you should, however, run the table upgrade script.
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  10. #10
    Dirk's Avatar
    Dirk is offline Moderator
    Join Date
    May 2006
    Location
    England.
    Posts
    927
    Rep Power
    9

    Default

    The documentaion does not state that this needs to be done with the server up or down, or even which user the command should be executed as.
    http://files.zimbra.com/website/docs...otes%207.0.pdf bottom of page 19


    so I've ran the script as myself which gave a load of errors (expected really) so it's now running as root with the server up. Let's hope it breaks nothing.

Page 1 of 3 123 LastLast

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Mailserver down when send file attach of 50Mb
    By ZMilton in forum Administrators
    Replies: 20
    Last Post: 04-10-2008, 11:44 AM
  2. [SOLVED] Database Integrity check report question
    By k7sle in forum Administrators
    Replies: 3
    Last Post: 02-07-2008, 09:53 AM
  3. [SOLVED] Database Integrity check report
    By cedbl in forum Administrators
    Replies: 9
    Last Post: 02-06-2008, 02:11 PM
  4. Database Integrity check report contains nothing
    By dljordaneku in forum Administrators
    Replies: 4
    Last Post: 12-17-2007, 11:28 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
  •