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

From Kyotaro Horiguchi
Subject Re: Could not read from file "pg_subtrans/00F5" at offset 122880: Success.
Date
Msg-id 20231128.175443.1171037512392479311.horikyota.ntt@gmail.com
Whole thread Raw
In response to Re: Could not read from file "pg_subtrans/00F5" at offset 122880: Success.  (Laurenz Albe <laurenz.albe@cybertec.at>)
Responses Re: Could not read from file "pg_subtrans/00F5" at offset 122880: Success.  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
List pgsql-general
At Mon, 27 Nov 2023 19:58:13 +0100, Laurenz Albe <laurenz.albe@cybertec.at> wrote in
> On Mon, 2023-11-27 at 11:50 +0000, Sri Mrudula Attili wrote:
> > ERROR:  could not access status of transaction 16087052
> > DETAIL:  Could not read from file "pg_subtrans/00F5" at offset 122880: Success.

By the way, just out of curiosity, but errno should not be zero at the
time the message above was output, yet "%m" is showing "success",
which implies errno = 0 in Linux. How can that happen?

slru.c:961
>     case SLRU_READ_FAILED:
>       if (errno)
>         ereport(ERROR,
>             (errcode_for_file_access(),
>              errmsg("could not access status of transaction %u", xid),
>              errdetail("Could not read from file \"%s\" at offset %d: %m.",

regards.

--
Kyotaro Horiguchi
NTT Open Source Software Center



pgsql-general by date:

Previous
From: Filip Sedlák
Date:
Subject: Re: Emitting JSON to file using COPY TO
Next
From: Dominique Devienne
Date:
Subject: Get back the number of columns of a result-set prior to JSON aggregation