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