From: | Richard Evans <richard(dot)evans(at)blueallegro(dot)net> |
---|---|
To: | Kris Jurka <books(at)ejurka(dot)com> |
Cc: | Daniel Migowski <dmigowski(at)ikoffice(dot)de>, pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: Deadlock condition in driver |
Date: | 2008-05-22 06:34:34 |
Message-ID: | 483513FA.8030406@blueallegro.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
We hit this problem and modified the driver to use non-blocking IO to
fix it. You lose some of the more unusual features of the driver (such
as switching the socket after open), but it does fix the blocking.
Richard Evans
>
>
> 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.
>
> Kris Jurka
>
From | Date | Subject | |
---|---|---|---|
Next Message | Kris Jurka | 2008-05-22 06:45:41 | Re: Deadlock condition in driver |
Previous Message | Thomas H | 2008-05-22 03:08:45 | BUG #4186: set lc_messages does not work |