[Pgpool-general] health check generates extra logs

[Gary Fu]

Hi,

After several hours running our application on two db servers with pgpool-II 2.0.1 under degenerated 
mode (2nd db server down), there is no more connections available.  With 'ps' command (see below),
I found that there is no more pgpool child processes available. However, I'm not sure why there are
so many child processes in 'defunct' mode ?  Any idea how does this happen and how to prevent it ?

Thanks,
Gary


9:41am 111 gfu at nppdist:~/pgadmin/pgadmin3-1.8.0> ps -ef | grep pgpool
postgres 23167  6635  0 Dec11 pts/9    00:00:17 /home/gfu/pgpool2_etc-2.0.1/bin/pgpool -n
postgres 23179 23167  0 Dec11 pts/9    00:00:27 pgpool: nppsd3 nppsd3 192.168.10.75(41873) idle
postgres 23200 23167  0 Dec11 pts/9    00:00:00 [pgpool] <defunct>
postgres  9361 23167  0 Dec11 pts/9    00:01:41 pgpool: nppsd3 nppsd3 192.168.10.76(36749) idle
postgres  5576 23167  0 Dec12 pts/9    00:00:00 pgpool: nppsd3 nppsd3 192.168.10.76(41278) idle
postgres 21975 23167  0 Dec12 pts/9    00:00:00 [pgpool] <defunct>
postgres 22695 23167  0 Dec12 pts/9    00:00:20 pgpool: nppsd3 nppsd3 192.168.10.75(35788) idle
postgres 22709 23167  0 Dec12 pts/9    00:00:14 pgpool: nppsd3 nppsd3 192.168.10.76(38092) idle
postgres 23218 23167  0 Dec12 pts/9    00:00:16 pgpool: nppsd3 nppsd3 192.168.10.75(58435) idle
postgres 23229 23167  0 Dec12 pts/9    00:00:17 pgpool: gfu nppsd3 192.168.10.75(57684) idle
postgres 23394 23167  0 Dec12 pts/9    00:00:02 [pgpool] <defunct>
postgres 24986 23167  0 Dec12 pts/9    00:00:00 [pgpool] <defunct>
postgres 25008 23167  0 Dec12 pts/9    00:00:22 pgpool: nppsd3 nppsd3 192.168.10.76(43060) idle
postgres 25861 23167  0 Dec12 pts/9    00:00:00 [pgpool] <defunct>
postgres 26142 23167  0 Dec12 pts/9    00:00:05 [pgpool] <defunct>
postgres 31348 23167  0 Dec12 pts/9    00:00:03 [pgpool] <defunct>
postgres   701 23167  0 Dec12 pts/9    00:00:11 pgpool: nppsd3 nppsd3 192.168.10.76(42527) idle
postgres  1100 23167  0 Dec12 pts/9    00:00:00 [pgpool] <defunct>
postgres  1136 23167  0 Dec12 pts/9    00:00:01 [pgpool] <defunct>
postgres  1582 23167  0 Dec12 pts/9    00:00:16 pgpool: nppsd3 nppsd3 192.168.10.75(37845) idle
postgres  1816 23167  0 Dec12 pts/9    00:00:01 [pgpool] <defunct>
postgres  2133 23167  0 Dec12 pts/9    00:00:00 [pgpool] <defunct>
postgres  2159 23167  0 Dec12 pts/9    00:00:01 [pgpool] <defunct>
postgres  2817 23167  0 Dec12 pts/9    00:00:00 [pgpool] <defunct>
postgres  4502 23167  0 Dec12 pts/9    00:00:01 [pgpool] <defunct>
postgres  5479 23167  0 Dec12 pts/9    00:00:00 [pgpool] <defunct>
postgres  5985 23167  0 Dec12 pts/9    00:00:12 pgpool: nppsd3 nppsd3 192.168.10.75(39487) idle
postgres  7008 23167  0 Dec12 pts/9    00:00:00 [pgpool] <defunct>
postgres  7504 23167  0 Dec12 pts/9    00:00:00 [pgpool] <defunct>
postgres  8422 23167  0 Dec12 pts/9    00:00:01 [pgpool] <defunct>
postgres  8804 23167  0 Dec12 pts/9    00:00:00 [pgpool] <defunct>
postgres  9011 23167  0 Dec12 pts/9    00:00:20 pgpool: nppsd3 nppsd3 192.168.10.76(42526) idle
postgres  9358 23167  0 Dec12 pts/9    00:00:11 pgpool: nppsd3 nppsd3 192.168.10.75(49813) idle
postgres 10197 23167  0 Dec12 pts/9    00:00:00 [pgpool] <defunct>