Database Integrity check report

[163828045]

Hello,
I have recived the following 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=XXXXXXXXXXX
mysql.db
warning : 1 client is using or hasn't closed the table properly
mysql.user
warning : 1 client is using or hasn't closed the table properly
zimbra.jiveID
warning : 1 client is using or hasn't closed the table properly
zimbra.jiveUserProp
warning : 2 clients are using or haven't closed the table properly
zimbra.jiveVersion
warning : 1 client is using or hasn't closed the table properly

Any ideias how i can fix this?

Thanks

[uxbod]

if you connect with MySQL and those parameters you can then

show tables;
check table {for each table reported above and if any fail}
repair table {table name}

[163828045]

Hello,
Will try that, and post the results.

Thanks

[163828045]

Hello,
I have runned the following commands,

mysql> CHECK TABLE jiveUserProp EXTENDED;
+---------------------+-------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+---------------------+-------+----------+----------+
| zimbra.jiveUserProp | check | status | OK |
+---------------------+-------+----------+----------+
1 row in set (0.00 sec)

mysql> CHECK TABLE jiveID EXTENDED;
+---------------+-------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+---------------+-------+----------+----------+
| zimbra.jiveID | check | status | OK |
+---------------+-------+----------+----------+
1 row in set (0.00 sec)

mysql> CHECK TABLE jiveVersion EXTENDED;
+--------------------+-------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+--------------------+-------+----------+----------+
| zimbra.jiveVersion | check | status | OK |
+--------------------+-------+----------+----------+
1 row in set (0.00 sec)

mysql> CHECK TABLE mysql.db EXTENDED;
+----------+-------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+----------+-------+----------+----------+
| mysql.db | check | status | OK |
+----------+-------+----------+----------+
1 row in set (0.01 sec)

mysql>

And it looks like no errors have been found, is this normal?

Thanks

[uxbod]

If the tables are all okay, and you can afford a short downtime period, then you could shutdown ZCS and run

myisamchk --update-state {ZCS DataPath/*.MYI}

[163828045]

when you say ZCS DataPath you are refering to /opt/zimbra?

Thanks

[uxbod]

Yes where the MySQL datafiles are stored for ZCS.

[163828045]

So it should be
/opt/zimbra/db/data
or do i need to insert the zimbra folder also?
/opt/zimbra/db/data/zimbra

Thanks

[uxbod]

You need to specify the full path to where the MYI files are held.

[163828045]

Systems says mysql not installed,i also have tried to rum as zimbra user but no luck.
Any other way?

Thanks