rpl.rpl_slave_load_remove_tmpfile fails in 5.5.11 as follows. It fails in the upstream server with the same symptoms, see http://bugs.mysql.com/bug.php?id=60044
rpl.rpl_slave_load_remove_tmpfile 'stmt' [ fail ]
Test ended at 2011-04-10 11:57:52
CURRENT_TEST: rpl.rpl_slave_load_remove_tmpfile
mysqltest: In included file "./include/wait_for_slave_sql_error.inc":
included from ./include/wait_for_slave_sql_error.inc at line 58:
At line 57: Slave stopped with wrong error code
The result from queries just before the failure was:
< snip >
SHOW BINLOG EVENTS IN 'master-bin.000001';
Log_name Pos Event_type Server_id End_log_pos Info
master-bin.000001 4 Format_desc 1 107 Server ver: 5.5.11-debug-log, Binlog ver: 4
master-bin.000001 107 Query 1 253 use `test`; create table t1(a int not null auto_increment, b int, primary key(a)) engine=innodb
master-bin.000001 253 Query 1 321 BEGIN
master-bin.000001 321 Intvar 1 349 INSERT_ID=1
master-bin.000001 349 Query 1 440 use `test`; insert into t1(b) values (1)
master-bin.000001 440 Intvar 1 468 INSERT_ID=2
master-bin.000001 468 Query 1 559 use `test`; insert into t1(b) values (2)
master-bin.000001 559 Intvar 1 587 INSERT_ID=3
master-bin.000001 587 Begin_load_query 1 622 ;file_id=1;block_len=12
master-bin.000001 622 Intvar 1 650 INSERT_ID=3
master-bin.000001 650 Execute_load_query 1 885 use `test`; LOAD DATA INFILE '../../std_data/rpl_loaddata.dat' INTO TABLE `t1` FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' (`a`, `b`) ;file_id=1
master-bin.000001 885 Xid 1 912 COMMIT /* xid=129 */
**** SHOW RELAYLOG EVENTS on server_1 ****
relaylog_name = 'No such row'
SHOW RELAYLOG EVENTS IN 'No such row';
Log_name Pos Event_type Server_id End_log_pos Info
**** Slave stopped with wrong error code: 1290 (expected 29, 13) ****
Trying to link to the MySQL bug:
http://