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 1tkaHS-0058OG-Dc for pgsql-hackers@arkaria.postgresql.org; Wed, 19 Feb 2025 02:57:46 +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 1tkaHQ-003T9Y-KU for pgsql-hackers@arkaria.postgresql.org; Wed, 19 Feb 2025 02:57:44 +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.94.2) (envelope-from ) id 1tkaHQ-003T9Q-1T for pgsql-hackers@lists.postgresql.org; Wed, 19 Feb 2025 02:57:44 +0000 Received: from esa9.fujitsucc.c3s2.iphmx.com ([68.232.159.90]) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1tkaHN-001dME-33 for pgsql-hackers@lists.postgresql.org; Wed, 19 Feb 2025 02:57:43 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=fujitsu.com; i=@fujitsu.com; q=dns/txt; s=fj1; t=1739933862; x=1771469862; h=from:to:cc:subject:date:message-id:references: in-reply-to:mime-version; bh=46XXQm/u8nupLBS/YAdpk0ng21g/L9ZN+WiPbrllrUI=; b=jHd6rPIR+M0JIYsQO5DILUQ8qW5t/qlUpTC5olbNBLfZSLoLm3pjkoMW l0CbUYq/VmqvDkg2wzQQ4llMdzuT/M/Utc7z99fGnsAqL8Qf7NRKsrJp9 YoeIf65ebaRCEXfMg3aU05pULzlrraVFCsbl/E2M/j9sD3qGG/UciyKx7 6pFAp5Ekj+QXrHg0yno4VHZBimrh+eiAM3DilrF7Ol6S5NdFOiAh2GmZs JUwDPsOtpMeYoY07HtQeCAVRhpdewK2kTP8r3EJ9EftMnX7uhKsytvx/5 YDmDYphpbLOTgrha+k0RQlvY+V3itzeQxoTtEScXiPR2mcDmOE1/eVQmh Q==; X-CSE-ConnectionGUID: tI5X3WYURZid2ezbbBwZGg== X-CSE-MsgGUID: aV2ntutnTSeWE5qxtt8XCg== X-IronPort-AV: E=McAfee;i="6700,10204,11348"; a="146913105" X-IronPort-AV: E=Sophos;i="6.13,296,1732546800"; d="scan'208,223";a="146913105" Received: from mail-japanwestazlp17011027.outbound.protection.outlook.com (HELO OS0P286CU010.outbound.protection.outlook.com) ([40.93.130.27]) by ob1.fujitsucc.c3s2.iphmx.com with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 19 Feb 2025 11:57:38 +0900 ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=ca136lKldFlxz5/R+kifHwsANZJmPhfpXJ2V69MclwtjaM/A0DkGCwIFy8+5wMr/LAp4jZ1AYM6ajF9ozTvzlq3k9694a9DfS+X+zxjj/aZAyDIMXle+SBpx5CIFK5kC0z1WOis2v3woA27ZpdP7Zkpk9a7lXnXqQA5M/0Epn+CJW0ejVaQIwJmYLhf/jCjMHG412u0/at1mjsad19xdJDPyg8MPXt0zZ8AjEo3eJs97t5HU8wGB2HFXbxGqBxe23a0CcfobZEOIWu+bKu0HXjDZfKX97UUDLaDyEnq5Xbik7CvjgW37fDIJFGRGVZgTgzJZCNJTowe7rn78Wb2Fsg== 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=s5fH+RkRY/WYfRgW6xR1TAd231aQAomiXyiZbMR9PVg=; b=m0O6K91611dvAO6jFhNDUk3IX2ExYIGPrXvqkMg5x/xD5R49Mih7iWQfJd6iGnsFmb0ZIpsO4XzhH+WE9uyF0W9ACl+L/IyfnrQZPoFtP8ghf6eeO8++dooyVUSZupQOYEqugHFXhuYgaJkD0SHZetNHmeYqSTF4E38bxJtzEX8rtkcO2+u/2/lZkx3eK/o07l2WUYFoeQCCYPB2X0mqPzjTnuaDsx0ISB3pu3jVHfexlsNbJ+4AR0uDVwKwZNrz6mO2ow3ZAL7sLMR4gEsAEMPAAJPCg2dCQBmjXdnbZxIhG+pIoK1Ou8H2cOqCGBFwfHGDouhDX7RuuvRIsa1rtA== 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 Received: from OSCPR01MB14966.jpnprd01.prod.outlook.com (2603:1096:604:3b1::6) by OS7PR01MB13799.jpnprd01.prod.outlook.com (2603:1096:604:36c::7) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.8445.18; Wed, 19 Feb 2025 02:57:34 +0000 Received: from OSCPR01MB14966.jpnprd01.prod.outlook.com ([fe80::584f:6bba:2ecf:6b06]) by OSCPR01MB14966.jpnprd01.prod.outlook.com ([fe80::584f:6bba:2ecf:6b06%4]) with mapi id 15.20.8466.013; Wed, 19 Feb 2025 02:57:34 +0000 From: "Hayato Kuroda (Fujitsu)" To: "Hayato Kuroda (Fujitsu)" CC: "'pgsql-hackers@lists.postgresql.org'" , 'Michael Paquier' Subject: RE: ReplicationSlotRelease() crashes when the instance is in the single user mode Thread-Topic: ReplicationSlotRelease() crashes when the instance is in the single user mode Thread-Index: AduBxJdn64KPa5CETf+apI8CWWnvvAAB/XMAAAIqX/AAASMfAAAAQnZgACfEuiA= Date: Wed, 19 Feb 2025 02:57:34 +0000 Message-ID: References: In-Reply-To: Accept-Language: ja-JP, en-US Content-Language: ja-JP X-MS-Has-Attach: yes X-MS-TNEF-Correlator: msip_labels: MSIP_Label_a7295cc1-d279-42ac-ab4d-3b0f4fece050_ActionId=690603f4-a56e-4e19-9e36-9cfebc8aac3b;MSIP_Label_a7295cc1-d279-42ac-ab4d-3b0f4fece050_ContentBits=0;MSIP_Label_a7295cc1-d279-42ac-ab4d-3b0f4fece050_Enabled=true;MSIP_Label_a7295cc1-d279-42ac-ab4d-3b0f4fece050_Method=Standard;MSIP_Label_a7295cc1-d279-42ac-ab4d-3b0f4fece050_Name=FUJITSU-RESTRICTED?;MSIP_Label_a7295cc1-d279-42ac-ab4d-3b0f4fece050_SetDate=2025-02-18T07:57:47Z;MSIP_Label_a7295cc1-d279-42ac-ab4d-3b0f4fece050_SiteId=a19f121d-81e1-4858-a9d8-736e267fd4c7; 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: OSCPR01MB14966:EE_|OS7PR01MB13799:EE_ x-ms-office365-filtering-correlation-id: 24987b74-4b2b-486e-6431-08dd509128da x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0;ARA:13230040|1800799024|376014|366016|7053199007|4053099003|1580799027|38070700018; x-microsoft-antispam-message-info: =?iso-2022-jp?B?KzdET1lmT0k3TE9PN1piam9LVU9nM3Q0ZmNTcXhzTGR5WFJveTBNNXZU?= =?iso-2022-jp?B?UmRwbWFzTWxaeVpocUd1czh6SWowbHJzVG5wYkdQd2dXMCt2WTZWZU1R?= =?iso-2022-jp?B?Zi9MMURzWkhRZm9ySTNmYVg3ZmZSaStoRFdhc25GbDR1Mk5LZjVTYjJp?= =?iso-2022-jp?B?WnFLQjZYOHRhVW8rY1FFUjFmalYxanplTkhGdFBaZnNKd0RMS3NqS1lZ?= =?iso-2022-jp?B?cUlWcU4yTm82UGEreGQrc3JnaDRtK3FMNnh1RkNYUnFVVkZ6bCtSZUNI?= =?iso-2022-jp?B?N3NEK2llVEtMWjZUYlQ5djBtY1JoejlIV2VoMmNQZXUwa0tCNGdRTDdM?= =?iso-2022-jp?B?ZTJrMDdpc2FlM2hOQVh4a0V0TzliSzBxWDJtc3BTVHVabDlKOEdlK2Zu?= =?iso-2022-jp?B?VDZNM0ZudHk0aHNoUFNHRTRyb3NNWi9ielJkKzIxWGV3OFIzbWtrejBJ?= =?iso-2022-jp?B?ZUg2NXRmR0hMVUtyZ2F3cmxRNTJINzREMzFHeTB3bEhNVkJCN1NRcXlJ?= =?iso-2022-jp?B?M3daTVpYV3JIS1pnV2pzN1JqVG1JdTB1Rk4xeHRVUlBLU1dIYVlMRm83?= =?iso-2022-jp?B?WUtWc1lDd2FCaDlTVlZPSkhRRmc5ek5OVS9oUjkxQjFyTHpCcGJLTmxn?= =?iso-2022-jp?B?SksrUG00c0I3TUlCWkd4aXlWMWozTHRLK3JZMExrbkcvVWF0Szl5bGVp?= =?iso-2022-jp?B?TENqSzU2TnhPTUV6RVQ0YytVZDdIZVFzbVpQTUxzZ09sZnIxNEY2cXZK?= =?iso-2022-jp?B?YkozbGxYRTFaVHdLUmljYWNYTHBjdCtyd3pzbzE0NXFTbkZ2aUljTit2?= =?iso-2022-jp?B?elZLOXVhTW1yU1lUTWJmRUUrcGhvRVdFSE1GeG5MKytkVFpia3J4Ylhu?= =?iso-2022-jp?B?Qncwa0ZBMUI5NkYyc01WOFgrVUJZT3UxT1FQa0xvUzJaaks0bWg0Q0NQ?= =?iso-2022-jp?B?Vk5wZTJpb0ZEQTd2bGZQQVlrWWh6YnAybG94Z0psSHJ1ek5CeEd2NDNS?= =?iso-2022-jp?B?bjlROEVKQUVCM2hXOHd3MEY0cDdyRzVJWXB5dzhYNnNkcFJ3NFdCNVBq?= =?iso-2022-jp?B?K1BJVDYzQXZ1SjNvb2lUVzdXT25wUzFicENiM0VMa2tpSVVha2d3ZWFr?= =?iso-2022-jp?B?aERhelA0U1pTaUw4dkpySWNQZWJaeEczMzNmYTRVV21NU05TVEVJMW1G?= =?iso-2022-jp?B?NTlwYUszWU95Qm1OWk5vKzBmT0cyalRKRlJVK0hlY3M1QVp2bnZtc1dF?= =?iso-2022-jp?B?OHZpclhBMUszVjU2blZMN25vSmlQdE16Y0RSendYMW9KYWQrUFVRd29w?= =?iso-2022-jp?B?VjZOaUFHY2gvbnhuN3kzaEpuRmdRRUhwWlEyS1dzdEF3SWVlcFJEajFK?= =?iso-2022-jp?B?ak5zeVh6Y3d6cmJHemNRU3dBTCs2SEVXRldnbTBKV3V4alRTcmh1Y0s0?= =?iso-2022-jp?B?T0o4TnprUHM1S0V3b2RFRWtSVlZYYURnR3R4MkJlM2htbzVSdVZ4Kzl4?= =?iso-2022-jp?B?MXNHQjAxUzQ3YXJtWlhvYndzT3R1a0twT0dtaml6anJEbVFmaHpWTDY4?= =?iso-2022-jp?B?MHFKT2d2bzJaaFFESTFIeXRqdXpvdnFxeHJHREdNWXZKYmwxS2Z6YllD?= =?iso-2022-jp?B?czVJUWVsRnZhS09WaEVJZzkyOGJ3V2tpUEdzNWd1MFVXQ2NHY0FjQlQ0?= =?iso-2022-jp?B?MDUxeFZJOG8rOUlOMkRTTjQyYjBVYmo0aW44MzFsZEhvNlBRbHZNenUy?= =?iso-2022-jp?B?YjVyMmV6eWpmQ3lxR2dGbUxvU2tmcXh2QmkySXZqaWpGWXppZEdGVmhl?= =?iso-2022-jp?B?Uk9kaDBjemYzK1ZOWDBrek9JS3ViaUNpMGV5MloyV2RmT2FKRDU1Wm9P?= =?iso-2022-jp?B?NElrNThTWDh4OWYySEo1ZUV1QlNYYW4wMEdwb0Z5T3lCak1qNS9tUmJN?= =?iso-2022-jp?B?NjhzWDJybGtFYzFJZHpqajJ5ci9ESitiLzRpZW9xWWtNQ2gyb250UVd6?= =?iso-2022-jp?B?ZFlScUtlTDEydVpCbWZUaWdhWUhuY1pScjlJOFlrUTdlQzUwaFN2Z2Jk?= =?iso-2022-jp?B?K3l4VHFxZXIrQmdkYlZZSWxZNkVVRHRrUXlZNFlobEZlZWlGTE80bkkw?= =?iso-2022-jp?B?b3VnNGNwVVRHRWhpZjlkb0U4eURNdm53PT0=?= x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:ja;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:OSCPR01MB14966.jpnprd01.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230040)(1800799024)(376014)(366016)(7053199007)(4053099003)(1580799027)(38070700018);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?iso-2022-jp?B?M3JER1RrSGxTRkl3aDMrSVJJZFlLcEZYTzFCbnd5eWtoZnhZc1JzbG9O?= =?iso-2022-jp?B?S2RjbHMyMFRScFRybDJpTE9Xbnc4YVgxaHJFZ25zcFlLNHVnZmUxUFd4?= =?iso-2022-jp?B?c3JKN0l0b1hBTHhNdUFxUC8rL1FuNkhQQ21RRDZpdWE3NnRnaXJHQTRl?= =?iso-2022-jp?B?dHVkS1JHSUVUL3JIcHVIcDNUcW5Ea1dyOGRrQlBlaHczb3ZTWTNlUEhk?= =?iso-2022-jp?B?N3NoN2x5TFRMcGQ0aVUramFzRkxxTzJNOTV3UkY3YVlZcEFNWDZwbTlj?= =?iso-2022-jp?B?dlVQNUl3Mml4RERqTHpkM2RhZ1dEKzR3K3hjSHdvNFJFZ0tKWHRIQjRj?= =?iso-2022-jp?B?UXU1YjgvOEVObXJ4K0pDcHpqZVl5ZDhjSDhGMEt0YkZwb2xvZElDLzVi?= =?iso-2022-jp?B?NjU3aFpEN3BDNTBTTFFIZm14WGdpS3VFNmNNTW8yNFVhS3ZCcFJSeVBa?= =?iso-2022-jp?B?amxKdStDY1Bqd2xZcnB5R1MyM1V1UUhmV21PQ1hmcWZYanVrcEp5Wmh3?= =?iso-2022-jp?B?SHZtdjRFcGVZSzRoQXZwZGZaQjdCWDFqK0NJQkt6QkFzWlNsbkpzejgr?= =?iso-2022-jp?B?aitwbjY2WG5aTXkvWmdpYzVOWndCMHoyOUQ5b25CUkc5dDV2UjRzK0o3?= =?iso-2022-jp?B?U0tXY2d1YVZJL1lpOEdGZ2VzN0FIcmV3R2lOSXkwak56TFlidWpkYU5B?= =?iso-2022-jp?B?dFlWbkxLcS82ZlRNL0JMSHZKMC9pS0k2ZnhVMWVJUUdlRVBZVFdHcTVB?= =?iso-2022-jp?B?ejdtY1FYVG9aTDFRT2xGRmR0dmRVTkN5WDN2dE84Q0c4eEVWMlhrU29K?= =?iso-2022-jp?B?VWYvVnhjbDFTeGNvWjRFVW9ydGdZYjVrWGpyUC9mQjVGNUVodGYrblZQ?= =?iso-2022-jp?B?alVBWUVZK0I4UjdXRUdEYVprcEx1UVdSWG84c2piRktDYmVFWFgrZE8z?= =?iso-2022-jp?B?Z0RaVE5vcFc5TTFiTllVUWtwbGNhV0tJVGFKeUZWc2ZLTkNzUWZnQnBl?= =?iso-2022-jp?B?NTJrajJCOWNRZFNtY3EwbUJab3QzcVU4WWFlTHRERVl6Wk8wRVVBY2ZP?= =?iso-2022-jp?B?d2hRQldlNzRMMFRMS2NaWHkweGNXdXNFZzhTR2xlTVAremVla0N5aHNO?= =?iso-2022-jp?B?eCtWblFtZzJMakpmWllpVVJjTkhqU3VwV1YrQkVoVDhHMHZHejRRWDNQ?= =?iso-2022-jp?B?Y0pBejJUTkx6aTlzcHJKNHZEQkpHb2FTaDBycXJndGlDdnIwNmJBLzNn?= =?iso-2022-jp?B?Um9XVmxmaWJFK2w4d2lqM0N0aGpPSFdUR1BiN0pEd3dKbTBUWUlHak1k?= =?iso-2022-jp?B?SmQ2UlFoc3I2dUtqRTBtd2FnK0tzOW1yQllUUDRiZUFwTitob1c2K2N4?= =?iso-2022-jp?B?Q3pmWGNTamN1UTAzYy9aL2V1d0VEbUdBNGtRVWFPY0M4R1J6VTgxR3BC?= =?iso-2022-jp?B?bUVHc0dMbnozUEdoVnRDelp2Ty9qM2pvRkEyUXQ1N3FEYStUSHBHeVMw?= =?iso-2022-jp?B?SllZRE5jODU1U1FTN2NHckFReDd2SUErdVZNMkkxdnFucTZvVXc3VkNK?= =?iso-2022-jp?B?RmlaYW1QSktjYndVVlphYXZXVTNFSmZtU0c2Zlp2K1ozSG8rcVI3Nk4r?= =?iso-2022-jp?B?SDlLeE8zTzBwUUhZbGNhdG1xcUpTb3dHamo3eDNGZEtzKzMvQU4xSUlJ?= =?iso-2022-jp?B?bXd1MDRrYjJpUFFGWWF3RENBYzY2blQvditxV3h6TGZxQXg5Q1NrVUtJ?= =?iso-2022-jp?B?d1JUbWt5QzFNRmxpckMvcXlGQk51OC9vMG8yY0I3STlEMWh6ZFI3L3Bq?= =?iso-2022-jp?B?dGxjVmR2OXJTZDFNRnVSTGlHYUJrck96M1l0Z083WVJQS2xicHY0TGE1?= =?iso-2022-jp?B?WXhJWS9YT29nelVhQTN1QVlpYnhhYm10dWFyeGNMeXJ0REdPWjdYVjRn?= =?iso-2022-jp?B?RnhVTnRiM2JMazE5TVFMV1VWWFpObVY0R2R5cThSak1ZbHZwK0c4TzdR?= =?iso-2022-jp?B?Vk1zRjEzN3UzekxlVUNoU2x2bXZoMXhsNklSWjNWYUpKT3N4c2JUU2lq?= =?iso-2022-jp?B?TXd1Vjd3TUxqbjduWVFITlhSR0w4YmExTHJWUHVnUjM4N2dQMVVYOVBC?= =?iso-2022-jp?B?TFEyNDAvdEUzWlF1amdiR1ZoVGRTTnRMdkpteFE4WXhRelVLWGRuWW1u?= =?iso-2022-jp?B?cTlDVW93YVY4VjFsblk3c3BCOE1zSjd0djVUVVVnZmpsOVQ5VUVuL05I?= =?iso-2022-jp?B?UzlTTkFDbXJkUC9zamFNMWRCZktZd3FLUEhGV2dsNENyN3htZXFRM1N6?= =?iso-2022-jp?B?SUV1bnoxMXJRK1BkRGxpd2dmeXd4VmtaMlE9PQ==?= Content-Type: multipart/mixed; boundary="_002_OSCPR01MB14966F234CD3121F51810D5CCF5C52OSCPR01MB14966jp_" MIME-Version: 1.0 X-MS-Exchange-AntiSpam-ExternalHop-MessageData-ChunkCount: 1 X-MS-Exchange-AntiSpam-ExternalHop-MessageData-0: DHvJ/O8mXE4d4Zoif9SZ5GMtbbQ8sOFLa73hFD0wwGJNTK62Fn2sxIqlLmBAVlph+1RmLJ6Cmh16C6gVVu3Tg3PXt+6VLDUZvSuvxBtOjkFDE6p1aK9iFxMn6mA7J4gAev5FD67FecrVLCRvNrsSARhjyf7Oe+1VRzjVxMLHzh1K0vjBBxyXuxDipFzsk2I+PRM6GKPrlGdfZRD57x/21SyahAnyYn8hD3kW707Tw2g6XD281aKT2BGVTg44VXKrEmS4mNPwLGtKPe4UeqJq+Daer+xzy7AMh4dvAAraayPfGV9VhrV+BUw0807epnSB1aWIHJKD0o0tST5pqyjHfTACg7XPvpA+kEr7tTgVdRgrcxNGzPUv5lX4xqTiSDhm31/c8hXvUNSALHJ4PqZdlxga+FF6686tOwxkRClU7qusicDnl+2jPf6yqixdieCUMJFzD5TqJAknjV86YKL7W7EV2SlJNDaqat0RISaLAbV3KcayragawEKnj/rf5dNUmyB5w+8RuSrQZ1v2D9BZFxwWxuykLsY6zS6+uazCX0Uf57o7dR4u0RMjGHfgoArCJvvGWONCTQarNZCtYKyDrjt+kVrpgjNv6VCFxXNuL7WqQOJbMFJaH+J5uO05gOuy X-OriginatorOrg: fujitsu.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: OSCPR01MB14966.jpnprd01.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: 24987b74-4b2b-486e-6431-08dd509128da X-MS-Exchange-CrossTenant-originalarrivaltime: 19 Feb 2025 02:57:34.2302 (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: 7EpVZ1S5lQHTHmBVDo2wV/QVl5JUwouCIDA1GXMzvhZ1dZbbtklvWy9GxX+9J5MGQDx6Cmy2AYCuMmJiNWhCQhS+kJGdi/PHW6U+Zl/xkKo= X-MS-Exchange-Transport-CrossTenantHeadersStamped: OS7PR01MB13799 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_002_OSCPR01MB14966F234CD3121F51810D5CCF5C52OSCPR01MB14966jp_ Content-Type: text/plain; charset="iso-2022-jp" Content-Transfer-Encoding: quoted-printable Dear hackers, Based on the discussion, I feel it is enough to add quick error out for SQL= functions. PSA attached. Best regards, Hayato Kuroda FUJITSU LIMITED > -----Original Message----- > From: Hayato Kuroda (Fujitsu) > Sent: Tuesday, February 18, 2025 5:24 PM > To: 'Michael Paquier' > Cc: 'pgsql-hackers@lists.postgresql.org' > Subject: RE: ReplicationSlotRelease() crashes when the instance is in the= single > user mode >=20 > Dear Michael, >=20 > > Ah, good point for the slot drop. So 0ce5cf2ef24f is claiming that > > some of these manipulations are OK. I didn't suspect this one. >=20 > Yeah, I think so. >=20 > > Slot advancing is a very different beast, unfortunately, that may > > depend on many other subsystems. For example with logical slots we > > would finish by calling rm_decode, which could be outside of core. > > Justifying that this operation is supported in single-user mode is > > larger than what you are suggesting here.. >=20 > OK. Actually, I do not have any use-cases in my mind. I played because > I found a special path for single user mode in ReplicationSlotAcquire() > so that I wanted to see the behavior. >=20 > Best regards, > Hayato Kuroda > FUJITSU LIMITED >=20 >=20 --_002_OSCPR01MB14966F234CD3121F51810D5CCF5C52OSCPR01MB14966jp_ Content-Type: application/octet-stream; name="0001-Prohibit-slot-operations-while-in-the-single-user-mo.patch" Content-Description: 0001-Prohibit-slot-operations-while-in-the-single-user-mo.patch Content-Disposition: attachment; filename="0001-Prohibit-slot-operations-while-in-the-single-user-mo.patch"; size=2377; creation-date="Wed, 19 Feb 2025 02:56:21 GMT"; modification-date="Wed, 19 Feb 2025 02:57:26 GMT" Content-Transfer-Encoding: base64 RnJvbSBlYjcyZTVlOTIxMzg4ZmNkYWNjNGQ1NGY4OWM4ZDMwODE4MGFjYzc0IE1vbiBTZXAgMTcg MDA6MDA6MDAgMjAwMQpGcm9tOiBIYXlhdG8gS3Vyb2RhIDxrdXJvZGEuaGF5YXRvQGZ1aml0c3Uu Y29tPgpEYXRlOiBXZWQsIDE5IEZlYiAyMDI1IDExOjM3OjI2ICswOTAwClN1YmplY3Q6IFtQQVRD SF0gUHJvaGliaXQgc2xvdCBvcGVyYXRpb25zIHdoaWxlIGluIHRoZSBzaW5nbGUgdXNlciBtb2Rl CgotLS0KIHNyYy9iYWNrZW5kL3JlcGxpY2F0aW9uL3Nsb3RmdW5jcy5jIHwgMjMgKysrKysrKysr KysrKysrKysrKysrKysKIDEgZmlsZSBjaGFuZ2VkLCAyMyBpbnNlcnRpb25zKCspCgpkaWZmIC0t Z2l0IGEvc3JjL2JhY2tlbmQvcmVwbGljYXRpb24vc2xvdGZ1bmNzLmMgYi9zcmMvYmFja2VuZC9y ZXBsaWNhdGlvbi9zbG90ZnVuY3MuYwppbmRleCA4YmU0YjhjNjViLi5jYmZhZGZhNDI4IDEwMDY0 NAotLS0gYS9zcmMvYmFja2VuZC9yZXBsaWNhdGlvbi9zbG90ZnVuY3MuYworKysgYi9zcmMvYmFj a2VuZC9yZXBsaWNhdGlvbi9zbG90ZnVuY3MuYwpAQCAtMTcsNiArMTcsNyBAQAogI2luY2x1ZGUg ImFjY2Vzcy94bG9ncmVjb3ZlcnkuaCIKICNpbmNsdWRlICJhY2Nlc3MveGxvZ3V0aWxzLmgiCiAj aW5jbHVkZSAiZnVuY2FwaS5oIgorI2luY2x1ZGUgIm1pc2NhZG1pbi5oIgogI2luY2x1ZGUgInJl cGxpY2F0aW9uL2xvZ2ljYWwuaCIKICNpbmNsdWRlICJyZXBsaWNhdGlvbi9zbG90LmgiCiAjaW5j bHVkZSAicmVwbGljYXRpb24vc2xvdHN5bmMuaCIKQEAgLTczLDYgKzc0LDEwIEBAIHBnX2NyZWF0 ZV9waHlzaWNhbF9yZXBsaWNhdGlvbl9zbG90KFBHX0ZVTkNUSU9OX0FSR1MpCiAJSGVhcFR1cGxl CXR1cGxlOwogCURhdHVtCQlyZXN1bHQ7CiAKKwlpZiAoIUlzVW5kZXJQb3N0bWFzdGVyKQorCQll bG9nKEVSUk9SLAorCQkJICJzbG90IG9wZXJhdGlvbiBpcyBwcm9oaWJpdGVkIGluIHRoZSBzaW5n bGUgdXNlciBtb2RlIik7CisJCiAJaWYgKGdldF9jYWxsX3Jlc3VsdF90eXBlKGZjaW5mbywgTlVM TCwgJnR1cGRlc2MpICE9IFRZUEVGVU5DX0NPTVBPU0lURSkKIAkJZWxvZyhFUlJPUiwgInJldHVy biB0eXBlIG11c3QgYmUgYSByb3cgdHlwZSIpOwogCkBAIC0xNzksNiArMTg0LDExIEBAIHBnX2Ny ZWF0ZV9sb2dpY2FsX3JlcGxpY2F0aW9uX3Nsb3QoUEdfRlVOQ1RJT05fQVJHUykKIAlEYXR1bQkJ dmFsdWVzWzJdOwogCWJvb2wJCW51bGxzWzJdOwogCisJaWYgKCFJc1VuZGVyUG9zdG1hc3RlcikK KwkJZWxvZyhFUlJPUiwKKwkJCSAic2xvdCBvcGVyYXRpb24gaXMgcHJvaGliaXRlZCBpbiB0aGUg c2luZ2xlIHVzZXIgbW9kZSIpOworCisKIAlpZiAoZ2V0X2NhbGxfcmVzdWx0X3R5cGUoZmNpbmZv LCBOVUxMLCAmdHVwZGVzYykgIT0gVFlQRUZVTkNfQ09NUE9TSVRFKQogCQllbG9nKEVSUk9SLCAi cmV0dXJuIHR5cGUgbXVzdCBiZSBhIHJvdyB0eXBlIik7CiAKQEAgLTUxNSw2ICs1MjUsMTAgQEAg cGdfcmVwbGljYXRpb25fc2xvdF9hZHZhbmNlKFBHX0ZVTkNUSU9OX0FSR1MpCiAKIAlBc3NlcnQo IU15UmVwbGljYXRpb25TbG90KTsKIAorCWlmICghSXNVbmRlclBvc3RtYXN0ZXIpCisJCWVsb2co RVJST1IsCisJCQkgInNsb3Qgb3BlcmF0aW9uIGlzIHByb2hpYml0ZWQgaW4gdGhlIHNpbmdsZSB1 c2VyIG1vZGUiKTsKKwogCUNoZWNrU2xvdFBlcm1pc3Npb25zKCk7CiAKIAlpZiAoWExvZ1JlY1B0 cklzSW52YWxpZChtb3ZldG8pKQpAQCAtNjEyLDYgKzYyNiwxMSBAQCBjb3B5X3JlcGxpY2F0aW9u X3Nsb3QoRnVuY3Rpb25DYWxsSW5mbyBmY2luZm8sIGJvb2wgbG9naWNhbF9zbG90KQogCVR1cGxl RGVzYwl0dXBkZXNjOwogCUhlYXBUdXBsZQl0dXBsZTsKIAorCWlmICghSXNVbmRlclBvc3RtYXN0 ZXIpCisJCWVsb2coRVJST1IsCisJCQkgInNsb3Qgb3BlcmF0aW9uIGlzIHByb2hpYml0ZWQgaW4g dGhlIHNpbmdsZSB1c2VyIG1vZGUiKTsKKworCiAJaWYgKGdldF9jYWxsX3Jlc3VsdF90eXBlKGZj aW5mbywgTlVMTCwgJnR1cGRlc2MpICE9IFRZUEVGVU5DX0NPTVBPU0lURSkKIAkJZWxvZyhFUlJP UiwgInJldHVybiB0eXBlIG11c3QgYmUgYSByb3cgdHlwZSIpOwogCkBAIC04NjYsNiArODg1LDEw IEBAIHBnX3N5bmNfcmVwbGljYXRpb25fc2xvdHMoUEdfRlVOQ1RJT05fQVJHUykKIAljaGFyCSAg ICplcnI7CiAJU3RyaW5nSW5mb0RhdGEgYXBwX25hbWU7CiAKKwlpZiAoIUlzVW5kZXJQb3N0bWFz dGVyKQorCQllbG9nKEVSUk9SLAorCQkJICJzbG90IG9wZXJhdGlvbiBpcyBwcm9oaWJpdGVkIGlu IHRoZSBzaW5nbGUgdXNlciBtb2RlIik7CisJCiAJQ2hlY2tTbG90UGVybWlzc2lvbnMoKTsKIAog CWlmICghUmVjb3ZlcnlJblByb2dyZXNzKCkpCi0tIAoyLjQzLjUKCg== --_002_OSCPR01MB14966F234CD3121F51810D5CCF5C52OSCPR01MB14966jp_--