[pgpool-general: 4265] Pgpool - connection hangs in DISCARD ALL
Gerhard Wiesinger
lists at wiesinger.com
Mon Dec 28 01:40:32 JST 2015
Hello,
Looks like the issue with hanging connections has not been solved in all
cases, backend hangind in DISCARD ALL, TCP connection is still alive,
but pgpool doesn't know the connection anymore.
Version: pgpool: 3.4.3
PostgreSQL: 9.4.5
Relevant pgpool config:
listen_addresses = '*'
child_life_time = 10
child_max_connections = 10
connection_life_time = 2
# One connection to the clients, but backend connection still alive
netstat -pan | grep pgpool | grep -i ESTABLISHED
tcp 0 0 127.0.0.1:50176 127.0.0.1:5432 ESTABLISHED
32119/pgpool: hei
tcp 0 0 127.0.0.1:50180 127.0.0.1:5432 ESTABLISHED
32119/pgpool: hei
tcp 0 0 127.0.0.1:52268 127.0.0.1:5432 ESTABLISHED
9967/pgpool: wait f
tcp 0 0 192.168.20.104:9999 192.168.20.113:42760
ESTABLISHED 32119/pgpool: hei
pcp_proc_info for all returned:
Database : ab3
Username : nag
Start time : 2015-12-27 15:48:38
Creation time: 2015-12-27 15:49:16
Major : 3
Minor : 0
Counter : 1
Backend PID : 32141
Connected : 0
Database : hei
Username : hei
Start time : 2015-12-27 15:48:38
Creation time: 2015-12-27 15:49:16
Major : 3
Minor : 0
Counter : 1
Backend PID : 32143
Connected : 1
# Tuned tcp stack:
net.ipv4.tcp_keepalive_intvl=10
net.ipv4.tcp_keepalive_probes=3
net.ipv4.tcp_retries2=3
Looks like that this bug in release 3.3.3 should have been fixed in 3.4.
But I guess there are some corner cases still available.
http://www.pgpool.net/docs/pgpool-II-3.4.0/NEWS.txt
Had it only once yet, connection was terminated after some minutes
automatically.
Any ideas?
Thnx.
Ciao,
Gerhard
More information about the pgpool-general
mailing list