JDBC Driver under load - Mailing list pgsql-jdbc

From Mike Cannon-Brookes
Subject JDBC Driver under load
Date
Msg-id NCBBKLKCHGCKLBAFEDFDKEFKILAA.mcannon@internet.com
Whole thread Raw
Responses Re: JDBC Driver under load  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-jdbc
Has anyone used the JDBC driver under heavy load?

We're having a problem on one of our production machines that on some
occasions under heavy load Postgres JDBC connections seem to be dying /
locking up. Here's an example trace:

An I/O error occured while reading from backend - Exception:
java.net.SocketException: Connection reset by peer: Connection reset by peer
Stack Trace:
java.net.SocketException: Connection reset by peer: Connection reset by peer
        at java.net.SocketInputStream.socketRead(Native Method)
        at java.net.SocketInputStream.read(SocketInputStream.java:86)
        at java.io.BufferedInputStream.fill(BufferedInputStream.java:186)
        at java.io.BufferedInputStream.read(BufferedInputStream.java:204)
        at org.postgresql.PG_Stream.ReceiveChar(PG_Stream.java:181)
        at org.postgresql.Connection.openConnection(Connection.java:160)
        at org.postgresql.Driver.connect(Driver.java:122)

or

An I/O error occured while reading from backend - Exception:
java.net.SocketException: Broken pipe: Broken pipe
Stack Trace:
java.net.SocketException: Broken pipe: Broken pipe
        at java.net.SocketInputStream.socketRead(Native Method)
        at java.net.SocketInputStream.read(SocketInputStream.java:86)
        at java.io.BufferedInputStream.fill(BufferedInputStream.java:186)
        at java.io.BufferedInputStream.read(BufferedInputStream.java:204)
        at org.postgresql.PG_Stream.ReceiveChar(PG_Stream.java:181)
        at org.postgresql.Connection.openConnection(Connection.java:160)
        at org.postgresql.Driver.connect(Driver.java:122)
...
        at org.postgresql.PG_Stream.ReceiveChar(PG_Stream.java:184)
        at org.postgresql.Connection.openConnection(Connection.java:160)
        at org.postgresql.Driver.connect(Driver.java:122)

any ideas where to start looking?

-mike



pgsql-jdbc by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: JDBC setObject
Next
From: Tom Lane
Date:
Subject: Re: JDBC Driver under load