<html><body><div style="color:#000; background-color:#fff; font-family:arial, helvetica, sans-serif;font-size:10px"><div class="" style=""><span class="" style="">Thanks Tatsuo, is there anything else we can do instead of upgrading or changing the </span><span style="font-family: monospace; font-size: 13px;" class="">connect_inet_domain_socket_by_port(). </span></div><div class="" style="color: rgb(0, 0, 0); font-size: 13px; font-family: monospace; font-style: normal; background-color: transparent;"><span style="font-family: monospace; font-size: 13px;" class="">I am asking this as a temporary workaround till we upgrade to 3.3.4 Please advise</span></div><div class="" style="color: rgb(0, 0, 0); font-size: 13px; font-family: monospace; font-style: normal; background-color: transparent;"><span style="font-family: monospace; font-size: 13px;" class=""><br></span></div><div class="" style="color: rgb(0, 0, 0); font-size: 13px; font-family:
monospace; font-style: normal; background-color: transparent;"><span style="font-family: monospace; font-size: 13px;" class="">Thanks</span></div><div class="" style="color: rgb(0, 0, 0); font-size: 13px; font-family: monospace; font-style: normal; background-color: transparent;"><span style="font-family: monospace; font-size: 13px;" class="">Karthick</span></div><div class="" style=""><br class="" style=""></div> <div style="font-family: arial, helvetica, sans-serif; font-size: 10px;" class=""> <div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, Sans-Serif; font-size: 12px;" class=""> <div dir="ltr" class="" style=""> <hr size="1" class="" style=""> <font size="2" face="Arial" class="" style=""> <b class="" style=""><span style="font-weight:bold;" class="">From:</span></b> Tatsuo Ishii <ishii@postgresql.org><br class="" style=""> <b class="" style=""><span style="font-weight: bold;" class="">To:</span></b>
kargold100@yahoo.com <br class="" style=""><b class="" style=""><span style="font-weight: bold;" class="">Cc:</span></b> pgpool-general@pgpool.net <br class="" style=""> <b class="" style=""><span style="font-weight: bold;" class="">Sent:</span></b> Thursday, 13 November 2014 3:18 PM<br class="" style=""> <b class="" style=""><span style="font-weight: bold;" class="">Subject:</span></b> Re: [pgpool-general: 3273] Issues with pgpool 3.3.3 and failover<br class="" style=""> </font> </div> <div class="" style=""><br class="" style="">Probably this:<br clear="none" class="" style=""><br clear="none" class="" style=""><a shape="rect" href="http://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=d0443ccc27ae1bbbc0715427072ffe67f632fd20" target="_blank" class="" style="">http://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=d0443ccc27ae1bbbc0715427072ffe67f632fd20</a><br clear="none" class="" style=""><br clear="none" class="" style="">Upgrading to
3.3.4 should fix the problem.<br clear="none" class="" style=""><br clear="none" class="" style="">Best regards,<br clear="none" class="" style="">--<br clear="none" class="" style="">Tatsuo Ishii<br clear="none" class="" style="">SRA OSS, Inc. Japan<br clear="none" class="" style="">English: <a shape="rect" href="http://www.sraoss.co.jp/index_en.php" target="_blank" class="" style="">http://www.sraoss.co.jp/index_en.php</a><br clear="none" class="" style="">Japanese:<a shape="rect" href="http://www.sraoss.co.jp/" target="_blank" class="" style="">http://www.sraoss.co.jp</a><div class="" id="yqtfd30712" style=""><br clear="none" class="" style=""><br clear="none" class="" style="">> Hi we have postgres 9.3.4 with pgpool 3.3 configured. we are facing the below errors and the pgpool goes out of sync though the streaming replication works fine:<br clear="none" class="" style="">> <br clear="none" class="" style="">> :2014-11-10 02:47:25 ERROR: pid
26332: connect_inet_domain_socket: select() timed out<br clear="none" class="" style="">> 2:2014-11-10 02:47:25 ERROR: pid 26332: make_persistent_db_connection: connection to node0(5432) failed<br clear="none" class="" style="">> 3:2014-11-10 02:47:25 ERROR: pid 26332: health check failed. 0 th host node0 at port 5432 is down<br clear="none" class="" style="">> <br clear="none" class="" style="">> the health_check_timeout is set to 15seconds and the system admin confirmed that there is network latency between the 2 nodes. there are no iptable rules set as well<br clear="none" class="" style="">> Any idea why this issue is happening quiet frequenbtly and anything can be done to fix it permamently?<br clear="none" class="" style="">> <br clear="none" class="" style="">> Thanks Karthick<br clear="none" class="" style=""></div><br class="" style=""><br class="" style=""></div> </div> </div> </div></body></html>