mysqld got signal 11 ; on SET GLOBAL query_cache_size=default | handle_fatal_signal (sig=11) in Query_cache::free_cache

[Roel Van de Paar]

2014-10-20 18:26:04 7f4a090a3700 InnoDB: Error: Table "mysql"."innodb_index_stats" not found.
2014-10-20 18:26:04 7f4a090a3700 InnoDB: Error: Fetch of persistent statistics requested for table "mysqltest"."t2" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
07:26:04 UTC - mysqld got signal 11 ;
[...]
Query (7f49c0004e90): SET GLOBAL query_cache_size=default
Connection ID (thread ID): 4
Status: NOT_KILLED

Single threaded run, single mysqld involved

Thread 1 (Thread 0x7f4a090a3700 (LWP 8251)):
+bt
#0 0x00007f4a224ad771 in pthread_kill () from /lib64/libpthread.so.0
#1 0x0000000000ab7586 in my_write_core (sig=11) 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=11) 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 0x00007f4a210f846d in malloc_consolidate () from /lib64/libc.so.6
#5 0x00007f4a210f9097 in _int_free () from /lib64/libc.so.6
#6 0x0000000000ab19f8 in my_free (ptr=0x7f49b41b2160) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/mysys/my_malloc.c:140
#7 0x0000000000789512 in Query_cache::free_cache (this=0x18724a0 <query_cache>) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_cache.cc:2685
#8 0x0000000000785248 in Query_cache::resize (this=0x18724a0 <query_cache>, query_cache_size_arg=1048576) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_cache.cc:1351
#9 0x000000000088649f in fix_query_cache_size (self=0x188b580 <Sys_query_cache_size>, thd=0x2a30460, type=OPT_GLOBAL) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sys_vars.cc:2623
#10 0x000000000072d450 in sys_var::update (this=0x188b580 <Sys_query_cache_size>, thd=0x2a30460, var=0x7f49c0004f70) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/set_var.cc:194
#11 0x000000000072d94e in sys_var::set_default (this=0x188b580 <Sys_query_cache_size>, thd=0x2a30460, var=0x7f49c0004f70) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/set_var.cc:258
#12 0x000000000072e5da in set_var::update (this=0x7f49c0004f70, thd=0x2a30460) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/set_var.cc:679
#13 0x000000000072e12e in sql_set_variables (thd=0x2a30460, var_list=0x2a33668) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/set_var.cc:579
#14 0x00000000007e60bc in mysql_execute_command (thd=0x2a30460) 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:4122
#15 0x00000000007ed193 in mysql_parse (thd=0x2a30460, rawbuf=0x7f49c0004e90 "SET GLOBAL query_cache_size=default", length=35, parser_state=0x7f4a090a1d50) 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=0x2a30460, packet=0x321f971 "SET GLOBAL query_cache_size=default;", packet_length=36) 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=0x2a30460) 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=0x2a30460) 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=0x31bf7f0) 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=0x31e2840) 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 0x00007f4a224a8df3 in start_thread () from /lib64/libpthread.so.0
#23 0x00007f4a2117201d 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-3220