handle_fatal_signal (sig=11) in I_P_List_iterator | sql/sql_plist.h:188

[Ramesh Sivaraman]

** Testcase

DROP DATABASE test;CREATE DATABASE test;USE test;
create table user_stopword_session(value varchar(1)) engine=innodb;
set session innodb_ft_user_stopword_table="test/user_stopword_session";
CREATE TABLE t1(c1 INT,c2 CHAR(1),c3 INT(1),c4 CHAR(1) KEY,c5 INT UNIQUE KEY,c6 DECIMAL(0,0) DEFAULT 3.141592);
SET STATEMENT myisam_sort_buffer_size=400000,myisam_repair_threads=2,sort_buffer_size=200000,binlog_format=row,keep_files_on_create=OFF,max_join_size=4444440000000 FOR PREPARE stmt2 FROM 'SELECT * ';
LOCK TABLES t1 WRITE,t1 b READ;
SET profiling=1;
SET SESSION innodb_ft_user_stopword_table=default;

The attached tarball gives the testcase as an exact match of our
system,
including some handy utilities

$ vi {epoch}_mybase # Update base path in this file (the only change
required!). For non-binary distribution please update SOURCE_DIR
location also.
$ ./{epoch}_init # Initializes the data dir
$ ./{epoch}_start # Starts mysqld
$ ./{epoch}_cl # To check mysqld is up
$ ./{epoch}_run # Run the testcase with pquery binary(produces
output)
$ vi /dev/shm/{epoch}/error.log.out # Verify the error log
$ ./{epoch}_gdb # Brings you to a gdb prompt attached to correct
mysqld
& generated core
$ ./{epoch}_parse_core # Create {epoch}_STD.gdb and {epoch}_FULL.gdb;
standard and full var gdb stack traces
etc.

** GDB info

#0 0x00007f4614cb4771 in __pthread_kill (threadid=<optimized out>, signo=11) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
#1 0x0000000000abb47a in my_write_core (sig=11) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/mysys/stacktrace.c:422
#2 0x00000000007312c3 in handle_fatal_signal (sig=11) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/sql/signal_handler.cc:236
#3 <signal handler called>
#4 0x000000000072148e in I_P_List_iterator<MDL_ticket, I_P_List<MDL_ticket, I_P_List_adapter<MDL_ticket, &MDL_ticket::next_in_context, &MDL_ticket::prev_in_context>, I_P_List_null_counter, I_P_List_no_push_back<MDL_ticket> > >::operator++ (this=0x7f461526ccd0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/sql/sql_plist.h:188
#5 0x0000000000720066 in MDL_context::set_transaction_duration_for_all_locks (this=0x7f4602f71138) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/sql/mdl.cc:3231
#6 0x00000000007a1c39 in THD::leave_locked_tables_mode (this=0x7f4602f71000) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/sql/sql_class.cc:5012
#7 0x0000000000773390 in Locked_tables_list::unlock_locked_tables (this=0x7f4602f733d0, thd=0x7f4602f71000) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/sql/sql_base.cc:3519
#8 0x00000000007986b5 in THD::cleanup (this=0x7f4602f71000) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/sql/sql_class.cc:1690
#9 0x00000000007989cb in THD::release_resources (this=0x7f4602f71000) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/sql/sql_class.cc:1771
#10 0x0000000000625a6c in one_thread_per_connection_end (thd=0x7f4602f71000, block_pthread=true) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/sql/mysqld.cc:2833
#11 0x00000000007a7dc4 in do_handle_one_connection (thd_arg=0x7f4602f71000) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/sql/sql_connect.cc:1546
#12 0x00000000007a7815 in handle_one_connection (arg=0x7f4602f71000) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/sql/sql_connect.cc:1443
#13 0x0000000000dcc8ac in pfs_spawn_thread (arg=0x7f460e341240) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/storage/perfschema/pfs.cc:1860
#14 0x00007f4614cafdf5 in start_thread (arg=0x7f461526d700) at pthread_create.c:308
#15 0x00007f46139791ad in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:113

[Shahriyar Rzayev (rzayev-sehriyar)]

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