mysqld got signal 11 ; | handle_fatal_signal (sig=11) in list_delete | on SET SESSION innodb_ft_user_stopword_table = default

[Roel Van de Paar]

[...see error log for more messages...]
InnoDB: user stopword table test/user_stopword does not exist.
InnoDB: user stopword table test/user_stopword_1 does not exist.
02:32:48 UTC - mysqld got signal 11 ;
[...]
Query (7f96dc004e90): SET SESSION innodb_ft_user_stopword_table = default
Connection ID (thread ID): 4
Status: NOT_KILLED

Thread 1 (Thread 0x7f972dc3e700 (LWP 17388)):
+bt
#0 0x00007f9747043771 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 0x0000000000a98cf8 in list_delete (root=0x7f96dc0bde00, element=0x7f96dc0de930) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/mysys/list.c:52
#5 0x00000000007fa5e5 in plugin_var_memalloc_session_update (thd=0x36544b0, var=0x1597120 <mysql_sysvar_ft_user_stopword_table>, dest=0x7f96dc001338, value=0x0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_plugin.cc:3076
#6 0x00000000007fac5e in sys_var_pluginvar::session_update (this=0x3664ff8, thd=0x36544b0, var=0x7f96dc004f90) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_plugin.cc:3237
#7 0x000000000072d49b in sys_var::update (this=0x3664ff8, thd=0x36544b0, var=0x7f96dc004f90) 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:197
#8 0x000000000072d94e in sys_var::set_default (this=0x3664ff8, thd=0x36544b0, var=0x7f96dc004f90) 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
#9 0x000000000072e5da in set_var::update (this=0x7f96dc004f90, thd=0x36544b0) 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
#10 0x000000000072e12e in sql_set_variables (thd=0x36544b0, var_list=0x36576b8) 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
#11 0x00000000007e60bc in mysql_execute_command (thd=0x36544b0) 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
#12 0x00000000007ed193 in mysql_parse (thd=0x36544b0, rawbuf=0x7f96dc004e90 "SET SESSION innodb_ft_user_stopword_table = default", length=51, parser_state=0x7f972dc3cd50) 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
#13 0x00000000007df5fc in dispatch_command (command=COM_QUERY, thd=0x36544b0, packet=0x3e4f6c1 "SET SESSION innodb_ft_user_stopword_table = default;", packet_length=52) 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
#14 0x00000000007de528 in do_command (thd=0x36544b0) 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
#15 0x00000000008c2c30 in threadpool_process_request (thd=0x36544b0) 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
#16 0x00000000008c5572 in handle_event (connection=0x3cdd3c0) 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
#17 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
#18 0x0000000000dc5bac in pfs_spawn_thread (arg=0x7f96dc004ba0) 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
#19 0x00007f974703edf3 in start_thread () from /lib64/libpthread.so.0
#20 0x00007f9745d0801d in clone () from /lib64/libc.so.6

[Roel Van de Paar (roel11)]

Single threaded run, single mysqld involved

[Ramesh Sivaraman (rameshvs02)]

********* Testcase

DROP DATABASE test;CREATE DATABASE test;USE test;
CREATE TABLE user_stopword(value varchar(0)) ENGINE=InnoDB;
set session innodb_ft_user_stopword_table="test/user_stopword";
SET STATEMENT myisam_sort_buffer_size=0,myisam_repair_threads=0,sort_buffer_size=0,binlog_format=row,keep_files_on_create=OFF,max_join_size=0 FOR PREPARE stmt0 FROM 'SELECT * from user_stopword';
SET SESSION innodb_ft_user_stopword_table=default;

[Roel Van de Paar (roel11)]

Laurynas to confirm triage

[Shahriyar Rzayev (rzayev-sehriyar)]

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