Bug #40173 rpl.rpl_slave_skip fails sporadically on Windows
Submitted: 20 Oct 2008 12:21 Modified: 2 Feb 2009 17:08
Reporter: Alexander Nozdrin Email Updates:
Status: Closed Impact on me:
None 
Category:Tests: Replication Severity:S3 (Non-critical)
Version:6.0-TRUNK OS:Windows
Assigned to: Serge Kozlov CPU Architecture:Any
Tags: pushbuild, sporadic, test failure

[20 Oct 2008 12:21] Alexander Nozdrin
Description:
rpl.rpl_slave_skip fails sporadically on Wndows:
------------------------------------------------------------
mysqltest: At line 289: command "cp ./suite/rpl/data/rpl_bug28618.dat $MYSQLTEST_VARDIR/tmp/" failed

The result from queries just before the failure was:
< snip >
a	b
3	master/slave
5	master/slave
SELECT * FROM t5 ORDER BY a;
a	b
3	master/slave
5	master/slave
SELECT * FROM t6 ORDER BY a;
a	b
3	master/slave
5	master/slave
DROP TABLE t4, t5, t6;
**** Case 3: Statement logging format and LOAD DATA with non-transactional table ****
*** On Master ***
CREATE TABLE t10 (a INT, b VARCHAR(20)) ENGINE=myisam;
*** On Slave ***
STOP SLAVE;
*** On Master ***
SET SESSION BINLOG_FORMAT=STATEMENT;
exec of 'cp ./suite/rpl/data/rpl_bug28618.dat e:/pb/bzr_mysql-6.0-dtrace/4/mysql-6.0.8-alpha-pb4/mysql-test/var-ps_row-6/tmp/' failed, error: 128, status: 128, errno: 0

More results from queries before failure can be found in e:\pb\bzr_mysql-6.0-dtrace\4\mysql-6.0.8-alpha-pb4\mysql-test\var-ps_row-6\log\rpl_slave_skip.log
------------------------------------------------------------

It seems, 'cp' is not reliable on Windows.

Reported after failure in 6.0-dtrace on 2008-10-17: http://tinyurl.com/6e2uhg

How to repeat:
XRef: http://tinyurl.com/6kgfdf
[20 Oct 2008 13:38] Alexander Nozdrin
It's confirmed: "cp" utility is not portable and must not be used in test cases.
"copy_file" MTR-directive must be used instead.

The test case seems to be fixed in 5.1-rpl (according to Sven).
Waiting for it to be merged.
[17 Dec 2008 10:58] Lars Thalmann
Since this is already fixed in rpl trees, setting to PQ state.
[2 Feb 2009 17:08] Jon Stephens
Test failure only, no end-user changes to document. Closed without further action.