Description:
When working on Windows with the build created from the current mysql-5.1 tree
(http://trollheim.norway.sun.com/archive/1198319.mysql-5.5.99-m3-win-x86.zip) and trying to run
mysql-next-mr\mysql-test>perl mysql-test-run.pl rpl_sync
The test case failed.
Please refer to:
http://pb2.norway.sun.com/web.py?template=push_details&push=841103
How to repeat:
Install MySQL from the build tree on Windows following the instructions that could be found in win/README.
Run
mysql-next-mr\mysql-test>perl mysql-test-run.pl rpl_sync
You'll get failure as following:
rpl.rpl_sync [ fail ]
Test ended at 2010-01-20 02:43:29
CURRENT_TEST: rpl.rpl_sync
The process cannot access the file because it is being used by another process.
mysqltest: At line 68: command "echo "failure" > $MYSQLD_SLAVE_DATADIR/$file" failed
Output from before failure:
exec of 'G:\pb2\test\sb_1-1198319-1263949630.84\mysql-5.5.99-m3-win-x86-test\client\debug\\echo.exe "failure" > G:/pb2/test/sb_1-1198319-1263949630.84/mysql-5.5.99-m3-win-x86-test/mysql-test/var-n_mix/mysqld.2/data//slave-relay-bin.000003' failed, error: 1, status: 1, errno: 0
The result from queries just before the failure was:
=====Configuring the enviroment=======;
stop slave;
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
reset master;
reset slave;
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
start slave;
call mtr.add_suppression('Attempting backtrace');
call mtr.add_suppression("Recovery from master pos .* and file master-bin.000001");
CREATE TABLE t1(a INT, PRIMARY KEY(a)) engine=innodb;
insert into t1(a) values(1);
insert into t1(a) values(2);
insert into t1(a) values(3);
=====Inserting data on the master but without the SQL Thread being running=======;
stop slave SQL_THREAD;
insert into t1(a) values(4);
insert into t1(a) values(5);
insert into t1(a) values(6);
=====Removing relay log files and crashing/recoverying the slave=======;
stop slave IO_THREAD;
Warnings from just before the error:
Note 1051 Unknown table 't1'
Note 1051 Unknown table 't2'
Note 1051 Unknown table 't3'
Note 1051 Unknown table 't4'
Note 1051 Unknown table 't5'
Note 1051 Unknown table 't6'
Note 1051 Unknown table 't7'
Note 1051 Unknown table 't8'
- saving 'G:/pb2/test/sb_1-1198319-1263949630.84/mysql-5.5.99-m3-win-x86-test/mysql-test/var-n_mix/log/rpl.rpl_sync/' to 'G:/pb2/test/sb_1-1198319-1263949630.84/mysql-5.5.99-m3-win-x86-test/mysql-test/var-n_mix/log/rpl.rpl_sync/'
