[pgpool-general: 2658] Re: connect() failed ERROR

Tatsuo Ishii ishii at postgresql.org
Wed Mar 26 08:31:19 JST 2014


Looks like you need to tune the kernel network parameters.

How is like net.ipv4.tcp_fin_timeout?
If it's 60 (the default), try to shorten it, say 30.

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

> Hello All,
> 
> We were getting the following error constantly in pgpool logs:
> 
> --------------------------------------------------------------------------------------------------
> 2014-03-24 11:14:20 LOG:   pid 26615: connection received:
> host=abcd.comport=56778
> 2014-03-24 11:14:20 ERROR: pid 26615: connect_inet_domain_socket: connect()
> failed: Cannot assign requested address
> 2014-03-24 11:14:20 ERROR: pid 26615: connection to xx.x.x.xxx(5432) failed
> 2014-03-24 11:14:20 ERROR: pid 26615: new_connection: create_cp() failed
> 2014-03-24 11:14:20 LOG:   pid 26615: new_connection: do not failover
> because fail_over_on_backend_error is off
> --------------------------------------------------------------------------------------------------
> 
> Also there was high count of netstat -a | grep TIME_WAIT | wc -l
> 10243
> on pgpool master.
> 
> These errors stopped coming after switching from master to slave pgpool and
> also the TIME_WAIT count came down below 100 after making slave pgpool the
> master while on the new pgpool master it went above 2000.
> 
> Regards,
> Granthana


More information about the pgpool-general mailing list