MySQL Bugs: #37941: rpl_flushlog_loop fails on pushbuild

Bug #37941	rpl_flushlog_loop fails on pushbuild
Submitted:	7 Jul 2008 16:57	Modified:	11 Jul 2008 18:15
Reporter:	Sven Sandberg	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Tests: Replication	Severity:	S7 (Test Cases)
Version:	6.0-rpl	OS:	Any
Assigned to:	Mats Kindahl	CPU Architecture:	Any
Tags:	pushbuild, rpl_flushlog_loop, test failure
Triage:	D3 (Medium)

Description:
rpl_flushlog_loop fails sporadically on pushbuild with the following error:

rpl.rpl_flushlog_loop          [ fail ]

CURRENT_TEST: rpl.rpl_flushlog_loop
--- /data0/pushbuild/pb2/pb/bzr_mysql-6.0-rpl/14/mysql-6.0.6-alpha-pb14/mysql-test/suite/rpl/r/rpl_flushlog_loop.result	2008-06-22 23:29:22.000000000 +0300
+++ /data0/pushbuild/pb2/pb/bzr_mysql-6.0-rpl/14/mysql-6.0.6-alpha-pb14/mysql-test/suite/rpl/r/rpl_flushlog_loop.reject	2008-06-23 01:09:40.248370666 +0300
@@ -16,37 +16,30 @@
 master_password='',master_port=MASTER_PORT;
 start slave;
 stop slave;
-change master to master_host='127.0.0.1',master_user='root',
-master_password='',master_port=SLAVE_PORT;
-start slave;
-
-let $result_pattern= '%127.0.0.1%root%slave-bin.000001%slave-bin.000001%Yes%Yes%0%0%None%' ;
-
---source include/wait_slave_status.inc
-FLUSH LOGS;
+"Failed while waiting for slave to stop"
 SHOW SLAVE STATUS;
 Slave_IO_State	#
 Master_Host	127.0.0.1
 Master_User	root
-Master_Port	SLAVE_PORT
-Connect_Retry	60
-Master_Log_File	slave-bin.000001
-Read_Master_Log_Pos	POSITION
+Master_Port	MASTER_PORT
+Connect_Retry	1
+Master_Log_File	master-bin.000001
+Read_Master_Log_Pos	#
 Relay_Log_File	#
 Relay_Log_Pos	#
-Relay_Master_Log_File	slave-bin.000001
+Relay_Master_Log_File	master-bin.000001
 Slave_IO_Running	Yes
 Slave_SQL_Running	Yes
 Replicate_Do_DB	
 Replicate_Ignore_DB	
 Replicate_Do_Table	
-Replicate_Ignore_Table	#
+Replicate_Ignore_Table	
 Replicate_Wild_Do_Table	
 Replicate_Wild_Ignore_Table	
 Last_Errno	0
 Last_Error	
 Skip_Counter	0
-Exec_Master_Log_Pos	POSITION
+Exec_Master_Log_Pos	#
 Relay_Log_Space	#
 Until_Condition	None
 Until_Log_File	
@@ -58,9 +51,8 @@
 Master_SSL_Cipher	
 Master_SSL_Key	
 Seconds_Behind_Master	#
-Master_SSL_Verify_Server_Cert	#
-Last_IO_Errno	#
+Master_SSL_Verify_Server_Cert	No
+Last_IO_Errno	0
 Last_IO_Error	
 Last_SQL_Errno	0
 Last_SQL_Error	
-DROP TABLE t1;

mysqltest: In included file "./include/wait_for_slave_to_stop.inc": Result content mismatch

Warnings from just before the error:
Note 1051 Unknown table 't1' 
Note 1051 Unknown table 't2' 
Note 1051 Unknown table 't3' 
Note 1051 Unknown table 't4' 
Note 1051 Unknown table 't5' 
Note 1051 Unknown table 't6' 
Note 1051 Unknown table 't7' 
Note 1051 Unknown table 't8' 

Stopping all servers...
Saving datadirs...
 - saving '/dev/shm/var-n_mix-110/mysqld.1'
 - saving '/dev/shm/var-n_mix-110/mysqld.2'
Resuming tests...

Retrying, attempt(1/3)...

Restarting all servers

How to repeat:
e.g., here:
https://intranet.mysql.com/secure/pushbuild/showpush.pl?dir=bzr_mysql-6.0-rpl&order=14
debx86-b 	n_mix

It fails on  many other locations too. See also xref: http://tinyurl.com/6nsagf

The test fails consistently, not sporadically, on all major platforms and configurations. The test was wrongly written to include 'include/wait_for_slave_to_stop.inc' after issuing a STOP SLAVE on *master*. However, the included file has a 'connection slave' as first line, causing it to wait for the *slave* to stop, which will never happen since the slave is running happily along.

Test case change. No changelog entry needed.

Pushed into 6.0.10-alpha (revid:luis.soares@sun.com-20090129165607-wiskabxm948yx463) (version source revid:luis.soares@sun.com-20090129163120-e2ntks4wgpqde6zt) (merge vers: 6.0.10-alpha) (pib:6)

Pushed into 5.1.32 (revid:luis.soares@sun.com-20090129165946-d6jnnfqfokuzr09y) (version source revid:mats@mysql.com-20080708162102-qbyxyqv4g1kc5seg) (merge vers: 5.1.28) (pib:6)

Pushed into 5.1.32-ndb-6.3.23 (revid:tomas.ulin@sun.com-20090217131017-6u8qz1edkjfiobef) (version source revid:tomas.ulin@sun.com-20090203133556-9rclp06ol19bmzs4) (merge vers: 5.1.32-ndb-6.3.22) (pib:6)

Pushed into 5.1.32-ndb-6.4.3 (revid:tomas.ulin@sun.com-20090217134419-5ha6xg4dpedrbmau) (version source revid:tomas.ulin@sun.com-20090203133556-9rclp06ol19bmzs4) (merge vers: 5.1.32-ndb-6.3.22) (pib:6)

Pushed into 5.1.32-ndb-6.2.17 (revid:tomas.ulin@sun.com-20090217134216-5699eq74ws4oxa0j) (version source revid:tomas.ulin@sun.com-20090201210519-vehobc4sy3g9s38e) (merge vers: 5.1.32-ndb-6.2.17) (pib:6)