Comment 5 for bug 1188447

Revision history for this message
Przemek (pmalkowski) wrote :

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.