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