Re: Postgresql12: ERROR: Could not read from file "pg_act/02 F 4" at offset 253952: read too few bytes - Mailing list pgsql-bugs

From Daniel Gustafsson
Subject Re: Postgresql12: ERROR: Could not read from file "pg_act/02 F 4" at offset 253952: read too few bytes
Date
Msg-id C57F6B62-5509-46AD-84B7-50F14CC4EDFB@yesql.se
Whole thread Raw
In response to RE: Postgresql12: ERROR: Could not read from file "pg_act/02 F 4" at offset 253952: read too few bytes  (Orishich Aleksey <a.orishich@cft.ru>)
Responses RE: Postgresql12: ERROR: Could not read from file "pg_act/02 F 4" at offset 253952: read too few bytes  (Orishich Aleksey <a.orishich@cft.ru>)
List pgsql-bugs
> On 27 Jul 2021, at 13:38, Orishich Aleksey <a.orishich@cft.ru> wrote:

> Do you have a result on my problem?

Troubleshooting why a file on your filesystem was corrupt/torn after the fact
when no logs or traces of evidence exists is next to impossible.  In this case
there isn't even an errno set from the system.  A good place to start would be
to upgrade your system as you are several bugfix releases behind.

> This is critical for us.

The PostgreSQL website lists several professional services companies who offer
support contracts with SLA's which this list doesn't, and who can be hands-on
to investigate should this ever happen again.

--
Daniel Gustafsson        https://vmware.com/




pgsql-bugs by date:

Previous
From: Orishich Aleksey
Date:
Subject: RE: Postgresql12: ERROR: Could not read from file "pg_act/02 F 4" at offset 253952: read too few bytes
Next
From: Andrey Borodin
Date:
Subject: Re: CREATE INDEX CONCURRENTLY does not index prepared xact's data