Bug #15628 Test case rpl_until failure
Submitted: 9 Dec 2005 10:55 Modified: 12 Dec 2005 11:58
Reporter: Kristian Nielsen Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Replication Severity:S3 (Non-critical)
Version:clone-5.0.17-release OS:various
Assigned to: CPU Architecture:Any

[9 Dec 2005 10:55] Kristian Nielsen
Description:
The test case rpl_until failed during a 5.0.17 test build:

12573: rpl_until                      [ fail ]
12574: 
12575: Errors are (from /Users/mysqldev/powermacg5/test/mysql-max-5.0.17-osx10.3-powerpc/mysql-test/var/log/mysqltest-time) :
12576: mysqltest: At line 1362068: Result length mismatch
12577: (the last lines may be the most important ones)
12578: Below are the diffs between actual and expected results:
12579: -------------------------------------------------------
12580: *** r/rpl_until.result	Thu Dec  8 08:59:37 2005
12581: --- r/rpl_until.reject	Thu Dec  8 12:05:27 2005
12582: ***************
12583: *** 31,37 ****
12584:   4
12585:   show slave status;
12586:   Slave_IO_State	Master_Host	Master_User	Master_Port	Connect_Retry	Master_Log_File	Read_Master_Log_Pos	Relay_Log_File	Relay_Log_Pos	Relay_Master_Log_File	Slave_IO_Running	Slave_SQL_Running	Replicate_Do_DB	Replicate_Ignore_DB	Replicate_Do_Table	Replicate_Ignore_Table	Replicate_Wild_Do_Table	Replicate_Wild_Ignore_Table	Last_Errno	Last_Error	Skip_Counter	Exec_Master_Log_Pos	Relay_Log_Space	Until_Condition	Until_Log_File	Until_Log_Pos	Master_SSL_Allowed	Master_SSL_CA_File	Master_SSL_CA_Path	Master_SSL_Cert	Master_SSL_Cipher	Master_SSL_Key	Seconds_Behind_Master
12587: ! #	127.0.0.1	root	MASTER_MYPORT	1	master-bin.000001	776	slave-relay-bin.000004	#	master-bin.000001	Yes	No							0		0	319	#	Master	master-bin.000001	319	No						#
12588:   start slave until master_log_file='master-no-such-bin.000001', master_log_pos=291;
12589:   select * from t1;
12590:   n
12591: --- 31,37 ----
12592:   4
12593:   show slave status;
12594:   Slave_IO_State	Master_Host	Master_User	Master_Port	Connect_Retry	Master_Log_File	Read_Master_Log_Pos	Relay_Log_File	Relay_Log_Pos	Relay_Master_Log_File	Slave_IO_Running	Slave_SQL_Running	Replicate_Do_DB	Replicate_Ignore_DB	Replicate_Do_Table	Replicate_Ignore_Table	Replicate_Wild_Do_Table	Replicate_Wild_Ignore_Table	Last_Errno	Last_Error	Skip_Counter	Exec_Master_Log_Pos	Relay_Log_Space	Until_Condition	Until_Log_File	Until_Log_Pos	Master_SSL_Allowed	Master_SSL_CA_File	Master_SSL_CA_Path	Master_SSL_Cert	Master_SSL_Cipher	Master_SSL_Key	Seconds_Behind_Master
12595: ! #	127.0.0.1	root	MASTER_MYPORT	1	master-bin.000001	776	slave-relay-bin.000004	#	master-bin.000001	No	No							0		0	319	#	Master	master-bin.000001	319	No						#
12596:   start slave until master_log_file='master-no-such-bin.000001', master_log_pos=291;
12597:   select * from t1;
12598:   n

How to repeat:
The problem doesn't look repeatable, seems to fail sporadically depending on timing or whatever.
[12 Dec 2005 11:58] Joerg Bruehe
Duplicate of bug#12429, but missed by automatic analysis due to different line numbers.
This symptom occurs in various places, the fix to bug#12429 should help a lot.