On Wed, 21 May 2008, Kris Jurka wrote:
On Wed, 21 May 2008, Daniel Migowski wrote:
I came across a deadlock condition in the JDBC driver that rises when very
large queries, containing thousends of statements are send to the server
with statement.execute().
We already consider this case for batch execution and break the batch into an
internal size that we expect is safe from deadlock. It looks like we should
be doing the same for these one query batches. I'm not sure how tough that
will be, but I'll take a look.
I've committed a fix to CVS for this problem, and it should fix your case,
but will not fix all deadlocks as a move to NIO or threading would.
For more details, see:
http://archives.postgresql.org/pgsql-jdbc/2008-10/msg00034.php
Kris Jurka
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs