Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

Re: java.net.SocketException: Connection reset by peer: socket


  • From: Oliver Jowett <oliver(at)opencloud(dot)com>
  • To: Markus Wollny <Markus(dot)Wollny(at)computec(dot)de>
  • Cc: pgsql-jdbc(at)postgresql(dot)org
  • Subject: Re: java.net.SocketException: Connection reset by peer: socket
  • Date: Fri, 03 Dec 2004 10:25:45 +1300
  • Message-id: <41AF8859.2090702@opencloud.com> <text/plain>

Markus Wollny wrote:
It seems
that somewhere along the line, the Application Server just looses the
connection to the database after about 2h17min total runtime of the
batch.

java.net.SocketException: Connection reset by peer: socket write error
	at java.net.SocketOutputStream.socketWrite0(Native Method)

Check for firewalls between the appserver and the database server. The error is a TCP-level connection error that means that the peer (the database server) unexpectedly disappeared on us, and we didn't see an orderly shutdown of the connection. If it always happens after a certain connection length, or after the connection has been idle for a certain period, it's likely that there is a stateful firewall in the way that is dropping the connection after that period.

Failing that, does the database side log anything about the disconnection?

-O



Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group