Bug #41503 rpl_row_log fails sporadically: query failed: "Unknown table 't1'"
Submitted: 16 Dec 2008 13:12 Modified: 13 Jan 2009 5:27
Reporter: Sven Sandberg Email Updates:
Status: Closed Impact on me:
None 
Category:Tests: Replication Severity:S7 (Test Cases)
Version:5.1-rpl, 6.0-rpl OS:Any
Assigned to: Zhenxing He CPU Architecture:Any
Tags: 5.1-rpl-green, pushbuild, rpl_row_log, sporadic, test failure

[16 Dec 2008 13:12] Sven Sandberg
Description:
rpl_row_log fails sporadically with the following message:

rpl.rpl_row_log                          [ fail ]

CURRENT_TEST: rpl.rpl_row_log
mysqltest: In included file "./extra/rpl_tests/rpl_log.test": At line 141: query 'drop table t1' failed: 1051: Unknown table 't1'

The result from queries just before the failure was:
< snip >
DROP TABLE t1;
DROP TABLE t2;
DROP TABLE t3;
create table t1(a int auto_increment primary key, b int);
insert into t1 values (NULL, 1);
reset master;
set insert_id=5;
insert into t1 values (NULL, last_insert_id()), (NULL, last_insert_id());
show binlog events from <binlog_start>;
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000001	#	Query	#	#	use `test`; BEGIN
master-bin.000001	#	Table_map	#	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	#	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Query	#	#	use `test`; COMMIT
select * from t1;
a	b
1	1
5	1
6	1
drop table t1;

More results from queries before failure can be found in /dev/shm/var-ps_row-171/8/log/rpl_row_log.log

 - saving '/dev/shm/var-ps_row-171/8/log/rpl.rpl_row_log/' to '/dev/shm/var-ps_row-171/log/rpl.rpl_row_log/'

Retrying test, attempt(2/3)...

How to repeat:
https://intranet.mysql.com/secure/pushbuild/showpush.pl?dir=bzr_mysql-5.1-rpl&order=70 sles10-ia64-a-2/ps_row
xref: http://tinyurl.com/6pzsg2
[16 Dec 2008 13:30] Sven Sandberg
Happens also in rpl_row_log_innodb:

rpl.rpl_row_log_innodb                   [ fail ]

CURRENT_TEST: rpl.rpl_row_log_innodb
mysqltest: In included file ".\extra\rpl_tests\rpl_log.test": At line 139: query 'drop table t1' failed: 1051: Unknown table 't1'

The result from queries just before the failure was:
< snip >
DROP TABLE t1;
DROP TABLE t2;
DROP TABLE t3;
create table t1(a int auto_increment primary key, b int);
insert into t1 values (NULL, 1);
reset master;
set insert_id=5;
insert into t1 values (NULL, last_insert_id()), (NULL, last_insert_id());
show binlog events from <binlog_start>;
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000001	#	Query	#	#	use `test`; BEGIN
master-bin.000001	#	Table_map	#	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	#	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Query	#	#	use `test`; COMMIT
select * from t1;
a	b
1	1
5	1
6	1
drop table t1;

More results from queries before failure can be found in e:\var-ps_row-101\2\log\rpl_row_log_innodb.log

 - saving 'e:/var-ps_row-101/2/log/rpl.rpl_row_log_innodb/' to 'e:/var-ps_row-101/log/rpl.rpl_row_log_innodb/'
Too many tests(10) failed! Terminating...
mysql-test-run: *** ERROR: Test suite aborted

https://intranet.mysql.com/secure/pushbuild/showpush.pl?dir=bzr_mysql-6.0-rpl&order=84 vm-win2003-32-a/ps_row