Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mevZv-00064w-3Q for pgsql-bugs@arkaria.postgresql.org; Mon, 25 Oct 2021 08:43:35 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mevZs-0004WZ-6x for pgsql-bugs@arkaria.postgresql.org; Mon, 25 Oct 2021 08:43:32 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mevZr-0004UM-VS for pgsql-bugs@lists.postgresql.org; Mon, 25 Oct 2021 08:43:31 +0000 Received: from lungold.riddles.org.uk ([82.68.208.19]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mevZl-0006JP-7W for pgsql-bugs@lists.postgresql.org; Mon, 25 Oct 2021 08:43:30 +0000 Received: from [192.168.127.1] (port=57666 helo=caithnard.riddles.org.uk) by lungold.riddles.org.uk with esmtp (Exim 4.92.3 (FreeBSD)) (envelope-from ) id 1mevZe-00055X-9D; Mon, 25 Oct 2021 08:43:18 +0000 Received: from localhost ([127.0.0.1]:50851 helo=caithnard.riddles.org.uk) by caithnard.riddles.org.uk with esmtp (Exim 4.93.0.4 (FreeBSD)) (envelope-from ) id 1mevZe-000NRa-4D; Mon, 25 Oct 2021 08:43:18 +0000 From: Andrew Gierth To: Alvaro Herrera Cc: Peter Geoghegan , PostgreSQL mailing lists , Thomas Munro , iijima.yun@koumakan.jp Subject: Re: BUG #17245: Index corruption involving deduplicated entries In-Reply-To: <202110250104.jve5vzdedck7@alvherre.pgsql> (Alvaro Herrera's message of "Sun, 24 Oct 2021 22:04:41 -0300") Message-ID: <87h7d57b3q.fsf@news-spur.riddles.org.uk> References: <202110250104.jve5vzdedck7@alvherre.pgsql> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/26.3 (berkeley-unix) Date: Mon, 25 Oct 2021 09:43:18 +0100 MIME-Version: 1.0 Content-Type: text/plain List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk >>>>> "Alvaro" == Alvaro Herrera writes: Alvaro> Do you happen to have WAL traffic for this table and index? Unfortunately there's no WAL archiving, and no available WAL files from before the state was known to be corrupt. We'll look into enabling archiving in case the problem recurs or can be reproduced. -- Andrew (irc:RhodiumToad)