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 1uzz5y-009Ej2-Qy for pgsql-general@arkaria.postgresql.org; Sat, 20 Sep 2025 15:01:50 +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 1uzz4x-00DE1j-MT for pgsql-general@arkaria.postgresql.org; Sat, 20 Sep 2025 15:00:47 +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 1uzz4w-00DE1a-IC for pgsql-general@lists.postgresql.org; Sat, 20 Sep 2025 15:00:47 +0000 Received: from fhigh-a4-smtp.messagingengine.com ([103.168.172.155]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1uzz4q-001soL-2b for pgsql-general@lists.postgresql.org; Sat, 20 Sep 2025 15:00:45 +0000 Received: from phl-compute-12.internal (phl-compute-12.internal [10.202.2.52]) by mailfhigh.phl.internal (Postfix) with ESMTP id 20FC514000BF; Sat, 20 Sep 2025 11:00:39 -0400 (EDT) Received: from phl-mailfrontend-01 ([10.202.2.162]) by phl-compute-12.internal (MEProxy); Sat, 20 Sep 2025 11:00:39 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= 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=fm3; t=1758380439; x=1758466839; bh=0Y6+Cc4MxN8oxFALR2S6ZY76Q1HovoRQYckogxOcSAI=; b= ZYoVXQTc+fStA68EKn6s2XWu614gaYCrh+XyhatreZFDbhVsrIZc099rhrqrTnM7 Lj3tSDkxcQxCC1mEoK2gwd6RZSQ+zYxhnRrMzq3ta4AxG8Z8D3olZhxMZx7Am/wA FaXG9/fSv56D4Jqp1dTfaCAVX0EvTdbqKZoL0N6sRIlp7P/sw7icPDMJuqzJhiRL RHAg9yTswu4dxK5+fcvFeahkPq+wXBkY9OkfLOk5z4gTRORtAD6aAAcFq0B7YH1r n3EyfvjlIuCl/WS/9vUBRuTLqJFIXZprEdimrHInookNoG6yaAxenD6MAfUQ9pvf t/GvxbVUD0FHw9J9mMRXFg== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=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=fm1; t=1758380439; x=1758466839; bh=0 Y6+Cc4MxN8oxFALR2S6ZY76Q1HovoRQYckogxOcSAI=; b=TQwTayi0Q2iuCxEUV /JAkdv20MaMAiRioB/RRQOYW7rxmpWQintUxHb1x2otDUI2WfgXXj8oPO9RvtmTC qi/hwwz3nW8Rqt6svN6/KKuIX7LVd0RE1zJ17K16R0btsuq7Rt2rhgYdKR7feY2p seaAvHr9whiPssImFMLyPNApPzUdHSMs9vP0JxicCQLHmDPbrg90Md0HZf2WxXJX X5RdA4eCiZWfP6AgF7JapJtSayH/FfZT/wxSmHGHEJmk3ZiMFk654wULEzfqCz/x Xd7HmkKBoFBk4ISYh85pssaBpNMrAVtpjxMaW36rFMyqrXxCSOsyWZLRX0Ccdgrd nEiWw== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeffedrtdeggdehvdegtdcutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpuffrtefokffrpgfnqfghnecuuegr ihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenucfjug hrpefkffggfgfuvfhfhfgjtgfgsehtkeertddtvdejnecuhfhrohhmpeetughrihgrnhcu mfhlrghvvghruceorggurhhirghnrdhklhgrvhgvrhesrghklhgrvhgvrhdrtghomheqne cuggftrfgrthhtvghrnhepiefhgeevleeggeefgfeujeehgeejfeduvedvfeejuddvtdeu feejgfdtteekjefgnecuffhomhgrihhnpehksggtrdgtohhmnecuvehluhhsthgvrhfuih iivgeptdenucfrrghrrghmpehmrghilhhfrhhomheprggurhhirghnrdhklhgrvhgvrhes rghklhgrvhgvrhdrtghomhdpnhgspghrtghpthhtohepfedpmhhouggvpehsmhhtphhouh htpdhrtghpthhtohepfihimhdrrhhouhhquhgrrhhtsehksggtrdgsvgdprhgtphhtthho pehrohhnlhhjohhhnhhsohhnjhhrsehgmhgrihhlrdgtohhmpdhrtghpthhtohepphhgsh hqlhdqghgvnhgvrhgrlheslhhishhtshdrphhoshhtghhrvghsqhhlrdhorhhg X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Sat, 20 Sep 2025 11:00:38 -0400 (EDT) Message-ID: Date: Sat, 20 Sep 2025 08:00:37 -0700 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Index (primary key) corrupt? To: Wim Rouquart , Ron Johnson , "pgsql-general@lists.postgresql.org" References: Content-Language: en-US From: Adrian Klaver In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 9/19/25 02:29, Wim Rouquart wrote: > Internal > >>> Does this problem keep happening, or has it only happened once? > > It is consistent on this database/index, haven’t noticed it anywhere > else yet luckily. Seems to be a one-off. The above is not clear to me. One-off as for this database/index only and repeatable across dumps or that it only happen in one dump. > This concerns a PostgreSQL version 15 btw. > >>> Are you at the current patch level? > > Yes. Please specify the actual version, current is a relative term. It matters for folks using this thread for researching an issue in the future. > > > Disclaimer -- Adrian Klaver adrian.klaver@aklaver.com