MySQL Bugs: #16077: Server crashes during execution of rpl

Bug #16077	Server crashes during execution of rpl_sys test on HPUX, RHAS4
Submitted:	29 Dec 2005 20:47	Modified:	9 Jun 2008 16:41
Reporter:	Alexey Stroganov	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:	5.0.17a-cert	OS:	HP/UX (HPUX-11.23, RHAS4)
Assigned to:	Assigned Account	CPU Architecture:	Any

Description:
I observed server crash during testing of 5.0.17 binary with rpl_sys test suite. Ran test 3 times yet trying to reproduce crash but without sucsess. Will work on isolation of this issue later after finishing with Network test Phase 1.

How to repeat:
run rpl_sys test with 50 threads, for 30min.

Server crashed on RHAS4 with sympthoms similar to HPUX.  Backtrace:

(gdb) bt
#0  0x0000003171109657 in pthread_kill () from /lib64/tls/libpthread.so.0
#1  0x0000000000532421 in handle_segfault ()
#2  <signal handler called>
#3  0x000000000075c1dc in end_key_cache ()
#4  0x000000000075c55c in end_key_cache ()
#5  0x000000000075d92c in key_cache_write ()
#6  0x000000000075dbd9 in flush_key_blocks ()
#7  0x000000000073c1a3 in mi_close ()
#8  0x0000000000570c82 in closefrm ()
#9  0x0000000000569579 in intern_close_table ()
#10 0x000000000076677a in hash_delete ()
#11 0x00000000005697a8 in close_thread_tables ()
#12 0x000000000062bab9 in sp_lex_keeper::reset_lex_and_exec_core ()
#13 0x000000000062dddb in sp_instr_stmt::execute ()
#14 0x0000000000629723 in sp_head::execute ()
#15 0x000000000062a48d in sp_head::execute_procedure ()
#16 0x000000000054c3d7 in mysql_execute_command ()
#17 0x000000000054d155 in mysql_parse ()
#18 0x000000000054dd58 in dispatch_command ()
#19 0x000000000054e585 in do_command ()
#20 0x000000000054eb86 in handle_one_connection ()
#21 0x00000031711060aa in start_thread () from /lib64/tls/libpthread.so.0
#22 0x00000031708c5b43 in clone () from /lib64/tls/libc.so.6
#23 0x0000000000000000 in ?? ()

Original issues didn't appear during testing of 5.0.17a with rpl_sys suite(will double check this a bit later) but another crash issue was found for HPUX (possible related?).

Backtrace:

#0  0xc0000000001017b0:0 in _lwp_kill+0x30 ()
   from /usr/lib/hpux64/libpthread.so.1
(gdb) bt
#0  0xc0000000001017b0:0 in _lwp_kill+0x30 ()
   from /usr/lib/hpux64/libpthread.so.1
#1  0xc0000000000b0cb0:0 in __vp_kill+0xb0 ()
   from /usr/lib/hpux64/libpthread.so.1
#2  0xc0000000000c0b90:0 in __pthread_internal_kill+0xb0 ()
   from /usr/lib/hpux64/libpthread.so.1
#3  0xc0000000000c0a20:0 in pthread_kill+0x2e0 ()
   from /usr/lib/hpux64/libpthread.so.1
#4  0x4000000000b11e30:0 in write_core+0xe0 ()
#5  0x40000000006882a0:0 in handle_segfault+0x850 ()
#6  <signal handler called>
#7  0x40000000007d2960:1 in remove_table_from_cache+0x491 ()
#8  0x4000000000672c70:0 in lock_table_name+0x3e0 ()
#9  0x4000000000673730:0 in lock_table_names+0x60 ()
#10 0x4000000000a25370:0 in mysql_rm_table_part2+0xa0 ()
#11 0x4000000000a24ec0:0 in mysql_rm_table+0x250 ()
#12 0x40000000006ffff0:0 in mysql_execute_command+0x65b0 ()
#13 0x40000000006f2ab0:0 in mysql_parse+0x430 ()
#14 0x40000000006eb030:0 in dispatch_command+0x1160 ()
#15 0x40000000006f0e00:0 in do_command+0x250 ()
#16 0x40000000006effc0:0 in handle_one_connection+0x960 ()
#17 0xc0000000000a1b20:0 in __pthread_bound_body+0x180 ()
   from /usr/lib/hpux64/libpthread.so.1

This bug is very old.  Could you please re-verify?

Hi Alexey,
Are you able to repeat still this bug with current source?. Thanks in advance.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".