MIME-Version: 1.0
References: <870ee861-8c1c-4979-846a-e9e507ca60f2@quadratum-braccas.com>
In-Reply-To: <870ee861-8c1c-4979-846a-e9e507ca60f2@quadratum-braccas.com>
From: Vijaykumar Jain <vijaykumarjain.github@gmail.com>
Date: Sun, 27 Apr 2025 01:34:37 +0530
Message-ID: 
 <CAM+6J97AxL-3OjSX38jgTzRyyF1cKT5Z51DC5neA73+eEn3OVQ@mail.gmail.com>
Subject: Re: Intermittent missing chunk ERRORS
To: Sbob <sbob@quadratum-braccas.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000009057b90633b3f6ed"
Archived-At: 
 <https://www.postgresql.org/message-id/CAM%2B6J97AxL-3OjSX38jgTzRyyF1cKT5Z51DC5neA73%2BeEn3OVQ%40mail.gmail.com>
Precedence: bulk

--0000000000009057b90633b3f6ed
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

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=E2=80=AFPM Sbob <sbob@quadratum-braccas.com> wr=
ote:

> 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 4491547=
7
> 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 w=
as
> 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 thought=
s
> on where to look /how to debug this?
>
>
> Thanks in advance
>
>
>

--0000000000009057b90633b3f6ed
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto"><div dir=3D"auto">a lot in this gist is something you can=
 debug to start with.</div><div dir=3D"auto"><br></div><div><a href=3D"http=
s://gist.github.com/supix/80f9a6111dc954cf38ee99b9dedf187a">https://gist.gi=
thub.com/supix/80f9a6111dc954cf38ee99b9dedf187a</a></div><div dir=3D"auto">=
<br></div><div dir=3D"auto">if not the index than the toast table might be =
corrupt.</div><div dir=3D"auto">the bigger problem might be to figure out h=
ow it got corrupt. a one off power incident, or bug or storage is having is=
sues etc.</div><div dir=3D"auto">once that is clear,</div><div dir=3D"auto"=
>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.</div><div><br></div><div data-sm=
artmail=3D"gmail_signature"><div dir=3D"ltr">Thanks,<div>Vijay</div><div><b=
r></div><div>Open to work</div><div>Resume -=C2=A0<a href=3D"https://github=
.com/cabecada" target=3D"_blank">Vijaykumar Jain</a><br></div></div></div><=
/div><br><div class=3D"gmail_quote gmail_quote_container"><div dir=3D"ltr" =
class=3D"gmail_attr">On Sat, Apr 26, 2025, 10:39=E2=80=AFPM Sbob &lt;<a hre=
f=3D"mailto:sbob@quadratum-braccas.com">sbob@quadratum-braccas.com</a>&gt; =
wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8e=
x;border-left:1px #ccc solid;padding-left:1ex"><u></u>

 =20

   =20
 =20
  <div>
    <p>All;</p>
    <p><br>
    </p>
    <p>I am working with a client, they have an app that is running into
      error&#39;s like this:<br>
    </p>
    <p><span><span style=3D"color:inherit"><u>SQL
            Error [XX001]: ERROR: missing chunk number 0 for toast value
            44915477 in pg_toast_5321896 <br>
          </u></span></span></p>
    <p><span><span style=3D"color:inherit"><br>
        </span></span></p>
    <p><span><span style=3D"color:inherit">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.</span></span></p>
    <p><span><span style=3D"color:inherit"><br>
        </span></span></p>
    <p><span><span style=3D"color:inherit">I assume
          that if this were a corrupt index issue then the query would
          continue to fail every time.</span></span></p>
    <p><span><span style=3D"color:inherit">Has anyone
          seen this type of intermittent index error before? and
          thoughts on where to look /how to debug this?</span></span></p>
    <p><span><span style=3D"color:inherit"><br>
        </span></span></p>
    <p><span><span style=3D"color:inherit">Thanks in
          advance</span></span></p>
    <p><span><span style=3D"color:inherit"><br>
        </span><span aria-label=3D"Mentioned you"><span dir=3D"auto"></span=
></span></span></p>
  </div>

</blockquote></div>

--0000000000009057b90633b3f6ed--