Re: Deadlock condition in driver

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
>

In response to

Responses

Browse pgsql-bugs by date

  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