Description:
rpl000012 failed on PB2.
Failure details
===============
Where Build Test Run Suite Case Mode When
mysql-5.0-bugteam
649746 tree-gcov-linux-x86_64-tar-gz
649985 tyr35 tree-gcov-linux-x86_64-tar-gz
649985 tyr35 ps rpl000012 None 2009-10-30 17:29:58
Failure Symptom
===============
rpl000012 [ fail ]
=== SHOW MASTER STATUS ===
---- 1. ----
File slave-bin.000001
Position 208
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 12000
Connect_Retry 1
Master_Log_File master-bin.000002
Read_Master_Log_Pos 850
Relay_Log_File slave-relay-bin.000005
Relay_Log_Pos 236
Relay_Master_Log_File master-bin.000002
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 1146
Last_Error Error 'Table 'test.t3' doesn't exist' on query. Default database: 'test'. Query: 'insert into t3 values (100)'
Skip_Counter 0
Exec_Master_Log_Pos 98
Relay_Log_Space 1843
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
=========================
mysqltest: At line 25: could not sync with master ('select master_pos_wait('master-bin.000002', 741)' returned NULL)
The result from queries just before the failure was:
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;
create table t2 (n int);
create temporary table t1 (n int);
insert into t1 values(1),(2),(3);
insert into t2 select * from t1;
create temporary table t3 (n int not null);
alter table t3 add primary key(n);
flush logs;
insert into t3 values (100);
insert into t2 select * from t3;
drop table if exists t3;
insert into t2 values (101);
create temporary table t1 (n int);
insert into t1 values (4),(5);
insert into t2 select * from t1;
More results from queries before failure can be found in /export/home3/pb2/build/sb_2-None-1256920213.68/mysql-5.0-bugteam-gcov/mysql-test/var/log/rpl000012.log
How to repeat:
see: http://pb2.norway.sun.com/web.py?template=push_details&push=649746
Suggested fix:
n/a
Description: rpl000012 failed on PB2. Failure details =============== Where Build Test Run Suite Case Mode When mysql-5.0-bugteam 649746 tree-gcov-linux-x86_64-tar-gz 649985 tyr35 tree-gcov-linux-x86_64-tar-gz 649985 tyr35 ps rpl000012 None 2009-10-30 17:29:58 Failure Symptom =============== rpl000012 [ fail ] === SHOW MASTER STATUS === ---- 1. ---- File slave-bin.000001 Position 208 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 12000 Connect_Retry 1 Master_Log_File master-bin.000002 Read_Master_Log_Pos 850 Relay_Log_File slave-relay-bin.000005 Relay_Log_Pos 236 Relay_Master_Log_File master-bin.000002 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 1146 Last_Error Error 'Table 'test.t3' doesn't exist' on query. Default database: 'test'. Query: 'insert into t3 values (100)' Skip_Counter 0 Exec_Master_Log_Pos 98 Relay_Log_Space 1843 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 ========================= mysqltest: At line 25: could not sync with master ('select master_pos_wait('master-bin.000002', 741)' returned NULL) The result from queries just before the failure was: 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; create table t2 (n int); create temporary table t1 (n int); insert into t1 values(1),(2),(3); insert into t2 select * from t1; create temporary table t3 (n int not null); alter table t3 add primary key(n); flush logs; insert into t3 values (100); insert into t2 select * from t3; drop table if exists t3; insert into t2 values (101); create temporary table t1 (n int); insert into t1 values (4),(5); insert into t2 select * from t1; More results from queries before failure can be found in /export/home3/pb2/build/sb_2-None-1256920213.68/mysql-5.0-bugteam-gcov/mysql-test/var/log/rpl000012.log How to repeat: see: http://pb2.norway.sun.com/web.py?template=push_details&push=649746 Suggested fix: n/a