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 on 2013-07-29
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

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

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 :

No yy file available

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

Adding additional occurrence, with yy file

Roel Van de Paar (roel11) wrote :
Roel Van de Paar (roel11) wrote :
Roel Van de Paar (roel11) wrote :
Roel Van de Paar (roel11) wrote :

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

Launchpad Janitor (janitor) wrote :

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

Launchpad Janitor (janitor) wrote :

[Expired for Percona Server 5.5 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