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 1sdZij-00GnNN-LP for pgsql-bugs@arkaria.postgresql.org; Mon, 12 Aug 2024 18:24:42 +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 1sdZih-00H6qN-Aa for pgsql-bugs@arkaria.postgresql.org; Mon, 12 Aug 2024 18:24:39 +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 1sdZif-00H6oR-R3 for pgsql-bugs@lists.postgresql.org; Mon, 12 Aug 2024 18:24:39 +0000 Received: from fout1-smtp.messagingengine.com ([103.168.172.144]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sdZib-004VVx-Mj for pgsql-bugs@lists.postgresql.org; Mon, 12 Aug 2024 18:24:36 +0000 Received: from phl-compute-05.internal (phl-compute-05.nyi.internal [10.202.2.45]) by mailfout.nyi.internal (Postfix) with ESMTP id F125C138FC80; Mon, 12 Aug 2024 14:24:30 -0400 (EDT) Received: from phl-mailfrontend-01 ([10.202.2.162]) by phl-compute-05.internal (MEProxy); Mon, 12 Aug 2024 14:24:30 -0400 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=fm3; t=1723487070; x= 1723573470; bh=gGlGhCz6WiD6Uf0qnbH0UJRTW8hPnh/blBc7U3CEYfg=; b=r z6wukBAZyWudXbU+YuN7J7Q/+dQ4iSzjsrpOpOQiSF67tBTp3YhqCHCg5xNNWgli 0wqSLl9Z6C318u18ZuhuDueIhaA54ZZLFK8r3rgyLPicw5kE37fhv/fPtRgZJqRQ 5uXW/i2wzT+v3DxV+UuEyhbxmNX3n9nnkiCfRlny0qBDaFBf9Rlw6WTBu6A1o4Ud JInOBS/GRC920hwKknbtHMzkHKKwrZQGYSJsPmeqqQqr/+S1vTkEpgRF9vsGNJpO gYYj0G3b2ucbFT4uDw3Sa1EuWgh77DnO4JeChPl0W/8xhF0g8ZDFk/NJlWMRGcl2 PtXujq7CsYxWQOyBCm0hg== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeftddruddttddguddvgecutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpggftfghnshhusghstghrihgsvgdp uffrtefokffrpgfnqfghnecuuegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivg hnthhsucdlqddutddtmdenucfjughrpeffhffvvefukfggtggugfgjsehmkeerredttdej necuhfhrohhmpeetlhhvrghrohcujfgvrhhrvghrrgcufhhrohhmucdvnhgusfhurggurh grnhhtuceorghlvhhhvghrrhgvsegrlhhvhhdrnhhoqdhiphdrohhrgheqnecuggftrfgr thhtvghrnhepudekteeugfetgeffjeefveekgfekjeffffejjeelvedugfffgfevgfdtff ekffdtnecuffhomhgrihhnpegvnhhtvghrphhrihhsvggusgdrtghomhenucevlhhushht vghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpegrlhhvhhgvrhhrvgesrg hlvhhhrdhnohdqihhprdhorhhgpdhnsggprhgtphhtthhopeegpdhmohguvgepshhmthhp ohhuthdprhgtphhtthhopehkuhhnthgrlhhghhhoshhhrddvtddtjeesghhmrghilhdrtg homhdprhgtphhtthhopehtnhgurhifrghnghesghhmrghilhdrtghomhdprhgtphhtthho peiihhhjfihpkhhusehgmhgrihhlrdgtohhmpdhrtghpthhtohepphhgshhqlhdqsghugh hssehlihhsthhsrdhpohhsthhgrhgvshhqlhdrohhrgh X-ME-Proxy: Feedback-ID: ia2694551:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon, 12 Aug 2024 14:24:30 -0400 (EDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=alvh.no-ip.org; s=schmee; t=1723487067; bh=9M3ytUPYhiI/hf+wFdLbKfzFldjLZjvAgyflRD4w5WM=; h=Date:From:To:Cc:Subject:In-Reply-To:From; b=fuRVkjS45Nmf25uVR/1Nvj+cOPswzMws7DspV+I9B/tqwz+HyLsTdI2FEN+fGrBUN hHLUflhjMEagKI5HgApDhjj678K0dcdCQOci3VKo42EaSjlWcNPqy1ciXvthOfIsuZ rAONGYuhkalynYpHsSHz9mzDSxk9T0gHCoOs0aAMh4UFR2usLlXDQRymkNPe5oiPAK kmwvYz26obLwVu4tz/LnwfB51nT0cBG8SLGrmA8gv5El0BpL+6KDsGD9n8rcnIiaRu 2rzAtm291u39dV8HtsQcBxAHZ9upaS57+EaimX5de05CgM3qCb18B9BxaLcVd554d3 0MKmPfCYpdWig== Received: by schmee.alvh.no-ip.org (Postfix, from userid 1000) id F25C733E; Mon, 12 Aug 2024 14:24:27 -0400 (-04) Date: Mon, 12 Aug 2024 14:24:27 -0400 From: Alvaro Herrera from 2ndQuadrant To: Junwang Zhao Cc: Kuntal Ghosh , Tender Wang , pgsql-bugs@lists.postgresql.org Subject: Re: BUG #18559: Crash after detaching a partition concurrently from another session Message-ID: <202408121824.gwvkmkugf6x7@alvherre.pgsql> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="kq4bryn2b3e5ezx3" 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 --kq4bryn2b3e5ezx3 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit On 2024-Aug-10, Junwang Zhao wrote: > > IIUC, a simple fix would be to retry if an entry is not found. Attached a patch. > > I can reproduce the issue, and the patch LGTM. Interesting issue, thanks for reporting and putting together a reproducer. I have added some comments to the proposed patch, so here's a v2 for it. I'm going to write a commit message for it and push to all branches since 14. -- Álvaro Herrera Breisgau, Deutschland — https://www.EnterpriseDB.com/ "La experiencia nos dice que el hombre peló millones de veces las patatas, pero era forzoso admitir la posibilidad de que en un caso entre millones, las patatas pelarían al hombre" (Ijon Tichy) --kq4bryn2b3e5ezx3 Content-Type: text/x-diff; charset=utf-8 Content-Disposition: attachment; filename="v2-0001-Fix-creation-of-partition-descriptor-during-concu.patch"