Re: connection reset error, followed by broken pipe (pg74.213.jdbc3.jar)

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: me(at)edblackmore(dot)net
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: connection reset error, followed by broken pipe (pg74.213.jdbc3.jar)
Date: 2006-04-20 01:08:32
Message-ID: 4446DF10.3040509@opencloud.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Ed Blackmore wrote:
> Hi Markus,
>
> Thankyou for your assistance.
>
>
>>So it seems that the network connection breaks from time to time
>>Independently from making your application more robust, you might want
>>to put some research into that.
>
>
> Yes, I put a minutely ping script in place, which wasn't able to
> detect a failure at a time when the connection was lost. The servers
> are dedicated server (installed and hosted by another company), so
> I've been trying to detect any outages to report to them.

One common cause of connection loss is if there is a stateful firewall
or NAT between your client and server .. if the firewall loses the
connection state for some reason (e.g. if the connection goes idle for a
while and the firewall times it out, or if the firewall is restarted),
then the connection will break.

-O

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Markus Schaber 2006-04-20 07:46:26 Re: connection reset error, followed by broken pipe (pg74.213.jdbc3.jar)
Previous Message Ed Blackmore 2006-04-19 17:21:58 Re: connection reset error, followed by broken pipe (pg74.213.jdbc3.jar)