Debug build asserts at storage/innobase/row/row0sel.c:2725:ut_ad(!rec_get_deleted_flag(rec, rec_offs_comp(offsets)));

Bug #1295638 reported by Alex Yurchenko
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MySQL patches by Codership
Status tracked in 5.6
5.5
New
High
Unassigned
5.6
New
High
Unassigned

Bug Description

Observed in both 5.5. and 5.6 branches under default sqlgen load (with in-memory data dirs)

5.5 stack trace:
#5 0x00007f7a2dceb5e8 in __GI_abort () at abort.c:90
#6 0x00000000008b8e65 in row_sel_store_mysql_rec (mysql_rec=mysql_rec@entry=0x7f79bc02a8b0 "a\002", prebuilt=prebuilt@entry=0x7f79bc0317d8, rec=rec@entry=0x7f7a0824c0ad "\200",
    rec_clust=rec_clust@entry=0, offsets=0x7f7a0270f3e0) at /home/ayurchen/codership/mysql/5.5/storage/innobase/row/row0sel.c:2725
#7 0x00000000008bed55 in row_search_for_mysql (buf=0x7f79bc02a8b0 "a\002", mode=2, prebuilt=0x7f79bc0317d8, match_mode=1, direction=0)
    at /home/ayurchen/codership/mysql/5.5/storage/innobase/row/row0sel.c:3732
#8 0x0000000000877a92 in ha_innobase::index_read (this=0x7f79bc02fd20, buf=0x7f79bc02a8b0 "a\002", key_ptr=0x7f79c8006578 "\001", key_len=<optimized out>, find_flag=<optimized out>)
    at /home/ayurchen/codership/mysql/5.5/storage/innobase/handler/ha_innodb.cc:6576
#9 0x00000000006cd0fc in handler::index_read_map (this=0x7f79bc02fd20, buf=0x7f79bc02a8b0 "a\002", key=0x7f79c8006578 "\001", keypart_map=<optimized out>, find_flag=HA_READ_KEY_EXACT)
    at /home/ayurchen/codership/mysql/5.5/sql/handler.h:1585
#10 0x00000000006c3d5e in handler::index_read_idx_map (this=0x7f79bc02fd20, buf=0x7f79bc02a8b0 "a\002", index=<optimized out>, key=0x7f79c8006578 "\001", keypart_map=1,
    find_flag=HA_READ_KEY_EXACT) at /home/ayurchen/codership/mysql/5.5/sql/handler.cc:4861
#11 0x00000000005cc9b0 in join_read_const (tab=tab@entry=0x7f79c80060a0) at /home/ayurchen/codership/mysql/5.5/sql/sql_select.cc:12303
#12 0x00000000005ccbd9 in join_read_const_table (tab=tab@entry=0x7f79c80060a0, pos=pos@entry=0x7f79c80a1600) at /home/ayurchen/codership/mysql/5.5/sql/sql_select.cc:12206
#13 0x00000000005d13d9 in make_join_statistics (join=join@entry=0x7f79c80a1570, tables_arg=0x7f79c8004df0, conds=0x7f79c8005e90, keyuse_array=keyuse_array@entry=0x7f79c80a2b28)
    at /home/ayurchen/codership/mysql/5.5/sql/sql_select.cc:3002
#14 0x00000000005d483d in JOIN::optimize (this=this@entry=0x7f79c80a1570) at /home/ayurchen/codership/mysql/5.5/sql/sql_select.cc:1057
#15 0x00000000005d9145 in mysql_select (thd=thd@entry=0x24deca0, rref_pointer_array=rref_pointer_array@entry=0x24e10a8, tables=0x7f79c8004df0, wild_num=1, fields=..., conds=<optimized out>,
    og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=select_options@entry=2148797184, result=result@entry=0x7f79c80056a8, unit=unit@entry=0x24e08a0,
    select_lex=select_lex@entry=0x24e0ec0) at /home/ayurchen/codership/mysql/5.5/sql/sql_select.cc:2590
#16 0x00000000005d9394 in handle_select (thd=thd@entry=0x24deca0, lex=lex@entry=0x24e07f0, result=result@entry=0x7f79c80056a8, setup_tables_done_option=setup_tables_done_option@entry=0)
    at /home/ayurchen/codership/mysql/5.5/sql/sql_select.cc:297
#17 0x000000000058de29 in execute_sqlcom_select (thd=thd@entry=0x24deca0, all_tables=<optimized out>) at /home/ayurchen/codership/mysql/5.5/sql/sql_parse.cc:5066
#18 0x00000000005941ad in mysql_execute_command (thd=thd@entry=0x24deca0) at /home/ayurchen/codership/mysql/5.5/sql/sql_parse.cc:2473
#19 0x000000000059c787 in mysql_parse (thd=thd@entry=0x24deca0, rawbuf=rawbuf@entry=0x7f79c8004c00 "SELECT * FROM comm00 WHERE p = 1", length=length@entry=32,
    parser_state=parser_state@entry=0x7f7a02712210) at /home/ayurchen/codership/mysql/5.5/sql/sql_parse.cc:6215
#20 0x000000000059d2a1 in wsrep_mysql_parse (thd=thd@entry=0x24deca0, rawbuf=0x7f79c8004c00 "SELECT * FROM comm00 WHERE p = 1", length=32, parser_state=parser_state@entry=0x7f7a02712210)
    at /home/ayurchen/codership/mysql/5.5/sql/sql_parse.cc:6047
#21 0x000000000059e876 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x24deca0, packet=packet@entry=0x24b29d1 "SELECT * FROM comm00 WHERE p = 1",
    packet_length=packet_length@entry=32) at /home/ayurchen/codership/mysql/5.5/sql/sql_parse.cc:1200
#22 0x00000000005a0cab in do_command (thd=0x24deca0) at /home/ayurchen/codership/mysql/5.5/sql/sql_parse.cc:854
#23 0x0000000000649eda in do_handle_one_connection (thd_arg=thd_arg@entry=0x2486520) at /home/ayurchen/codership/mysql/5.5/sql/sql_connect.cc:879
#24 0x000000000064a0be in handle_one_connection (arg=0x2486520) at /home/ayurchen/codership/mysql/5.5/sql/sql_connect.cc:795
#25 0x00007f7a2ecc2f6e in start_thread (arg=0x7f7a02713700) at pthread_create.c:311
#26 0x00007f7a2ddab9cd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:113

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

Setting impoertance to High as it pretty much blocks testing of debug builds.

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.