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

JDBC Driver under load

From: "Mike Cannon-Brookes" <mcannon(at)internet(dot)com>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: JDBC Driver under load
Date: 2001-04-19 00:22:26
Message-ID: NCBBKLKCHGCKLBAFEDFDKEFKILAA.mcannon@internet.com (view raw or flat)
Thread:
Lists: 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



Responses

pgsql-jdbc by date

Next:From: Tom LaneDate: 2001-04-19 00:55:01
Subject: Re: JDBC Driver under load
Previous:From: Bruce MomjianDate: 2001-04-18 19:54:08
Subject: Re: JDBC setObject

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group