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

[Stéphane Bouteille]

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 ?

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>