Database errors

Discuss your pilot or production implementation with other Zimbra admins or our engineers.
dljordaneku
Outstanding Member
Outstanding Member
Posts: 234
Joined: Fri Sep 12, 2014 10:44 pm

Database errors

Postby dljordaneku » Mon Sep 08, 2008 7:57 am

When my database check ran last night, it came back with the following errors.
[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=(REMOVED)

zimbra.jiveID

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

zimbra.jiveOffline

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

zimbra.jiveProperty

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[/QUOTE]
please help :)
dj


dljordaneku
Outstanding Member
Outstanding Member
Posts: 234
Joined: Fri Sep 12, 2014 10:44 pm

Database errors

Postby dljordaneku » Mon Sep 08, 2008 1:02 pm

Any idea on where to look first? Which log file?
dj
dljordaneku
Outstanding Member
Outstanding Member
Posts: 234
Joined: Fri Sep 12, 2014 10:44 pm

Database errors

Postby dljordaneku » Tue Sep 09, 2008 7:16 am

I have users that are unable to use the IM and I was wondering if this is related. I guess they can use it but sometimes their buddy list disappears. I was showing a user yesterday the IM part of Zimbra and she went in and sent a bunch of request out. She clicked back over to the mail tab and when she came back, all of her request were gone.
Can I use the CLI to turn the IM back off and then back on to fix this database issue?
dj
tim brennan
Advanced member
Advanced member
Posts: 93
Joined: Fri Sep 12, 2014 9:55 pm

Database errors

Postby tim brennan » Wed Oct 29, 2008 11:05 am

What version of ZCS are you running?
uxbod
Ambassador
Ambassador
Posts: 7811
Joined: Fri Sep 12, 2014 10:21 pm

Database errors

Postby uxbod » Wed Oct 29, 2008 11:15 am

Tim, looks like 5.0.8 in the profile. Please post
su - zimbra

zmcontrol -v
dljordaneku
Outstanding Member
Outstanding Member
Posts: 234
Joined: Fri Sep 12, 2014 10:44 pm

Database errors

Postby dljordaneku » Thu Oct 30, 2008 8:22 am

[quote user="uxbod"]Tim, looks like 5.0.8 in the profile. Please post
su - zimbra

zmcontrol -v
[/QUOTE]
It is 5.08 but everything seems to be working now. We had some filestorage issues after all of that and it when I ran a DB fix on those everything else seems to be working also.
My next question is that if the check doesn't detect any errors will send out an email?
dj

Return to “Administrators”

Who is online

Users browsing this forum: MSN [Bot] and 12 guests