Full backtrace of a crash when running SELECT MIN(id), MAX(id) FROM non-fully-imported-table;
#0 0x00007ffff6d9b885 in raise () from /lib64/libc.so.6 #1 0x00007ffff6d9d065 in abort () from /lib64/libc.so.6 #2 0x000000000087671e in btr_search_build_page_hash_index (index=0x7fe59c01f9e8, block=0x7fe65c771b00, n_fields=1, n_bytes=0, left_side=1) at /usr/src/debug/Percona-Server-5.5.21-rel25.1/Percona-Server-5.5.21-rel25.1/storage/innobase/btr/btr0sea.c:1549 #3 0x0000000000876efe in btr_search_info_update_slow (info=<value optimized out>, cursor=<value optimized out>) at /usr/src/debug/Percona-Server-5.5.21-rel25.1/Percona-Server-5.5.21-rel25.1/storage/innobase/btr/btr0sea.c:695 #4 0x000000000086c6d3 in btr_search_info_update (index=0x7fe59c01f9e8, level=0, tuple=0x7fe59c01c4e8, mode=3, latch_mode=35, cursor=0x7fe59c017188, has_search_latch=0, file=0xa54fb0 "/home/jenkins/workspace/percona-server-5.5-rpms/label_exp/centos6-64/target/BUILD/Percona-Server-5.5.21-rel25.1/Percona-Server-5.5.21-rel25.1/storage/innobase/btr/btr0pcur.c", line=490, mtr=0x7ffff7e4ba50) at /usr/src/debug/Percona-Server-5.5.21-rel25.1/Percona-Server-5.5.21-rel25.1/storage/innobase/include/btr0sea.ic:83 #5 btr_cur_search_to_nth_level (index=0x7fe59c01f9e8, level=0, tuple=0x7fe59c01c4e8, mode=3, latch_mode=35, cursor=0x7fe59c017188, has_search_latch=0, file=0xa54fb0 "/home/jenkins/workspace/percona-server-5.5-rpms/label_exp/centos6-64/target/BUILD/Percona-Server-5.5.21-rel25.1/Percona-Server-5.5.21-rel25.1/storage/innobase/btr/btr0pcur.c", line=490, mtr=0x7ffff7e4ba50) at /usr/src/debug/Percona-Server-5.5.21-rel25.1/Percona-Server-5.5.21-rel25.1/storage/innobase/btr/btr0cur.c:836 #6 0x000000000086fd8d in btr_pcur_open_with_no_init_func (cursor=0x7fe59c017188, mtr=0x7ffff7e4ba50) at /usr/src/debug/Percona-Server-5.5.21-rel25.1/Percona-Server-5.5.21-rel25.1/storage/innobase/include/btr0pcur.ic:482 #7 btr_pcur_restore_position_func (cursor=0x7fe59c017188, mtr=0x7ffff7e4ba50) at /usr/src/debug/Percona-Server-5.5.21-rel25.1/Percona-Server-5.5.21-rel25.1/storage/innobase/btr/btr0pcur.c:343 #8 btr_pcur_move_backward_from_page (cursor=0x7fe59c017188, mtr=0x7ffff7e4ba50) at /usr/src/debug/Percona-Server-5.5.21-rel25.1/Percona-Server-5.5.21-rel25.1/storage/innobase/btr/btr0pcur.c:490 #9 0x00000000008702ac in btr_pcur_move_to_prev (cursor=0x7fe59c017188, mtr=<value optimized out>) at /usr/src/debug/Percona-Server-5.5.21-rel25.1/Percona-Server-5.5.21-rel25.1/storage/innobase/btr/btr0pcur.c:546 #10 0x000000000082124f in row_search_for_mysql (buf=0x7fe59c010f50 "", mode=3, prebuilt=<value optimized out>, match_mode=0, direction=<value optimized out>) at /usr/src/debug/Percona-Server-5.5.21-rel25.1/Percona-Server-5.5.21-rel25.1/storage/innobase/row/row0sel.c:4707 #11 0x00000000007f5458 in ha_innobase::index_read (this=0x7fe59c00f320, buf=0x7fe59c010f50 "", key_ptr=0x0, key_len=0, find_flag=<value optimized out>) at /usr/src/debug/Percona-Server-5.5.21-rel25.1/Percona-Server-5.5.21-rel25.1/storage/innobase/handler/ha_innodb.cc:6518 #12 0x00000000007f28c9 in ha_innobase::index_last (this=0x7fe59c00f320, buf=0x7fe59c010f50 "") at /usr/src/debug/Percona-Server-5.5.21-rel25.1/Percona-Server-5.5.21-rel25.1/storage/innobase/handler/ha_innodb.cc:6894 #13 0x0000000000744ae7 in get_index_max_value (thd=0xab2cdb70, tables=0x7fe59c005100, all_fields=<value optimized out>, conds=0x0) at /usr/src/debug/Percona-Server-5.5.21-rel25.1/Percona-Server-5.5.21-rel25.1/sql/opt_sum.cc:207 #14 opt_sum_query (thd=0xab2cdb70, tables=0x7fe59c005100, all_fields=<value optimized out>, conds=0x0) at /usr/src/debug/Percona-Server-5.5.21-rel25.1/Percona-Server-5.5.21-rel25.1/sql/opt_sum.cc:388 #15 0x00000000005bc4f0 in JOIN::optimize (this=0x7fe59c019350) at /usr/src/debug/Percona-Server-5.5.21-rel25.1/Percona-Server-5.5.21-rel25.1/sql/sql_select.cc:1015 #16 0x00000000005bfb91 in mysql_select (thd=0xab2cdb70, rref_pointer_array=<value optimized out>, tables=<value optimized out>, wild_num=0, fields=<value optimized out>, conds=<value optimized out>, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7fe59c0056c0, unit=0xab2cf7f8, select_lex=0xab2cfe18) at /usr/src/debug/Percona-Server-5.5.21-rel25.1/Percona-Server-5.5.21-rel25.1/sql/sql_select.cc:2586 #17 0x00000000005c58bd in handle_select (thd=0xab2cdb70, lex=0xab2cf738, result=0x7fe59c0056c0, setup_tables_done_option=0) at /usr/src/debug/Percona-Server-5.5.21-rel25.1/Percona-Server-5.5.21-rel25.1/sql/sql_select.cc:312 #18 0x00000000005834c2 in execute_sqlcom_select (thd=0xab2cdb70, all_tables=0x7fe59c005100) at /usr/src/debug/Percona-Server-5.5.21-rel25.1/Percona-Server-5.5.21-rel25.1/sql/sql_parse.cc:4734 #19 0x0000000000586df6 in mysql_execute_command (thd=0xab2cdb70) at /usr/src/debug/Percona-Server-5.5.21-rel25.1/Percona-Server-5.5.21-rel25.1/sql/sql_parse.cc:2278 #20 0x000000000058a6f3 in mysql_parse (thd=0xab2cdb70, rawbuf=<value optimized out>, length=2871850808, parser_state=0x7ffff7e4ebb0) at /usr/src/debug/Percona-Server-5.5.21-rel25.1/Percona-Server-5.5.21-rel25.1/sql/sql_parse.cc:5804 #21 0x000000000058bd52 in dispatch_command (command=COM_QUERY, thd=0xab2cdb70, packet=0x7fe59c004b60 "select min(id), max(id) from art143.article143", packet_length=4158975128) at /usr/src/debug/Percona-Server-5.5.21-rel25.1/Percona-Server-5.5.21-rel25.1/sql/sql_parse.cc:1060 #22 0x0000000000623ec7 in do_handle_one_connection (thd_arg=<value optimized out>) at /usr/src/debug/Percona-Server-5.5.21-rel25.1/Percona-Server-5.5.21-rel25.1/sql/sql_connect.cc:1433 #23 0x0000000000624001 in handle_one_connection (arg=0xab2cdb70) at /usr/src/debug/Percona-Server-5.5.21-rel25.1/Percona-Server-5.5.21-rel25.1/sql/sql_connect.cc:1340 #24 0x00007ffff7bc87f1 in start_thread () from /lib64/libpthread.so.0 #25 0x00007ffff6e4eccd in clone () from /lib64/libc.so.6
Full backtrace of a crash when running SELECT MIN(id), MAX(id) FROM non-fully- imported- table;
#0 0x00007ffff6d9b885 in raise () from /lib64/libc.so.6 build_page_ hash_index (index= 0x7fe59c01f9e8, block=0x7fe65c7 71b00, n_fields=1, n_bytes=0, left_side=1) debug/Percona- Server- 5.5.21- rel25.1/ Percona- Server- 5.5.21- rel25.1/ storage/ innobase/ btr/btr0sea. c:1549 info_update_ slow (info=<value optimized out>, cursor=<value optimized out>) debug/Percona- Server- 5.5.21- rel25.1/ Percona- Server- 5.5.21- rel25.1/ storage/ innobase/ btr/btr0sea. c:695 info_update (index= 0x7fe59c01f9e8, level=0, tuple=0x7fe59c0 1c4e8, mode=3, latch_mode=35, cursor= 0x7fe59c017188, has_search_latch=0, jenkins/ workspace/ percona- server- 5.5-rpms/ label_exp/ centos6- 64/target/ BUILD/Percona- Server- 5.5.21- rel25.1/ Percona- Server- 5.5.21- rel25.1/ storage/ innobase/ btr/btr0pcur. c", line=490, mtr=0x7ffff7e4ba50) at /usr/src/ debug/Percona- Server- 5.5.21- rel25.1/ Percona- Server- 5.5.21- rel25.1/ storage/ innobase/ include/ btr0sea. ic:83 search_ to_nth_ level (index= 0x7fe59c01f9e8, level=0, tuple=0x7fe59c0 1c4e8, mode=3, latch_mode=35, cursor= 0x7fe59c017188, has_search_latch=0, jenkins/ workspace/ percona- server- 5.5-rpms/ label_exp/ centos6- 64/target/ BUILD/Percona- Server- 5.5.21- rel25.1/ Percona- Server- 5.5.21- rel25.1/ storage/ innobase/ btr/btr0pcur. c", line=490, mtr=0x7ffff7e4ba50) at /usr/src/ debug/Percona- Server- 5.5.21- rel25.1/ Percona- Server- 5.5.21- rel25.1/ storage/ innobase/ btr/btr0cur. c:836 open_with_ no_init_ func (cursor= 0x7fe59c017188, mtr=0x7ffff7e4ba50) debug/Percona- Server- 5.5.21- rel25.1/ Percona- Server- 5.5.21- rel25.1/ storage/ innobase/ include/ btr0pcur. ic:482 restore_ position_ func (cursor= 0x7fe59c017188, mtr=0x7ffff7e4ba50) debug/Percona- Server- 5.5.21- rel25.1/ Percona- Server- 5.5.21- rel25.1/ storage/ innobase/ btr/btr0pcur. c:343 move_backward_ from_page (cursor= 0x7fe59c017188, mtr=0x7ffff7e4ba50) debug/Percona- Server- 5.5.21- rel25.1/ Percona- Server- 5.5.21- rel25.1/ storage/ innobase/ btr/btr0pcur. c:490 move_to_ prev (cursor= 0x7fe59c017188, mtr=<value optimized out>) debug/Percona- Server- 5.5.21- rel25.1/ Percona- Server- 5.5.21- rel25.1/ storage/ innobase/ btr/btr0pcur. c:546 for_mysql (buf=0x7fe59c010f50 "", mode=3, prebuilt=<value optimized out>, match_mode=0, direction=<value optimized out>) debug/Percona- Server- 5.5.21- rel25.1/ Percona- Server- 5.5.21- rel25.1/ storage/ innobase/ row/row0sel. c:4707 :index_ read (this=0x7fe59c0 0f320, buf=0x7fe59c010f50 "", key_ptr=0x0, key_len=0, find_flag=<value optimized out>) debug/Percona- Server- 5.5.21- rel25.1/ Percona- Server- 5.5.21- rel25.1/ storage/ innobase/ handler/ ha_innodb. cc:6518 :index_ last (this=0x7fe59c0 0f320, buf=0x7fe59c010f50 "") debug/Percona- Server- 5.5.21- rel25.1/ Percona- Server- 5.5.21- rel25.1/ storage/ innobase/ handler/ ha_innodb. cc:6894 0x7fe59c005100, all_fields=<value optimized out>, conds=0x0) debug/Percona- Server- 5.5.21- rel25.1/ Percona- Server- 5.5.21- rel25.1/ sql/opt_ sum.cc: 207 0x7fe59c005100, all_fields=<value optimized out>, conds=0x0) debug/Percona- Server- 5.5.21- rel25.1/ Percona- Server- 5.5.21- rel25.1/ sql/opt_ sum.cc: 388 19350) at /usr/src/ debug/Percona- Server- 5.5.21- rel25.1/ Percona- Server- 5.5.21- rel25.1/ sql/sql_ select. cc:1015 array=< value optimized out>, tables=<value optimized out>, wild_num=0, fields=<value optimized out>, options= 2147748608, result= 0x7fe59c0056c0, unit=0xab2cf7f8, lex=0xab2cfe18) at /usr/src/ debug/Percona- Server- 5.5.21- rel25.1/ Percona- Server- 5.5.21- rel25.1/ sql/sql_ select. cc:2586 0x7fe59c0056c0, setup_tables_ done_option= 0) debug/Percona- Server- 5.5.21- rel25.1/ Percona- Server- 5.5.21- rel25.1/ sql/sql_ select. cc:312 sqlcom_ select (thd=0xab2cdb70, all_tables= 0x7fe59c005100) debug/Percona- Server- 5.5.21- rel25.1/ Percona- Server- 5.5.21- rel25.1/ sql/sql_ parse.cc: 4734 command (thd=0xab2cdb70) at /usr/src/ debug/Percona- Server- 5.5.21- rel25.1/ Percona- Server- 5.5.21- rel25.1/ sql/sql_ parse.cc: 2278 state=0x7ffff7e 4ebb0) debug/Percona- Server- 5.5.21- rel25.1/ Percona- Server- 5.5.21- rel25.1/ sql/sql_ parse.cc: 5804 0x7fe59c004b60 "select min(id), max(id) from art143.article143", packet_ length= 4158975128) debug/Percona- Server- 5.5.21- rel25.1/ Percona- Server- 5.5.21- rel25.1/ sql/sql_ parse.cc: 1060 one_connection (thd_arg=<value optimized out>) debug/Percona- Server- 5.5.21- rel25.1/ Percona- Server- 5.5.21- rel25.1/ sql/sql_ connect. cc:1433 one_connection (arg=0xab2cdb70) at /usr/src/ debug/Percona- Server- 5.5.21- rel25.1/ Percona- Server- 5.5.21- rel25.1/ sql/sql_ connect. cc:1340 libpthread. so.0
#1 0x00007ffff6d9d065 in abort () from /lib64/libc.so.6
#2 0x000000000087671e in btr_search_
at /usr/src/
#3 0x0000000000876efe in btr_search_
at /usr/src/
#4 0x000000000086c6d3 in btr_search_
file=0xa54fb0 "/home/
#5 btr_cur_
file=0xa54fb0 "/home/
#6 0x000000000086fd8d in btr_pcur_
at /usr/src/
#7 btr_pcur_
at /usr/src/
#8 btr_pcur_
at /usr/src/
#9 0x00000000008702ac in btr_pcur_
at /usr/src/
#10 0x000000000082124f in row_search_
at /usr/src/
#11 0x00000000007f5458 in ha_innobase:
at /usr/src/
#12 0x00000000007f28c9 in ha_innobase:
at /usr/src/
#13 0x0000000000744ae7 in get_index_max_value (thd=0xab2cdb70, tables=
at /usr/src/
#14 opt_sum_query (thd=0xab2cdb70, tables=
at /usr/src/
#15 0x00000000005bc4f0 in JOIN::optimize (this=0x7fe59c0
#16 0x00000000005bfb91 in mysql_select (thd=0xab2cdb70, rref_pointer_
conds=<value optimized out>, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_
select_
#17 0x00000000005c58bd in handle_select (thd=0xab2cdb70, lex=0xab2cf738, result=
at /usr/src/
#18 0x00000000005834c2 in execute_
at /usr/src/
#19 0x0000000000586df6 in mysql_execute_
#20 0x000000000058a6f3 in mysql_parse (thd=0xab2cdb70, rawbuf=<value optimized out>, length=2871850808, parser_
at /usr/src/
#21 0x000000000058bd52 in dispatch_command (command=COM_QUERY, thd=0xab2cdb70, packet=
at /usr/src/
#22 0x0000000000623ec7 in do_handle_
at /usr/src/
#23 0x0000000000624001 in handle_
#24 0x00007ffff7bc87f1 in start_thread () from /lib64/
#25 0x00007ffff6e4eccd in clone () from /lib64/libc.so.6