Results 1 to 5 of 5

Thread: [SOLVED] Database errors - table didn't close properly

  1. #1
    Join Date
    Nov 2008
    Posts
    237
    Rep Power
    7

    Default [SOLVED] Database errors - table didn't close properly

    Hello,

    Finally I installed zimbra, I check my email today, I noticed the following 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={password]
    zimbra.jiveID
    warning : 1 client is using or hasn't closed the table properly
    What does mean it? is there any thing I supposed to do it?

    Cheers,
    Last edited by uxbod; 04-06-2009 at 01:27 AM.

  2. #2
    Join Date
    Nov 2006
    Location
    UK
    Posts
    8,017
    Rep Power
    25

    Default

    You can just run a repair table on it and that should resolve the problem.

  3. #3
    Join Date
    Nov 2008
    Posts
    237
    Rep Power
    7

    Default

    Is there any command to do it? how do I repair it?

    Thank you

  4. #4
    Join Date
    Nov 2006
    Location
    UK
    Posts
    8,017
    Rep Power
    25

    Default

    Code:
    su - zimbra
    mysql
    use zimbra
    repair table jiveID
    I have also removed your MySQL password from the previous post

  5. #5
    Join Date
    Nov 2008
    Posts
    237
    Rep Power
    7

    Default

    Quote Originally Posted by uxbod View Post
    Code:
    su - zimbra
    mysql
    use zimbra
    repair table jiveID
    I have also removed your MySQL password from the previous post
    Thank you my dear for cooperation and taking care of this matter

    Cheers,

Similar Threads

  1. Database errors
    By dljordaneku in forum Administrators
    Replies: 5
    Last Post: 10-30-2008, 07:22 AM
  2. Replies: 1
    Last Post: 06-09-2008, 08:55 PM
  3. Database errors found. now?
    By maumar in forum Installation
    Replies: 5
    Last Post: 04-02-2008, 06:13 AM
  4. zmdbintegrityreport errors after 4.5.7 upgrade
    By jdell in forum Administrators
    Replies: 1
    Last Post: 09-24-2007, 10:53 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
  •