Comment 1 for bug 1000224

Revision history for this message
Aurimas Mikalauskas (aurimas-mikalauskas) wrote :

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