Horton

Re: Assertion failure when autovacuum drops orphan temp indexes.

Stepan Neretin <sndcppg@gmail.com>

View thread View on postgr.es
From: Stepan Neretin <sndcppg@gmail.com>
To: Masahiko Sawada <sawada.mshk@gmail.com>
Cc: Michael Paquier <michael@paquier.xyz>, Nathan Bossart <nathandbossart@gmail.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2024-10-28T04:47:59Z
Lists: pgsql-hackers 
> Thank you for your suggestion. IMHO I'm not sure we need to have a
> regression test for this bug as it's just an oversight of recently
> committed code. My suggestion was just to help Stepan reproduce this
> failure using TAP tests.
>
>
Yes, I have reproduced the issue manually before your changes, but I am
unable to do so in the perl test.
Best Regards, Stepan Neretin!

Commits

  1. Ensure we have a snapshot when updating pg_index in index_drop().

  2. Ensure we have a snapshot when updating pg_index entries.