On Mon, 2023-11-27 at 11:50 +0000, Sri Mrudula Attili wrote:
> ERROR: could not access status of transaction 16087052
> DETAIL: Could not read from file "pg_subtrans/00F5" at offset 122880: Success.
> STATEMENT: SELECT distinct
That's data corruption.
Time to restore your backup.
Investigate how you got there. Did you run "pg_resetwal"?
Did you restore a database from a file system backup?
Did you remove a "backup_label" file? Is your hardware broken?
Yours,
Laurenz Albe