Results 1 to 10 of 10

Thread: [SOLVED] Database Integrity check report

  1. #1
    cedbl is offline Senior Member
    Join Date
    Oct 2006
    Posts
    69
    Rep Power
    8

    Exclamation [SOLVED] Database Integrity check report

    Hi receive for the first time this email
    what i have to do?

    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.help_category
    error : Table upgrade required. Please do "REPAIR TABLE `help_category`" to fix it!
    mysql.help_keyword
    error : Table upgrade required. Please do "REPAIR TABLE `help_keyword`" to fix it!
    mysql.help_topic
    error : Table upgrade required. Please do "REPAIR TABLE `help_topic`" to fix it!
    mysql.user
    error : Table upgrade required. Please do "REPAIR TABLE `user`" to fix it!
    zimbra.config
    error : Table upgrade required. Please do "REPAIR TABLE `config`" to fix it!
    zimbra.mailbox_metadata
    error : Table upgrade required. Please do "REPAIR TABLE `mailbox_metadata`" to fix it!
    zimbra.out_of_office
    error : Table upgrade required. Please do "REPAIR TABLE `out_of_office`" to fix it!
    zimbra.service_status
    error : Table upgrade required. Please do "REPAIR TABLE `service_status`" to fix it!
    zimbra.table_maintenance
    error : Table upgrade required. Please do "REPAIR TABLE `table_maintenance`" to fix it!
    zimbra.volume
    error : Table upgrade required. Please do "REPAIR TABLE `volume`" to fix it!

    Friday 1 Feb i upgrade from FOSS 4.5.1 to 4.5.10
    in the upgrade script the verify integrity was ok
    i finished migration and all was ok at 20.00 o clock.

    Saturday i did not receive Database Integrity check report
    Today is monday (4 Feb ) and i recive this email with
    this time 03/02/2008 23.01
    zimbra was working now but i don't know what i have to do

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

    Default

    The upgrade will have done a check & repair on the database.
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  3. #3
    cedbl is offline Senior Member
    Join Date
    Oct 2006
    Posts
    69
    Rep Power
    8

    Default

    I don't understand:

    The upgrade
    will do
    or have just done

    a check & repair on the database

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

    Default

    The upgrade has done a check on the db. If you want to make sure that it's OK look in the /opt/zimbra/logger/db/data/yourservername.com.err log (obviously put the fqdn of your server instead of 'yourservername.com' in there) and see if there's any errors. The db integrity report runs overnight and if there's any erros you should have seen them. If you want to confirm that it's OK the run this /opt/zimbra/libexec/zmdbintegrityreport -m as the zimbra user and see if there's any errors (that script also logs to the file I mentioned above.

    Does that answer your question?
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  5. #5
    cedbl is offline Senior Member
    Join Date
    Oct 2006
    Posts
    69
    Rep Power
    8

    Exclamation

    Quote Originally Posted by phoenix View Post
    look in the /opt/zimbra/logger/db/data/yourservername.com.err log (obviously put the fqdn of your server instead of 'yourservername.com' in there) and see if there's any errors.
    there is a file mail.err but i don't find some like mail.mydomain.com.err
    ls -la on this file give me today date 5 feb 11.52
    Quote Originally Posted by phoenix View Post
    The db integrity report runs overnight and if there's any erros you should have seen them. If you want to confirm that it's OK the run this /opt/zimbra/libexec/zmdbintegrityreport -m as the zimbra user and see if there's any errors (that script also logs to the file I mentioned above.
    i don't receive any message at the prompt but i receive this mail
    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="mypassoword"
    mysql.help_category
    error : Table upgrade required. Please do "REPAIR TABLE `help_category`" to fix it!
    mysql.help_keyword
    error : Table upgrade required. Please do "REPAIR TABLE `help_keyword`" to fix it!
    mysql.help_topic
    error : Table upgrade required. Please do "REPAIR TABLE `help_topic`" to fix it!
    mysql.user
    error : Table upgrade required. Please do "REPAIR TABLE `user`" to fix it!
    zimbra.config
    error : Table upgrade required. Please do "REPAIR TABLE `config`" to fix it!
    zimbra.mailbox_metadata
    error : Table upgrade required. Please do "REPAIR TABLE `mailbox_metadata`" to fix it!
    zimbra.out_of_office
    error : Table upgrade required. Please do "REPAIR TABLE `out_of_office`" to fix it!
    zimbra.service_status
    error : Table upgrade required. Please do "REPAIR TABLE `service_status`" to fix it!
    zimbra.table_maintenance
    error : Table upgrade required. Please do "REPAIR TABLE `table_maintenance`" to fix it!
    zimbra.volume
    error : Table upgrade required. Please do "REPAIR TABLE `volume`" to fix it!

    now after /opt/zimbra/libexec/zmdbintegrityreport -m as the zimbra user if i do ls -la mail.err i have the same date 5 feb 11.52 as before to give the command

  6. #6
    peng1can is offline Senior Member
    Join Date
    Aug 2007
    Location
    Indianapolis
    Posts
    54
    Rep Power
    7

    Default

    Is your hostname "mail"? That may be why your file is just called mail.err. I don't know if mysql just uses the value of hostname variable, but if you type "hostname" at a shell prompt does it simply say "mail"? If so, you might want to fix that in your OS so that it's a FQDN. In any case, I'm sure this is probably the correct file.

    I don't think running the integrity report will affect the .err file... this will be continuously updated by mysql. Look at the contents of the file. Is it complaining about corrupted tables and such? If so (and well, from the content of the email you received), your tables probably are indeed corrupted and need repaired. Did you run out of disk space recently or anything like that? That's one cause I've seen for table corruption.

    I believe the correct fix is to do as the directions indicate and run the repair table commands via the mysql command line. I've only done this with the logger tables, so I'll let someone more experienced comment on what precautions you might need to take on these tables. In any case, make sure those backups have been running!

  7. #7
    cedbl is offline Senior Member
    Join Date
    Oct 2006
    Posts
    69
    Rep Power
    8

    Default

    Hi
    Th
    yes my server name is mail
    but in my /etc/hosts i have fqdn before
    yes the first time i start this server i had only 2G Ram and so i stop zimbra i enlarge my ram to 3G and then restart my OS and zimbra
    how can i run the repair table commands via the mysql command line?

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

    Default

    zmdbintegrityreport -v
    zmdbintegrityreport -r
    (located in /opt/zimbra/libexec/)
    v will give some verbose output & r is repair
    please make sure you have a backup as well...

  9. #9
    cedbl is offline Senior Member
    Join Date
    Oct 2006
    Posts
    69
    Rep Power
    8

    Smile

    Quote Originally Posted by mmorse View Post
    zmdbintegrityreport -v
    same message at prompt as above
    Quote Originally Posted by mmorse View Post
    zmdbintegrityreport -r
    the first time same message as above
    the second time some like
    "Generate report
    no error"


    then i do zmdbintegrityreport -m and i received an email with object "Database Integrity check report" and body clean

    now i think my zimbra is fine isn't it?

    Could you give me some information about the command "zmdbintegrityreport"
    what are the valid options?
    I look in the wiki in the forum and in pdf doc for zimbra 4.5 but i don't find these informations. I know perhaps i could do zmdbintegrityreport -? os similar but for the moment i prefer to wait i come from a critical situation!!

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

    Default

    Yup, if you got a blank email you should be set -it's a bug, future versions will send an 'all ok' status in that email.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Data Integrity check report Blank?
    By sel5150 in forum Installation
    Replies: 6
    Last Post: 04-04-2008, 10:51 AM
  2. Run Database Integrity Check or Skip during Upgrade?
    By soxfan in forum Administrators
    Replies: 8
    Last Post: 01-26-2008, 12:37 AM
  3. Database Integrity check report contains nothing
    By dljordaneku in forum Administrators
    Replies: 4
    Last Post: 12-17-2007, 11:28 AM
  4. 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
  •