[pgpool-general: 94] Re: "Connection Timed Out" on clients connecting to pgpool

[Mario Splivalo]

On 12/15/2011 03:14 PM, Mario Splivalo wrote:
> Since then I have lowered the max_pool and increased num_init_children
> to 1200, but the 'connection timed out' rate has not declined.

Moreover, here is what my pgpool connections look like:

root at pool1:~# ps -ef | grep pgpool | cut -c49- | sort | uniq -c
      1 grep --color=auto pgpool
      1 pgpool: PCP: wait for connection request
      1 pgpool: megasite megasite 10.13.3.1(15557) idle in transaction
      1 pgpool: megasite megasite 10.13.3.1(15565) SELECT
      1 pgpool: megasite megasite 10.13.3.1(15571) idle in transaction
      1 pgpool: megasite megasite 10.13.3.1(15580) idle in transaction
      1 pgpool: megasite megasite 10.13.3.1(15607) idle in transaction
      1 pgpool: megasite megasite 10.13.3.1(15613) idle in transaction
      1 pgpool: megasite megasite 10.13.3.1(25865) idle in transaction
      1 pgpool: megasite megasite 10.13.3.1(65008) idle in transaction
      1 pgpool: megasite megasite 10.13.1.12(46056) idle in transaction
      1 pgpool: megasite megasite 10.13.1.12(46135) idle in transaction
      1 pgpool: megasite megasite 10.13.1.12(46143) idle in transaction
   1189 pgpool: wait for connection request
      1 pgpool: worker process
      1 su -c /usr/local/pgpool2/bin/pgpool -n
      1 /usr/local/pgpool2/bin/pgpool -n


The number of active connections change, but there is always plenty of
available pgpool childs that should be ready to take the connection.