Re: JDBC executeBatch() hangs without error - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: JDBC executeBatch() hangs without error
Date
Msg-id alpine.BSO.2.03.1309261345001.26217@ejurka.com
Whole thread Raw
In response to Re: JDBC executeBatch() hangs without error  (Kevin Wooten <kdubb@me.com>)
Responses Re: JDBC executeBatch() hangs without error
List pgsql-jdbc

On Thu, 26 Sep 2013, Kevin Wooten wrote:

> Could this be related to the note in QueryExecutorImpl.java ~ line 287
> titled "Deadlock Avoidance"?
> If I remember correctly it's specifically related to batched queries and
> synchronous TCP.

Almost certainly.  The thing to look at is setting the network buffer
sizes to use to large values to avoid the deadlock.  The default values
are machine dependent which also explains it working or not on different
machines.  These are unfortunately not documented, but were introduced in
this commit:

https://github.com/pgjdbc/pgjdbc/commit/4e7f65b91e95d6249c78de6944f09cd34ef1ae87

Kris Jurka


pgsql-jdbc by date:

Previous
From: Kevin Wooten
Date:
Subject: Re: JDBC executeBatch() hangs without error
Next
From: "Vinay S (vinas)"
Date:
Subject: Re: JDBC executeBatch() hangs without error