Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wrqtR-000Fo1-0j for pgsql-bugs@arkaria.postgresql.org; Thu, 06 Aug 2026 05:43:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wrqtQ-002k6l-2R for pgsql-bugs@arkaria.postgresql.org; Thu, 06 Aug 2026 05:43:48 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wrqtP-002k6c-2x for pgsql-bugs@lists.postgresql.org; Thu, 06 Aug 2026 05:43:47 +0000 Received: from fout-a8-smtp.messagingengine.com ([103.168.172.151]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wrqtN-00000000Rxi-0zQL for pgsql-bugs@lists.postgresql.org; Thu, 06 Aug 2026 05:43:46 +0000 Received: from phl-compute-03.internal (phl-compute-03.internal [10.202.2.43]) by mailfout.phl.internal (Postfix) with ESMTP id C6F0AEC0098; Thu, 6 Aug 2026 01:43:43 -0400 (EDT) Received: from phl-frontend-03 ([10.202.2.162]) by phl-compute-03.internal (MEProxy); Thu, 06 Aug 2026 01:43:43 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:content-type:content-type:date:date:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:subject :subject:to:to; s=fm3; t=1785995023; x=1786081423; bh=HX8KO80OSS ki9H+9WesaRY+yWZgoJm1Hwqu/4heov1M=; b=sjVhcB3V8QlNm7bBcYJhbT7qGE KSGCx21PWnjRThIK9IxH6ug13JnpK6T5y0HjOiOZ5Hn75WTIboerlcpdGepGCEZS cT/S5SQ9GG+WeR5QrV+0zJ4edMsGPqryymBJQ6mW/PTYZiiRVDB07RcmvACHY6bQ EmgQwlE22HYfIZm1iDGTNixpR5zvR79GlsW7eEnLfSs/0Iu20ulqZ618suc6SFa+ XAWG9zEuAZ3lIyNVi6xMCUb2AmXxDdh+3b/BwbZn3PKn7fePNhXeIrBYp0G2hR7b Hkee59TNQmIk/2BLruo3PRMBIcu9jNVNAAMnhm0T7/xq8ed9e3yRk3sDAd5A== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:subject:subject:to :to:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm3; t= 1785995023; x=1786081423; bh=HX8KO80OSSki9H+9WesaRY+yWZgoJm1Hwqu /4heov1M=; b=N7vpWN5PVoLPI9lSFmN2y55KULG9gr0IvUUFES3gniaaI5V2WuD JkfGkra0XznMY4Z3IqADDCkf9vd1wnt3wCAF9kAsj4vk5vHDoha2MqJuPIsyYE/l vMYuFM0eKMQkKv33cjAmr0GRNDnr5MGY8kcM+pNg/UEpcpHrNslttghMOmYtOqAW YI9JJl97z/siHqePJ2C+Icz1bqxtzd4FNEl3vnoUtG4LILY+GbVfLsp6yJp8LfQi F8sOA2Q4D58OnhaBPyuVm99phLFc6fwgyR12tVcRYhOLozp4sne+c5uI5NU4EXJl n45QzPTetfO58tM/4xIlUIyENGuhTa0B/EA== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: dmFkZTFZ0k4bxtWz/vkljVgpH6VSAVPkWq7Ma7lKwihTHr+8SZe1lNZTeIsxbX/wpQdxvd TkN0ucmCttd415f2DWJDsVJpXwC6XSiwKqADiTvGeCUhSezs/ZSx3NBg2nv71trho/texd /XDNUjpM/xGtTy6+Tifk4BRORwAOhgck+BtvM/Rsu5ECEJdmmMZ/u0wd9Rhn0G6ZubZgfq DPIZfQZpAiGGc3cV3SyW3QYMhcnTEBXdlhFT0RDU6vbh74MR/xlAWuSL1zLkGkbs9yfJN4 Wth4AL4t+7WbPj6Ko4W9BX3sTrkm5BGZocDyB9Olg/Ehwk9cQbEjD/h1tuO69wm3oHLwAY yG9fp6d6bfc3NU0M20LmQwuDP+htYtQ+WfgMhojgGfh1S/giXgiwn4Od1gnQQdkipfl1aY 1K3MBQPUN0nZGMmlhJGAyX5XIvJNJhTu/IHo7d0OH9tiiMmcPAh4N0PvBbfHlAvNhVIF2g hV8l+EbFW6T1v1bxCBBrehJq8dmDow8zefuTNeO4+5MSdTSp9qV37I9zlrl3k7WAZK4nqd wj24DXyjU0X+ta32JeZPNxYcMT14JT8hi7Fhd9StjOwht1NspGKKt70BwfL2ma41gkJ3o8 RxHQcJa/hxgtraxyYzOBypyEjzuZzwUvGXdAm3Ec6DyDhKgqjqGC52Va86rA X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Thu, 6 Aug 2026 01:43:42 -0400 (EDT) Date: Thu, 6 Aug 2026 14:43:38 +0900 From: Michael Paquier To: kirtikumarkk21@gmail.com, pgsql-bugs@lists.postgresql.org Subject: Re: BUG #19608: Error while Reindexing Main Table Message-ID: References: <19608-228427dd13140895@postgresql.org> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="Z7ZtMKtdgMr6O7bT" Content-Disposition: inline In-Reply-To: <19608-228427dd13140895@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --Z7ZtMKtdgMr6O7bT Content-Type: text/plain; charset=us-ascii Content-Disposition: inline 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 --Z7ZtMKtdgMr6O7bT Content-Type: application/pgp-signature; name=signature.asc -----BEGIN PGP SIGNATURE----- iQIzBAEBCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmp0HwoACgkQnvQgOdby QH2mTxAAhp4FLHyv4RimRXaa5Ph8s+D9ajXHwZuRapLNVY8L2OeziCSl2AtJtZAU 1XCG1nvMAwNsTO9+d8x3DN8PuLWkcTwBW3hN+F3rhFdreZiGnla5KZMbewlWv092 3xuSY8NkVi2x0kD8+91n+eP9UVEt3QXQtcsaR9CIXzy5LcanKd2cfZA0Mjd9DnVj 5iWcxZSAQDO1lKWC2zBipkx5vCGhUD3ZqkAEy/SynzpHdNdnn2V63fBI8dO4NoqW pNnjjAdb/k/WxWk7tMzLlCcTbeswIlED2+0m7WQN0JFp02Q/GCq62IB9OS7ahxtX w8iA4hcl2X43gwqY/3y+Pw7IG83QCEKK8VpIYihKCUM7Mzs9JjEnCPtbMXjYpEsV o1PO6qcUuOzGEQ7SKDqONzwYM8wEi0UBPPrMRR/h6EiGzEJTm01o8vLPIOTkp3Nq hT+f1YUVxdm901P66wEIw4lVe31qP6EX/OtIDdCQLiG478MpiF4hi1WEbYJ3vfKa JXU2LqAkvRdLuFfIxDwgANUqk53mtVGotKXOKuARppzura4KquueeWSFXhybq34e Bl2snu7jup8JgsZiiCTr3vjNiaUfzbNHtHWMc/HFqW16JqHcNNTG2nWhE5sKL681 xDByaDvy1xxq/oXPOgUsqXSz5nTHQJCeeBTX+q271XeF0R3bDdc= =cxqA -----END PGP SIGNATURE----- --Z7ZtMKtdgMr6O7bT--