Re: Intermittent missing chunk ERRORS

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
Cc: Sbob <sbob(at)quadratum-braccas(dot)com>, pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Intermittent missing chunk ERRORS
Date: 2025-04-26 20:28:42
Message-ID: 106241.1745699322@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Sbob 2025-04-26 22:49:50 Re: Intermittent missing chunk ERRORS
Previous Message Laurenz Albe 2025-04-26 20:24:58 Re: Intermittent missing chunk ERRORS