Bug #43008 main.mysqlbinlog fails on Windows in PB2
Submitted: 19 Feb 2009 9:29 Modified: 2 Apr 2009 14:43
Reporter: Alexander Nozdrin Email Updates:
Status: Duplicate Impact on me:
None 
Category:Tests: Server Severity:S3 (Non-critical)
Version:6.0-TRUNK OS:Windows
Assigned to: Assigned Account CPU Architecture:Any
Tags: pb2, test failure

[19 Feb 2009 9:29] Alexander Nozdrin 
Description:
Symptoms:
------------------------------------------------------
CURRENT_TEST: main.mysqlbinlog
G:\pb2\test\sb_1-333153-1234874438.38\mysql-6.0.10-alpha-win-x86-test\client\relwithdebinfo\\mysql.exe: Error reading file 'root' (Errcode: 32)
G:\pb2\test\sb_1-333153-1234874438.38\mysql-6.0.10-alpha-win-x86-test\client\relwithdebinfo\\mysql.exe: Error reading file 'root' (Errcode: 32)
G:\pb2\test\sb_1-333153-1234874438.38\mysql-6.0.10-alpha-win-x86-test\client\relwithdebinfo\\mysql.exe: Error reading file 'root' (Errcode: 32)
'grep' is not recognized as an internal or external command,
operable program or batch file.
mysqltest: At line 235: command "$MYSQL_BINLOG --hexdump --local-load=$MYSQLTEST_VARDIR/tmp/ $MYSQLD_DATADIR/master-bin.000012 | grep 'Query' | sed 's/[0-9]\{1,\}/REMOVED/g'" failed

The result from queries just before the failure was:
< snip >
/*!*/;
SET TIMESTAMP=1000000000/*!*/;
SET @@session.collation_database=DEFAULT/*!*/;
load data LOCAL INFILE 'MYSQLTEST_VARDIR/tmp/SQL_LOAD_MB-b-0' INTO table t1
/*!*/;
SET TIMESTAMP=1000000000/*!*/;
load data LOCAL INFILE 'MYSQLTEST_VARDIR/tmp/SQL_LOAD_MB-c-0' INTO table t1 character set koi8r
/*!*/;
SET TIMESTAMP=1000000000/*!*/;
drop table t1
/*!*/;
DELIMITER ;
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
CREATE TABLE t1 (c1 CHAR(10));
flush logs;
INSERT INTO t1 VALUES ('0123456789');
flush logs;
DROP TABLE t1;
------------------------------------------------------

Reported after a failure on 2009-02-17 in 6.0 main.

How to repeat:
XRef2: http://tinyurl.com/cwkva3
[22 Feb 2009 10:15] Ingo Strüwing 
This may be a duplicate of Bug#38133 (Myisamlog test fails on Windows).
[4 Mar 2009 18:31] Omer Barnir 
triage: setting tag to SR60TEST
[2 Apr 2009 14:43] Patrick Crews 
Closing this out as a duplicate.

Please see: Bug#38831 -11 test cases fail on Windows due to missing commands

mysqlbinlog.test and its use of 'grep' were removed as part of this bug fix.   I think there was a brief period where the fixes for this bug were lost in a bad merge, but checking the -bugteam trees shows that the fix is in place and no grep calls are in the test.