Bug #48465 rpl000012 failed on PB2
Submitted: 2 Nov 2009 12:04 Modified: 4 Jan 2010 6:08
Reporter: Luis Manuel Oliveira Soares Email Updates:
Status: Can't repeat Impact on me:
None 
Category:Tests: Replication Severity:S3 (Non-critical)
Version:5.0 OS:Any
Assigned to: Daogang Qu CPU Architecture:Any

[2 Nov 2009 12:04] Luis Manuel Oliveira Soares
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
[15 Dec 2009 9:54] Daogang Qu
The bug can't be repeated.

I had successfully run the 'rpl000012' test case for four days 
on tyr35.norway.sun.com base on the following source binary:
http://trollheim.norway.sun.com/archive/909632.mysql-5.0-bugteam-gcov.tar.gz

The above binary is provided by mentioned link:
http://pb2.norway.sun.com/web.py?template=push_details&push=649746

And the last failure of the 'rpl000012' test case on PB2 is timed 
'2009-11-27 14:58:19'.