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

Bug #1417116 reported by Ramesh Sivaraman
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Status tracked in 5.7
5.1
Won't Fix
Undecided
Unassigned
5.5
New
Undecided
Unassigned
5.6
Triaged
High
Unassigned
5.7
Triaged
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
Revision history for this message
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.

Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

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

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

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.