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 Orishich Aleksey
Subject RE: Postgresql12: ERROR: Could not read from file "pg_act/02 F 4" at offset 253952: read too few bytes
Date
Msg-id 76ead10fde7a4f13b02c5afeeae049b6@cft.ru
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  (Daniel Gustafsson <daniel@yesql.se>)
List pgsql-bugs
ОК, what logs do you need?

-----Original Message-----
From: Daniel Gustafsson <daniel@yesql.se>
Sent: Tuesday, July 27, 2021 6:58 PM
To: Оришич Алексей Петрович <a.orishich@cft.ru>
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: Postgresql12: ERROR: Could not read from file "pg_act/02 F 4" at offset 253952: read too few bytes

> 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
isnext to impossible.  In this case there isn't even an errno set from the system.  A good place to start would be to
upgradeyour 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
listdoesn'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: PG Bug reporting form
Date:
Subject: BUG #17125: Operator precedence bug in websearch_to_tsquery function
Next
From: Etsuro Fujita
Date:
Subject: Re: The case when AsyncAppend exists also in the qual of Async ForeignScan