| Bug #40409 | main.mysqlbinlog fails sporadically, missing row in result | ||
|---|---|---|---|
| Submitted: | 29 Oct 2008 20:49 | Modified: | 21 Feb 2009 15:04 |
| Reporter: | Sven Sandberg | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | Tests: Replication | Severity: | S7 (Test Cases) |
| Version: | 6.0 | OS: | Windows |
| Assigned to: | Serge Kozlov | CPU Architecture: | Any |
| Tags: | pushbuild, sporadic, test failure | ||
[15 Feb 2009 23:40]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/66405 2801 Serge Kozlov 2009-02-16 Bug#40409: Command 'grep' doesn't exist for Windows platforms and this command replaced by perl code. modified: mysql-test/t/mysqlbinlog.test === modified file 'mysql-test/t/mysqlbinlog.test' --- a/mysql-test/t/mysqlbinlog.test 2008-02-28 11:21:44 +0000 +++ b/mysql-test/t/mysqlbinlog.test 2009-02-15 23:37:55 +0000 @@ -232,8 +232,17 @@ flush logs; INSERT INTO t1 VALUES ('0123456789'); flush logs; DROP TABLE t1; ---exec $MYSQL_BINLOG --hexdump --local-load=$MYSQLTEST_VARDIR/tmp/ $MYSQLD_DATADIR/master-bin.000012 | grep 'Query' | sed 's/[0-9]\{1,\}/REMOVED/g' - +--exec $MYSQL_BINLOG --hexdump --local-load=$MYSQLTEST_VARDIR/tmp/ $MYSQLD_DATADIR/master-bin.000012 > $MYSQLTEST_VARDIR/tmp/bug28293.sql +perl; +open F, $ENV{'MYSQLTEST_VARDIR'}.'/tmp/bug28293.sql' or die "File $ENV{'MYSQLTEST_VARDIR'}/tmp/bug28293.sql not found"; +while (<F>) { + if (m/Query/) { + s/[0-9]+/REMOVED/g; + print; + } +} +close F; +EOF # # Bug #29928: incorrect connection_id() restoring from mysqlbinlog out # -- MySQL Code Commits Mailing List For list archives: http://lists.mysql.com/commits To unsubscribe: http://lists.mysql.com/commits?unsub=commits@bugs.mysql.com
[21 Feb 2009 15:04]
Jon Stephens
Test failure only; no user-facing changes to document. Closed.
Description: pushbuild failure: main.mysqlbinlog [ fail ] e:\pb\bzr_mysql-6.0\79\mysql-6.0.8-alpha-pb79\client\relwithdebinfo\\mysql.exe: Error reading file '(null)' (Errcode: 32) e:\pb\bzr_mysql-6.0\79\mysql-6.0.8-alpha-pb79\client\relwithdebinfo\\mysql.exe: Error reading file '(null)' (Errcode: 32) e:\pb\bzr_mysql-6.0\79\mysql-6.0.8-alpha-pb79\client\relwithdebinfo\\mysql.exe: Error reading file '(null)' (Errcode: 32) e:\pb\bzr_mysql-6.0\79\mysql-6.0.8-alpha-pb79\client\relwithdebinfo\\mysqlbinlog.exe: File 'e:/pb/bzr_mysql-6.0/79/mysql-6.0.8-alpha-pb79/mysql-test/std_data/corrupt-relay-bin.000624' not found (Errcode: 2) ERROR 1227 (42000) at line 6: Access denied; you need the SUPER privilege for this operation --- e:/pb/bzr_mysql-6.0/79/mysql-6.0.8-alpha-pb79/mysql-test/r/mysqlbinlog.result 2008-10-28 11:08:24.000000000 +0300 +++ e:\pb\bzr_mysql-6.0\79\mysql-6.0.8-alpha-pb79\mysql-test\r\mysqlbinlog.reject 2008-10-28 13:15:40.838263400 +0300 @@ -394,7 +394,6 @@ INSERT INTO t1 VALUES ('0123456789'); flush logs; DROP TABLE t1; -# Query thread_id=REMOVED exec_time=REMOVED error_code=REMOVED flush logs; create table t1(a int); insert into t1 values(connection_id()); mysqltest: Result content mismatch Stopping All Servers Restoring snapshot of databases How to repeat: https://intranet.mysql.com/secure/pushbuild/showpush.pl?dir=bzr_mysql-6.0&order=79 win2003-x86/n_mix xref: http://tinyurl.com/57a7ma