handle_fatal_signal (sig=11) in ha_partition::clone at sql/ha_partition.cc:3444 on SELECT from VIEW table

[Roel Van de Paar]

Thread 1 (LWP 14361):
+bt
#0 0x000000362fa0c69c in pthread_kill () from /lib64/libpthread.so.0
#1 0x00000000006a649f in handle_fatal_signal (sig=11) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/signal_handler.cc:254
#2 <signal handler called>
#3 0x0000000000c7411b in ha_partition::clone (this=0x7fc17c07c240, name=0x7fc17c05b298 "./query014330/#sql-37b1_42", mem_root=0x2d92d90) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/ha_partition.cc:3444
#4 0x000000000076ca61 in store_temporary_table_record (thd=thd@entry=0x2d8f6d0, table=0x7fc10c02ca90, db=<optimized out>, tmp_table=0x7fc17c05a6a0, tmp_table=0x7fc17c05a6a0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_show.cc:3961
#5 0x000000000076cdce in fill_global_temporary_tables (thd=thd@entry=0x2c81480, tables=tables@entry=0x7fc10c009588, cond=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_show.cc:4049
#6 0x0000000000775889 in do_fill_table (join_table=0x7fc10c00e740, table_list=0x7fc10c009588, thd=0x2c81480) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_show.cc:7727
#7 get_schema_tables_result (join=join@entry=0x7fc10c00b3e0, executed_place=executed_place@entry=PROCESSED_BY_JOIN_EXEC) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_show.cc:7828
#8 0x000000000075360d in JOIN::prepare_result (this=this@entry=0x7fc10c00b3e0, columns_list=columns_list@entry=0x7fc1b863cfa0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_select.cc:824
#9 0x000000000070b0d8 in JOIN::exec (this=this@entry=0x7fc10c00b3e0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_executor.cc:116
#10 0x0000000000707b6e in mysql_derived_materialize (thd=<optimized out>, lex=0x2c838b8, derived=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_derived.cc:425
#11 0x000000000070c29a in join_materialize_derived (tab=0x7fc10c00f698) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_executor.cc:2410
#12 0x000000000070ba12 in st_join_table::prepare_scan (this=0x7fc10c00f698) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_executor.cc:1302
#13 0x000000000070c9b8 in sub_select (join=0x7fc10c016458, join_tab=0x7fc10c00f698, end_of_records=false) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_executor.cc:1211
#14 0x000000000070b257 in do_select (join=0x7fc10c016458) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_executor.cc:930
#15 JOIN::exec (this=0x7fc10c016458) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_executor.cc:191
#16 0x000000000075cd15 in mysql_execute_select (free_join=true, select_lex=0x2c83fc8, thd=0x2c81480) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_select.cc:1101
#17 mysql_select (thd=thd@entry=0x2c81480, tables=0x7fc130005018, wild_num=1, fields=..., conds=0x0, order=order@entry=0x2c84190, group=group@entry=0x2c840c8, having=0x0, select_options=2147781376, result=result@entry=0x7fc10c016430, unit=0x2c83980, select_lex=select_lex@entry=0x2c83fc8) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_select.cc:1222
#18 0x000000000075d14d in handle_select (thd=thd@entry=0x2c81480, result=0x7fc10c016430, setup_tables_done_option=setup_tables_done_option@entry=0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_select.cc:111
#19 0x00000000005abd2a in execute_sqlcom_select (thd=thd@entry=0x2c81480, all_tables=0x7fc130005018) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:5473
#20 0x000000000073318b in mysql_execute_command (thd=thd@entry=0x2c81480) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:2886
#21 0x0000000000736c38 in mysql_parse (thd=thd@entry=0x2c81480, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7fc1b863e550) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:6647
#22 0x0000000000737991 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x2c81480, packet=packet@entry=0x2d1a5f1 "", packet_length=packet_length@entry=81) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:1438
#23 0x00000000007387ab in do_command (thd=thd@entry=0x2c81480) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:1051
#24 0x00000000007d76e7 in threadpool_process_request (thd=0x2c81480) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_common.cc:313
#25 0x00000000007d891f in handle_event (connection=0x2c45950) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1468
#26 worker_main (param=param@entry=0x153ca00 <all_groups+1024>) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1521
#27 0x00000000009bbd73 in pfs_spawn_thread (arg=0x2c80f20) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/perfschema/pfs.cc:1858
#28 0x000000362fa07851 in start_thread () from /lib64/libpthread.so.0
#29 0x000000362f2e894d in clone () from /lib64/libc.so.6

Query (7fc130004d70): SELECT * FROM transforms.view_14348_merge /* TRANSFORM_OUTCOME_UNORDERED_MATCH */
Connection ID (thread ID): 26
Status: NOT_KILLED

[Roel Van de Paar (roel11)]

See bug 1193264

[Roel Van de Paar (roel11)]

Server: 508 <email address hidden>
RQG: 940 <email address hidden>

[Laurynas Biveinis (laurynas-biveinis)]

Likely to be fixed with the rest of I_S.GLOBAL_TEMP_TABLES bugs.

[Launchpad Janitor (janitor)]

[Expired for Percona Server 5.7 because there has been no activity for 60 days.]

[Launchpad Janitor (janitor)]

[Expired for Percona Server 5.5 because there has been no activity for 60 days.]

[Launchpad Janitor (janitor)]

[Expired for Percona Server 5.6 because there has been no activity for 60 days.]

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-748