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 1wDdAi-003Bc8-2j for pgsql-hackers@arkaria.postgresql.org; Fri, 17 Apr 2026 06:59:25 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wDdAi-008bXF-04 for pgsql-hackers@arkaria.postgresql.org; Fri, 17 Apr 2026 06:59:24 +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 1wDdAh-008bX7-1e for pgsql-hackers@lists.postgresql.org; Fri, 17 Apr 2026 06:59:23 +0000 Received: from mail-japanwestazlp170110001.outbound.protection.outlook.com ([2a01:111:f403:c407::1] helo=OS0P286CU010.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 1wDdAf-00000001Qym-0QpZ for pgsql-hackers@lists.postgresql.org; Fri, 17 Apr 2026 06:59:22 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=BxP8V0Zq19rLSOM1rvSMCtPlH0aK7DS4z2lrSHA9sFORotLt2cf+TzEC3KMCNWPEmHNFGz7w9ELocZz6w2SW6LzNIND0P3sZpupzZhHtzJ05Ejo1Wd8NNuRtqD2G2ism1S+s/ZhUnu8l4Zm8jExSnMwZ7aokgeGfAN0zdj4yz/uuOTSwz99atydWRaST69abe2RzN2HUQFzTP7U4phHYSsdOGjZ2glQ7jPyZhej/2SVXLHEk6pKUKM1ru5GvlDfbbkP9plRu2KPP/7kJUk+2Ukr47nPbPIPSbxm3jhYm68kTIUF0qADjJXkhi0cX/rMhXaD/hsRlia+7aNzV4Pu3IA== 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=IhyX7SfbTY85qWu0MPUfovv4KsBVCI1OELNPHmNKdcU=; b=mKd6wc3U5oM/4weTHRlArRaMQmgbonmHRjwPvyv8S6eJflIzuVk+03P8/PwDJaaXJrjflKnU247iwHb718yOszFQQHBQDP6xATukR+heqOdVOqjlBmDGLK1413sUDUu8XDslEnOrEAStWXA0wB+lJjlJDOA9Vvb3BPPJcd+Gr9U+XIqGknLEhxsoARsktJgsvaF0OfIdHQdFQx5UTJOo5LE+2nIdkwbM+r1P++C8uMehJzisFyObUmTATyjfawIrOjjtj5g9iqH7UjMga3UGEgrZ3as4Zn2yRBI+UuzW68r9cmUQ/RAsA8Vpl5r+ZmQ7O6DsHFHgvo24BP50e9DKAQ== 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=IhyX7SfbTY85qWu0MPUfovv4KsBVCI1OELNPHmNKdcU=; b=FOHyVMnBo51MYSlK2/hKHHCA9G1JsJNa14azGf8iIm2HaAhLSJj2DX6YAXbLes/hxl/bINVdFLtU42p8BysWRQ0SJVUyAF0OiVmTFB0dBrv24L62ZYnODBz9Z0v4d6/oXQMfgOFMqph1RwUgjSK0d5li63i8ZIL9u7OHSZniEheHsCfridOZKl/c1ZgmQ6dOqUMDwHc559zhrGARKqzkGdmedXwXpjVsMe8G9v0JCmbAtMPSt/T22IkfH2Qs0cEsyYR3j81aXGj6vHL1ZlltxfamA6ApT+sPaDcBU0W4biX4dXBda837obWEn78TIS8LStZfDGRHNKh6wDWNF8WN1g== Received: from TYRPR01MB14195.jpnprd01.prod.outlook.com (2603:1096:405:222::11) by TYRPR01MB15468.jpnprd01.prod.outlook.com (2603:1096:405:285::13) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.9769.48; Fri, 17 Apr 2026 06:59:15 +0000 Received: from TYRPR01MB14195.jpnprd01.prod.outlook.com ([fe80::72da:8d94:e5fa:dc22]) by TYRPR01MB14195.jpnprd01.prod.outlook.com ([fe80::72da:8d94:e5fa:dc22%5]) with mapi id 15.20.9818.023; Fri, 17 Apr 2026 06:59:15 +0000 From: "Zhijie Hou (Fujitsu)" To: JoongHyuk Shin CC: "pgsql-hackers@lists.postgresql.org" Subject: RE: [PATCH] Fix TOCTOU race in ReplicationSlotsComputeRequiredLSN() Thread-Topic: [PATCH] Fix TOCTOU race in ReplicationSlotsComputeRequiredLSN() Thread-Index: AQHczjZ3/JmcnQFF7EKJ6bWnP93oTbXi0M/w Date: Fri, 17 Apr 2026 06:59:14 +0000 Message-ID: References: In-Reply-To: Accept-Language: en-AS, ja-JP, en-US Content-Language: ja-JP X-MS-Has-Attach: X-MS-TNEF-Correlator: msip_labels: =?utf-8?B?TVNJUF9MYWJlbF9hNzI5NWNjMS1kMjc5LTQyYWMtYWI0ZC0zYjBmNGZlY2Uw?= =?utf-8?B?NTBfQWN0aW9uSWQ9NTlhYmJhZjMtYmJlYy00NWVjLTg2NjMtZGRjNzdmZWUw?= =?utf-8?B?MTU3O01TSVBfTGFiZWxfYTcyOTVjYzEtZDI3OS00MmFjLWFiNGQtM2IwZjRm?= =?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?ZXREYXRlPTIwMjYtMDQtMTdUMDY6NTE6MjhaO01TSVBfTGFiZWxfYTcyOTVj?= =?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: TYRPR01MB14195:EE_|TYRPR01MB15468:EE_ x-ms-office365-filtering-correlation-id: 572837e3-4bba-4c98-1591-08de9c4ed65b x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0;ARA:13230040|376014|1800799024|366016|38070700021|56012099003|18002099003|22082099003|1580799027; x-microsoft-antispam-message-info: Tyq9OhrH5wPMP+enhZEkn4f44smnWYmtuACBDAaS1+fNt0mCMptjuRPCmW2j/t6RKGtSqx6esev6OcSKkZ0EEMpp6lfGoVHV5UrIe0o9H7RT3W+rGWtI0pG+kEsmG/glwcJ3R63ue1pHmRninmAyYGM7Y7oO/QGmc+ijLMgmV1nxt2GjmYIHr2QOIKnD8raKkv8JvW8LxjwmSgw0iITQBxjAdt1AuvMCjNtnZI9EZ52tU3+Mw4McDRw+jTf35dZwFPB8jg0QP4V4HwcNyXA48cLgae3V0ZKa8YDAQuXaKr0llMfjR5CELbrZ2XQGpWVBEBq3D1FRFmU1/KBhGA06/bNGyMAOtG2GiywCz6HSrzGGtler1+2Gzovibs0NTwlrpi/CoqkYsnPn8bHt1CRBdpDitFKIUnABlQJuCS4RT9dKy8Cdm6x8XPoFakSGjIEauEljv7ZpTLnAyMlNW4oDhPQZoGQUjg8BwSTMN0DFSlWHb2ASFu4mhdCyKsVW+8Y9aKJs5t3N4PuVflSoDMHWaOyiB2iKj2VHzteifj0bZcTvm/qCIzb2Id4Bb7Rw2prTc6a4L5KearU3slB0t3UlSrZjtgvJgnRKzKLqCnmBGU4Rvt7GBGhHbGmAIgR3k5mLeC7qfQcBHNRr9161HK6TGxOpWxISLUJLNKlyB283vYYu5+HkFyJlfdTAceXts2j6pDzuhOS5FfiWZVoSREEi0s15yAbqs5o4B4cNX9uPs+gNcZxMWPEb2Zg0BHsaTorw46wNlsx0Q2cUUhvgUFhK3MaDkcWOioTNNSuXR4d/QWKKCjmLHnJFUvd+Yc+IUtlLYJmpkKAA1nIftbTgR0I4lw== x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:ja;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:TYRPR01MB14195.jpnprd01.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230040)(376014)(1800799024)(366016)(38070700021)(56012099003)(18002099003)(22082099003)(1580799027);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?utf-8?B?YmhTYTRhSnpzT1F4M3RRNUJLdGVIdG9RcTdDV3BsTVJTZnh4VExRdHJqNTJM?= =?utf-8?B?dC9lUEVnajNieGtTY3k5NWJueXJiUHFXVXE1L2U3KzVTLzVRdW0ySU9WZ0lW?= =?utf-8?B?akpsckhXVDkrYnlPaGk0WXpNTXh0ZXdyMjFlR3Z0RFZlVmpOU2tyZkZRV1A0?= =?utf-8?B?cmw2aGdocDRncEYzR3BCRUFOS1V1d2gvaGtWTURra2l5UWQyVjZtb0s2Ulow?= =?utf-8?B?NzR6UkZGN2hMUnNpYmpDQ0dEeVhQdENpa1JyZTJkOGVnNGhmbjdxYlpmRW9G?= =?utf-8?B?VTBhUGo0T2Y2bHUrYlQ2Z2p4WHhwWnhFQmkrdFR5ZWVRNUkzSjh0OC8wTTNV?= =?utf-8?B?R3Yzb1VQREw3WjVtRkZHb09XekIyY3VMNDRVOTRFMXJUQU1lUnhPMEIwTSty?= =?utf-8?B?cXhUKy84b2pXZTZ6QlZmc3pUa0Exc3U3dER2a1FBamFQc2VhTzNTZ2RjL2Zt?= =?utf-8?B?TnhUbVhtbjNBeEFYbDB3V2I1VlU5U3RlMGMycU95d2M5eUFmdjRsU0tEVStD?= =?utf-8?B?dWtXL3d4T2FrK3RWcy9LTzVEeEZKSGV3Z1F2MXFiMU92WW5LQUd2MGV0N3h3?= =?utf-8?B?MnYzMU8ycTlXZlZSc2tPaHF4ZFAwUEJzdFhJaC9uNkVROTJHY3JCOVBjcUM0?= =?utf-8?B?bXIycDNacjR5QWs5WlRIMkJRT1BVaEFVKzF5blBJZ1U3SUR2bWM3ellyVUxh?= =?utf-8?B?ZTYwWnM2R29HS0tkdXk5aUF0blM0UXBOOXNhRk5KeW9yNFlSb28zNklZbEV1?= =?utf-8?B?YVlteTJSNTV0QWFzVmIzZm55RjZvdExoald1NUdWWmtsa1UvbWFyQmdVNk9T?= =?utf-8?B?cmZwK0hqMXdBM0czZ285dk5wZU9pNk8xZmE4NGJHMUxjVjJRYkdQZXBCcFFJ?= =?utf-8?B?cmhiUU5teTZDNDBtb2pkNEU5c1JvalJmaDFza3l0YldMbVZRWEJKamd0V1gw?= =?utf-8?B?R0pSVHd1Ulc5QVNNNGFISW1nL1pETUF3OVhZQUYydkhsOFBGQnc4d21pSXF0?= =?utf-8?B?eGVzenV6SWd3WWJDRytjK0UzMFNJVzBuVFdjazRGRkY0aUxxMWxsdTNEM1Y2?= =?utf-8?B?YUpYRDlvanltUWJjUGFlcm14Wkx6bmNwQVM0d1NjZ2Yram93M05hMzdOSHFC?= =?utf-8?B?eWk2N1hVODJXTU16dVp2N1BvVExhcGd3QWl2K0NuWUFqWnlTbFdmSStGbXY3?= =?utf-8?B?ekxOdldValZKYm5wL2FqbTZQL3pqK2F3QWNPSFNzOE1yWkszbmJIZ25idTZ5?= =?utf-8?B?dHFrQ1h6N2hkaVZXZ0FTb2Q3SUtldDJ0V2JDK1FjRUFIcUQzMEM3amJldFlO?= =?utf-8?B?V3Z0MTk2L2hqd0YwcTR1VElFUzJSMEFzd2YxK0IrT2FMcmVRMC9ONEYrbUVo?= =?utf-8?B?cjI4czloUXdaaWJuZVU3NUlsRVpFWGRNYW55ZCtqaS9Lc3ZEWmoyTWNVRnhw?= =?utf-8?B?SSs5UXNGVEQydjZibEd3Tldlcko1a05QY1JkTVovampCK2NmdGdyU1RzVVN6?= =?utf-8?B?NVMzVDlxQnVRb1k4VG5oSFk5Mzl1SDdtT21yaHVsUzJXajJ0L3NLaHhSbSt6?= =?utf-8?B?R05RT3FEaUlZTVdZYXpYdVRjaUZiRW0xY1RPWmtWRE1lWlVjY0k4aXBPU1ZS?= =?utf-8?B?Lzl1TkRsbWxta0lwRHAydzdVSmJjekp1RlJVQWRQbE1WM1U0OFFXY3Jybnd5?= =?utf-8?B?S0pETEFzbER0eVJoNkpNSklJQzUzTnBxNTc4NEZ5aWJEY2l0SEVyTTNTdG1T?= =?utf-8?B?YWpxWGQ2N1p3cCtjMHJEbjF4cVZ2YTdvLzFZR3IzY1lYRUZZdVE1MmwyKzBw?= =?utf-8?B?UC8xczQxMHVpUmZFWm1oMWQ0OUpaaU9ETzR1ZDhXNHRwcUVCVjc2R0VZczdm?= =?utf-8?B?ZHUyRkg1OVFMaE5EV0dJNHgrcUFWYjNyMDNkaHQxNytFYjF0OFlkZkxaY2h0?= =?utf-8?B?SjZwdmljRXFrenFIRnJtcGo2T2htYWJia1pNMUYvK29wbnl0SU1ITWJZanNT?= =?utf-8?B?V05DQzhwRURNbURQWG9KYVlYM1h0WDVhUUFoYUNKeWhuY3V3SnlrMmZ2Tk9l?= =?utf-8?B?Q2h0bHJDU0Y5NnF2elU1SWVTcDFOdDVsbzE2cytKNjJ3bXBycDJ3OW9MMFEv?= =?utf-8?B?dGQzT0xydDU4MWRaY0ZIUEdzeHBhellsZWE1MkpMVnVwcWZFeHFhdDY5elJS?= =?utf-8?B?N0hIQ1g3d1hqUlA2eG9tSlJocGRrKzVpdzFDYkhWbkljOWRacnFtTWtxVjB3?= =?utf-8?B?M0hjRWE3ZzNRNU9ZbHNOc1B4VndpWkkzb2RpbVI0eW8yN0RFYVFXK3p3eGZF?= =?utf-8?B?K0NZK0NQZi9SZU5iVDg2MXV1cEZLaEJpUFVtZlVDVmdlK1I5eStBdz09?= Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-Exchange-RoutingPolicyChecked: pHF6goOkD/KypkRZOCuby8IABy+ziIKI9sUYQnIk+zVYSLbsYcGjuS7JhdOjXGY190a/FC4DyA6/hVN7LTP6ahkQYBw9P9sz7AU7lDBj7hkMNmHc+9DYo47reqF6ZVS8wBmjnC6d1mgKMPgK4EwdtvsxCGyL/wmMLx3ROTF8cpcGWZFxRL0C6M7/Ut0c8o69rs2z3GliNcrkmsUH1BOlBeiUqS4bsrpzP4I2zymAiKc+9jtawH9zVDbION137gpyvdiARTHaL1I6oyq1VjXz6LQovvrOzY1c4nd8R8bc2L6qBhZp6JQGO8Re0YH2l7yrY21Z05GZfIWcb4XpSMRrtA== X-OriginatorOrg: fujitsu.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: TYRPR01MB14195.jpnprd01.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: 572837e3-4bba-4c98-1591-08de9c4ed65b X-MS-Exchange-CrossTenant-originalarrivaltime: 17 Apr 2026 06:59:14.4079 (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: e3/TBfwjEUY8uhlN3/HsDG/7cm8BoJktAyypIzc59N05MPzmecsd4YpN17KUwvCP/WFINgIGcxqLIBiAnueOdQ== X-MS-Exchange-Transport-CrossTenantHeadersStamped: TYRPR01MB15468 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk T24gRnJpZGF5LCBBcHJpbCAxNywgMjAyNiAyOjUwIFBNIEpvb25nSHl1ayBTaGluIDxzamg5MTA4 MDVAZ21haWwuY29tPiAgd3JvdGU6DQo+IENvbW1pdCAyYTUyMjViOTlkNyBmaXhlZCBhIHJhY2Ug aW4gUmVwbGljYXRpb25TbG90c0NvbXB1dGVSZXF1aXJlZFhtaW4oKQ0KPiB3aGVyZSBSZXBsaWNh dGlvblNsb3RDb250cm9sTG9jayB3YXMgcmVsZWFzZWQgYmVmb3JlIHRoZSBnbG9iYWwgeG1pbg0K PiB1cGRhdGUsIGFsbG93aW5nIGEgY29uY3VycmVudCBiYWNrZW5kIHRvIG92ZXJ3cml0ZSBhIGNv cnJlY3QgdmFsdWUgd2l0aA0KPiBhIHN0YWxlIG9uZS4NCj4gDQo+IFJlcGxpY2F0aW9uU2xvdHND b21wdXRlUmVxdWlyZWRMU04oKSBoYXMgdGhlIHNhbWUgcHJvYmxlbSwgDQo+IGl0IHJlbGVhc2Vz IHRoZSBsb2NrIGJlZm9yZSBjYWxsaW5nIFhMb2dTZXRSZXBsaWNhdGlvblNsb3RNaW5pbXVtTFNO KCksIA0KPiBzbyBhIHN0YWxlIG1pbmltdW0gTFNOIGNhbiBvdmVyd3JpdGUgYSBjb3JyZWN0IChs b3dlcikgb25lLCANCj4gcG90ZW50aWFsbHkgbGVhZGluZyB0byBwcmVtYXR1cmUgV0FMIHJlbW92 YWwuDQo+IA0KPiBUaGUgYXR0YWNoZWQgcGF0Y2ggbW92ZXMgTFdMb2NrUmVsZWFzZSgpIHRvIGFm dGVyIHRoZSBMU04gdXBkYXRlLA0KPiBtYXRjaGluZyB0aGUgeG1pbiBmaXguDQo+IFNpbmNlIDJh NTIyNWI5OWQ3IHdhcyBiYWNrcGF0Y2hlZCB0byBhbGwgc3VwcG9ydGVkIHZlcnNpb25zLCANCj4g SSBiZWxpZXZlIHRoaXMgc2hvdWxkIGJlIGFzIHdlbGwuDQoNClRoYW5rcyBmb3Igbm90aWNpbmcg dGhpcy4gVGhlcmUgaXMgYW4gZXhpc3RpbmcgdGhyZWFkIFsxXSB0aGF0IEkgc3RhcnRlZA0KZm9s bG93aW5nIDJhNTIyNWI5OWQ3IHRvIGFkZHJlc3MgdGhlIHNhbWUgaXNzdWUuIFRoZSBwYXRjaCB5 b3UgcG9zdGVkDQpvbmx5IGluY3JlYXNlcyB0aGUgbG9jayBzY29wZSBpbiBSZXBsaWNhdGlvblNs b3RzQ29tcHV0ZVJlcXVpcmVkTFNOKCkgYnV0IGRvZXMNCm5vdCBpbmNyZWFzZSB0aGUgbG9jayBs ZXZlbCB3aGVuIHJlc2VydmluZyBXQUxzLCBzbyBJIHRoaW5rIGl0IHdvdWxkIG5vdA0KZml4IHRo ZSBpc3N1ZS4NCg0KUGxlYXNlIGZlZWwgZnJlZSB0byByZXZpZXcgdGhlIHBhdGNoIGluIHRoYXQg dGhyZWFkIGlmIHlvdSBmaW5kIGl0IGhlbHBmdWwuDQoNClsxXSBodHRwczovL2NvbW1pdGZlc3Qu cG9zdGdyZXNxbC5vcmcvcGF0Y2gvNjQ1MS8NCg0KQmVzdCBSZWdhcmRzLA0KSG91IHpqDQo=