Results 1 to 6 of 6

Thread: Database errors

  1. #1
    dljordaneku is offline Elite Member
    Join Date
    Sep 2007
    Location
    Richmond, Ky
    Posts
    281
    Rep Power
    7

    Default Database errors

    When my database check ran last night, it came back with the following errors.

    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
    please help

    dj

  2. #2
    dljordaneku is offline Elite Member
    Join Date
    Sep 2007
    Location
    Richmond, Ky
    Posts
    281
    Rep Power
    7

    Default

    Any idea on where to look first? Which log file?

    dj

  3. #3
    dljordaneku is offline Elite Member
    Join Date
    Sep 2007
    Location
    Richmond, Ky
    Posts
    281
    Rep Power
    7

    Default

    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

  4. #4
    tim brennan is offline Zimbra Employee
    Join Date
    Sep 2005
    Posts
    93
    Rep Power
    9

    Default

    What version of ZCS are you running?
    Bugzilla - Wiki - Downloads - Before posting... Search!

  5. #5
    uxbod's Avatar
    uxbod is offline Moderator
    Join Date
    Nov 2006
    Location
    UK
    Posts
    8,017
    Rep Power
    24

    Default

    Tim, looks like 5.0.8 in the profile. Please post
    Code:
    su - zimbra
    zmcontrol -v

  6. #6
    dljordaneku is offline Elite Member
    Join Date
    Sep 2007
    Location
    Richmond, Ky
    Posts
    281
    Rep Power
    7

    Default

    Quote Originally Posted by uxbod View Post
    Tim, looks like 5.0.8 in the profile. Please post
    Code:
    su - zimbra
    zmcontrol -v
    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

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 23
    Last Post: 01-24-2013, 03:44 PM
  2. Replies: 2
    Last Post: 08-18-2008, 02:43 PM
  3. Database errors found. now?
    By maumar in forum Installation
    Replies: 5
    Last Post: 04-02-2008, 05:13 AM
  4. 4.5.10 logger database errors
    By jescombe in forum Administrators
    Replies: 7
    Last Post: 03-16-2008, 12:31 AM
  5. Database Integrity check report: Errors found
    By mcevoys in forum Administrators
    Replies: 8
    Last Post: 12-07-2007, 08:26 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •