Re: Intermittent missing chunk ERRORS

From: Sbob <sbob(at)quadratum-braccas(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Intermittent missing chunk ERRORS
Date: 2025-04-26 22:49:50
Message-ID: 6835b152-5b12-489b-96f0-5c156c444da1@quadratum-braccas.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin


On 4/26/25 2:28 PM, Tom Lane wrote:
> 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

We are on V14

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Sbob 2025-04-26 22:54:18 Re: Intermittent missing chunk ERRORS
Previous Message Tom Lane 2025-04-26 20:28:42 Re: Intermittent missing chunk ERRORS