handle_fatal_signal (sig=11) in handler::clone at sql/handler.cc:2580

[Roel Van de Paar]

Thread 1 (LWP 22650):
+bt
#0 0x00007f3483d58771 in pthread_kill () from /lib64/libpthread.so.0
#1 0x0000000000ab09a2 in my_write_core (sig=11) 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=11) 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 0x000000000063ec9c in handler::clone (this=0x7f340794e010, name=0x7f3407904800 "./test/#sql-57de_16", mem_root=0x7f344c6397d0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.20-68.0/sql/handler.cc:2580
#5 0x0000000000acd326 in ha_innobase::clone (this=0x7f340794e010, name=0x7f3407904800 "./test/#sql-57de_16", mem_root=0x7f344c6397d0) 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:5728
#6 0x000000000082ea00 in store_temporary_table_record (thd=0x7f344c636000, table=0x7f340649c010, tmp_table=0x7f3407903c00, db=0x0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.20-68.0/sql/sql_show.cc:4121
#7 0x000000000082eecf in fill_global_temporary_tables (thd=0x7f344c63f000, tables=0x7f34430d2520, cond=0x7f34064e1218) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.20-68.0/sql/sql_show.cc:4209
#8 0x000000000083dae0 in do_fill_table (thd=0x7f344c63f000, table_list=0x7f34430d2520, join_table=0x7f340647ec00) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.20-68.0/sql/sql_show.cc:7902
#9 0x000000000083deaf in get_schema_tables_result (join=0x7f34064885f0, executed_place=PROCESSED_BY_JOIN_EXEC) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.20-68.0/sql/sql_show.cc:8003
#10 0x0000000000810382 in JOIN::prepare_result (this=0x7f34064885f0, columns_list=0x7f3464f798a0) 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:823
#11 0x00000000007ad4fb in JOIN::exec (this=0x7f34064885f0) 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:116
#12 0x0000000000810e7b in mysql_execute_select (thd=0x7f344c63f000, select_lex=0x7f344c641c58, 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
#13 0x0000000000811177 in mysql_select (thd=0x7f344c63f000, tables=0x7f34430d2520, wild_num=1, fields=..., conds=0x7f34064871a8, order=0x7f344c641e20, group=0x7f344c641d58, having=0x7f34064875e8, select_options=2684619520, result=0x7f34064885c8, unit=0x7f344c641610, select_lex=0x7f344c641c58) 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
#14 0x000000000080f206 in handle_select (thd=0x7f344c63f000, result=0x7f34064885c8, setup_tables_done_option=0) 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:110
#15 0x00000000007e7750 in execute_sqlcom_select (thd=0x7f344c63f000, all_tables=0x7f34430d2520) 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:5568
#16 0x00000000007dfd7a in mysql_execute_command (thd=0x7f344c63f000) 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:2953
#17 0x00000000007ea051 in mysql_parse (thd=0x7f344c63f000, rawbuf=0x7f34430d2010 "SELECT * FROM INFORMATION_SCHEMA . `GLOBAL_TEMPORARY_TABLES` AS table1 WHERE (NOT ( ( table1 . `INDEX_LENGTH` > '2002-07-12 17:21:39.049237' AND table1 . `CREATE_TIME` < '2004-12-06 06:54:17.037200') AND table1 . `AVG_ROW_LENGTH` <= '2002-01-26 18:05:42.053238') AND table1 . `DATA_LENGTH` >= 'c') HAVING NOT table1 . `INDEX_LENGTH` < 'lh' LIMIT 3", length=348, parser_state=0x7f3464f7ad10) 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
#18 0x00000000007dc5ec in dispatch_command (command=COM_QUERY, thd=0x7f344c63f000, packet=0x7f344c643001 " SELECT * FROM INFORMATION_SCHEMA . `GLOBAL_TEMPORARY_TABLES` AS table1 WHERE (NOT ( ( table1 . `INDEX_LENGTH` > '2002-07-12 17:21:39.049237' AND table1 . `CREATE_TIME` < '2004-12-06 06:54:17.037200') AND table1 .`AVG_ROW_LENGTH` <= '2002-01-26 18:05:42.053238') AND table1 . `DATA_LENGTH` >= 'c') HAVING NOT table1 . `INDEX_LENGTH` < 'lh' LIMIT 3", packet_length=349) 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
#19 0x00000000007db518 in do_command (thd=0x7f344c63f000) 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
#20 0x00000000008bf984 in threadpool_process_request (thd=0x7f344c63f000) 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
#21 0x00000000008c22c6 in handle_event (connection=0x7f344cbff1c0) 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
#22 0x00000000008c24f6 in worker_main (param=0x188d600 <all_groups+3584>) 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
#23 0x0000000000dbdbb8 in pfs_spawn_thread (arg=0x7f3467bbcba0) 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
#24 0x00007f3483d53df3 in start_thread () from /lib64/libpthread.so.0
#25 0x00007f3482a1d3dd in clone () from /lib64/libc.so.6

Likely related to bug 1222709, bug 1260154 and bug 1193308

Assigned to Vlad re: bug 1222709

[Roel Van de Paar (roel11)]

Vlad, can you please check if it's the same issue and what can be done here?

[Roel Van de Paar (roel11)]

5.1/5.5 may have same problem given bug #1222709

[Roel Van de Paar (roel11)]

This issue is seen in a fair amount of QA runs. Close to "qablock"

[Roel Van de Paar (roel11)]

Another occurence from a bit older run on Percona-Server-5.6.19-rel67.0-619

[Laurynas Biveinis (laurynas-biveinis)]

I thought I_S.GLOBAL_TEMP_TABLES queries are currently disabled in RQG tests?

[Roel Van de Paar (roel11)]

It is only disabled in Percona base grammar, not other runs

[Laurynas Biveinis (laurynas-biveinis)]

I think it should be disabled everywhere for now, or any new bugs will drown out among the reports that are duplicates of the currently open ones.

[Roel Van de Paar (roel11)]

Laurynas, ack. Can try. Would filter for "GLOBAL_TEMPORARY_TABLES" word be enough?

[Laurynas Biveinis (laurynas-biveinis)]

I guess so.

[Roel Van de Paar (roel11)]

Done for pquery
grep -vi "information_schema[ \.\t]*[global_]*temporary_tables" | \

[Roel Van de Paar (roel11)]

More crashes in various areas that are now being filtered

# i-s-temp-tables bugs: see https://bugs.launchpad.net/percona-server/+bugs?field.tag=i-s-temp-tables
grep 'Z21fill_temporary_tablesP3THDP10TABLE_LI' reducer* | sed 's|[a-z]*||;s|.sh.*||' | xargs -I_ $D _ # Another i-s-temp-tables bug (based on crashing query)
grep 'Z24get_schema_tables_resultP4JOIN23enum_' reducer* | sed 's|[a-z]*||;s|.sh.*||' | xargs -I_ $D _ # Another i-s-temp-tables bug (based on crashing query)
grep 'ZN12ha_myisammrg5cloneEPKcP11st_mem_root' reducer* | sed 's|[a-z]*||;s|.sh.*||' | xargs -I_ $D _ # Another i-s-temp-tables bug (based on crashing query)

[Roel Van de Paar (roel11)]

Done for RQG grammars (rqg commit 1042) - they were already disabled, but now the other i_s ones are re-enabled and some more info added.

[Roel Van de Paar (roel11)]

information_schema[ \.\t]*[global_]*temporary_tables grep exclusion added for maxigen also