Percona Server moved to https://jira.percona.com/projects/PS

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

This bug affects 1 person

	Status	Importance	Assigned to
Percona Server moved to https://jira.percona.com/projects/PS	Status tracked in 5.7
5.1	Won't Fix	Undecided	Unassigned
5.5	New	Undecided	Unassigned
5.6	New	High	Unassigned
5.7	New	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:

Revision history for this message

Roel Van de Paar (roel11) wrote on 2014-09-10:

Fulll bundle with all files (core, gdb stacks, error log, vardir and more) Edit (38.1 MiB, application/x-tar)

Revision history for this message

Roel Van de Paar (roel11) wrote on 2014-09-12:

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.