[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