Bug #72810 Relay log without xid_log_event may case parallel crash in debug mode

• Submitted: 30 May 2014 7:47
• Modified: 30 Apr 2015 21:35
• Reporter: qinglin zhang (OCA)
• Status: Can't repeat
• Category: MySQL Server: Replication
• Severity: S3 (Non-critical)
• OS: Any
• CPU Architecture: Any

[30 May 2014 7:47] qinglin zhang

Description:
slave crash may result in uncomplete transaction like bellow:
begin
table_map_event
write_rows
....
rotate
....
begin

in this case , slave may crash, and the stack lie bellow:
#0  0x0000003677232885 in raise () from /lib64/libc.so.6
#1  0x0000003677234065 in abort () from /lib64/libc.so.6
#2  0x000000367722b9fe in __assert_fail_base () from /lib64/libc.so.6
#3  0x000000367722bac0 in __assert_fail () from /lib64/libc.so.6
#4  0x0000000000a18fc8 in Log_event::get_slave_worker (this=0x2b64542a8fb0, rli=0xe1e67a0)
    at /u01/github/slave_delivery/sql/log_event.cc:2752
#5  0x0000000000a1a138 in Log_event::apply_event (this=0x2b64542a8fb0, rli=0xe1e67a0)
    at /u01/github/slave_delivery/sql/log_event.cc:3121
#6  0x0000000000a73d0b in apply_event_and_update_pos (ptr_ev=0x2b644c1008f0, thd=0x2b6454000a50, rli=0xe1e67a0)
    at /u01/github/slave_delivery/sql/rpl_slave.cc:3498
#7  0x0000000000a74de7 in exec_relay_log_event (thd=0x2b6454000a50, rli=0xe1e67a0)
    at /u01/github/slave_delivery/sql/rpl_slave.cc:3890
#8  0x0000000000a7a4e8 in handle_slave_sql (arg=0xe1a3aa0) at /u01/github/slave_delivery/sql/rpl_slave.cc:5736
#9  0x00000036776077f1 in start_thread () from /lib64/libpthread.so.0
#10 0x00000036772e570d in clone () from /lib64/libc.so.6

How to repeat:
refer to:http://bugs.mysql.com/bug.php?id=72794

[3 Jun 2014 12:46] MySQL Verification Team

Hello Zhang,

Thank you for the bug report.
I could not see the crash, could you please provide the exact test case to reproduce this issue at our end?

Thanks,
Umesh

[3 Jun 2014 13:13] qinglin zhang

HI, it's the same bug as http://bugs.mysql.com/bug.php?id=72794 in another mode , just read the code and you will find why it crashed. thank you.

[4 Jun 2014 3:01] qinglin zhang

Or you can leave you email and I will mail the relay log to you if you don't mind.

[30 Apr 2015 21:35] MySQL Verification Team

I could not repeat this with latest builds(5.6.24/5.6.25 builds).
Most probably fixed after Bug #72794.

If you can provide more information, feel free to add it to this bug and change the status back to 'Open'.