<html><body><div style="color:#000; background-color:#fff; font-family:arial, helvetica, sans-serif;font-size:10px"><div><span>ok thanks a lot</span></div><div><br></div> <div style="font-family: arial, helvetica, sans-serif; font-size: 10px;"> <div style="font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px;"> <div dir="ltr"> <hr size="1"> <font size="2" face="Arial"> <b><span style="font-weight:bold;">From:</span></b> Tatsuo Ishii <ishii@postgresql.org><br> <b><span style="font-weight: bold;">To:</span></b> kargold100@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> Thursday, 13 November 2014 3:27 PM<br> <b><span style="font-weight: bold;">Subject:</span></b> Re: [pgpool-general: 3273] Issues with pgpool 3.3.3 and failover<br> </font> </div> <div class="y_msg_container"><br>Unfortunately
no.<br clear="none"><br clear="none">Other thing I can think of is, upgrading RPM to <br clear="none"><br clear="none">pgpool-II-pg93-3.3.4-2.pgdg.x86_64.rpm or<br clear="none">pgpool-II-pg92-3.3.4-2.pgdg.x86_64.rpm<br clear="none"><br clear="none">if you use CentOS6/RedHat6.<br clear="none"><br clear="none">Best regards,<br clear="none">--<br clear="none">Tatsuo Ishii<br clear="none">SRA OSS, Inc. Japan<br clear="none">English: <a shape="rect" href="http://www.sraoss.co.jp/index_en.php" target="_blank">http://www.sraoss.co.jp/index_en.php</a><br clear="none">Japanese:<a shape="rect" href="http://www.sraoss.co.jp/" target="_blank">http://www.sraoss.co.jp</a><div class="qtdSeparateBR"><br><br></div><div class="yqt2491559252" id="yqtfd21987"><br clear="none"><br clear="none">> Thanks Tatsuo, is there anything else we can do instead of upgrading or changing the connect_inet_domain_socket_by_port(). <br clear="none">> I am asking this as a temporary
workaround till we upgrade to 3.3.4 Please advise<br clear="none">> <br clear="none">> Thanks<br clear="none">> Karthick<br clear="none">> <br clear="none">> <br clear="none">> ________________________________<br clear="none">> From: Tatsuo Ishii <<a shape="rect" ymailto="mailto:ishii@postgresql.org" href="mailto:ishii@postgresql.org">ishii@postgresql.org</a>><br clear="none">> To: <a shape="rect" ymailto="mailto:kargold100@yahoo.com" href="mailto:kargold100@yahoo.com">kargold100@yahoo.com</a> <br clear="none">> Cc: <a shape="rect" ymailto="mailto:pgpool-general@pgpool.net" href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a> <br clear="none">> Sent: Thursday, 13 November 2014 3:18 PM<br clear="none">> Subject: Re: [pgpool-general: 3273] Issues with pgpool 3.3.3 and failover<br clear="none">> <br clear="none">> <br clear="none">> Probably this:<br clear="none">> <br
clear="none">> <a shape="rect" href="http://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=d0443ccc27ae1bbbc0715427072ffe67f632fd20" target="_blank">http://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=d0443ccc27ae1bbbc0715427072ffe67f632fd20</a><br clear="none">> <br clear="none">> Upgrading to 3.3.4 should fix the problem.<br clear="none">> <br clear="none">> Best regards,<br clear="none">> --<br clear="none">> Tatsuo Ishii<br clear="none">> SRA OSS, Inc. Japan<br clear="none">> English: <a shape="rect" href="http://www.sraoss.co.jp/index_en.php" target="_blank">http://www.sraoss.co.jp/index_en.php</a><br clear="none">> Japanese:<a shape="rect" href="http://www.sraoss.co.jp/" target="_blank">http://www.sraoss.co.jp</a><br clear="none">> <br clear="none">> <br clear="none">>> 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">>> <br clear="none">>> :2014-11-10 02:47:25 ERROR: pid 26332: connect_inet_domain_socket: select() timed out<br clear="none">>> 2:2014-11-10 02:47:25 ERROR: pid 26332: make_persistent_db_connection: connection to node0(5432) failed<br clear="none">>> 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">>> <br clear="none">>> 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">>> Any idea why this issue is happening quiet frequenbtly and anything can be done to fix it permamently?<br clear="none">>> <br clear="none">>> Thanks Karthick<br clear="none"></div><br><br></div> </div> </div> </div></body></html>