Bug #40895 maria: Server crashes in sysbench OLTP_RO test at lf_alloc-pin.c:367
Submitted: 20 Nov 2008 16:39 Modified: 8 Jan 2009 10:39
Reporter: Alexey Stroganov Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Maria storage engine Severity:S1 (Critical)
Version:6.0.8-release OS:Any
Assigned to: Sergei Golubchik CPU Architecture:Any

[20 Nov 2008 16:39] Alexey Stroganov
Description:
The crash with following backtrace was observed in OLTP_RO sysbench test:

Program terminated with signal 11, Segmentation fault.
#0  0x00002aee0c5b74c5 in pthread_kill () from /lib64/libpthread.so.0
#0  0x00002aee0c5b74c5 in pthread_kill () from /lib64/libpthread.so.0
#1  0x000000000064944e in handle_segfault (sig=11) at mysqld.cc:2673
#2  <signal handler called>
#3  0x0000000000a90ad2 in _lf_pinbox_real_free (pins=0x3435b00) at lf_alloc-pin.c:367
#4  0x0000000000a8f8c8 in lf_hash_delete (hash=0x11e6780, pins=0x3435b00, key=0x2aab4dc0f748, keylen=8) at lf_hash.c:226
#5  0x0000000000a1105e in trnman_end_trn (trn=<value optimized out>, commit=<value optimized out>) at trnman.c:465
#6  0x0000000000a7da07 in ma_commit (trn=0x11e67a8) at ma_commit.c:37
#7  0x0000000000a23fce in ha_maria::external_lock (this=0x2aab4d921598, thd=0x1f09ac0, lock_type=2) at ha_maria.cc:2273
#8  0x000000000073c1aa in handler::ha_external_lock (this=0x11e67a8, thd=0x8, lock_type=1) at handler.cc:5298
#9  0x0000000000641f08 in mysql_unlock_tables (thd=0x1f09ac0, sql_lock=0x22d41b0) at lock.cc:821
#10 0x0000000000634845 in select_send::send_eof (this=0x2cd40f0) at sql_class.cc:1662
#11 0x00000000006b407b in do_select (join=0x1f15278, fields=0x1f16cc0, table=0x0, procedure=<value optimized out>) at sql_sel
ect.cc:13497
#12 0x00000000006c6e62 in JOIN::exec (this=0x1f15278) at sql_select.cc:2829
#13 0x00000000006c2cce in mysql_select (thd=0x1f09ac0, rref_pointer_array=0x2cd1f80, tables=<value optimized out>, wild_num=<
value optimized out>, fields=<value optimized out>, conds=0x2cd3ea8, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0
x0, select_options=0, result=0x2cd40f0, unit=0x2cd1938, select_lex=0x2cd1d98) at sql_select.cc:3019
#14 0x00000000006c875c in handle_select (thd=0x1f09ac0, lex=0x2cd1898, result=0x2cd40f0, setup_tables_done_option=0) at sql_s
elect.cc:301
#15 0x0000000000656bb7 in execute_sqlcom_select (thd=0x1f09ac0, all_tables=0x2cd2c00) at sql_parse.cc:4646
#16 0x000000000065a9de in mysql_execute_command (thd=0x1f09ac0) at sql_parse.cc:2066
#17 0x00000000006d4029 in Prepared_statement::execute (this=0x2cd1520, expanded_query=<value optimized out>, open_cursor=fals
e) at sql_prepare.cc:3578
#18 0x00000000006d6ffc in Prepared_statement::execute_loop (this=0x2cd1520, expanded_query=0x40a4d470, open_cursor=false, pac
ket=<value optimized out>, packet_end=<value optimized out>) at sql_prepare.cc:3245
#19 0x00000000006d76a5 in mysql_stmt_execute (thd=0x1f09ac0, packet_arg=0x1f0cf31 "", packet_length=16) at sql_prepare.cc:246
7
#20 0x000000000065febe in dispatch_command (command=COM_STMT_EXECUTE, thd=0x1f09ac0, packet=0x1f0cf31 "", packet_length=19) a
t sql_parse.cc:960
#21 0x0000000000652a72 in handle_one_connection (arg=<value optimized out>) at sql_connect.cc:1156
#22 0x00002aee0c5b3193 in start_thread () from /lib64/libpthread.so.0
#23 0x00002aee0ce2b45d in clone () from /lib64/libc.so.6
#24 0x0000000000000000 in ?? ()

How to repeat:
Instructions and test case will be provided later.
[15 Dec 2008 10:08] Bugs System
Pushed into 6.0.9-alpha  (revid:serg@mysql.com-20081205105151-tqxe1q4g3wqz0mk7) (version source revid:guilhem@mysql.com-20081213204800-0nubni3t4ihn4hv9) (pib:5)
[8 Jan 2009 10:39] MC Brown
Test case failure. No documentation needed.