[pgpool-general: 2878] Re: pgpool children process in DISCARD state

[Yugo Nagata]

On Mon, 26 May 2014 09:41:46 +0200
Stéphane Bouteille <stephane.bouteille at novigotech.com> wrote:

> Thanks for your response.
> 
> Do you known why these processes are in this state ?
> 
> So there is nothing automated in pgpool to prevent this behavior ?


I don't know why tomcat failed to disconnect or how connection status is
exatly in your case. But, you can specify child_life_time or client_idle_limit
to terminate children process which are idle too long.

http://www.pgpool.net/docs/latest/pgpool-en.html#CHILD_LIFE_TIME
http://www.pgpool.net/docs/latest/pgpool-en.html#CLIENT_IDLE_LIMIT

> 
> Stéphane
> 
> Le 26 mai 2014 à 09:17, Yugo Nagata <nagata at sraoss.co.jp> a écrit :
> 
> > Hi,
> > 
> > On Tue, 20 May 2014 18:01:27 +0200
> > Stéphane Bouteille <stephane.bouteille at novigotech.com> wrote:
> > 
> >> Hi,
> >> 
> >> I’ve been using pgpool for while but I have a problem with it:
> >> * Version of pgpool : 3.3.1
> >> * Version of postgresql : 9.1
> >> * Using hibernate and c3p0
> >> 
> >> When i shutdown my tomcat not cleanly (so connections are not well closed), some children processes of pgpool appeared with a ‘ps -ef’ command as DISCARD. Therefore, there are not available for allocation. How can I fixed it with a pgpool config or can i use pcp command to kill a child or is it possible to kill it by a shell command and then, pgpool recreate one ?
> > 
> > I'm not sure how ps command resuls, but you can kill a child process by `kill -9`
> > and kiilled the new child process would be restarted by the main process if this 
> > is running. There is no pcp command to kill children processes
> > 
> >> 
> >> Thanks for your help.
> >> 
> >> Stéphane
> >> 
> >> _______________________________________________
> >> pgpool-general mailing list
> >> pgpool-general at pgpool.net
> >> http://www.pgpool.net/mailman/listinfo/pgpool-general
> > 
> > 
> > -- 
> > Yugo Nagata <nagata at sraoss.co.jp>
> 


-- 
Yugo Nagata <nagata at sraoss.co.jp>