[Pgpool-general] pgpool hangs up

[Max Zorloff]

On Mon, 27 Aug 2007 16:13:06 +0400, Yoshiyuki Asaba <y-asaba at sraoss.co.jp>  
wrote:

> Hi,
>
> From: "Max Zorloff" <zorloff at gmail.com>
> Subject: Re: [Pgpool-general] pgpool hangs up
> Date: Mon, 27 Aug 2007 17:13:30 +0400
>
>> > Could you show us the config file?
>>
>> I tried also to connect with "psql -h localhost -p 10000" during this
>> time. psql just hangs waiting.
>> After the restart everything is fine for some time.
>>
>> The config is:
> ...
>> num_init_children = 3
>
> num_init_children is the number of concurrent users. If three
> connections are active, new connections are waited until these are
> closed.
>
>   % psql -h localhost -p 10000 (connected)
>   % psql -h localhost -p 10000 (connected)
>   % psql -h localhost -p 10000 (connected)
>   % psql -h localhost -p 10000 (waited)
>
> Can you increase num_init_children?

I can, but then the number of postgres connections will increase too.
I wanted to pipeline all connections to a very small number of postgres  
connections.

I don't think the trouble is there. Because a few days ago pgpool stopped
receiving any connections at 5 am and did this until 11am until I  
restarted it.
The thing is there was no significant increase in the load at 5am.
Then again it could be that apache php forks somehow stopped closing  
connections.

Hmmm, lets see if setting connection_life_time to 5 seconds will help.