Has anyone used Postgres + JDBC + Orion 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 as do Orion threads and we're not sure where to start looking.
Has anyone used this combo and has experience with this sort of thing?
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
