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.94.2) (envelope-from ) id 1u8oLU-00C08S-Ce for pgsql-admin@arkaria.postgresql.org; Sat, 26 Apr 2025 22:50:05 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1u8oLP-007Nmx-QG for pgsql-admin@arkaria.postgresql.org; Sat, 26 Apr 2025 22:50:00 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u8oLO-007Nmn-Hu for pgsql-admin@lists.postgresql.org; Sat, 26 Apr 2025 22:50:00 +0000 Received: from fhigh-a8-smtp.messagingengine.com ([103.168.172.159]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1u8oLK-002EwE-0k for pgsql-admin@lists.postgresql.org; Sat, 26 Apr 2025 22:49:58 +0000 Received: from phl-compute-03.internal (phl-compute-03.phl.internal [10.202.2.43]) by mailfhigh.phl.internal (Postfix) with ESMTP id C45761140191; Sat, 26 Apr 2025 18:49:52 -0400 (EDT) Received: from phl-mailfrontend-02 ([10.202.2.163]) by phl-compute-03.internal (MEProxy); Sat, 26 Apr 2025 18:49:52 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= quadratum-braccas.com; h=cc:cc:content-transfer-encoding :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=fm2; t=1745707792; x=1745794192; bh=EUNOON8uD0 KEpOt5e9wcm1MP9e2/Syi4rZJw1/xHpOg=; b=7roJ8zx5Te25OdEFdn2OuzRa6Y OV0dnQGNcB6Y4obX+HrglNbxPK07fXCs1OAo8Q7AqZRlExQ98XEcFClm8IwRxwMB Wkcbe7alBgoRd1hHh+jIygw9GDAwP2pPgif+Ui0o05ndgo5WA5PM8FxnpkQQF7gR LmnOWSrKNICqKDiX/mUZFS/9V+dVAKApd3+CDz8e2mbftLfbpQz+PmV4B5Gv9zK6 zLZ4OMohlnZgnBTH2mM4IgQGLjpC/vbRmXUWbFPVqwWdYubjRNVEO2V4sqdmvUWW zPOgJA23EDeyJvPMATuT6surt/wIkkp+55kE2KWiHfbav6gyiJKtDbtiN3JA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :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=1745707792; x= 1745794192; bh=EUNOON8uD0KEpOt5e9wcm1MP9e2/Syi4rZJw1/xHpOg=; b=S hYVlaAVtPTtnaKs8o0KVfVEuBKCWmV8ensK2mavepcllIGRogmjoqB3DNnLjHcZe egYw6KHd9vpklxJdBUD06HRoEVcRnt0rEWKsUbcrDqc6+laj/7AYYtHpSJSdIlda Pl124fDvS0ABecxihpCWobovDk0m/bjfNXZkdfFDhDhCi4XuVtOqtxgcMdehBb3y g+BYqTW4vJM7/DrEPzyXcxbGQgN7ddMNp+cf70x/AtL+vNL2vxF5n7P0E0/Bebqd Hgr7S1XozYooH0SJ7yitG/ioZPhVRsBz6hc3Tr8m7nZUezzaLfyOma7CfAiV0UDv Q5kHLVAC/go4p20nuvqQg== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefvddrtddtgddvheeigeegucetufdoteggodetrf dotffvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdggtfgfnhhsuhgsshgtrhhisggv pdfurfetoffkrfgpnffqhgenuceurghilhhouhhtmecufedttdenucesvcftvggtihhpih gvnhhtshculddquddttddmnecujfgurhepkfffgggfuffvvehfhfgjtgfgsehtjeertddt vdejnecuhfhrohhmpefusghosgcuoehssghosgesqhhurggurhgrthhumhdqsghrrggttg grshdrtghomheqnecuggftrfgrthhtvghrnhepjeffuedtudegteelgeefleetkefguefh tddvteekgfdvgeefleekjeeguedthefhnecuvehluhhsthgvrhfuihiivgeptdenucfrrg hrrghmpehmrghilhhfrhhomhepshgsohgssehquhgrughrrghtuhhmqdgsrhgrtggtrghs rdgtohhmpdhnsggprhgtphhtthhopeegpdhmohguvgepshhmthhpohhuthdprhgtphhtth hopehtghhlsehsshhsrdhpghhhrdhprgdruhhspdhrtghpthhtoheplhgruhhrvghniidr rghlsggvsegthigsvghrthgvtgdrrghtpdhrtghpthhtohepphhgshhqlhdqrggumhhinh eslhhishhtshdrphhoshhtghhrvghsqhhlrdhorhhgpdhrtghpthhtohepshgsohgssehq uhgrughrrghtuhhmqdgsrhgrtggtrghsrdgtohhm X-ME-Proxy: Feedback-ID: i374947ac:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Sat, 26 Apr 2025 18:49:51 -0400 (EDT) Message-ID: <6835b152-5b12-489b-96f0-5c156c444da1@quadratum-braccas.com> Date: Sat, 26 Apr 2025 16:49:50 -0600 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Intermittent missing chunk ERRORS To: Tom Lane , Laurenz Albe Cc: pgsql-admin@lists.postgresql.org References: <870ee861-8c1c-4979-846a-e9e507ca60f2@quadratum-braccas.com> <106241.1745699322@sss.pgh.pa.us> Content-Language: en-US From: Sbob In-Reply-To: <106241.1745699322@sss.pgh.pa.us> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 4/26/25 2:28 PM, Tom Lane wrote: > Laurenz Albe writes: >> On Sat, 2025-04-26 at 11:09 -0600, Sbob wrote: >>> SQL Error [XX001]: ERROR: missing chunk number 0 for toast value 44915477 in pg_toast_5321896 >>> Has anyone seen this type of intermittent index error before? and thoughts on where to >>> look /how to debug this? >> The error is data corruption. > We've seen transient errors of this sort arise from what are basically > timing problems, and fixed at least a few cases. I wonder exactly > which PG version the problematic installation is running. > > regards, tom lane We are on V14