Results 1 to 5 of 5

Thread: Database errors found

  1. #1
    Join Date
    Nov 2009
    Location
    Ljubljana, Slovenia
    Posts
    268
    Rep Power
    6

    Default Database errors found

    Hi,

    when I tried with upgrade from ZCS 7.0.0 to 7.0.1 database integrity checker found these errors:
    Code:
    Verifying integrity of message store databases.  This may take a while.
    mysqld is alive
    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=cKminGdFnKfF7JgD425v1h1cYvQM                                                             --auto-repair
    mysql.general_log
     Error    : You can't use locks with log tables.
     mysql.slow_log
     Error    : You can't use locks with log tables.
    I run --auto-repair two times, but still same errors.
    Is it safe to sontinue with upgrade?
    What's this about "can't use locks with log tables"?

    I mean, this bug was reported already for 5.1 version, so it's weird to me it's still present...
    ...or is it something wrong with my ZCS install?

  2. #2
    Join Date
    Feb 2011
    Posts
    82
    Rep Power
    4

    Default

    auto-repaire will not fix those.

    Those error are generated by mysqlcheck, which is a mysql tool, not exactly a zimbra tool. And it is a well know "error" that is safe to ignore.

  3. #3
    Join Date
    Nov 2009
    Location
    Ljubljana, Slovenia
    Posts
    268
    Rep Power
    6

    Default

    thanx John,
    I'll ignore it

  4. #4
    Join Date
    Jul 2008
    Location
    Bologna Italy
    Posts
    15
    Rep Power
    7

  5. #5
    Join Date
    Feb 2006
    Location
    FL, USA
    Posts
    75
    Rep Power
    9

    Cool

    Quote Originally Posted by John Siu View Post
    auto-repaire will not fix those.

    Those error are generated by mysqlcheck, which is a mysql tool, not exactly a zimbra tool. And it is a well know "error" that is safe to ignore.
    Ok..good..safe to ignore..I like it..sort of like ignoring wifey..

Similar Threads

  1. Replies: 6
    Last Post: 03-14-2011, 05:21 AM
  2. Database errors found. now?
    By maumar in forum Installation
    Replies: 5
    Last Post: 04-02-2008, 06:13 AM
  3. Replies: 20
    Last Post: 03-18-2008, 06:37 AM
  4. Replies: 2
    Last Post: 10-04-2007, 04: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
  •