handle_fatal_signal (sig=11) in ha_heap::table_type at storage/heap/ha_heap.h:39

Bug #1225208 reported by Roel Van de Paar on 2013-09-13
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server
High
Roel Van de Paar
5.1
Undecided
Unassigned
5.5
Undecided
Unassigned
5.6
High
Roel Van de Paar

Bug Description

PS @ Percona-Server-5.6.13-rc60.5-433-debug.Linux.x86_64 (QA-5.6 tree)
RQG @ 906 <email address hidden>

Thread 1 (LWP 25722):
+bt
#0 0x000000363720c69c in pthread_kill () from /lib64/libpthread.so.0
#1 0x00000000006874ae in handle_fatal_signal (sig=11) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/signal_handler.cc:251
#2 <signal handler called>
#3 ha_heap::table_type (this=0x7fa82800c770) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/storage/heap/ha_heap.h:39
#4 0x00000000007567c8 in store_temporary_table_record (thd=0x3461900, table=0x7fa83800de10, tmp_table=0x7fa82800af50, db=<optimized out>, belongs_to_this_connection=false) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/sql_show.cc:3940
#5 0x0000000000768e98 in fill_global_temporary_tables (thd=0x34416f0, tables=0x7fa838004ec8, cond=<optimized out>) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/sql_show.cc:4052
#6 0x000000000075a599 in do_fill_table (join_table=<optimized out>, table_list=0x7fa838004ec8, thd=0x34416f0) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/sql_show.cc:7725
#7 get_schema_tables_result (join=0x7fa8380062c8, executed_place=PROCESSED_BY_JOIN_EXEC) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/sql_show.cc:7826
#8 0x00000000007476e5 in JOIN::prepare_result (this=0x7fa8380062c8, columns_list=<optimized out>) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/sql_select.cc:823
#9 0x00000000006fd831 in JOIN::exec (this=0x7fa8380062c8) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/sql_executor.cc:116
#10 0x000000000074a5c0 in mysql_execute_select (free_join=true, select_lex=0x34441c0, thd=0x34416f0) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/sql_select.cc:1101
#11 mysql_select (thd=0x34416f0, tables=0x7fa838004ec8, wild_num=1, fields=..., conds=0x0, order=<optimized out>, group=0x34442c0, having=0x0, select_options=2687240704, result=0x7fa8380062a0, unit=0x3443b78, select_lex=0x34441c0) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/sql_select.cc:1222
#12 0x000000000074b0bb in handle_select (thd=0x34416f0, result=0x7fa8380062a0, setup_tables_done_option=0) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/sql_select.cc:111
#13 0x000000000071faed in execute_sqlcom_select (thd=0x34416f0, all_tables=0x7fa838004ec8) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/sql_parse.cc:5307
#14 0x00000000007225c7 in mysql_execute_command (thd=0x34416f0) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/sql_parse.cc:2764
#15 0x0000000000728628 in mysql_parse (thd=0x34416f0, rawbuf=0x3443ab0 "P\303\070\001", length=<optimized out>, parser_state=<optimized out>) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/sql_parse.cc:6479
#16 0x000000000072978c in dispatch_command (command=COM_QUERY, thd=0x34416f0, packet=0x7fa87059ba90 "\360\026D\003", packet_length=56) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/sql_parse.cc:1355
#17 0x000000000072a987 in do_command (thd=0x34416f0) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/sql_parse.cc:1049
#18 0x00000000006ee1ef in do_handle_one_connection (thd_arg=<optimized out>) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/sql_connect.cc:1615
#19 0x00000000006ee2d7 in handle_one_connection (arg=0x34416f0) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/sql_connect.cc:1526
#20 0x00000000009e033a in pfs_spawn_thread (arg=0x336bbc0) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/storage/perfschema/pfs.cc:1858
#21 0x0000003637207851 in start_thread () from /lib64/libpthread.so.0
#22 0x0000003636ee890d in clone () from /lib64/libc.so.6

Roel Van de Paar (roel11) wrote :
Roel Van de Paar (roel11) wrote :
Roel Van de Paar (roel11) wrote :
Roel Van de Paar (roel11) wrote :
Roel Van de Paar (roel11) wrote :
Roel Van de Paar (roel11) wrote :
tags: added: i-s-temp-tables

Roel -

Would it be possible to reduce the testcase involving table100_memory_int_autoinc? While fixing the immediate issue is easy, I was not able to figure out how did the server arrive at such temp table. I see its schema using the FRM in the vardir, and I see the ALTER TABLE that is executing at the time of failure, but repeating this in MTR does not repeat the failure.

tags: added: 56qual
Roel Van de Paar (roel11) wrote :

beta feature, so removing 56qual

tags: removed: 56qual qablock
Roel Van de Paar (roel11) wrote :

Also haven't seen it anymore in recent runs, could re-test with testcase however

Launchpad Janitor (janitor) wrote :

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

Launchpad Janitor (janitor) wrote :

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

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

Other bug subscribers