handle_fatal_signal (sig=11) in thd_sql_command at sql/sql_class.cc:700 on SELECT FROM I_S query

Bug #1206020 reported by Roel Van de Paar
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Incomplete
High
Roel Van de Paar
5.1
Expired
Undecided
Unassigned
5.5
Expired
Undecided
Unassigned
5.6
Incomplete
High
Roel Van de Paar

Bug Description

Thread 1 (LWP 19549):
+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 thd_sql_command (thd=0x8f8f8f8f8f8f8f8f) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_class.cc:700
#4 0x0000000000a08e49 in ha_innobase::info_low (this=0x7f40e006b4b0, flag=22, is_analyze=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/handler/ha_innodb.cc:11309
#5 0x00000000007555b1 in store_temporary_table_record (thd=0x36d3110, table=0x7f40e001db90, tmp_table=<optimized out>, db=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_show.cc:3967
#6 0x0000000000764b39 in fill_global_temporary_tables (thd=0x36c7010, tables=0x7f40e00050a8, cond=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_show.cc:4043
#7 0x0000000000759219 in do_fill_table (join_table=<optimized out>, table_list=0x7f40e00050a8, thd=0x36c7010) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_show.cc:7714
#8 get_schema_tables_result (join=0x7f40e0038e08, executed_place=PROCESSED_BY_JOIN_EXEC) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_show.cc:7815
#9 0x0000000000746425 in JOIN::prepare_result (this=0x7f40e0038e08, columns_list=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_select.cc:823
#10 0x00000000006fd211 in JOIN::exec (this=0x7f40e0038e08) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_executor.cc:116
#11 0x00000000007492d0 in mysql_execute_select (free_join=true, select_lex=0x36c9ae8, thd=0x36c7010) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_select.cc:1101
#12 mysql_select (thd=0x36c7010, tables=0x7f40e00050a8, wild_num=1, fields=..., conds=0x7f40e00066b8, order=<optimized out>, group=0x36c9be8, having=0x0, select_options=2684619520, result=0x7f40e0038de0, unit=0x36c94a0, select_lex=0x36c9ae8) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_select.cc:1222
#13 0x0000000000749dbb in handle_select (thd=0x36c7010, result=0x7f40e0038de0, setup_tables_done_option=0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_select.cc:111
#14 0x000000000071ecdd in execute_sqlcom_select (thd=0x36c7010, all_tables=0x7f40e00050a8) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:5305
#15 0x00000000007217b7 in mysql_execute_command (thd=0x36c7010) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:2762
#16 0x0000000000727818 in mysql_parse (thd=0x36c7010, rawbuf=0x36c93d8 "\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
#17 0x000000000072871f in dispatch_command (command=COM_QUERY, thd=0x36c7010, packet=0x37d8671 " SELECT * FROM INFORMATION_SCHEMA . `GLOBAL_TEMPORARY_TABLES` AS table1 WHERE ( ( ( table1 . `SESSION_ID` = table1 . `CREATE_TIME` AND table1 . `UPDATE_TIME` >= 6) AND table1 . `UPDATE_TIME` < table1 . `CREATE_TIME`) OR table1 . `TABLE_ROWS` = 'h') LIMIT 8", packet_length=257) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374
#18 0x0000000000729a47 in do_command (thd=0x36c7010) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1049
#19 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
#20 0x00000000006ed727 in handle_one_connection (arg=0x36c7010) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526
#21 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x3651d60) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855
#22 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0
#23 0x000000340c4e890d in clone () from /lib64/libc.so.6

2013-07-13 22:34:47 19493 [ERROR] /ssd/Percona-Server-5.6.12-rc60.4-405-debug.Linux.x86_64/bin/mysqld: Deadlock found when trying to get lock; try restarting transaction
2013-07-13 22:34:47 19493 [ERROR] /ssd/Percona-Server-5.6.12-rc60.4-405-debug.Linux.x86_64/bin/mysqld: Sort aborted: Deadlock found when trying to get lock; try restarting transaction
19:34:48 UTC - mysqld got signal 11 ;
[...]
Query (7f40e0004c50): SELECT * FROM INFORMATION_SCHEMA . `GLOBAL_TEMPORARY_TABLES` AS table1 WHERE ( ( ( table1 . `SESSION_ID` = table1 . `CREATE_TIME` AND table1 . `UPDATE_TIME` >= 6) AND table1 . `UPDATE_TIME` < table1 . `CREATE_TIME`) OR table1 . `TABLE_ROWS` = 'h') LIMIT 8
Connection ID (thread ID): 21
Status: NOT_KILLED

Revision history for this message
Roel Van de Paar (roel11) wrote :
Revision history for this message
Roel Van de Paar (roel11) wrote :
Revision history for this message
Roel Van de Paar (roel11) wrote :
Revision history for this message
Roel Van de Paar (roel11) wrote :
Revision history for this message
Roel Van de Paar (roel11) wrote :

No yy file available

tags: added: i-s-temp-tables
Revision history for this message
Roel Van de Paar (roel11) wrote :

Adding additional occurrence, with yy file

Revision history for this message
Roel Van de Paar (roel11) wrote :
Revision history for this message
Roel Van de Paar (roel11) wrote :
Revision history for this message
Roel Van de Paar (roel11) wrote :
Revision history for this message
Roel Van de Paar (roel11) wrote :
Revision history for this message
Laurynas Biveinis (laurynas-biveinis) wrote :

Similar to bug 1204859, but with user_thd trashed instead of upd_buf. Same way to proceed as with that bug.

Revision history for this message
Launchpad Janitor (janitor) wrote :

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

Revision history for this message
Launchpad Janitor (janitor) wrote :

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

Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

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

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

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.