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 1rhPMl-00BJF8-4k for pgsql-bugs@arkaria.postgresql.org; Tue, 05 Mar 2024 07:37:35 +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 1rhPMj-00EYT0-Ff for pgsql-bugs@arkaria.postgresql.org; Tue, 05 Mar 2024 07:37:33 +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 1rhPMj-00EYSs-7m for pgsql-bugs@lists.postgresql.org; Tue, 05 Mar 2024 07:37:33 +0000 Received: from fout8-smtp.messagingengine.com ([103.168.172.151]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rhPMg-002rDJ-Lq for pgsql-bugs@lists.postgresql.org; Tue, 05 Mar 2024 07:37:33 +0000 Received: from compute6.internal (compute6.nyi.internal [10.202.2.47]) by mailfout.nyi.internal (Postfix) with ESMTP id 0061B13800C2; Tue, 5 Mar 2024 02:37:29 -0500 (EST) Received: from mailfrontend1 ([10.202.2.162]) by compute6.internal (MEProxy); Tue, 05 Mar 2024 02:37:29 -0500 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 :reply-to:subject:subject:to:to:x-me-proxy:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm1; t=1709624248; x= 1709710648; bh=mRFt/fR7YZWWt1cHlOs9wnyqb5ccC/daIUZW4f8vj7U=; b=D zDD/oo9ZU0UtNscYc+bkTaovNV5l3DHFxUUb3QKy9UH4eJhpZNnzG+PDjH1bdZPQ Rv3h6GFBer9KdTbwGgbGKdjOB++QeCkZK5RKXmedFcl0JYOm09ax4IKykbvcbi06 I/ZtTRK+q9KKiRlvqigt8q7hv6NNbbLeBrLlXYuCVJpWuZpRYnMcApJcjUQaKNON 5yEDiUbQn33WG8Ywnwk/EDiRyIYcxFIuK6YGSZanDrkVPlJfCsOXnFXkOwrnlxEL 40BNq5pCd3rNGzYzEAOgxEwBlEmNijLHuUb7pT2TKw9yYTWLDlEV28KdtiQKKq8V WweXLSdMhm+SFKc5QiH4A== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvledrheekgddutdejucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepfffhvfevuffkgggtugfgjgesthekredttddtjeenucfhrhhomheprghlvhhh vghrrhgvuceorghlvhhhvghrrhgvsegrlhhvhhdrnhhoqdhiphdrohhrgheqnecuggftrf grthhtvghrnhepgeetgeelgeffteehfeejgeevfefgtdfhteffjefgffeihfeukeehffeg leekfeevnecuffhomhgrihhnpegvnhhtvghrphhrihhsvggusgdrtghomhenucevlhhush htvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpegrlhhvhhgvrhhrvges rghlvhhhrdhnohdqihhprdhorhhg X-ME-Proxy: Feedback-ID: ia2694551:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Tue, 5 Mar 2024 02:37:28 -0500 (EST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=alvh.no-ip.org; s=schmee; t=1709624247; bh=Wiw59s6/O/ttEcssaQT1NYpJPeCnheR23e6PODIoyl0=; h=Date:From:To:Cc:Subject:In-Reply-To:From; b=aZS/YOUvssijSNT/zwnQhMXj9lc9FMVnXfRXHi5yDu81opI1cXQUF1SsxPcAIRcpu 3L4KWG0Ok8V6NF3v5lyb5/M0yrqL3jN37t/iKucDwcPdA8blz4stOyP+lG1PZMvAjW Ko17JoKaSJmJOyiGO6NQtUs7B4VILnUhBTSZNhSfZIyX2c2+PL8lJQ94Xl9YfCOVak sSfgoEy1plWBvxAyivr7HiRcwP4AaVdKkXIsf+Mr8f0bPrBHwpZaM7eYgtibIPUL1L ZyrWKPSAE1Uy1x1Qije05ytvFRNe5+gLs0yoNNfN4UloWOE3NpSRY0ZlIQ2GWoeNTB yzjynPu4DEGYw== Received: by schmee.alvh.no-ip.org (Postfix, from userid 1000) id 0F1A3CD5; Tue, 5 Mar 2024 08:37:27 +0100 (CET) Date: Tue, 5 Mar 2024 08:37:27 +0100 From: alvherre To: Michael Paquier Cc: feichanghong , pgsql-bugs Subject: Re: BUG #18371: There are wrong constraint residues when detach hash partiton concurrently Message-ID: <202403050737.eik6gzyol3g5@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2024-Mar-05, Michael Paquier wrote: > This reproduces down to 14, for what I am assuming is an issue > introduced around 7b357cc6ae55. Alvaro, what do you think? Yeah, I have this on my list of things to fix this month. I haven't looked at it closely, but I will soon. -- Álvaro Herrera PostgreSQL Developer — https://www.EnterpriseDB.com/ "Los cuentos de hadas no dan al niño su primera idea sobre los monstruos. Lo que le dan es su primera idea de la posible derrota del monstruo." (G. K. Chesterton)