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

[Tatsuo Ishii]

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