Re: Better HINT message for "unexpected data beyond EOF"

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Andres Freund <andres(at)anarazel(dot)de>
Cc: Jakub Wartak <jakub(dot)wartak(at)enterprisedb(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Better HINT message for "unexpected data beyond EOF"
Date: 2025-03-27 14:55:39
Message-ID: CA+TgmoaQNaiSVcDjJBifpcHXkYg+nTHBPq3CJEo10QCRxznZDg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Mar 27, 2025 at 10:12 AM Andres Freund <andres(at)anarazel(dot)de> wrote:
> FWIW, I think we should just drop the HINT. We really have no clue what caused
> it and a HINT should imo have at least some value other than "*Shrug*", which
> is imo pretty much what these HINTs amount to, if they were a bit more blunt.

I think that would be better than what we have now, but I still wonder
if we should give some kind of a hint that an external process may be
doing something to that file. Jakub and I may be biased by having just
seen a case of exactly that in the field, but I wonder now how many
'data beyond EOF' messages are exactly that -- and it's not like the
user is going to guess that 'data beyond EOF' might mean that such a
thing occurred.

--
Robert Haas
EDB: http://www.enterprisedb.com

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Christoph Berg 2025-03-27 15:00:18 Re: Better HINT message for "unexpected data beyond EOF"
Previous Message Vik Fearing 2025-03-27 14:27:50 Re: SQL:2023 JSON simplified accessor support