<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:10pt"><div>client_idle_limit is set to '0'. Here is the other related settings:<br>....<br>pcp_timeout = 10<br>num_init_children = 32<br>max_pool = 4<br>child_life_time = 300<br>connection_life_time = 0<br>child_max_connections = 0<br>client_idle_limit = 0<br>....</div><div> </div><div><br></div> <div style="font-family: times new roman, new york, times, serif; font-size: 10pt;"> <div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"> <font size="2" face="Arial"> <hr size="1"> <b><span style="font-weight:bold;">From:</span></b> Tatsuo Ishii <ishii@sraoss.co.jp><br> <b><span style="font-weight: bold;">To:</span></b> sandeeptt@yahoo.com <br><b><span style="font-weight: bold;">Cc:</span></b> singh.gurjeet@gmail.com; pgpool-general@pgfoundry.org; pgpool-hackers@pgfoundry.org <br> <b><span
style="font-weight: bold;">Sent:</span></b> Wednesday, November 23, 2011 8:21 PM<br> <b><span style="font-weight: bold;">Subject:</span></b> Re: [Pgpool-general] pgpool limitations<br> </font> <br>
One possibility is client_idle_limit.<br>--<br>Tatsuo Ishii<br>SRA OSS, Inc. Japan<br>English: http://www.sraoss.co.jp/index_en.php<br>Japanese: http://www.sraoss.co.jp<br><br>> I have found that sometimes the client connections get disconnected and the new ones are established. What I do is I get the PIDs using "pcp_proc_count" before running "pcp_attach_node" and then run "pcp_proc_count" to check if the PIDs remain same. I found that the behaviour is random. When can this happen?<br>> <br>> <br>> ________________________________<br>> From: Tatsuo Ishii <<a ymailto="mailto:ishii@sraoss.co.jp" href="mailto:ishii@sraoss.co.jp">ishii@sraoss.co.jp</a>><br>> To: <a ymailto="mailto:singh.gurjeet@gmail.com" href="mailto:singh.gurjeet@gmail.com">singh.gurjeet@gmail.com</a> <br>> Cc: <a ymailto="mailto:pgpool-general@pgfoundry.org" href="mailto:pgpool-general@pgfoundry.org">pgpool-general@pgfoundry.org</a>; <a
ymailto="mailto:pgpool-hackers@pgfoundry.org" href="mailto:pgpool-hackers@pgfoundry.org">pgpool-hackers@pgfoundry.org</a> <br>> Sent: Thursday, August 11, 2011 6:11 AM<br>> Subject: Re: [Pgpool-general] pgpool limitations<br>> <br>>>> > > Is there something in the works to enable this, or is this feature<br>>>> still in<br>>>> > > design phase? If it is already being/been developed, I wish to know if<br>>>> this<br>>>> > > can be back-patched to a point release of pgpool 3.0.x.<br>>>> ><br>>>> > It has been already in pgpool-II 3.1 alpha version.<br>>>> > Currently there's no plan to back-patching to 3.0.x.<br>>>><br>>>> I certainly hope we won't backpatch a new feature. That would be insane.<br>>>><br>>> <br>>> I don't consider this a new feature. I'd say this is unexpected side-effect<br>>>
(a.k.a bug) of pcp_attach_node, since nowhere in the docs does is say that<br>>> invoking pcp_attach_node would drop all client connections.<br>> <br>> This behavior has not been changed since pcp_attach_node was born in<br>> 2006. Moreover, the enhancement in 3.1 is only for steaming<br>> replication mode. Other modes including replication mode does not take<br>> advantage of this.<br>> --<br>> Tatsuo Ishii<br>> SRA OSS, Inc. Japan<br>> English: <a href="http://www.sraoss.co.jp/index_en.php" target="_blank">http://www.sraoss.co.jp/index_en.php</a><br>> Japanese: <a href="http://www.sraoss.co.jp" target="_blank">http://www.sraoss.co.jp</a><br>> _______________________________________________<br>> Pgpool-general mailing list<br>> <a ymailto="mailto:Pgpool-general@pgfoundry.org" href="mailto:Pgpool-general@pgfoundry.org">Pgpool-general@pgfoundry.org</a><br>>
http://pgfoundry.org/mailman/listinfo/pgpool-general<br><br><br> </div> </div> </div></body></html>