Results 1 to 3 of 3

Thread: Database errors found - can't use locks with log tables

  1. #1
    yasanthau is offline Active Member
    Join Date
    Nov 2009
    Posts
    38
    Rep Power
    5

    Default Database errors found - can't use locks with log tables

    Dear All,

    I observed a regular email on the zimbra admin mail account with the subject "Database Integrity check report for mail.domain.com". Following is the content of that email. Is it a critical issue? What steps can be taken to resolve it? Zimbra version is 7. Thanks in advance

    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=TNZjj8IlXCK6_xOIxEK7bC55UFtxN
    mysql.general_log
    Error : You can't use locks with log tables.
    mysql.slow_log
    Error : You can't use locks with log tables.

  2. #2
    phoenix is online now Zimbra Consultant & Moderator
    Join Date
    Sep 2005
    Location
    Vannes, France
    Posts
    23,582
    Rep Power
    57

    Default

    Quote Originally Posted by yasanthau View Post
    What steps can be taken to resolve it? Zimbra version is 7.
    This subject has been covered several times (at least) in the forums, search the forums and/or bugzilla for the error message.
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  3. #3
    661
    661 is offline Junior Member
    Join Date
    Aug 2012
    Posts
    9
    Rep Power
    3

    Default

    Created a patch for this some might find useful. Please to enjoy...

    Code:
      unless (open(CMD, "$cmd --password=${mysql_root_passwd} |")) {
        addToReport("can't run $cmd: $!\n");
        return undef;
      }
      my @output = <CMD>;
    
    ############################################
    # BEGIN FILTER PATCH - zmbdintegrityreport
    # If the ouput of mysqlcheck is the following, and ONLY the following, it
    # may be safely ignored; so filter it out.  I'm sure there is a more
    # elegant way to do this... but it works.
    
      my $filter = "mysql.general_log\n" .
                   "Error    : You can't use locks with log tables.\n" .
                   "mysql.slow_log\n" .
                   "Error    : You can't use locks with log tables.\n";
    
      my $ouput2str = join("",@output);
    
      if (scalar @output == 4 && $ouput2str eq $filter) { @output = (); }
    
    # END FILTER PATCH
    ############################################
    
    
      if (scalar @output != 0) {
        addToReport("Database errors found.\n");
        addToReport("$cmd --password=XXXXXXXX\n");
        addToReport("@output");
      } else {
        addToReport("No errors found\n") if $verbose;
      }

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. The installer was interrupted...
    By spiderbo in forum Zimbra Connector for Outlook
    Replies: 9
    Last Post: 05-23-2013, 06:33 AM
  2. Database errors found. now?
    By maumar in forum Installation
    Replies: 5
    Last Post: 04-02-2008, 05:13 AM
  3. Replies: 20
    Last Post: 03-18-2008, 05:37 AM
  4. Replies: 2
    Last Post: 10-04-2007, 03:20 PM

Posting Permissions

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