[Pgpool-general] pgpool hangs up

[Michael Ulitskiy]

I think you don't realize how pgpool works and expect (as well as I did at the 
time) it to have connection manager functionality.
It's not there and probably won't be there in the nearest future.
Please see the discussion at 
http://lists.pgfoundry.org/pipermail/pgpool-general/2006-August/000424.html
In your config num_init_children=3 and that's the max number of concurrent 
connections pgpool will accept. So it can't serve more than 3 concurrent 
clients. If you use persistent connections in php then as soon as it seize 
all 3 connections your other pgpool connections will hang.

Michael

On Monday 27 August 2007 11:17:23 am Max Zorloff wrote:
> 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.
> _______________________________________________
> Pgpool-general mailing list
> Pgpool-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgpool-general