handle_fatal_signal (sig=11) in store_temporary_table_record at sql/sql_show.cc:3967

[Roel Van de Paar]

Thread 1 (LWP 11984):
+bt
#0 0x000000340cc0c69c in pthread_kill () from /lib64/libpthread.so.0
#1 0x0000000000686bde in handle_fatal_signal (sig=11) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/signal_handler.cc:251
#2 <signal handler called>
#3 0x00000000007555ab in store_temporary_table_record (thd=0x23bfd80, table=0x7f7894017e80, tmp_table=<optimized out>, db=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_show.cc:3967
#4 0x0000000000764b39 in fill_global_temporary_tables (thd=0x2496e80, tables=0x7f7894005238, cond=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_show.cc:4043
#5 0x0000000000759219 in do_fill_table (join_table=<optimized out>, table_list=0x7f7894005238, thd=0x2496e80) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_show.cc:7714
#6 get_schema_tables_result (join=0x7f7894023e40, executed_place=PROCESSED_BY_JOIN_EXEC) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_show.cc:7815
#7 0x0000000000746425 in JOIN::prepare_result (this=0x7f7894023e40, columns_list=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_select.cc:823
#8 0x00000000006fd211 in JOIN::exec (this=0x7f7894023e40) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_executor.cc:116
#9 0x00000000007492d0 in mysql_execute_select (free_join=true, select_lex=0x2499958, thd=0x2496e80) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_select.cc:1101
#10 mysql_select (thd=0x2496e80, tables=0x7f7894005238, wild_num=1, fields=..., conds=0x7f7894022490, order=<optimized out>, group=0x2499a58, having=0x7f7894022e08, select_options=2684619520, result=0x7f7894023d90, unit=0x2499310, select_lex=0x2499958) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_select.cc:1222
#11 0x0000000000749dbb in handle_select (thd=0x2496e80, result=0x7f7894023d90, setup_tables_done_option=0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_select.cc:111
#12 0x000000000071ecdd in execute_sqlcom_select (thd=0x2496e80, all_tables=0x7f7894005238) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:5305
#13 0x00000000007217b7 in mysql_execute_command (thd=0x2496e80) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:2762
#14 0x0000000000727818 in mysql_parse (thd=0x2496e80, rawbuf=0x2499248 "\360R7\001", length=<optimized out>, parser_state=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:6477
#15 0x000000000072871f in dispatch_command (command=COM_QUERY, thd=0x2496e80, packet=0x249a801 " SELECT * FROM INFORMATION_SCHEMA . `GLOBAL_TEMPORARY_TABLES` AS table1 WHERE (NOT ( (NOT table1 . `DATA_LENGTH` < '2002-02-15 22:55:51.046345' AND table1 . `TABLE_NAME` >= '2009-06-26 09:15:55.042403') OR table1 . `AVG_ROW_LENGTH` = table1 . `DATA_LENGTH`) OR table1 . `TABLE_SCHEMA` >= '2008-04-11 20:34:12.047478') HAVING (table1 . `UPDATE_TIME` < '2000-08-23 04:05:00.026536' IS NULL OR table1 . `AVG_ROW_LENGTH` = '2002-01-03 10:19:31.003921') LIMIT 9", packet_length=457) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374
#16 0x0000000000729a47 in do_command (thd=0x2496e80) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1049
#17 0x00000000006ed63f in do_handle_one_connection (thd_arg=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1615
#18 0x00000000006ed727 in handle_one_connection (arg=0x2496e80) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526
#19 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x2311be0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855
#20 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0
#21 0x000000340c4e890d in clone () from /lib64/libc.so.6

2013-07-16 16:55:18 11910 [Note] /ssd/Percona-Server-5.6.12-rc60.4-405-debug.Linux.x86_64/bin/mysqld: ready for connections.
Version: '5.6.12-rc60.4-debug-log' socket: '/ssd/441045/current1_1/tmp/master.sock' port: 13000 Percona Server with XtraDB (GPL), Release rc60.4, Revision 405-debug
13:55:45 UTC - mysqld got signal 11 ;
[...]
Query (7f7894004c50): SELECT * FROM INFORMATION_SCHEMA . `GLOBAL_TEMPORARY_TABLES` AS table1 WHERE (NOT ( (NOT table1 . `DATA_LENGTH` < '2002-02-15 22:55:51.046345' AND table1 . `TABLE_NAME` >= '2009-06-26 09:15:55.042403') OR table1 . `AVG_ROW_LENGTH` = table1 . `DATA_LENGTH`) OR table1 . `TABLE_SCHEMA` >= '2008-04-11 20:34:12.047478') HAVING (table1 . `UPDATE_TIME` < '2000-08-23 04:05:00.026536' IS NULL OR table1 . `AVG_ROW_LENGTH` = '2002-01-03 10:19:31.003921') LIMIT 9
Connection ID (thread ID): 22

[Laurynas Biveinis (laurynas-biveinis)]

This is caused by bug 1206486, marking this one as duplicate.