What version's r u using?
We use postgres + orion here with no problems.
What do you classify as 'heavy load'? Is it testing or real life load?
On 19 Apr 2001 10:27:02 +1000, Mike Cannon-Brookes wrote:
> 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
>
>
>
>
--
Adam Cassar
Technical Development Manager
___________________________________________
NetRegistry http://www.netregistry.au.com
Tel: +61 2 9641 8609 | Fax: +61 2 9699 6088
PO Box 270 Broadway NSW 2007 Australia