Bug #46149 rpl_deadlock fails sporadically in pb2
Submitted: 13 Jul 2009 14:38 Modified: 22 Sep 2009 4:29
Reporter: Georgi Kodinov Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Replication Severity:S3 (Non-critical)
Version:5.0-bugteam OS:Windows (test-max-win_ws2008-x86)
Assigned to: Assigned Account CPU Architecture:Any
Tags: crash, pushbuild, single, sporadic

[13 Jul 2009 14:38] Georgi Kodinov 
Description:
Sometimes rpl_deadlock fails with the following output: 
rpl_deadlock                   [ fail ]

mysqltest: At line 76: query 'stop slave' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
Replicate_Do_Table	
Replicate_Ignore_Table	
Replicate_Wild_Do_Table	
Replicate_Wild_Ignore_Table	
Last_Errno	0
Last_Error	
Skip_Counter	0
Exec_Master_Log_Pos	18918
Relay_Log_Space	#
Until_Condition	None
Until_Log_File	
Until_Log_Pos	0
Master_SSL_Allowed	No
Master_SSL_CA_File	
Master_SSL_CA_Path	
Master_SSL_Cert	
Master_SSL_Cipher	
Master_SSL_Key	
Seconds_Behind_Master	#
stop slave;

More results from queries before failure can be found in G:\pb2\test\sb_1-640536-1247489086.61\mysql-5.0.85-win-x86-test\mysql-test\var\log\rpl_deadlock.log

How to repeat:
Run the test suite enough times on windows

Suggested fix:
n/a