Feedback-ID: i374947ac:Fastmail
Content-Type: multipart/alternative;
 boundary="------------08B0Q5q0WcUOcNkKTlyYNhd0"
Message-ID: <870ee861-8c1c-4979-846a-e9e507ca60f2@quadratum-braccas.com>
Date: Sat, 26 Apr 2025 11:09:32 -0600
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
To: pgsql-admin@lists.postgresql.org
Content-Language: en-US
From: Sbob <sbob@quadratum-braccas.com>
Subject: Intermittent missing chunk ERRORS
Archived-At: 
 <https://www.postgresql.org/message-id/870ee861-8c1c-4979-846a-e9e507ca60f2%40quadratum-braccas.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------08B0Q5q0WcUOcNkKTlyYNhd0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

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


--------------08B0Q5q0WcUOcNkKTlyYNhd0
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit

<!DOCTYPE html>
<html>
  <head>

    <meta http-equiv="content-type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <p>All;</p>
    <p><br>
    </p>
    <p>I am working with a client, they have an app that is running into
      error's like this:<br>
    </p>
    <p><span data-teams="true"><span style="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 data-teams="true"><span style="color: inherit;"><br>
        </span></span></p>
    <p><span data-teams="true"><span style="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 data-teams="true"><span style="color: inherit;"><br>
        </span></span></p>
    <p><span data-teams="true"><span style="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 data-teams="true"><span style="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 data-teams="true"><span style="color: inherit;"><br>
        </span></span></p>
    <p><span data-teams="true"><span style="color: inherit;">Thanks in
          advance</span></span></p>
    <p><span data-teams="true"><span style="color: inherit;"><br>
        </span><span
class="___87nhvx0 fau6ura f3052tw lpcCommonWeb-hoverTarget container-160"
          aria-label="Mentioned you"><span dir="auto"
class="fui-StyledText ___b84x0u0 f1l8vj45 f1leeax8 f1k6fduh fdvs7vj fx5ovu0 f3ug3cj"
            itemtype="http://schema.skype.com/Mention"></span></span></span></p>
  </body>
</html>

--------------08B0Q5q0WcUOcNkKTlyYNhd0--