handle_fatal_signal (sig=11) in inline_mysql_mutex_lock | psi/mysql_thread.h:659

Bug #1417116 reported by Ramesh Sivaraman on 2015-02-02
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;
GRANT SELECT ON _db1.* TO _u1@localhost;
SET @@GLOBAL.userstat=ON;
create temporary table t1(a int,index (a))ENGINE=InnoDB;
LOCK BINLOG FOR BACKUP;
create table t2(b bit);
LOCK TABLES t2 WRITE,t1 WRITE;
LOCK TABLES schema.instances WRITE;
CREATE SQL SECURITY DEFINER VIEW mysqltest1.ti AS SELECT * FROM mysqltest1.t1;
DROP TABLE IF EXISTS table0;
BINLOG '0';
GRANT REPLICATION CLIENT ON *.* TO _u1@localhost;

** startup

--plugin-load=audit_log=audit_log.so --audit_log_strategy=PERFORMANCE --audit_log_flush=ON --audit_log_buffer_size=1G --audit_log_format=NEW --audit_log_rotate_on_size=20 --audit_log_rotations=10 --event-scheduler=ON --maximum-bulk_insert_buffer_size=1M --maximum-join_buffer_size=1M --maximum-max_heap_table_size=1M --maximum-max_join_size=1M --maximum-myisam_max_sort_file_size=1M --maximum-myisam_mmap_size=1M --maximum-myisam_sort_buffer_size=1M --maximum-optimizer_trace_max_mem_size=1M --maximum-preload_buffer_size=1M --maximum-query_alloc_block_size=1M --maximum-query_prealloc_size=1M --maximum-range_alloc_block_size=1M --maximum-read_buffer_size=1M --maximum-read_rnd_buffer_size=1M --maximum-sort_buffer_size=1M --maximum-tmp_table_size=1M --maximum-transaction_alloc_block_size=1M --maximum-transaction_prealloc_size=1M --log-output=none --sql_mode=ONLY_FULL_GROUP_BY --log-error=/dev/shm/1422875776/error.log.out --event-scheduler=ON

** GDB info

#0 0x00007fca1cfd1771 in pthread_kill () from /lib64/libpthread.so.0
#1 0x00000000006772cd in handle_fatal_signal (sig=11) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/signal_handler.cc:236
#2 <signal handler called>
#3 inline_mysql_mutex_lock (src_file=0xbfd2f8 "/mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/mdl.cc", src_line=1117, that=0x71) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/include/mysql/psi/mysql_thread.h:659
#4 remove (lock=0x7fc9bcc6c580, this=0x1) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/mdl.cc:1117
#5 MDL_map::remove (this=this@entry=0x137ab80 <mdl_locks>, lock=lock@entry=0x7fc9bcc6c580) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/mdl.cc:1105
#6 0x000000000066a049 in MDL_lock::remove_ticket (this=0x7fc9bcc6c580, list=list@entry=&MDL_lock::m_granted, ticket=ticket@entry=0x7fc9bcc240c0) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/mdl.cc:1908
#7 0x000000000066af3a in MDL_context::release_lock (this=<optimized out>, duration=<optimized out>, ticket=0x7fc9bcc240c0) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/mdl.cc:2869
#8 0x000000000066af72 in MDL_context::release_lock (this=<optimized out>, ticket=<optimized out>) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/mdl.cc:2889
#9 0x00000000007eed3c in Global_backup_lock::release (this=this@entry=0x7fca0a73aa08, thd=thd@entry=0x7fca0a739000) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/lock.cc:1144
#10 0x00000000006c84ad in THD::cleanup (this=this@entry=0x7fca0a739000) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/sql_class.cc:1704
#11 0x00000000006c8858 in THD::release_resources (this=this@entry=0x7fca0a739000) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/sql_class.cc:1771
#12 0x00000000005adb9c in one_thread_per_connection_end (thd=0x7fca0a739000, block_pthread=true) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/mysqld.cc:2833
#13 0x00000000006cc316 in do_handle_one_connection (thd_arg=thd_arg@entry=0x7fca0a739000) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/sql_connect.cc:1546
#14 0x00000000006cc480 in handle_one_connection (arg=arg@entry=0x7fca0a739000) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/sql_connect.cc:1443
#15 0x0000000000afd6b3 in pfs_spawn_thread (arg=0x7fca1673f060) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/storage/perfschema/pfs.cc:1860
#16 0x00007fca1cfccdf3 in start_thread () from /lib64/libpthread.so.0
#17 0x00007fca1bc961ad in clone () from /lib64/libc.so.6

Tags: qa Edit Tag help
Ramesh Sivaraman (rameshvs02) wrote :

PFA testcase info. To reproduce this bug please change 1422875776_mybase to PS base path, then init > start > cl (to verify it's up) > run. But testcase above should work fine.

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers