Postgres Pro
Downloads
Home   >   mailing lists

Re: deadlock of lock-waits (on transaction and on tuple) using same update statement - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: deadlock of lock-waits (on transaction and on tuple) using same update statement
Date
Msg-id 20140925140502.GX5311@eldon.alvh.no-ip.org
Whole thread Raw
In response to Re: deadlock of lock-waits (on transaction and on tuple) using same update statement  (Andrej Vanek <andrej.vanek.sk@gmail.com>)
Responses Re: deadlock of lock-waits (on transaction and on tuple) using same update statement  (Andrej Vanek <andrej.vanek.sk@gmail.com>)
List pgsql-general
Tree view 
Andrej Vanek wrote:
> Hi,
>
>
> now I've checked release-notes of 9.3.5 (my version 9.3.4)- found a fix
> which probably could lead to my deadlocks:
>
> > Fix race condition when updating a tuple concurrently locked by another
> > process (Andres Freund,Álvaro Herrera)
>
> How can I make sure I've run into this bug?

Update and see if you can reproduce the bug there.  If you can, let us
know; I didn't trace through your example and won't unless you confirm
it's still an issue.

It's a bad idea to run any 9.3 version other than the latest one.  There
are some ugly bugs in there.

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Installing Postgresql on Linux Friendlyarm
Next
From: Thomas Kellerer
Date:
Subject: Re: Synchronous replication + pgPool: not all transactions immediately visible on standby