Database errors found. now?

[maumar]

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=P4F.87begMuVgNOKvoAJzkL6ve6 --auto-repair
mysql.db
warning : 2 clients are using or haven't closed the table properly
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!

Checking for installable packages

Found zimbra-core
Found zimbra-ldap
Found zimbra-logger
Found zimbra-mta
Found zimbra-snmp
Found zimbra-store
Found zimbra-apache
Found zimbra-spell


The Zimbra Collaboration Suite appears already to be installed.
It can be upgraded with no effect on existing accounts,
or the current installation can be completely removed prior
to installation for a clean install.

Do you wish to upgrade? [Y] N

*** WARNING - you are about to delete all existing users and mail

Delete users/mail? [N]

Do you wish to upgrade? [Y]

Now??
what shoul i do??
if i answer Y .what next? system will be upgraded?
i tried to answer no and i get a terrible:
*** WARNING - you are about to delete all existing users and mail

Please any help will be very apreciated
TIA

[flavio]

Do you want to verify message store database integrity? [Y]
Verifying integrity of message store databases. This may take a while.
Starting mysqld daemon with databases from /opt/zimbra/db/data
mysqld is alive
Generating report
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=NBHrySp9ISR_ILPzM38FiSnq --auto-repair
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!

Checking for installable packages

Found zimbra-core
Found zimbra-ldap
Found zimbra-logger
Found zimbra-mta
Found zimbra-snmp
Found zimbra-store
Found zimbra-apache
Found zimbra-spell


The Zimbra Collaboration Suite appears already to be installed.
It can be upgraded with no effect on existing accounts,
or the current installation can be completely removed prior
to installation for a clean install.

Do you wish to upgrade? [Y]

[KirkIsmay]

Anyone know what to do here?

I tried to run "repair table xxx" from the mysql shell, this is what I got:
mysql> REPAIR TABLE config;
+---------------+--------+----------+---------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+---------------+--------+----------+---------------------------------------------------------+
| zimbra.config | repair | note | The storage engine for the table doesn't support repair |
+---------------+--------+----------+---------------------------------------------------------+
1 row in set (0.00 sec)

[jholder]

Hi guys-
Sorry I didn't reply to this sooner.

The error can be safely ignored. Once you proceed, the upgrade script will call mysql_upgrade with the right parameters. This will fix the problem.

Hope that helps,
john

[Mark Daniel]

I'm getting what they were getting... is this still safe to ignore?

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=YABG1Sy6x1.20BPnVihAQTvAAATQSfg_
zimbra.jiveID
warning : 1 client is using or hasn't closed the table properly
zimbra.jiveRoster
warning : 1 client is using or hasn't closed the table properly
zimbra.jiveRosterGroups
warning : 1 client is using or hasn't closed the table properly
zimbra.jiveUserProp
warning : 1 client is using or hasn't closed the table properly

Only anomaly is that zimbra seems to be randomly "forgetting" my new HTML signature, and reverting back to the plaintext version I had before updating from 5.0.1 to 5.0.3.

I'm getting these errors, btw, in database integrity check emails to the administrator. I see they're referring to Jive, which isn't that critical... but still a bit worrisome.

[carlsanders]

Greetings...

If you're nervous and want to do a full backup first, read on...

Zimbra does its own thing, all out of /opt/zimbra, even on a mac.
So, if you stop zimbra, and make sure that the database, and http
are also stopped, then you can back up the /opt/zimbra
directory structure and that'll cover things well.

You can use:

cd /opt; tar czf zimbra.20080401.tar.gz zimbra

to make a big, compressed backup.

Or, if you like, you can use rsync (remote synchronize):

cd /opt; rsync -avz zimbra /tmp

to make a complete copy in your local /tmp directory,
or you can use rsync to another system:

cd /opt; rsync -avz zimbra username@someotherinternalsystem:/var/tmp

You get the idea. Just make sure all of the services are stopped first.
The mysql database is great in that if it's stopped, backing up all of the
files is the equivalent of backing up the database.

Hope this helps.