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 [EMAIL PROTECTED]:~/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> _______________________________________________ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general
