pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Carl E. McMillin <carlymac@earthlink.net>
To: 'Reynir Þór Hübner' <reynir@hugsmidjan.is>
To: pgsql-general@postgresql.org
Subject: Re: JDBC problem
Date: Tue, 11 May 2004 11:15:59 -0700
Message-ID: <000a01c43784$061c1150$6600a8c0@DEVSONY> (raw)
In-Reply-To: <40A0ACB3.1080405@hugsmidjan.is>

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





view thread (13+ messages)  latest in thread

Message-ID: <000a01c43784$061c1150$6600a8c0@DEVSONY>
Permalink:  ../000a01c43784$061c1150$6600a8c0@DEVSONY/
Also on:    postgresql.org/message-id/000a01c43784$061c1150$6600a8c0@DEVSONY

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-general@postgresql.org
  Cc: carlymac@earthlink.net, reynir@hugsmidjan.is
  Subject: Re: JDBC problem
  In-Reply-To: <000a01c43784$061c1150$6600a8c0@DEVSONY>
  References: <40A0ACB3.1080405@hugsmidjan.is> <000a01c43784$061c1150$6600a8c0@DEVSONY>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox