public inbox for [email protected]  

help / color / mirror / Atom feed

From: Vijaykumar Jain <[email protected]>
To: Sbob <[email protected]>
Cc: Pgsql-admin <[email protected]>
Subject: Re: Intermittent missing chunk ERRORS
Date: Sun, 27 Apr 2025 01:42:14 +0530
Message-ID: <CAM+6J96GFJ4+N6=ptmPn_KcOjBtJbRbs5xb4_dwToSbiBwOA3g@mail.gmail.com> (raw)
In-Reply-To: <CAM+6J97AxL-3OjSX38jgTzRyyF1cKT5Z51DC5neA73+eEn3OVQ@mail.gmail.com>
References: <[email protected]>
	<CAM+6J97AxL-3OjSX38jgTzRyyF1cKT5Z51DC5neA73+eEn3OVQ@mail.gmail.com>

forgot about the core tool to check for the problem.

https://www.postgresql.org/docs/current/amcheck.html

this can help find corruption issues much faster.


Thanks,
Vijay

Open to work
Resume - Vijaykumar Jain <https://github.com/cabecada;

On Sun, Apr 27, 2025, 1:34 AM Vijaykumar Jain <
[email protected]> wrote:

> a lot in this gist is something you can debug to start with.
>
> https://gist.github.com/supix/80f9a6111dc954cf38ee99b9dedf187a
>
> 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 <https://github.com/cabecada;
>
> On Sat, Apr 26, 2025, 10:39 PM Sbob <[email protected]> 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
>>
>>
>>

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Intermittent missing chunk ERRORS
  In-Reply-To: <CAM+6J96GFJ4+N6=ptmPn_KcOjBtJbRbs5xb4_dwToSbiBwOA3g@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox