Comment 16 for bug 1189430

Revision history for this message
Alex Yurchenko (ayurchen) wrote :

Got almost identical stack trace with a trivial SELECT, default innodb_flush_method, no VM and datadir in /dev/shm:

#5 0x00007fa2d806d698 in __GI_abort () at abort.c:90
#6 0x00000000009c110d in row_sel_store_mysql_rec (mysql_rec=0x7fa2c0020110 "\341\003", prebuilt=0x7fa2c0020958, rec=0x7fa2a44c00dc "\200", rec_clust=0, offsets=0x7fa2c80e9370)
    at /home/ayurchen/codership/mysql/5.5/storage/innobase/row/row0sel.c:2724
#7 0x00000000009c2b38 in row_search_for_mysql (buf=0x7fa2c0020110 "\341\003", mode=2, prebuilt=0x7fa2c0020958, match_mode=1, direction=0)
    at /home/ayurchen/codership/mysql/5.5/storage/innobase/row/row0sel.c:3701
#8 0x000000000097d366 in ha_innobase::index_read (this=0x7fa2c001e6c0, buf=0x7fa2c0020110 "\341\003", key_ptr=0x7fa270006538 "\002", key_len=4, find_flag=HA_READ_KEY_EXACT)
    at /home/ayurchen/codership/mysql/5.5/storage/innobase/handler/ha_innodb.cc:6485
#9 0x0000000000777568 in handler::index_read_map (this=0x7fa2c001e6c0, buf=0x7fa2c0020110 "\341\003", key=0x7fa270006538 "\002", keypart_map=1, find_flag=HA_READ_KEY_EXACT)
    at /home/ayurchen/codership/mysql/5.5/sql/handler.h:1585
#10 0x0000000000775a79 in handler::index_read_idx_map (this=0x7fa2c001e6c0, buf=0x7fa2c0020110 "\341\003", index=0, key=0x7fa270006538 "\002", keypart_map=1, find_flag=HA_READ_KEY_EXACT)
    at /home/ayurchen/codership/mysql/5.5/sql/handler.cc:4858
#11 0x000000000063ee9a in join_read_const (tab=0x7fa270006060) at /home/ayurchen/codership/mysql/5.5/sql/sql_select.cc:12278
#12 0x000000000063ea2e in join_read_const_table (tab=0x7fa270006060, pos=0x7fa27005f960) at /home/ayurchen/codership/mysql/5.5/sql/sql_select.cc:12181
#13 0x00000000006281f4 in make_join_statistics (join=0x7fa27005f8d0, tables_arg=0x7fa270004db0, conds=0x7fa270005e50, keyuse_array=0x7fa270060e88)
    at /home/ayurchen/codership/mysql/5.5/sql/sql_select.cc:3002
#14 0x000000000062116d in JOIN::optimize (this=0x7fa27005f8d0) at /home/ayurchen/codership/mysql/5.5/sql/sql_select.cc:1057
#15 0x0000000000626c4f in mysql_select (thd=0x20121c0, rref_pointer_array=0x2014580, tables=0x7fa270004db0, wild_num=1, fields=..., conds=0x7fa270005468, og_num=0, order=0x0, group=0x0,
    having=0x0, proc_param=0x0, select_options=2148797184, result=0x7fa270005668, unit=0x2013d78, select_lex=0x2014398) at /home/ayurchen/codership/mysql/5.5/sql/sql_select.cc:2590
#16 0x000000000061ed4c in handle_select (thd=0x20121c0, lex=0x2013cc8, result=0x7fa270005668, setup_tables_done_option=0) at /home/ayurchen/codership/mysql/5.5/sql/sql_select.cc:297
#17 0x00000000005f8900 in execute_sqlcom_select (thd=0x20121c0, all_tables=0x7fa270004db0) at /home/ayurchen/codership/mysql/5.5/sql/sql_parse.cc:4985
#18 0x00000000005f087a in mysql_execute_command (thd=0x20121c0) at /home/ayurchen/codership/mysql/5.5/sql/sql_parse.cc:2450
#19 0x00000000005fb895 in mysql_parse (thd=0x20121c0, rawbuf=0x7fa270004bc0 "SELECT * FROM comm02 WHERE p = 2", length=32, parser_state=0x7fa2c80ec2a0)
    at /home/ayurchen/codership/mysql/5.5/sql/sql_parse.cc:6208
#20 0x00000000005fb0d9 in wsrep_mysql_parse (thd=0x20121c0, rawbuf=0x7fa270004bc0 "SELECT * FROM comm02 WHERE p = 2", length=32, parser_state=0x7fa2c80ec2a0)
    at /home/ayurchen/codership/mysql/5.5/sql/sql_parse.cc:6041
#21 0x00000000005edb8d in dispatch_command (command=COM_QUERY, thd=0x20121c0, packet=0x2015161 "SELECT * FROM comm02 WHERE p = 2", packet_length=32)
    at /home/ayurchen/codership/mysql/5.5/sql/sql_parse.cc:1212
#22 0x00000000005ecacd in do_command (thd=0x20121c0) at /home/ayurchen/codership/mysql/5.5/sql/sql_parse.cc:869
#23 0x00000000006d5e01 in do_handle_one_connection (thd_arg=0x20121c0) at /home/ayurchen/codership/mysql/5.5/sql/sql_connect.cc:878
#24 0x00000000006d591b in handle_one_connection (arg=0x20121c0) at /home/ayurchen/codership/mysql/5.5/sql/sql_connect.cc:790
#25 0x00007fa2d9042f8e in start_thread (arg=0x7fa2c80ed700) at pthread_create.c:311
#26 0x00007fa2d812ce1d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:113