468,136 Members | 1,451 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,136 developers. It's quick & easy.

JDBC problem

I'm running an engine with 15 databases, with fair amount of load. Every
4-5 days I'm getting error like this from the java side and the
application stops working (and wont come back unless I restart) :

java.net.SocketException: Broken pipe
at java.net.SocketOutputStream.socketWrite0(Native Method)
at java.net.SocketOutputStream.socketWrite(SocketOutp utStream.java:92)
at java.net.SocketOutputStream.write(SocketOutputStre am.java:136)
at java.io.BufferedOutputStream.flushBuffer(BufferedO utputStream.java:66)
at java.io.BufferedOutputStream.write(BufferedOutputS tream.java:110)
at java.io.FilterOutputStream.write(FilterOutputStrea m.java:80)
at org.postgresql.PG_Stream.Send(PG_Stream.java:87)
at org.postgresql.core.QueryExecutor.sendQuery(QueryE xecutor.java:184)
at org.postgresql.core.QueryExecutor.execute(QueryExe cutor.java:71)
at
org.postgresql.jdbc1.AbstractJdbc1Connection.ExecS QL(AbstractJdbc1Connection.java:505)
at
org.postgresql.jdbc1.AbstractJdbc1Statement.execut e(AbstractJdbc1Statement.java:360)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execut e(AbstractJdbc2Statement.java:48)
at
org.postgresql.jdbc1.AbstractJdbc1Statement.execut eQuery(AbstractJdbc1Statement.java:176)
at
org.postgresql.jdbc1.AbstractJdbc1Statement.execut eQuery(AbstractJdbc1Statement.java:163)
at
org.apache.commons.dbcp.DelegatingStatement.execut eQuery(DelegatingStatement.java:162)
at
com.eplica.model.persistence.JDBCPersistenceHelper .findByUniqueSql(JDBCPersistenceHelper.java:704)
Does anyone know what this is about ?
I'm using Red hat Enterprise, and all the correct JDBC drivers etc.
thanx
-reynir

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 23 '05 #1
1 1189
Hi,
...I'm getting error like this from the java side and the
application stops working (and wont come back unless I restart...


How is the "application" invoked? Is it a "service" (servlet instance, RMI
object-mediated, etc.), i.e. does a core-component run forever and spawn
helpers to handle requests?

I'd guess that you are slurping output from an external process'
STDOUT/STDERR and the process-control API noticed that one or both sides of
the conversation broke the underlying conduit (the pipe) between the
processes.

Carl <|};-)>

-----Original Message-----
From: pg*****************@postgresql.org
[mailto:pg*****************@postgresql.org] On Behalf Of Reynir Žór Hübner
Sent: Tuesday, May 11, 2004 3:37 AM
To: pg***********@postgresql.org
Subject: [GENERAL] JDBC problem
I'm running an engine with 15 databases, with fair amount of load. Every
4-5 days I'm getting error like this from the java side and the
application stops working (and wont come back unless I restart) :

java.net.SocketException: Broken pipe
at java.net.SocketOutputStream.socketWrite0(Native Method)
at java.net.SocketOutputStream.socketWrite(SocketOutp utStream.java:92)
at java.net.SocketOutputStream.write(SocketOutputStre am.java:136)
at java.io.BufferedOutputStream.flushBuffer(BufferedO utputStream.java:66)
at java.io.BufferedOutputStream.write(BufferedOutputS tream.java:110)
at java.io.FilterOutputStream.write(FilterOutputStrea m.java:80)
at org.postgresql.PG_Stream.Send(PG_Stream.java:87)
at org.postgresql.core.QueryExecutor.sendQuery(QueryE xecutor.java:184)
at org.postgresql.core.QueryExecutor.execute(QueryExe cutor.java:71)
at
org.postgresql.jdbc1.AbstractJdbc1Connection.ExecS QL(AbstractJdbc1Connection
..java:505)
at
org.postgresql.jdbc1.AbstractJdbc1Statement.execut e(AbstractJdbc1Statement.j
ava:360)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execut e(AbstractJdbc2Statement.j
ava:48)
at
org.postgresql.jdbc1.AbstractJdbc1Statement.execut eQuery(AbstractJdbc1Statem
ent.java:176)
at
org.postgresql.jdbc1.AbstractJdbc1Statement.execut eQuery(AbstractJdbc1Statem
ent.java:163)
at
org.apache.commons.dbcp.DelegatingStatement.execut eQuery(DelegatingStatement
..java:162)
at
com.eplica.model.persistence.JDBCPersistenceHelper .findByUniqueSql(JDBCPersi
stenceHelper.java:704)
Does anyone know what this is about ?
I'm using Red hat Enterprise, and all the correct JDBC drivers etc.
thanx
-reynir

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by jdavis999x | last post: by
reply views Thread by Nils Valentin | last post: by
reply views Thread by sridhar nagabhurshana | last post: by
5 posts views Thread by Steffen | last post: by
4 posts views Thread by Olivier | last post: by
1 post views Thread by tom.eeraerts | last post: by
27 posts views Thread by didacticone | last post: by
1 post views Thread by gcdp | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.