Horton

Re: BUG #18127: Assertion HaveRegisteredOrActiveSnapshot failed on REINDEX CONCURRENTLY when blocksize=1

Andres Freund <andres@anarazel.de>

View thread View on postgr.es
From: Andres Freund <andres@anarazel.de>
To: Alexander Lakhin <exclusion@gmail.com>
Cc: pgsql-bugs@lists.postgresql.org
Date: 2023-09-28T16:31:52Z
Lists: pgsql-bugs 
Hi,

On 2023-09-22 15:00:01 +0300, Alexander Lakhin wrote:
> Andres, could you please look at this and determine whether the state,
> highlighted by the assert, is unexpected?

Yes, I think these are a problem.  I don't really see another solution than
making the assertions trigger more widely and going through and fixing the
cases one by one.

Greetings,

Andres Freund

Commits

  1. Ensure we have a snapshot when updating various system catalogs.