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)

[7 Jul 2008 16:57] Sven Sandberg
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
[9 Jul 2008 14:14] Mats Kindahl
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.
[11 Jul 2008 18:15] Paul Dubois
Test case change. No changelog entry needed.
[30 Jan 2009 13:32] Bugs System
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)
[30 Jan 2009 15:11] Bugs System
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)
[17 Feb 2009 15:01] Bugs System
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)
[17 Feb 2009 16:49] Bugs System
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)
[17 Feb 2009 18:25] Bugs System
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)