Re: BUG #17245: Index corruption involving deduplicated entries

Hi,

On 2021-10-29 00:46:29 +0300, Kamigishi Rei wrote:
> The issue manifested again earlier today *after* a REINDEX followed by
> enabling WAL replica logging on the 24th of October. I saved a snapshot of
> the filesystem holding the data directory. Would that be useful for further
> analysis?

Yes, that's *quite* useful.  I assume you can't just share that snapshot?

Once we identified an affected heap and index page with the corruption, we
should use pg_waldump to scan for all chanes to that table.

Do you have the log file(s) from between the 24th and now? That might give us
a good starting point for the LSN range to scan.

Greetings,

Andres Freund