Re: Intermittent missing chunk ERRORS - Mailing list pgsql-admin

From Tom Lane
Subject Re: Intermittent missing chunk ERRORS
Date
Msg-id 106241.1745699322@sss.pgh.pa.us
Whole thread Raw
In response to Re: Intermittent missing chunk ERRORS  (Laurenz Albe <laurenz.albe@cybertec.at>)
Responses Re: Intermittent missing chunk ERRORS
List pgsql-admin
Laurenz Albe <laurenz.albe@cybertec.at> writes:
> On Sat, 2025-04-26 at 11:09 -0600, Sbob wrote:
>> SQL Error [XX001]: ERROR: missing chunk number 0 for toast value 44915477 in pg_toast_5321896
>> Has anyone seen this type of intermittent index error before? and thoughts on where to
>> look /how to debug this?

> The error is data corruption.

We've seen transient errors of this sort arise from what are basically
timing problems, and fixed at least a few cases.  I wonder exactly
which PG version the problematic installation is running.

            regards, tom lane



pgsql-admin by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Intermittent missing chunk ERRORS
Next
From: Sbob
Date:
Subject: Re: Intermittent missing chunk ERRORS