Another similar crash was observed on a slave that was stuck with status variable Slave_open_temp_tables = 1 all the time. After following statement was run:
select * from information_schema.global_temporary_tables;
the server crashed.
Version: Percona Server 5.5.36-34.2-34.2
Prior to crash, the temp table was confirm to exist on disk:
-rw-rw---- 1 mysql mysql 8568 Sep 23 15:07 #sql1a67_3ca8e30a_7a.frm
-rw-rw---- 1 mysql mysql 98304 Sep 23 15:08 #sql1a67_3ca8e30a_7a.ibd
Thread pointer: 0x1335fb400
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 7fdca36a1d78 thread_stack 0x40000
/usr/sbin/mysqld(my_print_stacktrace+0x35)[0x7c8425]
/usr/sbin/mysqld(handle_fatal_signal+0x4b4)[0x69d824]
/lib64/libpthread.so.0[0x32fe80f500]
/usr/sbin/mysqld[0x82c166]
/usr/sbin/mysqld[0x5da0c4]
/usr/sbin/mysqld[0x5eacac]
/usr/sbin/mysqld(_Z24get_schema_tables_resultP4JOIN23enum_schema_table_state+0x25e)[0x5d97de]
/usr/sbin/mysqld(_ZN4JOIN4execEv+0x4dd)[0x5d424d]
/usr/sbin/mysqld(_Z12mysql_selectP3THDPPP4ItemP10TABLE_LISTjR4ListIS1_ES2_jP8st_orderSB_S2_SB_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x12c)[0x5d612c]
/usr/sbin/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x1cd)[0x5d6bdd]
/usr/sbin/mysqld[0x590b5a]
/usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x1f1a)[0x59632a]
/usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x33b)[0x59937b]
/usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x1eb2)[0x59bb02]
/usr/sbin/mysqld(_Z24do_handle_one_connectionP3THD+0x13f)[0x63a5ff]
/usr/sbin/mysqld(handle_one_connection+0x51)[0x63a6e1]
/lib64/libpthread.so.0[0x32fe807851]
/lib64/libc.so.6(clone+0x6d)[0x32fe4e894d]
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (d2da8010): select * from information_schema.global_temporary_tables
Connection ID (thread ID): 1385568033
Status: NOT_KILLED
(...)
141024 12:47:00 [Note] Starting crash recovery...
141024 12:47:00 [Note] Crash recovery finished.
141024 12:47:00 InnoDB: Error: table `tmp`.`#sql1a67_3ca8e30a_7a` does not
exist in the InnoDB internal
InnoDB: data dictionary though MySQL is trying to drop it.
Another similar crash was observed on a slave that was stuck with status variable Slave_open_ temp_tables = 1 all the time. After following statement was run: schema. global_ temporary_ tables;
select * from information_
the server crashed.
Version: Percona Server 5.5.36-34.2-34.2
Prior to crash, the temp table was confirm to exist on disk: 3ca8e30a_ 7a.frm 3ca8e30a_ 7a.ibd
-rw-rw---- 1 mysql mysql 8568 Sep 23 15:07 #sql1a67_
-rw-rw---- 1 mysql mysql 98304 Sep 23 15:08 #sql1a67_
Thread pointer: 0x1335fb400 mysqld( my_print_ stacktrace+ 0x35)[0x7c8425] mysqld( handle_ fatal_signal+ 0x4b4)[ 0x69d824] libpthread. so.0[0x32fe80f5 00] mysqld[ 0x82c166] mysqld[ 0x5da0c4] mysqld[ 0x5eacac] mysqld( _Z24get_ schema_ tables_ resultP4JOIN23e num_schema_ table_state+ 0x25e)[ 0x5d97de] mysqld( _ZN4JOIN4execEv +0x4dd) [0x5d424d] mysqld( _Z12mysql_ selectP3THDPPP4 ItemP10TABLE_ LISTjR4ListIS1_ ES2_jP8st_ orderSB_ S2_SB_yP13selec t_resultP18st_ select_ lex_unitP13st_ select_ lex+0x12c) [0x5d612c] mysqld( _Z13handle_ selectP3THDP3LE XP13select_ resultm+ 0x1cd)[ 0x5d6bdd] mysqld[ 0x590b5a] mysqld( _Z21mysql_ execute_ commandP3THD+ 0x1f1a) [0x59632a] mysqld( _Z11mysql_ parseP3THDPcjP1 2Parser_ state+0x33b) [0x59937b] mysqld( _Z16dispatch_ command19enum_ server_ commandP3THDPcj +0x1eb2) [0x59bb02] mysqld( _Z24do_ handle_ one_connectionP 3THD+0x13f) [0x63a5ff] mysqld( handle_ one_connection+ 0x51)[0x63a6e1] libpthread. so.0[0x32fe8078 51] libc.so. 6(clone+ 0x6d)[0x32fe4e8 94d]
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 7fdca36a1d78 thread_stack 0x40000
/usr/sbin/
/usr/sbin/
/lib64/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/lib64/
/lib64/
Trying to get some variables. schema. global_ temporary_ tables
Some pointers may be invalid and cause the dump to abort.
Query (d2da8010): select * from information_
Connection ID (thread ID): 1385568033
Status: NOT_KILLED
(...) #sql1a67_ 3ca8e30a_ 7a` does not
141024 12:47:00 [Note] Starting crash recovery...
141024 12:47:00 [Note] Crash recovery finished.
141024 12:47:00 InnoDB: Error: table `tmp`.`
exist in the InnoDB internal
InnoDB: data dictionary though MySQL is trying to drop it.