Re: Could not read from file "pg_subtrans/00F5" at offset 122880: Success. - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Could not read from file "pg_subtrans/00F5" at offset 122880: Success.
Date
Msg-id 6ada6cc4-3fd0-48bc-8229-3173faf69ea8@aklaver.com
Whole thread Raw
In response to Re:Could not read from file "pg_subtrans/00F5" at offset 122880: Success.  (Sri Mrudula Attili <sri@ebi.ac.uk>)
List pgsql-general
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




pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Emitting JSON to file using COPY TO
Next
From: Dominique Devienne
Date:
Subject: Re: Emitting JSON to file using COPY TO