Write to outputstream in PGStream blocks indefinitely - Mailing list pgsql-jdbc

From Jonas Partner
Subject Write to outputstream in PGStream blocks indefinitely
Date
Msg-id 9b8dd34605070401153340015c@mail.gmail.com
Whole thread Raw
Responses Re: Write to outputstream in PGStream blocks indefinitely  (Oliver Jowett <oliver@opencloud.com>)
List pgsql-jdbc
I am having a problem where by my application freezes after a period
of time under load.  Doing a thread dump shows a large number of
threads seem to be attempting to write to output streams as shown
below.  The application code is attempting to add a single row to a
table, including binary data of between 3kb - 10kb. This requires a
restart of the application to clear.

Has anyone else seen similar behaviour?  Could this be related to the
issue discussed in
http://archives.postgresql.org/pgsql-jdbc/2004-12/msg00096.php where
the server and driver are filling their respective buffers.  If so
what is the best approach to reducing the likelyhodd of this
happening.

This occurs using PostgreSQL 8.0.3 with JDBC driver version 8.0-311.


Regards

Jonas




"Thread-49" prio=5 tid=0x00488d08 nid=0x1397 runnable [cc77e000..cc77fc28]
       at org.postgresql.core.PGStream.Send(PGStream.java:207)
       at org.postgresql.core.PGStream.SendStream(PGStream.java:479)
       at org.postgresql.core.v3.SimpleParameterList.streamBytea(SimpleParameterList.java:118)
       at org.postgresql.core.v3.SimpleParameterList.writeV3Value(SimpleParameterList.java:201)
       at org.postgresql.core.v3.QueryExecutorImpl.sendBind(QueryExecutorImpl.java:816)
       at org.postgresql.core.v3.QueryExecutorImpl.sendOneQuery(QueryExecutorImpl.java:1008)
       at org.postgresql.core.v3.QueryExecutorImpl.sendQuery(QueryExecutorImpl.java:599)
       at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:173)
       - locked <0xd616e6c0> (a org.postgresql.core.v3.QueryExecutorImpl)
       at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:389)
       at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:330)
       at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:282)

pgsql-jdbc by date:

Previous
From: Jesper Thorhauge
Date:
Subject: Re: Streaming blob to db
Next
From: Oliver Jowett
Date:
Subject: Re: Write to outputstream in PGStream blocks indefinitely