[pgpool-general: 3276] Re: Issues with pgpool 3.3.3 and failover

[Karthick Thanigaimani]

Thanks Tatsuo, is there anything else we can do instead of upgrading or changing the connect_inet_domain_socket_by_port(). 
I am asking this as a temporary workaround till we upgrade to 3.3.4 Please advise

Thanks
Karthick


________________________________
 From: Tatsuo Ishii <ishii at postgresql.org>
To: kargold100 at yahoo.com 
Cc: pgpool-general at pgpool.net 
Sent: Thursday, 13 November 2014 3:18 PM
Subject: Re: [pgpool-general: 3273] Issues with pgpool 3.3.3 and failover
 

Probably this:

http://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=d0443ccc27ae1bbbc0715427072ffe67f632fd20

Upgrading to 3.3.4 should fix the problem.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp


> 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:
> 
> :2014-11-10 02:47:25 ERROR: pid 26332: connect_inet_domain_socket: select() timed out
> 2:2014-11-10 02:47:25 ERROR: pid 26332: make_persistent_db_connection: connection to node0(5432) failed
> 3:2014-11-10 02:47:25 ERROR: pid 26332: health check failed. 0 th host node0 at port 5432 is down
> 
> 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
> Any idea why this issue is happening quiet frequenbtly and anything can be done to fix it permamently?
> 
> Thanks Karthick
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20141113/c64ef956/attachment-0001.html>