agora inbox for pgsql-bugs@postgresql.org  
help / color / mirror / Atom feed
From: Michael Paquier <michael@paquier.xyz>
To: kirtikumarkk21@gmail.com
To: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #19608: Error while Reindexing Main Table
Date: Thu, 6 Aug 2026 14:43:38 +0900
Message-ID: <anQfCjf1kD02eon7@paquier.xyz> (raw)
In-Reply-To: <19608-228427dd13140895@postgresql.org>
References: <19608-228427dd13140895@postgresql.org>

On Mon, Aug 03, 2026 at 09:54:17AM +0000, PG Bug reporting form wrote:
> REINDEX TABLE CONCURRENTLY leaves corrupted TOAST index unresolved; explicit
> REINDEX INDEX on TOAST index fixes "missing chunk number" errorr
> ERROR processing traceable: missing chunk number 0 for toast value
> 1040152679 in pg_toast_16499

This may point to a bug, however you are giving no information except
the error, meaning that one has no pointers.  One thing that could
count here is what kind of workload is running in parallel of the
failing REINDEX CONCURRENTLY, for example.  Having a reproducible test
case would be of course nicer.
--
Michael

Attachments:

  [application/pgp-signature] signature.asc (832B, ../anQfCjf1kD02eon7@paquier.xyz/2-signature.asc)
  download

view thread (2+ messages)

Message-ID: <anQfCjf1kD02eon7@paquier.xyz>
Permalink:  ../anQfCjf1kD02eon7@paquier.xyz/
Also on:    postgresql.org/message-id/anQfCjf1kD02eon7@paquier.xyz

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: pgsql-bugs@postgresql.org
  Cc: michael@paquier.xyz, kirtikumarkk21@gmail.com, pgsql-bugs@lists.postgresql.org
  Subject: Re: BUG #19608: Error while Reindexing Main Table
  In-Reply-To: <anQfCjf1kD02eon7@paquier.xyz>

* 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