Postgres Pro
Downloads
Home   >   mailing lists

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

From Sri Mrudula Attili
Subject Re:Could not read from file "pg_subtrans/00F5" at offset 122880: Success.
Date
Msg-id 2004615f-02a6-4058-97f2-31f019e1cf93@ebi.ac.uk
Whole thread Raw
Responses Re: Could not read from file "pg_subtrans/00F5" at offset 122880: Success.
Re: Could not read from file "pg_subtrans/00F5" at offset 122880: Success.
List pgsql-general
Tree view

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


Thanks, Sri Attili

pgsql-general by date:

Previous
From: Dominique Devienne
Date:
Subject: Re: Emitting JSON to file using COPY TO
Next
From: "David G. Johnston"
Date:
Subject: Re: Emitting JSON to file using COPY TO