[pgpool-general: 2655] connect() failed ERROR

[Granthana Biswas]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20140325/de2ba8b6/attachment.html>