[pgpool-general: 2875] Re: pgpool children process in DISCARD state
Yugo Nagata
nagata at sraoss.co.jp
Mon May 26 16:17:47 JST 2014
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>
More information about the pgpool-general
mailing list