Hello Laurenz,
Thanks for your response.
This error we are seeing on a delphix Virtual database that was
refreshed using the snapshot of production standalone database.
It keeps the database in pg_start_backup and to take the snapshot.
I did check the dsource(production) database logs and it hasnt got any
error like this.
Thanks,
Sri Attili
On 27/11/2023 18:58, Laurenz Albe wrote:
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
