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

On 11/27/23 03:50, Sri Mrudula Attili wrote:
> Hello,
> 
> Post refresh of a Delphix VDB , while trying to connect from application 
> users are getting the below error.
> 
> Could also see these errors in postgresql.log
> 
> Error Message:
> 
> < 2023-11-24 12:24:10.031 GMT >ERROR:  could not access status of 
> transaction 16087052
> < 2023-11-24 12:24:10.031 GMT >DETAIL:  Could not read from file 
> *"pg_subtrans/00F5" at offset 122880: Success.*
> < 2023-11-24 12:24:10.031 GMT >STATEMENT:  SELECT distinct
> 
> Postgresql Version:
> 
> ----------------------------------------------------------------------------------------------------------
>   PostgreSQL 11.16 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 
> 20150623 (Red Hat 4.8.5-44), 64-bit

 From this:

https://docs.delphix.com/docs537/delphix-administration/postgresql-environments-and-data-sources/provisioning-vdbs-from-postgresql-dsources/provisioning-a-postgresql-vdb

there seems to be a lot of moving parts to using Delphix VDB with a 
Postgres database.  You are going to need to provide more information 
about your setup.

> 
> 
> Thanks,
> 
> Sri Attili

-- 
Adrian Klaver
adrian.klaver@aklaver.com