Re: Deadlock condition in driver - Mailing list pgsql-bugs

From Richard Evans
Subject Re: Deadlock condition in driver
Date
Msg-id 483513FA.8030406@blueallegro.net
Whole thread Raw
In response to Re: Deadlock condition in driver  (Kris Jurka <books@ejurka.com>)
Responses Re: Deadlock condition in driver  (Kris Jurka <books@ejurka.com>)
List 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
>

pgsql-bugs by date:

Previous
From: "TIAN Justin"
Date:
Subject: Re: error message "psql: expected authentication request from server, but received " when using psql to connect remote database
Next
From: Kris Jurka
Date:
Subject: Re: Deadlock condition in driver