Bug #37941 rpl_flushlog_loop fails on pushbuild

• Submitted: 7 Jul 2008 18:57
• Modified: 11 Jul 2008 20:15
• Reporter: Sven Sandberg
• Status: Closed
• Category: Tests: Replication
• Severity: S2 (Serious)
• Version: 6.0-rpl
• OS: Any
• Assigned to: Mats Kindahl
• Target Version: 6.0
• Tags: rpl_flushlog_loop, pushbuild, test failure
• Triage: D3 (Medium)

[7 Jul 2008 18: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 16: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 20:15] Paul DuBois

Test case change. No changelog entry needed.

[30 Jan 14:32] Bugs System

Pushed into 6.0.10-alpha (revid:[e-mail]-20090129165607-wiskabxm948yx463)
(version source revid:[e-mail]-20090129163120-e2ntks4wgpqde6zt) (merge vers:
6.0.10-alpha) (pib:6)

[30 Jan 16:11] Bugs System

Pushed into 5.1.32 (revid:[e-mail]-20090129165946-d6jnnfqfokuzr09y) (version
source revid:[e-mail]-20080708162102-qbyxyqv4g1kc5seg) (merge vers: 5.1.28) (pib:6)

[17 Feb 16:01] Bugs System

Pushed into 5.1.32-ndb-6.3.23 (revid:[e-mail]-20090217131017-6u8qz1edkjfiobef)
(version source revid:[e-mail]-20090203133556-9rclp06ol19bmzs4) (merge vers:
5.1.32-ndb-6.3.22) (pib:6)

[17 Feb 17:49] Bugs System

Pushed into 5.1.32-ndb-6.4.3 (revid:[e-mail]-20090217134419-5ha6xg4dpedrbmau)
(version source revid:[e-mail]-20090203133556-9rclp06ol19bmzs4) (merge vers:
5.1.32-ndb-6.3.22) (pib:6)

[17 Feb 19:25] Bugs System

Pushed into 5.1.32-ndb-6.2.17 (revid:[e-mail]-20090217134216-5699eq74ws4oxa0j)
(version source revid:[e-mail]-20090201210519-vehobc4sy3g9s38e) (merge vers:
5.1.32-ndb-6.2.17) (pib:6)