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(dot)klaver(at)aklaver(dot)com