Bug #12857 RBR (ps-protocol) slave core in call to myisam_index_read
Submitted: 29 Aug 2005 18:30 Modified: 24 Oct 2005 19:45
Reporter: Jonathan Miller Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Replication Severity:S1 (Critical)
Version:5.0-wl1012 OS:Linux (Linux)
Assigned to: Guilhem Bichot CPU Architecture:Any

[29 Aug 2005 18:30] Jonathan Miller
Description:
rpl_loadfile.core
#0  0x40250da1 in kill () from /lib/libc.so.6
#1  0x40181f4a in pthread_kill () from /lib/libpthread.so.0
#2  0x0829602d in write_core (sig=11) at stacktrace.c:220
#3  0x0818ef2d in handle_segfault (sig=11) at mysqld.cc:2062
#4  0x401855cd in __pthread_sighandler () from /lib/libpthread.so.0
#5  <signal handler called>
#6  0x08241182 in ha_myisam::index_read(char*, char const*, unsigned, ha_rkey_function) (this=0x874de40, buf=0x0, key=0x0, key_len=0, 
    find_flag=HA_READ_KEY_EXACT) at ha_myisam.cc:1154
#7  0x082129ed in find_and_fetch_row (table=0x872cd80, key=0x0, 
    record_buf=0x8754858 "\\ì4@Øçt\b") at log_event.cc:5683
#8  0x08212585 in Update_rows_log_event::do_exec_row(st_table*, st_relay_log_info*) (this=0x40189bdc, table=0x872cd80, rli=0x87452fc)
    at log_event.cc:6032
#9  0x082111dc in Rows_log_event::exec_event(st_relay_log_info*) (
    this=0x872cb08, rli=0x87452fc) at log_event.cc:5106
#10 0x0828bdd9 in exec_relay_log_event (thd=0x877d258, rli=0x87452fc)
    at slave.cc:2960
#11 0x08289af8 in handle_slave_sql (arg=0x873f118) at slave.cc:3508
#12 0x4017f6de in pthread_start_thread () from /lib/libpthread.so.0
(gdb) quit

How to repeat:
rpl_loadfile.test
[29 Aug 2005 18:39] Jonathan Miller
In addition since the last merge was done from 5.0 base a new test rpl_sp004.test under rbr was passing. It now causes a core without the use of ps-protocol.

#0  0x40250da1 in kill () from /lib/libc.so.6
#1  0x40181f4a in pthread_kill () from /lib/libpthread.so.0
#2  0x0829602d in write_core (sig=11) at stacktrace.c:220
#3  0x0818ef2d in handle_segfault (sig=11) at mysqld.cc:2062
#4  0x401855cd in __pthread_sighandler () from /lib/libpthread.so.0
#5  <signal handler called>
#6  0x08241182 in ha_myisam::index_read(char*, char const*, unsigned, ha_rkey_function) (this=0x41302cd8, buf=0x0, key=0x0, key_len=0, 
    find_flag=HA_READ_KEY_EXACT) at ha_myisam.cc:1154
#7  0x082129ed in find_and_fetch_row (table=0x413025e8, key=0x0, 
    record_buf=0x4131bfd0 "\230À1Ast/t\b") at log_event.cc:5683
#8  0x08212585 in Update_rows_log_event::do_exec_row(st_table*, st_relay_log_info*) (this=0x40189bdc, table=0x413025e8, rli=0x87452fc)
    at log_event.cc:6032
#9  0x082111dc in Rows_log_event::exec_event(st_relay_log_info*) (
    this=0x4131bfe8, rli=0x87452fc) at log_event.cc:5106
#10 0x0828bdd9 in exec_relay_log_event (thd=0x877d258, rli=0x87452fc)
    at slave.cc:2960
#11 0x08289af8 in handle_slave_sql (arg=0x873f118) at slave.cc:3508
#12 0x4017f6de in pthread_start_thread () from /lib/libpthread.so.0
(gdb) quit
[24 Sep 2005 10:43] Guilhem Bichot
fixed, nothing to document
[17 Oct 2005 20:45] Jonathan Miller
Pulled al the latest patches and built today. rpl_sp004.test produced:
#0  0x001b6402 in __kernel_vsyscall ()
#1  0x00a2855f in pthread_kill () from /lib/libpthread.so.0
#2  0x082c916b in write_core (sig=31826) at stacktrace.c:220
#3  0x081a1262 in handle_segfault (sig=11) at mysqld.cc:2067
#4  <signal handler called>
#5  0x08268180 in ha_myisam::index_read_idx (this=0x971eee8, buf=0x0, index=0, key=0x0,
    key_len=0, find_flag=HA_READ_KEY_EXACT) at ha_myisam.cc:1176
#6  0x08228cd6 in find_and_fetch_row (table=0x9703248, key=0x97048f0 "\b",
    record_buf=0x97048e8 "") at log_event.cc:6058
#7  0x08228e5a in Update_rows_log_event::do_exec_row (this=0x0, table=0x9703248, rli=0x96d6a4c)
    at log_event.cc:6435
#8  0x082286d7 in Rows_log_event::exec_event (this=0x971f2a0, rli=0x96d6a4c)
    at log_event.cc:5212
#9  0x082beb4b in handle_slave_sql (arg=0x96d0868) at slave.cc:2966
#10 0x00a25b80 in start_thread () from /lib/libpthread.so.0
#11 0x0097d9ce in clone () from /lib/libc.so.6
[17 Oct 2005 20:55] Jonathan Miller
Note: I was not using --ps-protocol
[24 Oct 2005 19:29] 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/internals/31401
[24 Oct 2005 19:45] Guilhem Bichot
Jeb,
as I couldn't repeat, I re-enabled the test. Please re-open if it fails for you.