5.5 mysqld daemon with installed handlersocket plugin ignores any signals
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
Invalid
|
Undecided
|
Unassigned | ||
5.1 |
Invalid
|
Undecided
|
Unassigned | ||
5.5 |
Fix Released
|
High
|
Laurynas Biveinis | ||
5.6 |
Invalid
|
Undecided
|
Unassigned |
Bug Description
After updating from Percona-
i discovered that the problem appears only while enabling handlersocket plugin and affected all versions higher than Percona-
how to reproduce:
install Percona-Server higher than Percona-
install handlersocket as usual
mysql> INSTALL PLUGIN handlersocket SONAME 'handlersocket.so';
add next row in my.cnf in [mysqld] section - loose_handlerso
restart percona server
after than you can try to stop it. mysqld ignores any signal except SIGKILL
here is my config
[mysqld]
socket = /local/
datadir = /local/mysql/data/
innodb_
innodb_
innodb_
innodb_
innodb_
loose_handlerso
description: | updated |
tags: | added: handlersocket |
tags: | added: pxc |
summary: |
- mysqld daemon with installed handlersocket plugin did not stop + mysqld daemon with installed handlersocket plugin ignores any signals |
Confirmed on Ubuntu:
openxs@ao756:~$ mysql -uroot -proot test 35.0-657. saucy (Ubuntu)
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 37
Server version: 5.5.37-
Copyright (c) 2009-2014 Percona LLC and/or its affiliates
Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show variables like '%handlers%'; ------- ------- ------- ----+-- -----+ ------- ------- ------- ----+-- -----+ accept_ balance | 0 | address | | backlog | 32768 | plain_secret | | plain_secret_ wr | | port_wr | | rcvbuf | 0 | readsize | 0 | sndbuf | 0 | threads | 16 | threads_ wr | 1 | timeout | 300 | verbose | 10 | wrlock_ timeout | 12 | ------- ------- ------- ----+-- -----+
mysql> show variables like '%handlers%';
+------
| Variable_name | Value |
+------
| handlersocket_
| handlersocket_
| handlersocket_
| handlersocket_epoll | 1 |
| handlersocket_
| handlersocket_
| handlersocket_port | 9998 |
| handlersocket_
| handlersocket_
| handlersocket_
| handlersocket_
| handlersocket_
| handlersocket_
| handlersocket_
| handlersocket_
| handlersocket_
+------
16 rows in set (0,01 sec)
mysql> show plugins; ------- ------- ------- -----+- ------- --+---- ------- ------- --+---- ------- ------- +------ ---+ ------- ------- ------- -----+- ------- --+---- ------- ------- --+---- ------- ------- +------ ---+ password | ACTIVE | AUTHENTICATION | NULL | GPL |
+------
| Name | Status | Type | Library | License |
+------
| binlog | ACTIVE | STORAGE ENGINE | NULL | GPL |
| mysql_native_
| mysql_old_password | ACTIVE | AUTHENTICATION | NULL | GPL |
| MyISAM | ACTIVE | STORAGE ENGINE | NULL | GPL |
| MEMORY | ACTIVE | STORAGE ENGINE | NULL | GPL |
| CSV | ACTIVE | STORAGE ENGINE | NULL | GPL |
| MRG_MYISAM | ACTIVE | STORAGE ENGINE | NULL | GPL |
| ARCHIVE | ACTIVE | STORAGE ENGINE | NULL | GPL |
| PERFORMANCE_SCHEMA | ACTIVE | STORAGE ENGINE | NULL | GPL |
| FEDERATED | DISABLED | STORAGE ENGINE | NULL | GPL |
| InnoDB | ACTIVE | STORAGE ENGINE | NULL | GPL |
| INNODB_RSEG | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_UNDO_LOGS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_TRX | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_LOCKS | ACTIVE |...