Assertion `!table->file || table->file->inited == handler::NONE' failed. in sql/sql_base.cc:1480 | abort (sig=6) in close_thread_table

[Roel Van de Paar]

2014-10-20 07:07:43 28666 [Warning] Could not remove temporary table: '/dev/shm/629181/11962/tmp/#sql6ffa_4_6', error: 0
mysqld: /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_base.cc:1480: void close_thread_table(THD*, TABLE**): Assertion `!table->file || table->file->inited == handler::NONE' failed.
20:07:43 UTC - mysqld got signal 6 ;
[...]
Query (7f63dc004e90): SET GLOBAL query_cache_type=OFF
Connection ID (thread ID): 4
Status: NOT_KILLED

(gdb) bt
#0 0x00007f64489f6771 in pthread_kill () from /lib64/libpthread.so.0
#1 0x0000000000ab7586 in my_write_core (sig=6) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/mysys/stacktrace.c:422
#2 0x000000000072f9ff in handle_fatal_signal (sig=6) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/signal_handler.cc:236
#3 <signal handler called>
#4 0x00007f64475fa5c9 in raise () from /lib64/libc.so.6
#5 0x00007f64475fbcd8 in abort () from /lib64/libc.so.6
#6 0x00007f64475f3536 in __assert_fail_base () from /lib64/libc.so.6
#7 0x00007f64475f35e2 in __assert_fail () from /lib64/libc.so.6
#8 0x000000000076d91e in close_thread_table (thd=0x31704e0, table_ptr=0x7f63e0152d68) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_base.cc:1480
#9 0x00000000007bc403 in mysql_ha_close_table (thd=0x31704e0, tables=0x7f63e0152cc0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_handler.cc:137
#10 0x00000000007be9f0 in mysql_ha_flush (thd=0x31704e0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_handler.cc:985
#11 0x0000000000774586 in open_tables (thd=0x31704e0, start=0x7f64403f3a90, counter=0x7f64403f3ad4, flags=0, prelocking_strategy=0x7f64403f3b10) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_base.cc:5137
#12 0x000000000077577d in open_and_lock_tables (thd=0x31704e0, tables=0x0, derived=true, flags=0, prelocking_strategy=0x7f64403f3b10) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_base.cc:5860
#13 0x000000000076751d in open_and_lock_tables (thd=0x31704e0, tables=0x0, derived=true, flags=0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_base.h:477
#14 0x00000000007e608a in mysql_execute_command (thd=0x31704e0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_parse.cc:4120
#15 0x00000000007ed193 in mysql_parse (thd=0x31704e0, rawbuf=0x7f63dc004e90 "SET GLOBAL query_cache_type=OFF", length=31, parser_state=0x7f64403f4d50) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_parse.cc:6773
#16 0x00000000007df5fc in dispatch_command (command=COM_QUERY, thd=0x31704e0, packet=0x39748d1 "SET GLOBAL query_cache_type=OFF;", packet_length=32) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_parse.cc:1432
#17 0x00000000007de528 in do_command (thd=0x31704e0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_parse.cc:1049
#18 0x00000000008c2c30 in threadpool_process_request (thd=0x31704e0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/threadpool_common.cc:311
#19 0x00000000008c5572 in handle_event (connection=0x390e470) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/threadpool_unix.cc:1553
#20 0x00000000008c57a2 in worker_main (param=0x1898400 <all_groups+2048>) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/threadpool_unix.cc:1606
#21 0x0000000000dc5bac in pfs_spawn_thread (arg=0x38fcd00) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/perfschema/pfs.cc:1860
#22 0x00007f64489f1df3 in start_thread () from /lib64/libpthread.so.0
#23 0x00007f64476bb01d in clone () from /lib64/libc.so.6

[Shahriyar Rzayev (rzayev-sehriyar)]

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