Bug #50452 show slave status crashed server in rpl_deadlock_innodb
Submitted: 19 Jan 2010 19:00 Modified: 12 Jul 2010 14:25
Reporter: Andrei Elkin Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: Replication Severity:S3 (Non-critical)
Version:5.1, 5.x-wl5136 OS:Any
Assigned to: CPU Architecture:Any

[19 Jan 2010 19:00] Andrei Elkin 
Description:
wl#5136 code has reproduced crashes

rpl.rpl_deadlock_innodb                  [ fail ]
        Test ended at 2010-01-19 15:08:35

CURRENT_TEST: rpl.rpl_deadlock_innodb
mysqltest: In included file ".\include\wait_for_slave_param.inc": At line 70: Error running query 'SHOW SLAVE STATUS': 2013 Lost connection to MySQL server during query

as showed by PB2 e.g https://central.sun.net/http://pb2.norway.sun.com/?template=mysql_show_test_failure&test_f...

Earlier a similar (most probably the same) crash was noticed last year as

rpl.rpl_deadlock_innodb                  w8 [ fail ]
        Test ended at 2009-07-26 16:06:08

CURRENT_TEST: rpl.rpl_deadlock_innodb
==14272== Memcheck, a memory error detector.
==14272== Copyright (C) 2002-2006, and GNU GPL'd, by Julian Seward et al.
==14272== Using LibVEX rev 1658, a library for dynamic binary translation.
==14272== Copyright (C) 2004-2006, and GNU GPL'd, by OpenWorks LLP.
==14272== Using valgrind-3.2.1, a dynamic binary instrumentation framework.
==14272== Copyright (C) 2000-2006, and GNU GPL'd, by Julian Seward et al.
==14272== For more details, rerun with: -v
==14272== 
mysqltest: In included file "./include/wait_for_slave_param.inc": At line 68: Error running query 'SHOW SLAVE STATUS': 2013 Lost connection to MySQL server during query

in https://central.sun.net/http://pb2.norway.sun.com/?template=mysql_show_test_failure&test_f...

How to repeat:
xref on pb2 or branch mysql-next-mr-wl5136 and run rpl_deadlock_innodb (might take few times to hit).
[17 Jun 2010 12:06] Valeriy Kravchuk 
Do you still see this problem with recent 5.1.x versions?
[12 Jul 2010 14:25] Andrei Elkin 
Attempting to find regression with
http://pb2.norway.sun.com/?template=mysql_show_test_failure&test_failure_id=&test_output_i...

does not show up more failures since time of reporting.
Setting to Can't Repeat.