Bug #64127 MTR --warnings option misses some of InnoDB errors and warnings
Submitted: 25 Jan 2012 9:29 Modified: 9 Jan 2015 10:18
Reporter: Laurynas Biveinis (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:Tools: MTR / mysql-test-run Severity:S3 (Non-critical)
Version:5.1 bzr revno 3670, 5.5 OS:Any
Assigned to: CPU Architecture:Any
Tags: Contribution

[25 Jan 2012 9:29] Laurynas Biveinis
Description:
mysql-test-run.pl does not expect InnoDB errors and warnings in the format "InnoDB: ERROR" and "InnoDB: WARNING" with all-uppercase "ERROR" and "WARNING".

But grepping the sources shows that some of the messages do use this ignored format, causing the error/warning being missed by the MTR error/warning check, for example, in the innodb_bug34300 test.

I will report innodb_bug34300 (and other test failures if any) separately.

How to repeat:
cd mysql-test && ./mysql-test-run --warnings innodb_bug34300

(...the testcase passes, no errors nor warnings found...)

$ grep ERROR var/log/mysqld.1.err
120125 12:19:17  InnoDB: ERROR: the age of the last checkpoint is 9439048,

This error is not in the global suppression list nor does the testcase suppress it.

With the suggested fix the output becomes

innodb_plugin.innodb_bug34300            [ fail ]  Found warnings/errors in server log file!
        Test ended at 2012-01-25 11:26:07
line
120125 12:26:06  InnoDB: ERROR: the age of the last checkpoint is 9439048,
^ Found warnings in /home/laurynas/percona/mysql-PS/5.1/mysql-test/var/log/mysqld.1.err
ok

Suggested fix:
Add 
"     qr/InnoDB: WARNING|InnoDB: ERROR/,"

to @patterns around mysql-test-run.pl line 3930.
[25 Jan 2012 10:07] Valeriy Kravchuk
Thank you for the problem report and fix contributed. Verified just as described with current 5.1.62 from bzr (revno 3673) on 64-bit Linux FC14.
[27 Sep 2012 9:58] Laurynas Biveinis
This bug has been fixed and may be closed. Thank you.

In 5.1:

revno: 3676
committer: sayantan.dutta@oracle.com
branch nick: mysql-5.1
timestamp: Tue 2012-01-31 17:09:32 +0530
message:
  Bug #64127: MTR --warnings option misses some of InnoDB errors and warnings

In 5.5:

    ------------------------------------------------------------
    revno: 3654.1.5 [merge]
    committer: sayantan.dutta@oracle.com
    branch nick: mysql-5.5
    timestamp: Tue 2012-01-31 17:20:56 +0530
    message:
      merge #64127 5.1 => 5.5
        ------------------------------------------------------------
        revno: 2661.799.6
        committer: sayantan.dutta@oracle.com
        branch nick: mysql-5.1
        timestamp: Tue 2012-01-31 17:09:32 +0530
        message:
          Bug #64127: MTR --warnings option misses some of InnoDB errors and warnings