handle_fatal_signal (sig=11) in Rpl_info::~Rpl_info | sql/rpl_info.cc:70

Bug #1401068 reported by Ramesh Sivaraman on 2014-12-10
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server
Status tracked in 5.7
5.1
Undecided
Unassigned
5.5
Undecided
Unassigned
5.6
High
Unassigned
5.7
High
Unassigned

Bug Description

** Testcase

DROP DATABASE test;CREATE DATABASE test;USE test;
set global sync_relay_log=0;
create table user_stopword(value varchar(30)) engine = innodb;
set session innodb_ft_user_stopword_table = "test/user_stopword";
CREATE TABLE t1(c1 FLOAT UNSIGNED NULL);
update performance_schema.setup_consumers set enabled='NO' where name='global_instrumentation';
SET GLOBAL innodb_log_archive = OFF;
SET STATEMENT sort_buffer_size=150000 FOR SELECT * FROM t1 ;
CREATE SCHEMA schema1;
BINLOG ' SOgWTg8BAAAAbgAAAHIAAAAAAAQANS42LjMtbTUtZGVidWctbG9nAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAABI6BZOEzgNAAgAEgAEBAQEEgAAVgAEGggAAAAICAgCAAAAAAVAYI8= '/*!*/;
set session innodb_ft_user_stopword_table = default;
show global variables like 'performance_schema_max_socket_instances';
SET @@session.pseudo_slave_mode = FALSE;

** GDB info

+bt
#0 0x00007f4f826f7771 in pthread_kill () from /lib64/libpthread.so.0
#1 0x000000000067679d in handle_fatal_signal (sig=11) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.21-70.0/sql/signal_handler.cc:236
#2 <signal handler called>
#3 0x00000000008c1047 in Rpl_info::~Rpl_info (this=0x7f4ec9093000, __in_chrg=<optimized out>) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.21-70.0/sql/rpl_info.cc:70
#4 0x00000000008c0bb1 in Relay_log_info::~Relay_log_info (this=0x7f4ec9093000, __in_chrg=<optimized out>) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.21-70.0/sql/rpl_rli.cc:183
#5 0x0000000000769e97 in check_pseudo_slave_mode (self=<optimized out>, thd=0x7f4ef2335000, var=<optimized out>) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.21-70.0/sql/sys_vars.cc:4749
#6 0x0000000000675337 in sys_var::check (this=0x137eb00 <Sys_pseudo_slave_mode>, thd=thd@entry=0x7f4ef2335000, var=var@entry=0x7f4ec901d190) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.21-70.0/sql/set_var.cc:214
#7 0x0000000000675837 in set_var::check (this=0x7f4ec901d190, thd=0x7f4ef2335000) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.21-70.0/sql/set_var.cc:632
#8 0x0000000000675ea9 in sql_set_variables (thd=thd@entry=0x7f4ef2335000, var_list=var_list@entry=0x7f4ef23381d8) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.21-70.0/sql/set_var.cc:572
#9 0x00000000006f8e61 in mysql_execute_command (thd=thd@entry=0x7f4ef2335000) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.21-70.0/sql/sql_parse.cc:4126
#10 0x00000000006fc0e8 in mysql_parse (thd=thd@entry=0x7f4ef2335000, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7f4f82cad270) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.21-70.0/sql/sql_parse.cc:6777
#11 0x00000000006fd859 in dispatch_command (command=<optimized out>, thd=0x7f4ef2335000, packet=0x7f4ee63a8001 "SET @@session.pseudo_slave_mode = FALSE", packet_length=<optimized out>) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.21-70.0/sql/sql_parse.cc:1432
#12 0x00000000006ff5b9 in do_command (thd=<optimized out>) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.21-70.0/sql/sql_parse.cc:1049
#13 0x00000000006cb3c2 in do_handle_one_connection (thd_arg=thd_arg@entry=0x7f4ef2335000) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.21-70.0/sql/sql_connect.cc:1532
#14 0x00000000006cb4b0 in handle_one_connection (arg=arg@entry=0x7f4ef2335000) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.21-70.0/sql/sql_connect.cc:1443
#15 0x0000000000af86d3 in pfs_spawn_thread (arg=0x7f4ef234b3e0) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.21-70.0/storage/perfschema/pfs.cc:1860
#16 0x00007f4f826f2df3 in start_thread () from /lib64/libpthread.so.0
#17 0x00007f4f813bc01d in clone () from /lib64/libc.so.6

Here is a testcase which was reduced with a very little extra effort:

create table user_stopword(value varchar(30)) engine = innodb;
set session innodb_ft_user_stopword_table = "test/user_stopword";
SET STATEMENT sort_buffer_size=150000 FOR SELECT * FROM user_stopword;
set session innodb_ft_user_stopword_table = default;
SET @@session.pseudo_slave_mode = FALSE;

(Please compare with the original and please apply this effort for the future testcases)

tags: added: set-statement
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers