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

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Sri Mrudula Attili <sri(at)ebi(dot)ac(dot)uk>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Could not read from file "pg_subtrans/00F5" at offset 122880: Success.
Date: 2023-11-27 16:12:12
Message-ID: 6ada6cc4-3fd0-48bc-8229-3173faf69ea8@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs 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(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2023-11-27 17:42:16 Re: BUG #18187: Unexpected error: "variable not found in subplan target lists" triggered by JOIN
Previous Message Tom Lane 2023-11-27 14:49:29 Re: psql include text file with bom

Browse pgsql-general by date

  From Date Subject
Next Message Dominique Devienne 2023-11-27 16:14:46 Re: Emitting JSON to file using COPY TO
Previous Message Adrian Klaver 2023-11-27 16:04:05 Re: Emitting JSON to file using COPY TO