Re: Could not read from file "pg_subtrans/00F5" at offset 122880: Success.

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