Re-confirmed present in Percona-Server-5.6.21-rel70.0-693.Linux.x86_64-debug
[roel@localhost test]$ for i in {1..25}; do /sda/Percona-Server-5.6.21-rel70.0-693.Linux.x86_64-debug/bin/mysql --socket=/dev/shm/1416639569/subreducer/$i/socket.sock -uroot -e "SHOW FULL PROCESSLIST\GSHOW GLOBAL VARIABLES LIKE 'pid_file'";done
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/dev/shm/1416639569/subreducer/1/socket.sock' (111)
[...]
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/dev/shm/1416639569/subreducer/15/socket.sock' (2)
*************************** 1. row ***************************
Id: 1
User: event_scheduler
Host: localhost
db: NULL
Command: Daemon
Time: 177
State: Waiting on empty queue
Info: NULL
Rows_sent: 0
Rows_examined: 0
*************************** 2. row ***************************
Id: 5
User: root
Host: localhost
db: mysql
Command: Query
Time: 176
State: System lock
Info: CREATE EVENT querytimeout ON SCHEDULE EVERY 20 SECOND DO BEGIN
SET @id:='';
SET @id:=(SELECT id FROM INFORMATION_SCHEMA.PROCESSLIST WHERE ID<>CONNECTION_ID() AND STATE<>'killed' AND TIME>90 ORDER BY TIME DESC LIMIT 1);
IF @id > 1 THEN KILL QUERY @id; END IF;
END
Rows_sent: 0
Rows_examined: 0
*************************** 3. row ***************************
Id: 33
User: root
Host: localhost
db: NULL
Command: Query
Time: 0
State: init
Info: SHOW FULL PROCESSLIST
Rows_sent: 0
Rows_examined: 0
+---------------+-------------------------------------------+
| Variable_name | Value |
+---------------+-------------------------------------------+
| pid_file | /dev/shm/1416639569/subreducer/16/pid.pid |
+---------------+-------------------------------------------+
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/dev/shm/1416639569/subreducer/17/socket.sock' (2)
[...]
Re-confirmed present in Percona- Server- 5.6.21- rel70.0- 693.Linux. x86_64- debug
[roel@localhost test]$ for i in {1..25}; do /sda/Percona- Server- 5.6.21- rel70.0- 693.Linux. x86_64- debug/bin/ mysql --socket= /dev/shm/ 1416639569/ subreducer/ $i/socket. sock -uroot -e "SHOW FULL PROCESSLIST\GSHOW GLOBAL VARIABLES LIKE 'pid_file'";done 1416639569/ subreducer/ 1/socket. sock' (111) 1416639569/ subreducer/ 15/socket. sock' (2) ******* ******* ****** 1. row ******* ******* ******* ****** ******* ******* ****** 2. row ******* ******* ******* ****** SCHEMA. PROCESSLIST WHERE ID<>CONNECTION_ID() AND STATE<>'killed' AND TIME>90 ORDER BY TIME DESC LIMIT 1); ******* ******* ****** 3. row ******* ******* ******* ****** ------- --+---- ------- ------- ------- ------- ------- ----+ ------- --+---- ------- ------- ------- ------- ------- ----+ 1416639569/ subreducer/ 16/pid. pid | ------- --+---- ------- ------- ------- ------- ------- ----+ 1416639569/ subreducer/ 17/socket. sock' (2)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/dev/shm/
[...]
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/dev/shm/
*******
Id: 1
User: event_scheduler
Host: localhost
db: NULL
Command: Daemon
Time: 177
State: Waiting on empty queue
Info: NULL
Rows_sent: 0
Rows_examined: 0
*******
Id: 5
User: root
Host: localhost
db: mysql
Command: Query
Time: 176
State: System lock
Info: CREATE EVENT querytimeout ON SCHEDULE EVERY 20 SECOND DO BEGIN
SET @id:='';
SET @id:=(SELECT id FROM INFORMATION_
IF @id > 1 THEN KILL QUERY @id; END IF;
END
Rows_sent: 0
Rows_examined: 0
*******
Id: 33
User: root
Host: localhost
db: NULL
Command: Query
Time: 0
State: init
Info: SHOW FULL PROCESSLIST
Rows_sent: 0
Rows_examined: 0
+------
| Variable_name | Value |
+------
| pid_file | /dev/shm/
+------
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/dev/shm/
[...]