rpl.rpl_temporary [ fail ] Test ended at 2009-12-16 16:37:56 CURRENT_TEST: rpl.rpl_temporary === SHOW MASTER STATUS === ---- 1. ---- File slave-bin.000001 Position 1548 Binlog_Do_DB Binlog_Ignore_DB ========================== === SHOW SLAVE STATUS === ---- 1. ---- Slave_IO_State Waiting for master to send event Master_Host 127.0.0.1 Master_User root Master_Port 13010 Connect_Retry 1 Master_Log_File master-bin.000001 Read_Master_Log_Pos 3445 Relay_Log_File slave-relay-bin.000005 Relay_Log_Pos 1014 Relay_Master_Log_File master-bin.000001 Slave_IO_Running Yes Slave_SQL_Running No Replicate_Do_DB Replicate_Ignore_DB Replicate_Do_Table Replicate_Ignore_Table Replicate_Wild_Do_Table Replicate_Wild_Ignore_Table Last_Errno 1050 Last_Error Error 'Table 't3' already exists' on query. Default database: 'test'. Query: 'create temporary table t3(f int)' Skip_Counter 0 Exec_Master_Log_Pos 1548 Relay_Log_Space 3619 Until_Condition None Until_Log_File Until_Log_Pos 0 Master_SSL_Allowed No Master_SSL_CA_File Master_SSL_CA_Path Master_SSL_Cert Master_SSL_Cipher Master_SSL_Key Seconds_Behind_Master Master_SSL_Verify_Server_Cert No Last_IO_Errno 0 Last_IO_Error Last_SQL_Errno 1050 Last_SQL_Error Error 'Table 't3' already exists' on query. Default database: 'test'. Query: 'create temporary table t3(f int)' Replicate_Ignore_Server_Ids Master_Server_Id 1 ========================= === SHOW PROCESSLIST === ---- 1. ---- Id 2 User root Host localhost:45264 db test Command Query Time 0 State Info SHOW PROCESSLIST ---- 2. ---- Id 3 User root Host localhost:45265 db test Command Sleep Time 1 State Info ---- 3. ---- Id 8 User system user Host db Command Connect Time 0 State Waiting for master to send event Info ======================== analyze: sync_with_master mysqltest: At line 212: sync_slave_with_master failed: 'select master_pos_wait('master-bin.000001', 3445, 300)' returned NULL indicating slave SQL thread failure The result from queries just before the failure was: < snip > SET @@session.pseudo_thread_id=1; insert into t2 select count(*) from t3; SET TIMESTAMP=1040324200; SET @@session.pseudo_thread_id=2; insert into t3 select * from t1 where f>=4; SET TIMESTAMP=1040324211; SET @@session.pseudo_thread_id=1; drop temporary table t3; SET TIMESTAMP=1040324219; SET @@session.pseudo_thread_id=2; insert into t2 select count(*) from t3; SET TIMESTAMP=1040324224; SET @@session.pseudo_thread_id=2; drop temporary table t3; select * from t2 ORDER BY f; f 5 7 drop table t1,t2; create temporary table t3 (f int); More results from queries before failure can be found in /export/home2/pb2/test/sb_1-1089233-1260976243.09/mysql-5.5.0-beta-linux-x86_64-test/mysql-test/var-n_mix/log/rpl_temporary.log == /export/home2/pb2/test/sb_1-1089233-1260976243.09/mysql-5.5.0-beta-linux-x86_64-test/mysql-test/var-n_mix/tmp/analyze-sync_with_master-mysqld.1.err == SHOW PROCESSLIST; Id User Host db Command Time State Info 99 root localhost:44617 NULL Binlog Dump 0 Master has sent all binlog to slave; waiting for binlog to be updated NULL 103 root localhost NULL Query 0 NULL SHOW PROCESSLIST 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.0-beta-log, Binlog ver: 4 master-bin.000001 107 Query 1 193 use `test`; DROP TABLE IF EXISTS t1 master-bin.000001 193 Query 1 293 use `test`; CREATE TEMPORARY TABLE t1 (a char(1)) master-bin.000001 293 Query 1 383 use `test`; INSERT INTO t1 VALUES ('a') master-bin.000001 383 Query 1 473 use `test`; INSERT INTO t1 VALUES ('b') master-bin.000001 473 Query 1 559 use `test`; DROP TABLE IF EXISTS t1 master-bin.000001 559 Query 1 687 use `test`; CREATE TEMPORARY TABLE `t1`(`a` tinyint,`b` char(1))engine=myisam master-bin.000001 687 Query 1 788 use `test`; INSERT INTO `t1` set `a`=128,`b`='128' master-bin.000001 788 Query 1 889 use `test`; INSERT INTO `t1` set `a`=128,`b`='128' master-bin.000001 889 Query 1 965 use `test`; DROP TABLE t1 master-bin.000001 965 Query 1 1054 use `test`; drop table if exists t1,t2 master-bin.000001 1054 Query 1 1139 use `test`; create table t1(f int) master-bin.000001 1139 Query 1 1224 use `test`; create table t2(f int) master-bin.000001 1224 Query 1 1349 use `test`; insert into t1 values (1),(2),(3),(4),(5),(6),(7),(8),(9),(10) master-bin.000001 1349 Query 1 1444 use `test`; create temporary table t3(f int) master-bin.000001 1444 Query 1 1548 use `test`; insert into t3 select * from t1 where f<6 master-bin.000001 1548 Query 1 1643 use `test`; create temporary table t3(f int) master-bin.000001 1643 Query 1 1744 use `test`; insert into t2 select count(*) from t3 master-bin.000001 1744 Query 1 1849 use `test`; insert into t3 select * from t1 where f>=4 master-bin.000001 1849 Query 1 1935 use `test`; drop temporary table t3 master-bin.000001 1935 Query 1 2036 use `test`; insert into t2 select count(*) from t3 master-bin.000001 2036 Query 1 2122 use `test`; drop temporary table t3 master-bin.000001 2122 Query 1 2202 use `test`; drop table t1, t2 master-bin.000001 2202 Query 1 2287 use `test`; create table t1(f int) master-bin.000001 2287 Query 1 2372 use `test`; create table t2(f int) master-bin.000001 2372 Query 1 2497 use `test`; insert into t1 values (1),(2),(3),(4),(5),(6),(7),(8),(9),(10) master-bin.000001 2497 Query 1 2592 use `test`; create temporary table t3(f int) master-bin.000001 2592 Query 1 2696 use `test`; insert into t3 select * from t1 where f<6 master-bin.000001 2696 Query 1 2791 use `test`; create temporary table t3(f int) master-bin.000001 2791 Query 1 2892 use `test`; insert into t2 select count(*) from t3 master-bin.000001 2892 Query 1 2997 use `test`; insert into t3 select * from t1 where f>=4 master-bin.000001 2997 Query 1 3083 use `test`; drop temporary table t3 master-bin.000001 3083 Query 1 3184 use `test`; insert into t2 select count(*) from t3 master-bin.000001 3184 Query 1 3270 use `test`; drop temporary table t3 master-bin.000001 3270 Query 1 3349 use `test`; drop table t1,t2 master-bin.000001 3349 Query 1 3445 use `test`; create temporary table t3 (f int) master-bin.000001 3445 Query 1 3555 use `test`; DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `t3` == /export/home2/pb2/test/sb_1-1089233-1260976243.09/mysql-5.5.0-beta-linux-x86_64-test/mysql-test/var-n_mix/tmp/analyze-sync_with_master-mysqld.2.err == SHOW PROCESSLIST; Id User Host db Command Time State Info 8 system user NULL Connect 0 Waiting for master to send event NULL 10 root localhost NULL Query 0 NULL SHOW PROCESSLIST SHOW BINLOG EVENTS IN 'slave-bin.000001'; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000001 4 Format_desc 2 107 Server ver: 5.5.0-beta-log, Binlog ver: 4 slave-bin.000001 107 Query 1 193 use `test`; DROP TABLE IF EXISTS t1 slave-bin.000001 193 Query 1 293 use `test`; CREATE TEMPORARY TABLE t1 (a char(1)) slave-bin.000001 293 Query 1 383 use `test`; INSERT INTO t1 VALUES ('a') slave-bin.000001 383 Query 1 473 use `test`; INSERT INTO t1 VALUES ('b') slave-bin.000001 473 Query 1 559 use `test`; DROP TABLE IF EXISTS t1 slave-bin.000001 559 Query 1 687 use `test`; CREATE TEMPORARY TABLE `t1`(`a` tinyint,`b` char(1))engine=myisam slave-bin.000001 687 Query 1 788 use `test`; INSERT INTO `t1` set `a`=128,`b`='128' slave-bin.000001 788 Query 1 889 use `test`; INSERT INTO `t1` set `a`=128,`b`='128' slave-bin.000001 889 Query 1 965 use `test`; DROP TABLE t1 slave-bin.000001 965 Query 1 1054 use `test`; drop table if exists t1,t2 slave-bin.000001 1054 Query 1 1139 use `test`; create table t1(f int) slave-bin.000001 1139 Query 1 1224 use `test`; create table t2(f int) slave-bin.000001 1224 Query 1 1349 use `test`; insert into t1 values (1),(2),(3),(4),(5),(6),(7),(8),(9),(10) slave-bin.000001 1349 Query 1 1444 use `test`; create temporary table t3(f int) slave-bin.000001 1444 Query 1 1548 use `test`; insert into t3 select * from t1 where f<6 - saving '/export/home2/pb2/test/sb_1-1089233-1260976243.09/mysql-5.5.0-beta-linux-x86_64-test/mysql-test/var-n_mix/log/rpl.rpl_temporary/' to '/export/home2/pb2/test/sb_1-1089233-1260976243.09/mysql-5.5.0-beta-linux-x86_64-test/mysql-test/var-n_mix/log/rpl.rpl_temporary/' Retrying test, attempt(2/3)...