<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:10pt">I just see some additional statements like "failback event found. restart myself"...<br><br>2011-11-30 10:39:46 LOG: pid 7398: find_primary_node_repeatedly: waiting for finding a primary node<br>2011-11-30 10:39:46 LOG: pid 7398: find_primary_node: primary node id is 1<br>2011-11-30 10:39:46 LOG: pid 7398: failover: set new primary node: 1<br>2011-11-30 10:39:46 LOG: pid 7398: failover: set new master node: 0<br>2011-11-30 10:39:46 LOG: pid 7398: failback done. reconnect host localhost(5447)<br>2011-11-30 10:39:46 LOG: pid 7532: worker process received restart request<br>2011-11-30 10:39:47 LOG: pid 7565: pcp child process received restart request<br>2011-11-30 10:39:47 LOG: pid 7398: worker child 7532 exits with status
256<br>2011-11-30 10:39:47 LOG: pid 7398: fork a new worker child pid 7648<br><span style="font-weight: bold;">2011-11-30 10:44:10 LOG: pid 7533: do_child: failback event found. restart myself.</span><br style="font-weight: bold;"><span style="font-weight: bold;">2011-11-30 10:44:10 LOG: pid 7534: do_child: failback event found. restart myself.</span><br>....<br>....<br><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@postgresql.org><br> <b><span style="font-weight: bold;">To:</span></b> sandeeptt@yahoo.com <br><b><span style="font-weight: bold;">Cc:</span></b> pgpool-general@pgpool.net <br> <b><span style="font-weight: bold;">Sent:</span></b>
Tuesday, November 29, 2011 3:24 PM<br> <b><span style="font-weight: bold;">Subject:</span></b> Re: [pgpool-general: 8] Re: [Pgpool-general] pgpool limitations<br> </font> <br>
I can't think of any other reasons. Can you find anything special in<br>the pgpool log when pgpool child exits?<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>> 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>> ....<br>> <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:sandeeptt@yahoo.com" href="mailto:sandeeptt@yahoo.com">sandeeptt@yahoo.com</a> <br>> Cc: <a ymailto="mailto:singh.gurjeet@gmail.com"
href="mailto:singh.gurjeet@gmail.com">singh.gurjeet@gmail.com</a>; <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: Wednesday, November 23, 2011 8:21 PM<br>> Subject: Re: [Pgpool-general] pgpool limitations<br>> <br>> One possibility is client_idle_limit.<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>>> 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>