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 1nrXqO-00079M-42 for pgsql-bugs@arkaria.postgresql.org; Thu, 19 May 2022 04:33:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nrXqN-00033y-1W for pgsql-bugs@arkaria.postgresql.org; Thu, 19 May 2022 04:32:59 +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 1nrXqL-00031i-Bq for pgsql-bugs@lists.postgresql.org; Thu, 19 May 2022 04:32:58 +0000 Received: from out2-smtp.messagingengine.com ([66.111.4.26]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nrXqH-00048m-JT for pgsql-bugs@lists.postgresql.org; Thu, 19 May 2022 04:32:56 +0000 Received: from compute3.internal (compute3.nyi.internal [10.202.2.43]) by mailout.nyi.internal (Postfix) with ESMTP id 770085C0054; Thu, 19 May 2022 00:32:52 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute3.internal (MEProxy); Thu, 19 May 2022 00:32:52 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:cc:content-type:date:date:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:sender:subject :subject:to:to; s=fm1; t=1652934772; x=1653021172; bh=R9NVcJocHK vK+oWJLDMw8exwz8PbLak4m5VAeRF9CuU=; b=jkp7XXNpJQ0O0v7AUHzHpoV1WV dXedjtsaBhw9LRtLZVe3U2MECgjL500kwe+P9ti4qR734pT7kTwlTmpnlcixo4dT 4VKKPNKoikSN1Q7K7RYY54eot6uPt/xGlCEcpdIjmrYEXrPSnlv5Av9pRxvCpiGs q7VGelQ1MWd5RpGiwvKh6JvUoJKcJdkDSiZWn6jFp3HYAC+VRB9uKYloS9fcO73t E+TQcpOWmSF709CCgOIrmkoN/nl/yeCvDOFOJz5NXdhw+20c8PZKNkKcQ3T99d6h rQ9U0+GikUyXJ+2zPVqVPoKvp5LBzwSP04soEtXyIcv27LmZvGnllRHEAUTA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:date:date:feedback-id :feedback-id:from:from:in-reply-to:in-reply-to:message-id :mime-version:references:reply-to:sender:subject:subject:to:to :x-me-proxy:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s= fm1; t=1652934772; x=1653021172; bh=R9NVcJocHKvK+oWJLDMw8exwz8Pb Lak4m5VAeRF9CuU=; b=Kudly8o4rEM2xKaVN1UaaTpQCxisl6iI8XlkVdDnC1Dr E+cSusaCnU7oYmxrbMhm6G9oVOYFBIDl5UeefXkQsUQD7UToq4pWX7awiLkLDyo9 NuuKjK0fXP6ApGwt1sINbiThnpAC4nmbwU3qZG3ewBDucudMHDR8QC1sRw1Xcq6W lQQ8hdbvwRwMjBmKwsd/9CwdgiOuZL44NlEj584pqYRXdNz9AIvnmrKkKrRL/SDp uthozkwF2mN/D1VvLSKLCSP6tR/DtE6t45Ge3aiLM6tcXJxIi/DYwZx80UNICLe9 rzkUc9osrkDYf4vLyGu3WUQOKhGYhIWaS6sDD/3GAA== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvfedriedtgdekhecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecufghrlhcuvffnffculdejtddmnecujfgurhepfffhvf evuffkfhggtggujgesghdtreertddtvdenucfhrhhomhepofhitghhrggvlhcurfgrqhhu ihgvrhcuoehmihgthhgrvghlsehprghquhhivghrrdighiiiqeenucggtffrrghtthgvrh hnpeetleeifedufffhhfdtteelgeeggeffhfekueevteeigfduudevudetgfegiedvjeen ucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpehmihgthh grvghlsehprghquhhivghrrdighiii X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Thu, 19 May 2022 00:32:50 -0400 (EDT) Date: Thu, 19 May 2022 13:32:46 +0900 From: Michael Paquier To: Andrey Borodin Cc: pet.slavov@gmail.com, PostgreSQL mailing lists Subject: Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Message-ID: References: <17485-396609c6925b982d@postgresql.org> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="KMnH8b1vt4tW6Yyw" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --KMnH8b1vt4tW6Yyw Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Thu, May 19, 2022 at 09:22:44AM +0500, Andrey Borodin wrote: > Uhm, that's very...interesting. I'll look closely next week. Though I did= n't have a chance to reproduce yet. > We have fixed similar problem in 14.1. And now we have very similar > TAP test to you reproduction [0]. How do you think, what's the key > difference between TAP test and your repro?=20 Interesting, indeed. Another question I have: is this limited to v14 or are you able to see it in older versions? REINDEX CONCURRENTLY has been introduced in v12. -- Michael --KMnH8b1vt4tW6Yyw Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmKFyG4ACgkQnvQgOdby QH3jfA//Uqg9nSu9IRWU3DFB/vPhRyHJe0HHbnbnNtrxJqkyd84JB/agugTHvQbg sNMBGuryXxayT2ryqANIw4+J50T3BABM6QkbV9y5VqdVTRZxHj/dpCG6EXBnV0aC HzJjAnuhVOU9uSFNPx2IDI9CUcqUB4z8CzLjDzbfF+32tEtQ4MznDjyav/0F9LFv 71c5FRCyCCPRto0dSYiZY4PrCKAeTr0gHziWD2QexArItWAmKes8zT4/9hobWbey kO4V+QOBWoUKRful4sSh/x7az6j67IRh3mpeJv2gkf4qYge5t536P0KDH/KIXCQa inAM3gkJt0fUsL8QecFMMdt9geiBnlA+XnwXISWLZkeHxKKf4GtVbfMfkT2motnT jseNx+asl9vb7VuKW0TX2TKcZwbqsT3eyh+tM8f8HVWrUCTpZXS3nQd9ZleWoChC i/AkIQnj1I/AejTXEDs6zd7KmGr1mOSOWLhMP2T0rZYnz53qu2NQ6iaTOecrWSo5 5KvcK9zvG1pXMGXHwMe3aX9IfD7H7OQ4+/ox5tQ1j7hPDIDKutL9egxoq8sQ2DZN IbaO0CershC57iE5opq2elWEdQASrHns3e1aNCzPGdeecJk7XAdWxoB8ZyW96V9q zifRlD4MEfu4YKd7a03ytwx/aCqalgpUgONh8bAP5RjwH7aKoxM= =Qb7L -----END PGP SIGNATURE----- --KMnH8b1vt4tW6Yyw--