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