Re: JDBC problem - Mailing list pgsql-general

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: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Reynir Þór Hübner
Sent: Tuesday, May 11, 2004 3:37 AM
To: pgsql-general@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(SocketOutputStream.java:92)
   at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
   at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:66)
   at java.io.BufferedOutputStream.write(BufferedOutputStream.java:110)
   at java.io.FilterOutputStream.write(FilterOutputStream.java:80)
   at org.postgresql.PG_Stream.Send(PG_Stream.java:87)
   at org.postgresql.core.QueryExecutor.sendQuery(QueryExecutor.java:184)
   at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:71)
   at
org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connection
.java:505)
   at
org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.j
ava:360)
   at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.j
ava:48)
   at
org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statem
ent.java:176)
   at
org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statem
ent.java:163)
   at
org.apache.commons.dbcp.DelegatingStatement.executeQuery(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