Re: upgrades in row-level locks can deadlock - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: upgrades in row-level locks can deadlock
Date
Msg-id 20190613180014.GA9775@alvherre.pgsql
Whole thread Raw
In response to Re: upgrades in row-level locks can deadlock  (Oleksii Kliukin <alexk@hintbits.com>)
Responses Re: upgrades in row-level locks can deadlock
List pgsql-hackers
On 2019-Jun-13, Oleksii Kliukin wrote:

> Makes sense. For the symmetry I have included those that perform lock
> upgrades in one session and those that doesn’t, while the other sessions
> acquire locks, do updates or deletes. For those that don’t upgrade locks the
> test checks that the locks are acquired in the correct order.

Thanks for the updated patch!  I'm about to push to branches 9.6-master.
It applies semi-cleanly (only pgindent-maturity whitespace conflicts).

The [pg11 version of the] patch does applies to 9.5 cleanly ... but the
isolation test doesn't work, because isolationtester was not smart
enough back then.  Since there have been no previous reports of this
problem, and to avoid pushing untested code, I'm going to refrain from
back-patching there.  My guess is that it should work ...

In 9.4 there are quite some severe conflicts, because 27846f02c176 was
not back-patched there.  (The bug number "#8470" still floats in my
memory from time to time.  Shudder)

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



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: PG 11 JIT deform failure
Next
From: didier
Date:
Subject: Re: PG 11 JIT deform failure