Results 1 to 5 of 5

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

  1. #1
    snake_eyes's Avatar
    snake_eyes is offline Advanced Member
    Join Date
    Nov 2008
    Posts
    237
    Rep Power
    6

    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 12:27 AM.

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

    Default

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

  3. #3
    snake_eyes's Avatar
    snake_eyes is offline Advanced Member
    Join Date
    Nov 2008
    Posts
    237
    Rep Power
    6

    Default

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

    Thank you

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

    Default

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

  5. #5
    snake_eyes's Avatar
    snake_eyes is offline Advanced Member
    Join Date
    Nov 2008
    Posts
    237
    Rep Power
    6

    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,

Thread Information

Users Browsing this Thread

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

Similar Threads

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