Percona Server moved to https://jira.percona.com/projects/PS

  1. Bug #1395249
  2. Comment #0

Comment 0 for bug 1395249

Revision history for this message
Roel Van de Paar (roel11) wrote :

(gdb) bt
#0 0x00007fa08f79b771 in pthread_kill () from /lib64/libpthread.so.0
#1 0x0000000000a90dda in my_write_core (sig=6) at /bzr/5.6.hacked_dbg/mysys/stacktrace.c:422
#2 0x0000000000722176 in handle_fatal_signal (sig=6) at /bzr/5.6.hacked_dbg/sql/signal_handler.cc:236
#3 <signal handler called>
#4 0x00007fa08dd4e5c9 in raise () from /lib64/libc.so.6
#5 0x00007fa08dd4fcd8 in abort () from /lib64/libc.so.6
#6 0x0000000000c8bbe1 in row_search_for_mysql (buf=0x7f9fe4141c10 "\377\331\001", mode=2, prebuilt=0x7f9fe422b078, match_mode=1, direction=0) at /bzr/5.6.hacked_dbg/storage/innobase/row/row0sel.cc:3932
#7 0x0000000000b66dd1 in ha_innobase::index_read (this=0x7f9fef6fad10, buf=0x7f9fe4141c10 "\377\331\001", key_ptr=0x7f9fe280bb50 "\002", key_len=4, find_flag=HA_READ_KEY_EXACT) at /bzr/5.6.hacked_dbg/storage/innobase/handler/ha_innodb.cc:8224
#8 0x0000000000647a4a in handler::index_read_map (this=0x7f9fef6fad10, buf=0x7f9fe4141c10 "\377\331\001", key=0x7f9fe280bb50 "\002", keypart_map=1, find_flag=HA_READ_KEY_EXACT) at /bzr/5.6.hacked_dbg/sql/handler.h:2284
#9 0x0000000000644ffd in handler::index_read_idx_map (this=0x7f9fef6fad10, buf=0x7f9fe4141c10 "\377\331\001", index=0, key=0x7f9fe280bb50 "\002", keypart_map=1, find_flag=HA_READ_KEY_EXACT) at /bzr/5.6.hacked_dbg/sql/handler.cc:7153
#10 0x000000000063cbfc in handler::ha_index_read_idx_map (this=0x7f9fef6fad10, buf=0x7f9fe4141c10 "\377\331\001", index=0, key=0x7f9fe280bb50 "\002", keypart_map=1, find_flag=HA_READ_KEY_EXACT) at /bzr/5.6.hacked_dbg/sql/handler.cc:2983
#11 0x00000000007a36e8 in join_read_const (tab=0x7f9fe280b2e8) at /bzr/5.6.hacked_dbg/sql/sql_executor.cc:1963
#12 0x00000000007a320a in join_read_const_table (tab=0x7f9fe280b2e8, pos=0x7f9fe280b7d8) at /bzr/5.6.hacked_dbg/sql/sql_executor.cc:1852
#13 0x00000000009a9b1d in make_join_statistics (join=0x7f9fe280abb8, tables_arg=0x7f9fe280a228, conds=0x7f9fe280b0b0, keyuse_array=0x7f9fe280ade0, first_optimization=true) at /bzr/5.6.hacked_dbg/sql/sql_optimizer.cc:3610
#14 0x00000000009a18a7 in JOIN::optimize (this=0x7f9fe280abb8) at /bzr/5.6.hacked_dbg/sql/sql_optimizer.cc:382
#15 0x00000000007ff413 in mysql_execute_select (thd=0x7f9fe0419000, select_lex=0x7f9fe041bc60, free_join=true) at /bzr/5.6.hacked_dbg/sql/sql_select.cc:1086
#16 0x00000000007ff74c in mysql_select (thd=0x7f9fe0419000, tables=0x7f9fe280a228, wild_num=0, fields=..., conds=0x7f9fe280a958, order=0x7f9fe041be28, group=0x7f9fe041bd60, having=0x0, select_options=2148797184, result=0x7f9fe280ab90, unit=0x7f9fe041b618, select_lex=0x7f9fe041bc60) at /bzr/5.6.hacked_dbg/sql/sql_select.cc:1221
#17 0x00000000007fd872 in handle_select (thd=0x7f9fe0419000, result=0x7f9fe280ab90, setup_tables_done_option=0) at /bzr/5.6.hacked_dbg/sql/sql_select.cc:110
#18 0x00000000007d6fb3 in execute_sqlcom_select (thd=0x7f9fe0419000, all_tables=0x7f9fe280a228) at /bzr/5.6.hacked_dbg/sql/sql_parse.cc:5601
#19 0x00000000007cf72a in mysql_execute_command (thd=0x7f9fe0419000) at /bzr/5.6.hacked_dbg/sql/sql_parse.cc:2959
#20 0x00000000007d976b in mysql_parse (thd=0x7f9fe0419000, rawbuf=0x7f9fe280a010 "SELECT c FROM sbtest1 WHERE id=2", length=32, parser_state=0x7f9fd8f1acf0) at /bzr/5.6.hacked_dbg/sql/sql_parse.cc:6777
#21 0x00000000007cc0b7 in dispatch_command (command=COM_QUERY, thd=0x7f9fe0419000, packet=0x7f9fef711001 "SELECT c FROM sbtest1 WHERE id=2", packet_length=32) at /bzr/5.6.hacked_dbg/sql/sql_parse.cc:1432
#22 0x00000000007cb038 in do_command (thd=0x7f9fe0419000) at /bzr/5.6.hacked_dbg/sql/sql_parse.cc:1049
#23 0x000000000079591e in do_handle_one_connection (thd_arg=0x7f9fe0419000) at /bzr/5.6.hacked_dbg/sql/sql_connect.cc:1532
#24 0x0000000000795435 in handle_one_connection (arg=0x7f9fe0419000) at /bzr/5.6.hacked_dbg/sql/sql_connect.cc:1443
#25 0x0000000000add6af in pfs_spawn_thread (arg=0x7f9fecb40520) at /bzr/5.6.hacked_dbg/storage/perfschema/pfs.cc:1860
#26 0x00007fa08f796df3 in start_thread () from /lib64/libpthread.so.0
#27 0x00007fa08de0f01d in clone () from /lib64/libc.so.6

This assert was seen during a very long sysbench run which was kill -9'ed regularly, then re-started. Hopefully the coredump + a code review show the bug, but will add testcase I used also. PZ first found this bug doing Sysbench runs + ctrl+c.