[SOLVED] Database Integrity check report

[cedbl]

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

[phoenix]

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

[cedbl]

I don't understand:

The upgrade
will do
or have just done

a check & repair on the database

[phoenix]

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?

[cedbl]

Originally Posted by phoenix

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

Originally Posted by phoenix

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

[peng1can]

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!

[cedbl]

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?

[mmorse]

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...

[cedbl]

Originally Posted by mmorse

zmdbintegrityreport -v

same message at prompt as above

Originally Posted by mmorse

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!!

[mmorse]

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.