Description:
the rpl_temporary test fails sporadically on Windows boxes as follows :
rpl.rpl_temporary [ fail ]
Test ended at 2009-03-26 18:36:30
CURRENT_TEST: rpl.rpl_temporary
mysqltest: At line 249: query 'KILL $id' failed with wrong errno 1094: 'Unknown thread id: 7', instead of 1095...
The result from queries just before the failure was:
< snip >
create temporary table `#sql_not_user_table202` (id int);
set @@session.pseudo_thread_id=300;
create temporary table t301 (id int);
create temporary table t302 (id int);
create temporary table `#sql_not_user_table303` (id int);
create table t1(f int);
insert into t1 values (1);
select * from t1 /* must be 1 */;
f
1
drop table t1;
select * from t1;
a
1
drop table t1;
Bug#43748
make a non-privileged user on slave.
FLUSH PRIVILEGES;
GRANT USAGE ON *.* TO user43748@127.0.0.1 IDENTIFIED BY 'meow';
try to KILL system-thread as non-privileged user.
More results from queries before failure can be found in e:\var-ps_row-101\log\rpl_temporary.log
- saving 'e:/var-ps_row-101/log/rpl.rpl_temporary/' to 'e:/var-ps_row-101/log/rpl.rpl_temporary/'
Retrying test, attempt(2/3)...
rpl.rpl_temporary [ retry-pass ] 531
Retrying test, attempt(3/3)...
rpl.rpl_temporary [ retry-pass ] 468
How to repeat:
Run the test enough times on a windows box
Suggested fix:
Refine the test suite of bug #43748
Description: the rpl_temporary test fails sporadically on Windows boxes as follows : rpl.rpl_temporary [ fail ] Test ended at 2009-03-26 18:36:30 CURRENT_TEST: rpl.rpl_temporary mysqltest: At line 249: query 'KILL $id' failed with wrong errno 1094: 'Unknown thread id: 7', instead of 1095... The result from queries just before the failure was: < snip > create temporary table `#sql_not_user_table202` (id int); set @@session.pseudo_thread_id=300; create temporary table t301 (id int); create temporary table t302 (id int); create temporary table `#sql_not_user_table303` (id int); create table t1(f int); insert into t1 values (1); select * from t1 /* must be 1 */; f 1 drop table t1; select * from t1; a 1 drop table t1; Bug#43748 make a non-privileged user on slave. FLUSH PRIVILEGES; GRANT USAGE ON *.* TO user43748@127.0.0.1 IDENTIFIED BY 'meow'; try to KILL system-thread as non-privileged user. More results from queries before failure can be found in e:\var-ps_row-101\log\rpl_temporary.log - saving 'e:/var-ps_row-101/log/rpl.rpl_temporary/' to 'e:/var-ps_row-101/log/rpl.rpl_temporary/' Retrying test, attempt(2/3)... rpl.rpl_temporary [ retry-pass ] 531 Retrying test, attempt(3/3)... rpl.rpl_temporary [ retry-pass ] 468 How to repeat: Run the test enough times on a windows box Suggested fix: Refine the test suite of bug #43748