Results 1 to 3 of 3

Thread: Database Errors During Integrity Checks

  1. #1
    Paul Csiki is offline Active Member
    Join Date
    Apr 2012
    Posts
    43
    Rep Power
    3

    Default Database Errors During Integrity Checks

    Hello,

    I've been using zimbra for quite a while now and I keep getting these email reports that there are errors during the mysql integrity check:

    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.general_log
    Error : You can't use locks with log tables.
    mysql.slow_log
    Error : You can't use locks with log tables.
    Anything I can to fix these?

    Thank You,
    Paul Csiki.

  2. #2
    chauvetp is offline Elite Member
    Join Date
    Apr 2008
    Location
    New Paltz, NY
    Posts
    313
    Rep Power
    7

    Default

    I'm assuming this has been happening since updating from a previous version to a 7.x version? If so, see the below forum post:

    [SOLVED] Database errors found after migration to 7.0.0

    P.S. Googling for (or searching the forum for) Zimbra and "You can't use locks with log tables" gets a lot of results, most/all of which point to the solution.
    ---
    Paul Chauvet
    State University of New York at New Paltz

  3. #3
    LMStone's Avatar
    LMStone is offline Moderator
    Join Date
    Sep 2006
    Location
    477 Congress Street | Portland, ME 04101
    Posts
    1,367
    Rep Power
    10

    Default

    Other threads here indicate that Zimbra believe this to be a MySQL bug; entirely benign.

    So long as you have only two errors for just the log tables, then your MySQL is OK (though you may have fragmented tables).

    Hope that helps,
    Mark

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Errors in Database Integrity check
    By Web Hosting in forum Administrators
    Replies: 4
    Last Post: 04-30-2012, 04:15 AM
  2. [SOLVED] database integrity check shows errors
    By alto in forum Administrators
    Replies: 6
    Last Post: 09-10-2011, 06:16 AM
  3. Database integrity check
    By mludwig in forum Administrators
    Replies: 4
    Last Post: 08-15-2011, 02:56 AM
  4. Replies: 2
    Last Post: 08-18-2008, 02:43 PM
  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
  •