[Pgpool-general] pgpool hangs up

[Max Zorloff]

On Tue, 28 Aug 2007 08:50:19 +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 19:17:23 +0400
>
>> 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.
>
> Could you get the result of ps command?
>
>   % ps auwwx | grep pgpool
>
> When pgpool is idle, the result is the following text.
>
>   ... pgpool: wait for connection request
>
> We can get the following when pgpool accepts connection,
>
>   ... pgpool: user database [local] idle
>

The output during the time when php (or psql) cannot connect to pgpool:

xxx at terr23 ~/sql $ ps axwu | grep pgpool
xxx   4870  0.0  0.0   7456   676 ?        Ss   14:00   0:00 ./pgpool -f  
/home/xxx/sql/pgpool.conf -a /home/xxx/sql/pool_hba.conf
xxx   4871  0.8  0.0   7468   668 ?        S    14:00   0:03 pgpool: xxx  
dbname 127.0.0.1(40994) idle
xxx   4872  0.8  0.0   7468   668 ?        S    14:00   0:03 pgpool: xxx  
dbname 127.0.0.1(40968) idle
xxx   4873  0.8  0.0   7468   668 ?        S    14:00   0:03 pgpool: xxx  
dbname 127.0.0.1(41012) idle
xxx   4874  0.8  0.0   7468   668 ?        S    14:00   0:03 pgpool: xxx  
dbname 127.0.0.1(40993) idle
xxx   4875  0.8  0.0   7468   668 ?        S    14:00   0:03 pgpool: xxx  
dbname 127.0.0.1(40991) idle
xxx   5898  0.0  0.0   2616   580 pts/9    S+   14:06   0:00 grep pgpool

I added connection_life_time = 5 to config before that. It doesn't seem to  
have any effect. I have to restart
pgpool once every 5 minutes. Even when I restart it every 15 minutes it  
sometimes hangs in this state.