Comment 27 for bug 1371827

Revision history for this message
Roel Van de Paar (roel11) wrote : Re: Sporadic partial-hangup

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)
[...]