Postgres Pro
Downloads
Home   >   mailing lists

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

From Vijaykumar Jain
Subject Re: Intermittent missing chunk ERRORS
Date
Msg-id CAM+6J97AxL-3OjSX38jgTzRyyF1cKT5Z51DC5neA73+eEn3OVQ@mail.gmail.com
Whole thread Raw
In response to Intermittent missing chunk ERRORS  (Sbob <sbob@quadratum-braccas.com>)
Responses Re: Intermittent missing chunk ERRORS
List pgsql-admin
Tree view
a lot in this gist is something you can debug to start with.


if not the index than the toast table might be corrupt.
the bigger problem might be to figure out how it got corrupt. a one off power incident, or bug or storage is having issues etc.
once that is clear,
a simple start would be to run a pg_dump of the database to /dev/null and check if the dump is clean without errors.

Thanks,
Vijay

Open to work
Resume - Vijaykumar Jain

On Sat, Apr 26, 2025, 10:39 PM Sbob <sbob@quadratum-braccas.com> wrote:

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


pgsql-admin by date:

Previous
From: Sbob
Date:
Subject: Intermittent missing chunk ERRORS
Next
From: Vijaykumar Jain
Date:
Subject: Re: Intermittent missing chunk ERRORS