database errors found

Discuss your pilot or production implementation with other Zimbra admins or our engineers.
4610silbro
Posts: 46
Joined: Fri Sep 12, 2014 11:19 pm

database errors found

Postby 4610silbro » Mon Jul 30, 2012 6:39 am

Hi all
I get this error message
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=.................................

backup.shared_blob_digest

warning : 1 client is using or hasn't closed the table properly

command failed

I have read the forum about how this is a bug of mysql. All I'm worried about is

warning  : 1 client is using or hasn't closed the table properly


Is this also part of the mysql bug or do I need to be worried about that message? (I'm just a bit worried because we had a Database crash recently where I had to restore the whole Zimbra.)
Thanks in advance for your answers.


phoenix
Ambassador
Ambassador
Posts: 26677
Joined: Fri Sep 12, 2014 9:56 pm
Location: Liverpool, England

database errors found

Postby phoenix » Mon Jul 30, 2012 6:49 am

A forum search will give you all the information you need.
Regards

Bill

Rspamd: A high performance spamassassin replacement

Per ardua ad astra
4610silbro
Posts: 46
Joined: Fri Sep 12, 2014 11:19 pm

database errors found

Postby 4610silbro » Mon Jul 30, 2012 7:17 am

Thanks already :)
But I actually tried to check the table backup.shared_blob_digest and table shared_blob_digest and they both dont exist. Should I open a ticket ?
yekski389
Posts: 4
Joined: Sat Sep 13, 2014 2:58 am

database errors found

Postby yekski389 » Mon Nov 05, 2012 7:52 am

Hi,
I'm new here and new in zimbra.

Without doing anything on the server, I got the following error message. Should I be worried? How can I fix this.
I'm using:

Zimbra 8 Open Source

Centos 6.3
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=XXXXXXXX

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
phoenix
Ambassador
Ambassador
Posts: 26677
Joined: Fri Sep 12, 2014 9:56 pm
Location: Liverpool, England

database errors found

Postby phoenix » Mon Nov 05, 2012 8:08 am

[quote user="yekski389"]Without doing anything on the server, I got the following error message. Should I be worried? How can I fix this.[/QUOTE]See the answer in post #2.
Regards

Bill

Rspamd: A high performance spamassassin replacement

Per ardua ad astra
yekski389
Posts: 4
Joined: Sat Sep 13, 2014 2:58 am

database errors found

Postby yekski389 » Wed Nov 07, 2012 9:25 pm

thanks.
but im no longer receiving the error. should i still try running the commands?

Return to “Administrators”

Who is online

Users browsing this forum: No registered users and 13 guests