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.96) (envelope-from ) id 1wTEpl-000P1S-20 for pgsql-hackers@arkaria.postgresql.org; Sat, 30 May 2026 08:14:18 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wTEpk-005l08-0T for pgsql-hackers@arkaria.postgresql.org; Sat, 30 May 2026 08:14:16 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wTEpj-005l00-1z for pgsql-hackers@lists.postgresql.org; Sat, 30 May 2026 08:14:16 +0000 Received: from mail-japaneastazon11010068.outbound.protection.outlook.com ([52.101.229.68] helo=TY3P286CU002.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wTEph-00000000FHR-1w1f for pgsql-hackers@lists.postgresql.org; Sat, 30 May 2026 08:14:15 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=gcwLXSlZvm3amAGfzz8peYSyXG+tJCa8w1gP9VXpVvy18zcy6+Mj5vAbuDzCFkahI7E46/IQfLAdscizbUPTng6CH9sYzSnWm1YCajyImIeYFfy1Th9PHUoreMZZMONIEFw0svECFURUceonPUJT+bsaOAB/Zu681pr0s981EhXBUzPfF9XYGTw8DEiXB/cHACQU9ArThlyBzPOmOUM36q6i4c+TwzpF8UALiR9gkK5eXZfW9V7DJEFdFDxzxoJFDAUD++YNm1v6tyKat6+GCNVAPK95xmb8sl+ZJmSmSbjPdpig56q6FZP/zTuU0c2IJ2JSrOglYar7nK1AB1KJyA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector10001; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=ZEIsHfjH+y1ZihdNdcYZMKE/sVIyc2JrG55R1xsyFSI=; b=AlJHfb6p2fhvSEkNFkwV/0JLCxsZCBRG423SJuVSabEeAymqub/rC/CLmu3F2AaZ1dh2QN0chdWPbebUDs7NCHRrTRRbdEkFPYzXEk6hM0KocTIwwlpNtXuKO3LLopm/0geyiOec+kwygtBTCatbY5g961CMPQsRPgLLHDk1dEraD53YgkL5PVeWcLbgGbHnA15m2Em1Y+Mu6ZN4Xbgy241xWF0i7ADoE2xrVIqWE0IcMwXw0arq2eg3lat0XM9MD+eblYEDTQc+z2jnccSmK7k4qMtyZr2jMxi2pbzBN2r4qH7NOCqPAYjB1GqDlrvnjeOgBUgCdV9Q9BpWWzs2ZQ== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=fujitsu.com; dmarc=pass action=none header.from=fujitsu.com; dkim=pass header.d=fujitsu.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=fujitsu.com; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=ZEIsHfjH+y1ZihdNdcYZMKE/sVIyc2JrG55R1xsyFSI=; b=V7aa/Mfs1Ic13HvPIJ9Qeni2dIZGX6WTPuCwlXRfqOs62MPapzSpKBg6ISrg9MbDG5gUlOjl+Wi8xDwIreFPKi4WP6QGo8eTK6VE884eaHRHuTHFoUUa6YuhaMEH5el0IV4GgGM1VJVf3BwOdNUSlCunMEdbQrkay9UOfJk8FIk/Fbr9ZO4KNmUBN1QASaNDpMmgUQqwCemYqH+mS62uMEHl6QgA+lATW5KX/jXLy3L/vnraoqJPRBtjO5dQ3pD7ARdh0EzZay18iwfTx14ZegfVqfvpKuIv+fnmOruSZN8yCzC5hudrfIqvGe8T+kt92Z/s11jLolh52aJF0Q0TVQ== Received: from TY4PR01MB17718.jpnprd01.prod.outlook.com (2603:1096:405:38a::22) by OSOPR01MB18042.jpnprd01.prod.outlook.com (2603:1096:604:476::20) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.21.71.16; Sat, 30 May 2026 08:14:08 +0000 Received: from TY4PR01MB17718.jpnprd01.prod.outlook.com ([fe80::7430:f96b:750d:8a04]) by TY4PR01MB17718.jpnprd01.prod.outlook.com ([fe80::7430:f96b:750d:8a04%5]) with mapi id 15.21.0048.013; Sat, 30 May 2026 08:14:08 +0000 From: "Zhijie Hou (Fujitsu)" To: Srinath Reddy Sadipiralla CC: PostgreSQL Hackers Subject: RE: Fix race in ReplicationSlotRelease for ephemeral slots Thread-Topic: Fix race in ReplicationSlotRelease for ephemeral slots Thread-Index: Adztxq7jT1CuwZjqTjO1S2+BFTl8LgBw7CMAACBC04A= Date: Sat, 30 May 2026 08:14:08 +0000 Message-ID: References: In-Reply-To: Accept-Language: en-AS, ja-JP, en-US Content-Language: zh-CN X-MS-Has-Attach: X-MS-TNEF-Correlator: msip_labels: =?utf-8?B?TVNJUF9MYWJlbF9hNzI5NWNjMS1kMjc5LTQyYWMtYWI0ZC0zYjBmNGZlY2Uw?= =?utf-8?B?NTBfQWN0aW9uSWQ9MzZiNDEyM2MtZDI3Mi00Nzc1LWFkZDAtYzQ1MTBjZGVk?= =?utf-8?B?Y2EzO01TSVBfTGFiZWxfYTcyOTVjYzEtZDI3OS00MmFjLWFiNGQtM2IwZjRm?= =?utf-8?B?ZWNlMDUwX0NvbnRlbnRCaXRzPTA7TVNJUF9MYWJlbF9hNzI5NWNjMS1kMjc5?= =?utf-8?B?LTQyYWMtYWI0ZC0zYjBmNGZlY2UwNTBfRW5hYmxlZD10cnVlO01TSVBfTGFi?= =?utf-8?B?ZWxfYTcyOTVjYzEtZDI3OS00MmFjLWFiNGQtM2IwZjRmZWNlMDUwX01ldGhv?= =?utf-8?B?ZD1TdGFuZGFyZDtNU0lQX0xhYmVsX2E3Mjk1Y2MxLWQyNzktNDJhYy1hYjRk?= =?utf-8?B?LTNiMGY0ZmVjZTA1MF9OYW1lPUZVSklUU1UtUkVTVFJJQ1RFROKAiztNU0lQ?= =?utf-8?B?X0xhYmVsX2E3Mjk1Y2MxLWQyNzktNDJhYy1hYjRkLTNiMGY0ZmVjZTA1MF9T?= =?utf-8?B?ZXREYXRlPTIwMjYtMDUtMzBUMDg6MDc6NTRaO01TSVBfTGFiZWxfYTcyOTVj?= =?utf-8?B?YzEtZDI3OS00MmFjLWFiNGQtM2IwZjRmZWNlMDUwX1NpdGVJZD1hMTlmMTIx?= =?utf-8?B?ZC04MWUxLTQ4NTgtYTlkOC03MzZlMjY3ZmQ0Yzc7TVNJUF9MYWJlbF9hNzI5?= =?utf-8?B?NWNjMS1kMjc5LTQyYWMtYWI0ZC0zYjBmNGZlY2UwNTBfVGFnPTEwLCAzLCAw?= =?utf-8?Q?,_1;?= authentication-results: dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=fujitsu.com; x-ms-publictraffictype: Email x-ms-traffictypediagnostic: TY4PR01MB17718:EE_|OSOPR01MB18042:EE_ x-ms-office365-filtering-correlation-id: b024c0a2-1815-4e6c-2bd2-08debe236c40 x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0;ARA:13230040|366016|376014|1800799024|56012099006|4143699003|22082099003|18002099003|11063799006|5023799004|1580799027|38070700021; x-microsoft-antispam-message-info: xqI8yxDKHSI6RgUkCuBbK/lJy/CPW+Pypf/FtGOIfiGsFZaH4wrYuZFvHFcXDD8KPfCC19gdqYnKzB03ZJ+5JmEDuD3SgpxMHk4Hz2Idmm8iFrWkkPoqSFpb95ZLgmF0pkAuJnu5tmZrNQnyLqrccOhiO+E/9rObBzRp+yEI8oeW47C1Cze57LEZu8p64uOXOVhHqBzr8bPkZIPGx2T8yYZ4fCg3IOejMZ/nKqfMKAIuZHaa9l17+tqR6WAL9MjtFSKAL8sWyKMD1czeNJX0ldOtqrBFpk7PAqWNtuRXdxL+1X0xdxHxY4NrHQ5xYpoewtCPgUaFZrWtnUEhffzOT+5SAZyclJcB5b8ywnP3DBe3mbZNFVWmFUJTr+TKOWAisqAiEAubR392M7Zd/IZEbTeEEsEvF9T8A2WufP8Ia+p7NDyQ3SCC7n5dihhlB35iZSXi6tNVwmZhutpH1DIscpsgKHaHQw0Z34qhk/b0e9ChEhkeM2G8a4hRCMLDM6SOE+DZXtmREezRIFRygp5yMbLSTWeHptblPEHG1DMLIA1jZY6MY6VhUgm1DqChOP3c4y/npV+XO2l6AWxVjgU2mkYZ6pefR5Gj76MiQyKDA1lWfhwQR41UOJVsLdzXHSBhtHU+dyyVEzb8az3lNXR5IV5sPf8iSvR5R7ZNHjH9RfLdb6HsG1y75rbE5wCVAYduRVM2VBhLd6XW4E0HJBigGfRqnt58RZYowwmcBNFjZ22k026jmxPv5k+E5ALAEXMOTbJ6KuMwK7aFfvpNilp0JA== x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:zh-cn;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:TY4PR01MB17718.jpnprd01.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230040)(366016)(376014)(1800799024)(56012099006)(4143699003)(22082099003)(18002099003)(11063799006)(5023799004)(1580799027)(38070700021);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?utf-8?B?VFJrdXJvbkc0ckE1TENaTjVXdHhxMjg4dml1TTc1RkF3bWFieGl0dlpkYmRU?= =?utf-8?B?ZEJXc2VGRzRQemFEbUc1T01Ja1NwK0FtUmFrZHVKS2w4TWRjRWgvRDZUUm5Z?= =?utf-8?B?MXF5TnptRTFhc29BYllDTVJHeWpzUkJnK1FMZUdQL3UrUkxtdlBiMGNrSFI2?= =?utf-8?B?SmEwME5EeHdOeXp2MWJsdFZpZzRpRDZmM2lPTm9zdGd4OFZ1VldreDhPSG1R?= =?utf-8?B?QnV0ZXVyeTU1VTk4SDEreTkyOXB6Sm12Ymh6eWxCcTFXNFRmdVM2b1hGQlNZ?= =?utf-8?B?VjhvdEF4RFZ4Qmx0NmU1czVmTGVBakdxaE54SjVuSnZZcmN5RnZBcUdjRU9z?= =?utf-8?B?dVpVZU95K2tWcjlGQ0wzYWR0TENycjFFenNLajlUUTlxc3M0bnNIUEZSZllR?= =?utf-8?B?MW04SzRoMXZpazVyUVFwVjJidHFmbVZ1RFByVi9taFBETUMxOWE0bnBWblRo?= =?utf-8?B?VDNFK0JEYW9HTHgra0w4eTdZanVkTUk2NlBRZ0FDQlJrcStNUDIvZXFGaElh?= =?utf-8?B?djV2L2xDMEU3QWFJMVZIMm9zQndoelM4a09SNFdDRE1aSmw0Y3B1ejNSZlZr?= =?utf-8?B?MWcrTTFNcUlqbHVxL3hKVjJZTFMveFYySlR5bGlkeVhlZzRyNmNuTDlPcEcz?= =?utf-8?B?NmdMNDNLNGpvOHlOdHBBdnlYM2xqd3hFRHJTTGhkQmg1YXQvVS9CclpoalQ4?= =?utf-8?B?NDZCNFphV3FiU2lYVkw0aFVmZ3hrVW8rMEZabmNUdjFaUGdRd0x3bXBQdnVY?= =?utf-8?B?QnpFclQrc3RlZThwdFQ3amJ1eVdLZS9QMUJIUlJsVmFKYWlwdXNMSktjMUZr?= =?utf-8?B?bTM4ME1BNTRQd2JaTGs3ZE04OTdENXIvTEhMaDdseUowVm52TDdYVnVjdTh5?= =?utf-8?B?VXllNStUMFJHdjRDN1lpWTZUTGF2V1ltU01iMCtRUWF2WmZEdEhGOXo1T0hl?= =?utf-8?B?dWV4WWU0eDBnU3lmYnJaNWV4T0wvY0M5OG54V2VVemIxS1FaZGgrZzdHaFZy?= =?utf-8?B?WnJXanc0b2xoTGFWVHNTWCtCa0VjVUZhd1Q1eHJ0S2F0V3Npck9neEllWG51?= =?utf-8?B?THBiaHNnU1ZEMzRQUW5VZ3Ryd2JoWnJrdmVRdzIvZ0VaUi9scTk0eXQ1b1Fi?= =?utf-8?B?dFhzVWZIMm5NWk1zOTR0Mk5YRjBIanRoNW9XUWNHVWd4Y3VMNFlSbkhIdTdJ?= =?utf-8?B?N294WVdnckFhVktRTDFHd1QrRndlR09mQW1Ld1B6UkE4RHNaVHBFeFhHdVd1?= =?utf-8?B?SHFjYktEZFErenEybzB2ZDcvVWM1amdKd3dMbjlGSHFsL2w0WEZJVWh6UXBN?= =?utf-8?B?RVZHWThkMmJPNzdSdEEwbkc1ZEhseVVneUZTUytxVkc4SEpTQ0w0UkVqQm00?= =?utf-8?B?TEhYS0hVYTdtak5TLzhvOWo0Q3hBNjd5YU1SL3NIaCtuRjhEM3hhc2doVG00?= =?utf-8?B?bFpYRG9PMGNoN2VjZ09ZalluVmJKSGlXWlRUZzl0SHJKbEFhQmxxUkJDaDBy?= =?utf-8?B?bjZ0TjJjSUdMNlJld0VtTGpuNUh5T1dHV0ZlcVM5UVNMRmFqQVZpSDRGZkdk?= =?utf-8?B?SlZjVHB1eTY5TUdvYnY1a1BlKzNmWW1RY2Z4L090RTNmYUwwdTZDTUZDWFpu?= =?utf-8?B?WktPcHBjd2wvdHBleVJMbEJ5aW84SUl4ZDRsUi9DWHJSMTd4bENQUlRkRlZl?= =?utf-8?B?ZUgvMjgvTFNYVy9QYTI0ZFNIb1h3ak16V2haRytLN1VZMlBBdnI2cXFCcmFQ?= =?utf-8?B?TEhocG50cVFpcWJDVVdLbXEzNi9yMEw3cGpqc0VpRm0vUTg5WEVKbkk2YXhM?= =?utf-8?B?NEttZElzcjFwbzdvc1ZKQU1GUVVab2dlaXdrTkNyaStySWxmb08vWVhIWVdV?= =?utf-8?B?a29yK3Y0K05EbHNZVnpaMEcraUJFa3Y1SWZHWS90YVJUNWxpS0loWDZJWWRN?= =?utf-8?B?V3kvdFVWSUhyY2JBaVl0MlBZMnp2UUFqVko1WW9lQUZ5Sk82TmFTOUFhNEtp?= =?utf-8?B?VHhHUWlmaW9DQ24vR1VSVmloVzdJVzMvSWdQNWQ2NERzVHhIelFScHhQL2xU?= =?utf-8?B?ZmdYaVdCZ2IvQkMrS1dTNDhuMVo4dGlGM2VrOHcyZjYvMWd0T1RKbEVKZit1?= =?utf-8?B?VHpWUkY1RWhEeU1nSzY0TjdMb1FjNTlsbDN5cmMvb2RaNFNjczd2RW5aTFpF?= =?utf-8?B?ZUJTQ084QnljZ05zL0FNL3N6WEx2QmQ3YW5SZEhkQmQ0S2xZOGRFYjZYNWJ2?= =?utf-8?B?NGxFVXV2QUJqNkVrRXp1NGU1cFZnUFhORERGRUpJdDRLazJuelRta0tUSytJ?= =?utf-8?B?WkdZMHlmZlVtMTdYWXlFUjVRelpCQ1BFbzhSY0lIaHFJWDlLa3U0QT09?= Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-Exchange-RoutingPolicyChecked: YvYtcvzBqi3L2WP1RZepxwO9G7fbvCOZJSufw+u997py/TFE7brUVYuBFrnzJIf5V40xTGeGqu/ohAfewULiuCDynCjyoL+yKh/FzCdIF/K5gZDAXA1KtshICGqkcyD5CklpDZMWb4rkuRzbG500lEeYEILy03Xoh1/1gNbA1MBAS5qSHWa3sHLJltfezwy1txzLpgmx5qM4cvdcgPp7ycxrX7+9QfjlqZrFecVI9dpx2TSVkFuauNRTbq+ju1hY+/Yybuv8MpLa5QDOsMY42ClFEVtOjGYtt5/2KPvJ7BkcdXgHFTYyygKWtskMIO+8vmukjUtvUMGVghDMiwjE2Q== X-OriginatorOrg: fujitsu.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: TY4PR01MB17718.jpnprd01.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: b024c0a2-1815-4e6c-2bd2-08debe236c40 X-MS-Exchange-CrossTenant-originalarrivaltime: 30 May 2026 08:14:08.2358 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: a19f121d-81e1-4858-a9d8-736e267fd4c7 X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: 859aJlYEFLJkq3bqQnOZkSxXrrFCJYwbBXnpSqLJZO0JI5YaU+Rh+TIArioSoGvnMJ5QE4ixf+9yl8/6KyFp9A== X-MS-Exchange-Transport-CrossTenantHeadersStamped: OSOPR01MB18042 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk T24gU2F0dXJkYXksIE1heSAzMCwgMjAyNiAxOjQ0IEFNIFNyaW5hdGggUmVkZHkgU2FkaXBpcmFs bGEgPHNyaW5hdGgyMTMzQGdtYWlsLmNvbT4gIHdyb3RlOg0KDQo+ID4gT24gV2VkLCBNYXkgMjcs IDIwMjYgYXQgNToyMOKAr1BNIFpoaWppZSBIb3UgKEZ1aml0c3UpIDxtYWlsdG86aG91emouZm5z dEBmdWppdHN1LmNvbT4gd3JvdGU6DQo+ID4gSSBoYXZlbid0IGF0dGFjaGVkIGEgdGVzdCBmb3Ig dGhpcyBmaXgsIGFzIHRoZSBjaGFuZ2UgaXMgc3RyYWlnaHRmb3J3YXJkIGFuZCB0aGUNCj4gPiBM aWtlbGlob29kIG9mIGVuY291bnRlcmluZyB0aGlzIGJ1ZyBpcyBsb3csIHNvIGl0IG1heSBub3Qg YmUgd29ydGggYWRkaW5nIHRlc3QNCj4gPiBjeWNsZXMgZm9yIGl0LiBIb3dldmVyLCBpZiBvdGhl cnMgZmVlbCBkaWZmZXJlbnRseSwgSSdtIE9LIHRvIGFkZCBvbmUuDQo+DQo+ICsxIGZvciBhIHRl c3QuIFRoZSBmaXggaXMganVzdCBhbiBlbHNlLCBzbyBhIGZ1dHVyZSByZWZhY3RvciBjb3VsZCBj aGFuZ2UgaXQgYW5kIHNpbGVudGx5DQo+IHJlaW50cm9kdWNlIHRoZSBjb3JydXB0aW9uLCBzaW5j ZSBpdCBzY3JpYmJsZXMgb24gYW4gdW5yZWxhdGVkIHJldXNlZCBzbG90LCBub3RoaW5nDQo+IHdv dWxkIGNhdGNoIGl0LiBJbmplY3Rpb24gcG9pbnRzIG1ha2UgaXQgZGV0ZXJtaW5pc3RpYzsgSSd2 ZSBhdHRhY2hlZCBhIGRpZmYgcGF0Y2ggdGhhdCBhZGRzDQo+IGEgdGVzdCB0aGF0IGZhaWxzIHdp dGhvdXQgdGhlIGZpeCBhbmQgcGFzc2VzIHdpdGggaXQuDQoNClRoYW5rcyBmb3IgdGhlIHRlc3Qu DQoNCkknbSBub3Qgc3VyZSBpZiBhZGRpbmcgYW4gaW5qZWN0aW9uIHBvaW50IGZvciB0aGlzIHJh cmUgY2FzZSBpcyB3b3J0aHdoaWxlLiBFdmVuDQppZiB3ZSB3ZXJlIHRvIGFkZCBvbmUsIGZ1dHVy ZSByZWZhY3RvcmluZyBvZiB0aGF0IGZ1bmN0aW9uIGNvdWxkIHNoaWZ0IHRoZQ0KcG9zaXRpb24g b2YgdGhlIGluamVjdGlvbiBwb2ludCwgc28gaXRzIGxvbmctdGVybSB1c2VmdWxuZXNzIGlzIHVu Y2VydGFpbi4gSQ0KZG9uJ3QgaGF2ZSBhIHN0cm9uZyBvcGluaW9uIG9uIHRoaXMsIHNvIEknbGwg bGVhdmUgaXQgdG8gRnVqaWktU2FuIHRvIGRlY2lkZS4NCg0KQmVzdCBSZWdhcmRzLA0KSG91IHpq DQoNCg0K