Horton

Re: v12.0: reindex CONCURRENTLY: lock ShareUpdateExclusiveLock on object 14185/39327/0 is already held

Justin Pryzby <pryzby@telsasoft.com>

View thread View on postgr.es
From: Justin Pryzby <pryzby@telsasoft.com>
To: Michael Paquier <michael@paquier.xyz>
Cc: pgsql-hackers@lists.postgresql.org, Peter Eisentraut <peter.eisentraut@2ndquadrant.com>, Andreas Karlsson <andreas@proxel.se>
Date: 2019-10-24T03:08:21Z
Lists: pgsql-hackers 
On Thu, Oct 24, 2019 at 11:42:04AM +0900, Michael Paquier wrote:
> Please see the attached.  Justin, does it fix your problems regarding
> the locks?

Confirmed.

Thanks,
Justin

Commits

  1. Fix handling of pg_class.relispartition at swap phase in REINDEX CONCURRENTLY

  2. Handle interrupts within a transaction context in REINDEX CONCURRENTLY