| Bug #62157 | binlog.binlog_bug36391 fails when run with --repeat=2 | ||
|---|---|---|---|
| Submitted: | 12 Aug 2011 15:59 | Modified: | 12 Aug 2011 16:32 |
| Reporter: | Oleg Tsarev | Email Updates: | |
| Status: | Verified | Impact on me: | |
| Category: | MySQL Server: Tests | Severity: | S3 (Non-critical) |
| Version: | 5.5 | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
[12 Aug 2011 16:32]
MySQL Verification Team
Thank you for the bug report.
C:\build\5.5-2011-07-26\mysql-test>mysql-test-run.pl binlog_bug36391 --repeat=2
Found handle.exe version 3.42
Logging: C:\build\5.5-2011-07-26\mysql-test\mysql-test-run.pl binlog_bug36391 --repeat=2
110812 13:29:17 [Note] Plugin 'FEDERATED' is disabled.
MySQL Version 5.5.16
Checking supported features...
- skipping ndbcluster
- SSL connections supported
Collecting tests...
- adding combinations for binlog
vardir: C:/build/5.5-2011-07-26/mysql-test/var
Checking leftover processes...
Removing old var directory...
Creating var directory 'C:/build/5.5-2011-07-26/mysql-test/var'...
Installing system database...
Using server port 63460
==============================================================================
TEST RESULT TIME (ms) or COMMENT
--------------------------------------------------------------------------
worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009
binlog.binlog_bug36391 'mix' [ pass ] 1351
binlog.binlog_bug36391 'mix' [ fail ]
Test ended at 2011-08-12 13:29:33
CURRENT_TEST: binlog.binlog_bug36391
ERROR 1051 (42S02) at line 22: Unknown table 't1'
mysqltest: At line 26: command "$MYSQL_BINLOG $binlog_path | $MYSQL test" failed
Output from before failure:
exec of 'C:\build\5.5-2011-07-26\client\Release\\mysqlbinlog.exe --defaults-file=C:/build/5.5-2011-07-26/mysql-test/var/my.cnf C:/build/5.5-2011-07-26/mysql-test/var/mysqld.1/data/master-bin.000002 | C:\build
ysql.exe --defaults-file=C:/build/5.5-2011-07-26/mysql-test/var/my.cnf test' failed, error: 1, status: 1, errno: 0
The result from queries just before the failure was:
CREATE TABLE t1(id INT);
SHOW TABLES;
Tables_in_test
t1
FLUSH LOGS;
DROP TABLE t1;
- saving 'C:/build/5.5-2011-07-26/mysql-test/var/log/binlog.binlog_bug36391-mix/' to 'C:/build/5.5-2011-07-26/mysql-test/var/log/binlog.binlog_bug36391-mix/'
Only 1 of 3 completed.
mysql-test-run: *** ERROR: Not all tests completed
C:\build\5.5-2011-07-26\mysql-test>
Description: binlog.binlog_bug36391 'mix' [ fail ] Test ended at 2011-08-12 18:58:07 CURRENT_TEST: binlog.binlog_bug36391 ERROR 1051 (42S02) at line 22: Unknown table 't1' mysqltest: At line 26: command "$MYSQL_BINLOG $binlog_path | $MYSQL test" failed Output from before failure: exec of '/storage/dev/percona/repeat/bug_report/Percona-Server-5.1.58-rel12.9/client/mysqlbinlog --defaults-file=/storage/dev/percona/repeat/bug_report/Percona-Server-5.1.58-rel12.9/mysql-test/var/my.cnf /storage/dev/percona/repeat/bug_report/Percona-Server-5.1.58-rel12.9/mysql-test/var/mysqld.1/data/master-bin.000002 | /storage/dev/percona/repeat/bug_report/Percona-Server-5.1.58-rel12.9/client/mysql --defaults-file=/storage/dev/percona/repeat/bug_report/Percona-Server-5.1.58-rel12.9/mysql-test/var/my.cnf test' failed, error: 256, status: 1, errno: 0 The result from queries just before the failure was: CREATE TABLE t1(id INT); SHOW TABLES; Tables_in_test t1 FLUSH LOGS; DROP TABLE t1; How to repeat: ./mysql-test-run binlog_bug36391 --repeat=2 Suggested fix: https://code.launchpad.net/~tsarev/percona-server/binlog-repeatable-fix/+merge/70935