Database errors found.

[rolandCA]

I have received the following error in my 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=****************
zimbra.jiveUserProp
warning : 1 client is using or hasn't closed the table properly

3 days ago we had a power outage and the server lost its power. Is there anything I should do ?

#######################
zimbra@mail:~$ zmcontrol -v


Release 5.0.11_GA_2695.UBUNTU6 UBUNTU6 NETWORK edition

zimbra@mail:~$ uname -a
Linux mail.domain.com 2.6.15-51-server #1 SMP Tue Feb 12 17:12:18 UTC 2008 i686 GNU/Linux

[uxbod]

Welcome to the forums

Have a look in /opt/zimbra/db/data/hostname.err for any error messages. You then may need to follow Wiki :: MySQL Crash Recovery if you cannot just repair the databases.

[rolandCA]

hi, thanks for reply. I dont have the /opt/zimbra/db/data/hostname.err

zimbra@mail:~$ ls /opt/zimbra/db/data/
backup mboxgroup2 mboxgroup34 mboxgroup49 mboxgroup63 mboxgroup78 mboxgroup92
ib_logfile0 mboxgroup20 mboxgroup35 mboxgroup5 mboxgroup64 mboxgroup79 mboxgroup93
ib_logfile1 mboxgroup21 mboxgroup36 mboxgroup50 mboxgroup65 mboxgroup8 mboxgroup94
ibdata1 mboxgroup22 mboxgroup37 mboxgroup51 mboxgroup66 mboxgroup80 mboxgroup95
mboxgroup1 mboxgroup23 mboxgroup38 mboxgroup52 mboxgroup67 mboxgroup81 mboxgroup96
mboxgroup10 mboxgroup24 mboxgroup39 mboxgroup53 mboxgroup68 mboxgroup82 mboxgroup97
mboxgroup100 mboxgroup25 mboxgroup4 mboxgroup54 mboxgroup69 mboxgroup83 mboxgroup98
mboxgroup11 mboxgroup26 mboxgroup40 mboxgroup55 mboxgroup7 mboxgroup84 mboxgroup99
mboxgroup12 mboxgroup27 mboxgroup41 mboxgroup56 mboxgroup70 mboxgroup85 mysql
mboxgroup13 mboxgroup28 mboxgroup42 mboxgroup57 mboxgroup71 mboxgroup86 test
mboxgroup14 mboxgroup29 mboxgroup43 mboxgroup58 mboxgroup72 mboxgroup87 zimbra
mboxgroup15 mboxgroup3 mboxgroup44 mboxgroup59 mboxgroup73 mboxgroup88
mboxgroup16 mboxgroup30 mboxgroup45 mboxgroup6 mboxgroup74 mboxgroup89
mboxgroup17 mboxgroup31 mboxgroup46 mboxgroup60 mboxgroup75 mboxgroup9
mboxgroup18 mboxgroup32 mboxgroup47 mboxgroup61 mboxgroup76 mboxgroup90
mboxgroup19 mboxgroup33 mboxgroup48 mboxgroup62 mboxgroup77 mboxgroup91

[uxbod]

Are you in a position where you can completely shutdown ZCS and restart it ? Once that has been done check your logfiles for any error messages.

[rolandCA]

thanks for the help but I would prefer not to reboot it if not absolutely necessary. Additionally I do have an error message as in my original post.

quote**
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=****************
zimbra.jiveUserProp
warning : 1 client is using or hasn't closed the table properly
**quote

Is this message so cryptic and obscure that noone is able to decipher? I would think that someone else has come across it.

For now the queue is empty and email is being delivered but I would appreciate any insight into the problem.

[uxbod]

Okay, if you want to check that table you can do

su - zimbra
/opt/zimbra/mysql/bin/mysql --defaults-file=/opt/zimbra/conf/my.cnf -S /opt/zimbra/db/mysql.sock -A -C -s -u root --password=*****
> use zimbra;
> check table jiveUserProp;
> repair table jiveUserProp;

I would recommend you take a backup first though! and you can get the password using

su - zimbra
zmlocalconfig -s | grep -i mysql