Page 4 of 4 FirstFirst ... 234
Results 31 to 39 of 39

Thread: [SOLVED] Error : You can't use locks with log tables (after upgrade to ZCS OSE 7)

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

    Default

    Quote Originally Posted by Frazzled Penguin View Post
    I haven't seen this error yet, but rest assured I would be very upset if my root credentials would appear in an email to me as plain text.
    Then use one of the solutions available in the forums if it bothers you that much.
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  2. #32
    liverpoolfcfan's Avatar
    liverpoolfcfan is offline Outstanding Member
    Join Date
    Oct 2009
    Location
    Dublin, IRELAND
    Posts
    712
    Rep Power
    6

    Default

    Quote Originally Posted by Frazzled Penguin View Post
    I personally think that an warning message that is emailing out your root MySQL password is a critical issue! MySQL bug or not, you can certainly spend a few moments to at least filter it out for your users.
    Seems they have gone to the trouble of spending that "few moments" for release 7.2

    The locks error still exists - but they have masked the password.

    Code:
    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.

  3. #33
    bhwong is offline Outstanding Member
    Join Date
    Feb 2009
    Location
    Singapore
    Posts
    503
    Rep Power
    7

    Default

    Quote Originally Posted by phoenix View Post
    I think you need to read what you've posted earlier.

    I'll say it again, nobody from Zimbra has made such a statement in this thread (or on these forums).
    But someone did make such statement in this thread:

    The product that causes this problem is Open Source (as are most of the ZCS components), you're not paying for Zimbra to fix problems in third party products.

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

    Default

    Quote Originally Posted by bhwong View Post
    But someone did make such statement in this thread:
    I didn't say nobody had made that comment, what I was disagreeing with was your assertion that somebody 'from Zimbra' made that statement and nobody from Zimbra has even posted in this thread.

    If you're talking about my comment earlier then I'm just another person posting here and I'm not 'from Zimbra'. Anyone who posts here does so voluntarily and in their free time, any comments made in these forums are the opinion of the person posting and do not represent official Zimbra (or VMware) policy.

    If you think that your support contract entitles you to demand that Zimbra fixes bugs in third party products then file a report or open a support case, that would be the correct course of action.
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

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

    Default

    Personally, I loath "error" messages that can be safely ignored; so I did something about it.

    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 - zmdbintegrityreport
    # 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 != 0 && $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;
      }

  6. #36
    pup_seba is offline Special Member
    Join Date
    Aug 2012
    Posts
    110
    Rep Power
    3

    Default Thank you

    Quote Originally Posted by fab View Post
    I don't see this as a real MySQL bug, it's just a warning message from the MySQL db engine telling that you can't lock a table whose type (engine) is CSV. I guess Zimbra should either filter the output of zmdbintegrityreport or avoid checking those tables; another viable solution is to remove at all those tables because ZCS doesn't need them (see below to understand why).

    Both general_log and slow_log are CSV-type tables created by default in every MySQL installation into the 'mysql' database but they are used only if you configure MySQL to log into its own database: in this case the error log should end up in general_log and the slow queries in slow_log.

    BTW, when MySQL is left at its default settings it logs in the usual, standard text log files and even the MySQL instance used by ZCS logs in such files, indeed in /opt/zimbra/conf/my.cnf we have:
    Code:
    slow_query_log_file = /opt/zimbra/log/myslow.log
    err-log = /opt/zimbra/log/mysqld.log
    Moreover, notice that .frm files are used to store the table's structure for whatever table type you use (MyISAM, InnoDB, CSV), thus removing the .frm file it's like removing the whole table because you no longer see its data even if you leave the other files in place (the .CSV and .CSM files in this case).

    My conclusion is that you may safely remove both tables by using this simple command after you have stopped all ZCS services:
    Code:
    cd /opt/zimbra/db/data/mysql ; rm -f general_log.* slow_log.*
    I have deleted them on our ZCS 7.1.4 servers and we didn't experience any problem.
    Thank you for explaining what is happening. Brillant and it works perfectly

  7. #37
    quanah is online now Zimbra Employee
    Join Date
    May 2007
    Location
    Zimbra
    Posts
    1,285
    Rep Power
    10

    Default

    You'll be happy to know then that MariaDB already fixed this problem, and Zimbra will be using MariaDB in ZCS 8.5
    Quanah Gibson-Mount
    Server Architect
    Zimbra, Inc
    --------------------
    Zimbra :: the leader in open source messaging and collaboration

  8. #38
    fab
    fab is offline Active Member
    Join Date
    Oct 2008
    Posts
    38
    Rep Power
    6

    Default

    Great, do you have a scheduled release date for 8.5?

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

    Default

    Quote Originally Posted by fab View Post
    Great, do you have a scheduled release date for 8.5?
    Products releases are not pre-announced, you'll see a forum announcment when it available. You can also follow the state of development via bugzilla and the current status of outstanding bug and closer to release the Product Management portal when it's added to that.
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

Page 4 of 4 FirstFirst ... 234

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. Error Installing Outlook Connector
    By DanO in forum Zimbra Connector for Outlook
    Replies: 17
    Last Post: 08-28-2007, 09:35 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
  •