<html><head><meta http-equiv="Content-Type" content="text/html charset=windows-1252"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;">Thkx, i’ll try<div><br></div><div>Stéphane<br><div>
<br><div><div>Le 26 mai 2014 à 10:01, Yugo Nagata <<a href="mailto:nagata@sraoss.co.jp">nagata@sraoss.co.jp</a>> a écrit :</div><br class="Apple-interchange-newline"><blockquote type="cite"><div style="font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;">On Mon, 26 May 2014 09:41:46 +0200<br>Stéphane Bouteille <<a href="mailto:stephane.bouteille@novigotech.com">stephane.bouteille@novigotech.com</a>> wrote:<br><br><blockquote type="cite">Thanks for your response.<br><br>Do you known why these processes are in this state ?<br><br>So there is nothing automated in pgpool to prevent this behavior ?<br></blockquote><br><br>I don't know why tomcat failed to disconnect or how connection status is<br>exatly in your case. But, you can specify child_life_time or client_idle_limit<br>to terminate children process which are idle too long.<br><br><a href="http://www.pgpool.net/docs/latest/pgpool-en.html#CHILD_LIFE_TIME">http://www.pgpool.net/docs/latest/pgpool-en.html#CHILD_LIFE_TIME</a><br><a href="http://www.pgpool.net/docs/latest/pgpool-en.html#CLIENT_IDLE_LIMIT">http://www.pgpool.net/docs/latest/pgpool-en.html#CLIENT_IDLE_LIMIT</a><br><br><blockquote type="cite"><br>Stéphane<br><br>Le 26 mai 2014 à 09:17, Yugo Nagata <<a href="mailto:nagata@sraoss.co.jp">nagata@sraoss.co.jp</a>> a écrit :<br><br><blockquote type="cite">Hi,<br><br>On Tue, 20 May 2014 18:01:27 +0200<br>Stéphane Bouteille <<a href="mailto:stephane.bouteille@novigotech.com">stephane.bouteille@novigotech.com</a>> wrote:<br><br><blockquote type="cite">Hi,<br><br>I’ve been using pgpool for while but I have a problem with it:<br>* Version of pgpool : 3.3.1<br>* Version of postgresql : 9.1<br>* Using hibernate and c3p0<br><br>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 ?<br></blockquote><br>I'm not sure how ps command resuls, but you can kill a child process by `kill -9`<br>and kiilled the new child process would be restarted by the main process if this<span class="Apple-converted-space"> </span><br>is running. There is no pcp command to kill children processes<br><br><blockquote type="cite"><br>Thanks for your help.<br><br>Stéphane<br><br>_______________________________________________<br>pgpool-general mailing list<br><a href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>http://www.pgpool.net/mailman/listinfo/pgpool-general<br></blockquote><br><br>--<span class="Apple-converted-space"> </span><br>Yugo Nagata <<a href="mailto:nagata@sraoss.co.jp">nagata@sraoss.co.jp</a>><br></blockquote><br></blockquote><br><br>--<span class="Apple-converted-space"> </span><br>Yugo Nagata <<a href="mailto:nagata@sraoss.co.jp">nagata@sraoss.co.jp</a>></div></blockquote></div><br></div></div></body></html>