Re: Deadlock detection - Mailing list pgsql-jdbc

From Simon Riggs
Subject Re: Deadlock detection
Date
Msg-id 1244152413.23910.311.camel@ebony.2ndQuadrant
Whole thread Raw
In response to Re: Deadlock detection  (Kris Jurka <books@ejurka.com>)
List pgsql-jdbc
On Mon, 2009-06-01 at 19:30 -0400, Kris Jurka wrote:

> 1) It avoids deadlocks by buffering the writes in local memory.  That's
> great, but wasn't really the point of the thread.  Would we suggest people
> run with antiDeadlock=true in a production environment to avoid deadlocks?
> If so, why wouldn't it be the default.

> So it's a useful piece of code, but I'm not sure what context it should
> really be used in.  Is anyone using this?  For what purpose?

The reason the code was written went away before the code could sensibly
be used. We removed the contention in the database by redesign rather
than by JDBC changes. Thanks to Oliver for taking the time.

Having said that, it is clear there were some issues there that are not
fully explained. It may be that it is a JDBC driver issue, but also it
may be a protocol/handling issue. Intermittent issues are hard to get a
full state on to debug, and we are left looking at spoor or wishing we
had some.

I would like to see code added to the driver for (1), or other code. My
main request is that we have some way of responding to the problems that
we know can exist. The main argument for not buffering everything would
be performance, I think. 99.9% of users are happy as is, so to act in a
way that effects them would be bad. Sometimes, a "safe mode" would be a
useful thing to be able to enable, as a way of eliminating doubt.

--
 Simon Riggs           www.2ndQuadrant.com
 PostgreSQL Training, Services and Support


pgsql-jdbc by date:

Previous
From: "Peirong Feng (pefeng)"
Date:
Subject: how to modify connection socket timeout
Next
From: Hannu Krosing
Date:
Subject: Re: Strings with null characters produce exceptions when selectedor inserted. Attempts to select messages with null bytes produces "ERROR:insufficient data left in message". And inserting produces "ERROR: invalidbyte sequence for encoding \"UTF8\":