Bug #16920 rpl_deadlock_innodb fails in show slave status
Submitted: 30 Jan 2006 23:21 Modified: 26 Apr 2006 15:31
Reporter: Elliot Murphy Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Replication Severity:S3 (Non-critical)
Version:mysql-5.1 OS:Solaris (Solaris10, SuSE SLES9 x86)
Assigned to: Matthias Leich CPU Architecture:Any

[30 Jan 2006 23:21] Elliot Murphy
Description:
In the current mysql-5.1-new tree, this test is failing on the am64 solaris 10 machines:

*** r/rpl_deadlock_innodb.result	Mon Jan 30 21:12:31 2006
--- r/rpl_deadlock_innodb.reject	Tue Jan 31 00:03:41 2006
***************
*** 63,69 ****
  22
  show slave status;
  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
! #	127.0.0.1	root	MASTER_MYPORT	1	master-bin.000001	#	#	#	master-bin.000001	Yes	Yes				#			0		0	#	#	None		0	No						#
  set global max_relay_log_size=0;
  stop slave;
  change master to master_log_pos=536;
--- 63,69 ----
  22
  show slave status;
  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
! #	127.0.0.1	root	MASTER_MYPORT	1	master-bin.000001	#	#	#	master-bin.000001	No	Yes				#			0		0	#	#	None		0	No						#
  set global max_relay_log_size=0;
  stop slave;
  change master to master_log_pos=536;
-------------------------------------------------------

How to repeat:
Look at the test results from the pushbuild page for mysql-5.1 on Solaris 10 AMD64
[12 Apr 2006 18:30] Kent Boortz
Less frequent, but also occurs on SuSE SLES9 x86
[13 Apr 2006 18:09] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/4932
[13 Apr 2006 18:43] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/4933
[20 Apr 2006 17:44] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/5216
[25 Apr 2006 16:28] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/5487
[26 Apr 2006 15:22] Matthias Leich
Got approval for bug fix via email.
[26 Apr 2006 15:31] Matthias Leich
Fixed in 5.1.10-beta
No changelog entry needed.