Re: Assertion on create index concurrently - Mailing list pgsql-bugs

From Andrey Lepikhov
Subject Re: Assertion on create index concurrently
Date
Msg-id a988c2c0-5c6c-27e4-3acb-a4e2bdebd064@postgrespro.ru
Whole thread Raw
In response to Re: Assertion on create index concurrently  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Assertion on create index concurrently  (Michael Paquier <michael@paquier.xyz>)
List pgsql-bugs
On 27/6/21 18:37, Tom Lane wrote:
> Michael Paquier <michael@paquier.xyz> writes:
>> On Sat, Jun 26, 2021 at 09:48:45PM +0300, Andrey Lepikhov wrote:
>>> This problem affects PG 9.6 - 13. The master branch was fixed 9 months ago
>>> by commit 83158f7, that made this operation transactional, but still.
> 
>> This looks like a good argument for back-patching 83158f7 all the way
>> down, as 813fb03 exists since 9.4.  Any thoughts from others?
> 
> +1 ... 83158f7 has survived long enough to have reasonable confidence
> in it.
Technically, 83158f7 is trivial patch. I think, some efforts is required 
only for PG9.6. I prepared a patch for this version.

-- 
regards,
Andrey Lepikhov
Postgres Professional

Attachment

pgsql-bugs by date:

Previous
From: Alexander Lakhin
Date:
Subject: Re: BUG #17072: Assert for clogGroupNext failed due to a race condition in TransactionGroupUpdateXidStatus()
Next
From: Michael Paquier
Date:
Subject: Re: Assertion on create index concurrently