From: | Sbob <sbob(at)quadratum-braccas(dot)com> |
---|---|
To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
Subject: | Intermittent missing chunk ERRORS |
Date: | 2025-04-26 17:09:32 |
Message-ID: | 870ee861-8c1c-4979-846a-e9e507ca60f2@quadratum-braccas.com |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
All;
I am working with a client, they have an app that is running into
error's like this:
_SQL Error [XX001]: ERROR: missing chunk number 0 for toast value
44915477 in pg_toast_5321896
_
I thought it was a corruption / REINDEX issue, however I have run
REINDEXon the index, REINDEX on the table and even a reindexdb on the
database. Today they passed me another error (the one above) and once I
was able to login I ran the same query the app team referenced and it
ran without any errors. I asked them to re-run the query and they
informed me that it now works for them as well.
I assume that if this were a corrupt index issue then the query would
continue to fail every time.
Has anyone seen this type of intermittent index error before? and
thoughts on where to look /how to debug this?
Thanks in advance
From | Date | Subject | |
---|---|---|---|
Next Message | Vijaykumar Jain | 2025-04-26 20:04:37 | Re: Intermittent missing chunk ERRORS |
Previous Message | Laurenz Albe | 2025-04-25 22:41:08 | Re: When indexing is needed for a temp table |