Re: prion failed with ERROR: missing chunk number 0 for toast value 14334 in pg_toast_2619 - Mailing list pgsql-hackers

From Tom Lane
Subject Re: prion failed with ERROR: missing chunk number 0 for toast value 14334 in pg_toast_2619
Date
Msg-id 2601445.1621204973@sss.pgh.pa.us
Whole thread Raw
In response to Re: prion failed with ERROR: missing chunk number 0 for toast value 14334 in pg_toast_2619  (Andres Freund <andres@anarazel.de>)
Responses Re: prion failed with ERROR: missing chunk number 0 for toast value 14334 in pg_toast_2619
List pgsql-hackers
Andres Freund <andres@anarazel.de> writes:
> On 2021-05-16 18:21:21 -0400, Tom Lane wrote:
>> Hm, yeah.  I'm not sure if transferring the value forward from the
>> old cluster is entirely safe, but if it is, that seems like a
>> promising route to a fix.  (We should still have more sanity checking
>> around the GlobalVis code, though.)

> Why would it not be safe?

I'm just wondering about the catalog tuples set up by pg_upgrade
itself.  If they're all frozen then they probably don't matter to
this, but it might take some thought.

> I think we should remove the heuristic thing from pg_resetwal entirely,
> and error out if next-xid is set to something too far away from oldest
> xid, unless oldexid is also specified.

Seems plausible ...

            regards, tom lane



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: prion failed with ERROR: missing chunk number 0 for toast value 14334 in pg_toast_2619
Next
From: Andres Freund
Date:
Subject: Re: prion failed with ERROR: missing chunk number 0 for toast value 14334 in pg_toast_2619