Re: CREATE INDEX CONCURRENTLY does not index prepared xact's data - Mailing list pgsql-bugs

From Andrey Borodin
Subject Re: CREATE INDEX CONCURRENTLY does not index prepared xact's data
Date
Msg-id 9B31541B-4750-4058-90DC-58FF975F37B3@yandex-team.ru
Whole thread Raw
In response to Re: CREATE INDEX CONCURRENTLY does not index prepared xact's data  (Peter Geoghegan <pg@bowt.ie>)
List pgsql-bugs

> 31 июля 2021 г., в 13:51, Peter Geoghegan <pg@bowt.ie> написал(а):
>
> maybe use rr for this?
Thanks, Peter!
I'll give it a try.

Currently I observe that during PrepareTransaction() there might be a moment when the transaction is not reported by
GetLockConflicts()with relevant lock. 

I observe that PrepareTransaction() for violating xid is somewhere between
CallXactCallbacks(XACT_EVENT_PREPARE);
and
PostPrepare_PgStat();

And GetLockConflicts() fails to detect this transaction.

Thanks!

Best regards, Andrey Borodin.


pgsql-bugs by date:

Previous
From: Wojciech Strzalka
Date:
Subject: Re: psql doesn't show tables duplicated in multiple schemas
Next
From: Tom Lane
Date:
Subject: Re: Many queries stuck for waiting MultiXactOffsetControlLock on PostgreSQL 9.6.1 replica