InnoDB: Failing assertion: prebuilt->sql_stat_start || trx->state == TRX_STATE_ACTIVE in file row0sel.cc line 4021 | sig6 in handler::ha_rnd_pos

Bug #1367938 reported by Roel Van de Paar on 2014-09-10
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server
Status tracked in 5.7
5.1
Undecided
Unassigned
5.5
Undecided
Unassigned
5.6
High
Unassigned
5.7
High
Unassigned

Bug Description

Thread 1 (LWP 26135):
+bt
#0 0x00007f3006b75771 in pthread_kill () from /lib64/libpthread.so.0
#1 0x0000000000ab09a2 in my_write_core (sig=6) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.20-68.0/mysys/stacktrace.c:422
#2 0x000000000072ca03 in handle_fatal_signal (sig=6) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.20-68.0/sql/signal_handler.cc:236
#3 <signal handler called>
#4 0x00007f3005779989 in raise () from /lib64/libc.so.6
#5 0x00007f300577b098 in abort () from /lib64/libc.so.6
#6 0x0000000000c0295a in row_search_for_mysql (buf=0x7f2f8f019010 "\002\374\022", mode=2, prebuilt=0x7f2f8f290078, match_mode=1, direction=0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.20-68.0/storage/innobase/row/row0sel.cc:4021
#7 0x0000000000ad19e8 in ha_innobase::index_read (this=0x7f2f8f28e010, buf=0x7f2f8f019010 "\002\374\022", key_ptr=0x7f2f8eae5e48 "\023", key_len=4, find_flag=HA_READ_KEY_EXACT) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.20-68.0/storage/innobase/handler/ha_innodb.cc:8213
#8 0x0000000000ad2cfe in ha_innobase::rnd_pos (this=0x7f2f8f28e010, buf=0x7f2f8f019010 "\002\374\022", pos=0x7f2f8eae5e48 "\023") at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.20-68.0/storage/innobase/handler/ha_innodb.cc:8745
#9 0x000000000063fcde in handler::ha_rnd_pos (this=0x7f2f8f28e010, buf=0x7f2f8f019010 "\002\374\022", pos=0x7f2f8eae5e48 "\023") at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.20-68.0/sql/handler.cc:2898
#10 0x000000000099534c in rr_from_pointers (info=0x7f2fe71576c0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.20-68.0/sql/records.cc:562
#11 0x00000000009ab4b9 in multi_delete::do_table_deletes (this=0x7f2f8ea65a50, table=0x7f2f8f09a600, ignore=true) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.20-68.0/sql/sql_delete.cc:990
#12 0x00000000009ab1a8 in multi_delete::do_deletes (this=0x7f2f8ea65a50) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.20-68.0/sql/sql_delete.cc:946
#13 0x00000000009ab632 in multi_delete::send_eof (this=0x7f2f8ea65a50) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.20-68.0/sql/sql_delete.cc:1054
#14 0x00000000007afc37 in do_select (join=0x7f2f8ea65ab8) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.20-68.0/sql/sql_executor.cc:983
#15 0x00000000007ad9b9 in JOIN::exec (this=0x7f2f8ea65ab8) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.20-68.0/sql/sql_executor.cc:194
#16 0x0000000000810e7b in mysql_execute_select (thd=0x7f2fcf610000, select_lex=0x7f2fcf612c58, free_join=true) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.20-68.0/sql/sql_select.cc:1100
#17 0x0000000000811177 in mysql_select (thd=0x7f2fcf610000, tables=0x7f2f88c35060, wild_num=0, fields=..., conds=0x7f2f8ea65800, order=0x0, group=0x0, having=0x0, select_options=3489926016, result=0x7f2f8ea65a50, unit=0x7f2fcf612610, select_lex=0x7f2fcf612c58) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.20-68.0/sql/sql_select.cc:1221
#18 0x00000000007e2b37 in mysql_execute_command (thd=0x7f2fcf610000) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.20-68.0/sql/sql_parse.cc:4020
#19 0x00000000007ea051 in mysql_parse (thd=0x7f2fcf610000, rawbuf=0x7f2f88c34010 "DELETE LOW_PRIORITY IGNORE FROM OUTR1.*, OUTR2.* USING E AS OUTR1 INNER JOIN E AS OUTR2 ON ( OUTR1 . `col_datetime_key` = OUTR2 . `col_datetime_key` ) RIGHT JOIN D AS OUTR3 ON ( OUTR1 . `col_varchar_key` = OUTR3 . `col_varchar_nokey` ) WHERE ( OUTR1 . `col_varchar_key` , OUTR1 . `col_varchar_nokey` ) IN ( SELECT DISTINCT INNR1 . `col_varchar_nokey` AS x , INNR1 . `col_varchar_key` AS y FROM DD AS INNR1 WHERE INNR1 . `col_varchar_nokey` <= INNR1 . `col_varchar_nokey` OR NOT OUTR2 . `col_varchar_key` IS NULL ORDER BY INNR1 . `col_varchar_nokey` )", length=550, parser_state=0x7f2fe7158d10) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.20-68.0/sql/sql_parse.cc:6744
#20 0x00000000007dc5ec in dispatch_command (command=COM_QUERY, thd=0x7f2fcf610000, packet=0x7f2fcf614001 " DELETE LOW_PRIORITY IGNORE FROM OUTR1.*, OUTR2.* USING E AS OUTR1 INNER JOIN E AS OUTR2 ON ( OUTR1 . `col_datetime_key` = OUTR2 . `col_datetime_key` ) RIGHT JOIN D AS OUTR3 ON ( OUTR1 . `col_varchar_key` = OUTR3 . `col_varchar_nokey` ) WHERE ( OUTR1 . `col_varchar_key` , OUTR1 . `col_varchar_nokey` ) IN ( SELECT DISTINCT INNR1 . `col_varchar_nokey` AS x , INNR1 . `col_varchar_key` AS y FROM DD AS INNR1 WHERE INNR1 . `col_varchar_nokey` <= INNR1 . `col_varchar_nokey` OR NOT OUTR2 . `col_varchar_key` IS NULL ORDER BY INNR1 . `col_varchar_nokey` ) ", packet_length=552) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.20-68.0/sql/sql_parse.cc:1432
#21 0x00000000007db518 in do_command (thd=0x7f2fcf610000) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.20-68.0/sql/sql_parse.cc:1049
#22 0x00000000008bf984 in threadpool_process_request (thd=0x7f2fcf610000) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.20-68.0/sql/threadpool_common.cc:311
#23 0x00000000008c22c6 in handle_event (connection=0x7f2fcffa5ee0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.20-68.0/sql/threadpool_unix.cc:1553
#24 0x00000000008c24f6 in worker_main (param=0x188c800 <all_groups>) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.20-68.0/sql/threadpool_unix.cc:1606
#25 0x0000000000dbdbb8 in pfs_spawn_thread (arg=0x7f2f88c1b0c0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.20-68.0/storage/perfschema/pfs.cc:1860
#26 0x00007f3006b70df3 in start_thread () from /lib64/libpthread.so.0
#27 0x00007f300583a3dd in clone () from /lib64/libc.so.6

Tags: qa Edit Tag help
Roel Van de Paar (roel11) wrote :

Now found http://bugs.mysql.com/bug.php?id=59513 - slightly different stack. Added another occurence there (that one looks more similar in stack). Is it the same? If so, please mark this one as dup of 59513.

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

Other bug subscribers

Remote bug watches

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