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 1w10rB-002PmF-12 for pgsql-hackers@arkaria.postgresql.org; Fri, 13 Mar 2026 11:39:05 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w10r9-003bUv-2R for pgsql-hackers@arkaria.postgresql.org; Fri, 13 Mar 2026 11:39:04 +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 1w10r9-003bUm-19 for pgsql-hackers@lists.postgresql.org; Fri, 13 Mar 2026 11:39:03 +0000 Received: from mail-japanwestazlp170100003.outbound.protection.outlook.com ([2a01:111:f403:c407::3] helo=OS0P286CU011.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 1w10r7-00000001vlu-3hYU for pgsql-hackers@postgresql.org; Fri, 13 Mar 2026 11:39:02 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=UrQ4rkzJYj3PTVIt9ff/K/viKgSCqPsa/jV9DoYv5N5lkwLFPIISsjZoXocQ4u6Y+9qdAi/qvws5QSB4+20JNtiu7NSRlT4YEZaXl2eUjwQSHAdb4pbMsQQ3XXsUDXJ/ch1WTkzHJn9/X07fUfbg6ovLcj0sz4rhPlaJ5A+C/Qwc32IEHcS/uOv9pYt1RtEfcbst/Q49VO5G7Y4bwDjRS4cgXjNni880qWs8vxE3XI2ma130KVzyrGLWcsJypDYERK3Gh9yOFhQjaJHsjfYzjoWoOuDoFykioPe4QSU7pLBElA85qQk9XTly/Om4Tp1NG6CneeHfad/eZJA1LqfrOg== 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=TSKTtdaxi0Btvzovhfp/BcKx06YKK7FNusOor7E1tk8=; b=I7/WFxni8Igpadgrhjy3i86zjdhYTp1ybZpKItlSbTh8FoP6FoliEkNJKJyXLwJAu/G1gbq0hBLgtXkSBQflG5KLypP/JjrWaGIoAXxUvlNjRhz25LEb94YufOUfqJfPtUVjO4oS9S+RSC99ZrWE1wjjWlXofjVwTwlSSasOCDBvmGyuW2JzUv3vrAJM9tMFQulRSCbI+ToWwzlrRk3kITpPCe9Kgj/I5p3WYjaC/7Ozg7hIfu7P7wzJsACcIr0SCWPhX9U2W38W3xKF46AtinJyBJtK35iHuFsK+4yr/erLIeWcd/1FTq6Ap7AZo6vctpF0bMcr5UOvT/cL2eISmQ== 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=TSKTtdaxi0Btvzovhfp/BcKx06YKK7FNusOor7E1tk8=; b=UAky3h/Urxb1gdgR0udPwHJx8vQQv9iHWq26tzhVJVqJrm532lw6564Ynj3VI3fpGQGqjd8EyNi4/reQZiLGyMNDF7UB+qSdtQeVHIv//tCIiuXZtMEd4wgeT99OIs8W+Vh1gE2tJBcxBkOCssnbYL4a7e97EEOp/VYwBi3YM5BhRqvmGCFz9m7p9EyHxGtOmLcNSNNdq2ptKPIMg/QbT6t7kL/j5mdTdFpkiMxsIjEwyzMreXbdMWw0bA/9iExOQAyd9w849yvYQPpNZsd7DkF7ZiJiQ1jy7DNbJDQi34iA/QiPIu/+jsQSUf6adHxwALoXG8FGdtZsSXE6n0naHw== Received: from OS3PR01MB8889.jpnprd01.prod.outlook.com (2603:1096:604:154::9) by TY4PR01MB12926.jpnprd01.prod.outlook.com (2603:1096:405:1e1::5) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.9700.16; Fri, 13 Mar 2026 11:38:41 +0000 Received: from OS3PR01MB8889.jpnprd01.prod.outlook.com ([fe80::b63:fd5f:e8f:fc53]) by OS3PR01MB8889.jpnprd01.prod.outlook.com ([fe80::b63:fd5f:e8f:fc53%6]) with mapi id 15.20.9700.015; Fri, 13 Mar 2026 11:38:52 +0000 From: "Aya Iwata (Fujitsu)" To: 'Michael Paquier' , Peter Smith CC: Pavel Stehule , Chao Li , "Hayato Kuroda (Fujitsu)" , pgsql-hackers Subject: RE: [PROPOSAL] Termination of Background Workers for ALTER/DROP DATABASE Thread-Topic: [PROPOSAL] Termination of Background Workers for ALTER/DROP DATABASE Thread-Index: Adw0Q6iYueu3o2DFQ0mAqFGMYYi8fgCHrYogAANaoAAADhfaoAAkABYAAAgFebAAHqlkgAAc+sDgABamIwAAB8zgcAAA2L7gAAJh2gAAAJsSIAABnF4AAACrZPAADnLD0AAdyhgAAAccG9AAiEaFAAAGACmAAGU3sZAANwlJgAufFI0AADTJjNAACU7dgABjuTRwAAWSjQAAKB4N0AALRsgAAVn4LyACE1bdgAACmtMAAARr5QAAEDsw8AAPo6WAABFxbgANA82wUA== Date: Fri, 13 Mar 2026 11:38:51 +0000 Message-ID: References: In-Reply-To: Accept-Language: ja-JP, en-US Content-Language: ja-JP X-MS-Has-Attach: X-MS-TNEF-Correlator: msip_labels: MSIP_Label_a7295cc1-d279-42ac-ab4d-3b0f4fece050_ActionId=000a6f0c-be60-4bba-b375-95a57c91e906;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=2026-03-13T11:38:00Z;MSIP_Label_a7295cc1-d279-42ac-ab4d-3b0f4fece050_SiteId=a19f121d-81e1-4858-a9d8-736e267fd4c7;MSIP_Label_a7295cc1-d279-42ac-ab4d-3b0f4fece050_Tag=10, 3, 0, 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: OS3PR01MB8889:EE_|TY4PR01MB12926:EE_ x-ms-office365-filtering-correlation-id: 76a9906c-bfe8-4434-113f-08de80f519bf x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0;ARA:13230040|376014|1800799024|366016|22082099003|18002099003|56012099003|1580799027|3613699012|38070700021; x-microsoft-antispam-message-info: ortQct6T/d0ig+OrCWOUfoH7mXH3h28Hv0s5kYt6tK9cNcafPjRocYX0ssOouq+ffRT57V4XV7w1Y6tUUm6jEc/BbindFTKN/LavEBuUk7CZ5IexoPibRDeA4gdgL2CcA23vyL/3TmwhGLjENdTVh9eJJaTVgFiDJrCVeHq7aoLXR5nRcS7pUgsZKTaVngvuFrx7tMA90OJgN/heEVU9C5SiU97P0jFY7atYOWIaWHgsqN0dup4BqgmSWGJi9t70nzPAxhLOhKlta0lVRwAQaLEVMnYs42up/dz+2UmMV8kmcKWsYARVSRWFJLD/rvVMADq7q0XTgWpr5MBHw5Q9ifCluOgRFyoEVQpSU3EmluYAcnYzeE19I/bFkCOA+l/Lv0ZLOadIm9UmfIUSITIAxc8Ll3UvqmuYleRYqoJ83kQOrJh3UnihHLYsNaXoJDLFKvO3Nrf7UkulStYlM+oUkf0Eg6jziJKmavTiCTL9ih03Sr8MBHORIIbyblgC8cA2HEUma9Zt7vLA6EN+WvChBtS627o9v+pkaV9s7wR4Gdh4vB/DGYn2ncqZDrvEugWxFfRhSPMRGxHoHEmb31qUexh0ypWinfVi0pCc/wnGRmIJtbotfKTzPQVTELrlU9nHTCWTWL9/P+8r1p5FWf7UNJs3HE6di3E5zK/jU7uF3RuX2NK7+c0jmuNDEM1Ng0k2TWCs6HZApxzEBsYryfsAm11wO1D2G34snAqyqnR2eyscCjux+3FItcI1x69sH41cJdQIJAYHgotvbv4itD1SoqpOQJNgHDUd65OJ+Z8eHnPYeEUMWXSxAVSSuQl1TOIb x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:ja;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:OS3PR01MB8889.jpnprd01.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230040)(376014)(1800799024)(366016)(22082099003)(18002099003)(56012099003)(1580799027)(3613699012)(38070700021);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?iso-2022-jp?B?cHdBYzJZVnp4MktJYjIySm9CVDBJYzBSYnZ6dHhEbnJHc1hLclR4OWwr?= =?iso-2022-jp?B?dlpvYUZJVFNodFMwcmFoNXRYdXdBakZNNU5EOTBmMEtmV1dXcHFmMnhr?= =?iso-2022-jp?B?ZU1BRjJENDF1ZSthd3hZWWFtTFdoWTR5OU5tSFE1N3FEMzR2dlBjaThu?= =?iso-2022-jp?B?OGU1S3dRdDNyalF3U1UxVm9OL01BV1BpMFc3aUVuVU5lL1MvUXhUV2Ns?= =?iso-2022-jp?B?MzhSaWhDVTJvMWl2UWlFTjFJMnhDQ2VhSGFxN0Iya1BLUW05UnFQV3ph?= =?iso-2022-jp?B?S1FYeG9HVXB3d1lzdUNVWVUzN3VmOVNySTBuWlladC9icmM5MEcwTGlv?= =?iso-2022-jp?B?SHpXbjE1S055WnVqN283V283dDZkMXZXS004bjMzYjA0enR5UmtWeVNs?= =?iso-2022-jp?B?SkVNNnRMY1JDUWlCdlB6bUNxOEVrTEMrWUMrQU9RQ1QyVnVkUmJHVjgr?= =?iso-2022-jp?B?RDZXSFlIK20rQVFhdDFWdzBWVENDV0RCUmxkTDdFZEN2bFd2eW5lVHVW?= =?iso-2022-jp?B?T3BxZnB0RHJtb0w5ZEovMnc3TkZkWmR1bVNPZUFTWVV6SWZvV1BhODdn?= =?iso-2022-jp?B?b29iSlV3eFhBaDhYK0JYS2NzVnhLNlRpcHkwbkVXdDhPdU9JcUxsV3RQ?= =?iso-2022-jp?B?a2pNaGtmNDcvdEJrMGRRdSs5Q2NWWjM4UzJxelRNVC9mSHJUTnlEQWNq?= =?iso-2022-jp?B?akgra2xlYWE3Mk05NGxHS1ErYUQ5RG5MdkVJTkFaOWJIcy92TmVVTzFF?= =?iso-2022-jp?B?QUxxM29CMU1SaSt5ZHdyY1ZVbDN0NlI4djZiL2VWdjhvMHM4bmcyUGls?= =?iso-2022-jp?B?NFJWeWZ2dHZaTkdlQmtkb05RS2VYZU9FU3VHRGs4YWlkWW9LLzZhOGZY?= =?iso-2022-jp?B?Yzg4c2JRS0VvbTVkeWw0RGxHVlgwRjMvWHpvTmxOd3BZRmRBTGNyK0wr?= =?iso-2022-jp?B?UU4xNXJJbVNUWG1QZVREeVVUZDhVajdRL0Q5WmFVTU9ZbjRpNnZHWmpC?= =?iso-2022-jp?B?UWhrQWsxdWFwN0w3RmdGVmRrRjZFWE9XSUNsVit2YXdMdVo3M3ZBWWdm?= =?iso-2022-jp?B?ZGJKUFVYY0lLMjJDSmN4bVF3VUhpLzZMMEREb2NVTnV6T0VCVmhMVnl1?= =?iso-2022-jp?B?b2NId3V6UEVicXF0RTdCWWUvOGI4bWo5cktsbDIvZXI4bFlnV2Yvb1hJ?= =?iso-2022-jp?B?NmR5bWorQWtRWEM5NnFFUTYrOG1KSndwUkhSL0h0ZVBXS1ZoalRqSmtF?= =?iso-2022-jp?B?QXJNRGlvQjhDTUJNZWwwUGNNWXZqTjAxb3RSV1VBcXdvU3RXZ0xIQ3di?= =?iso-2022-jp?B?Qk9BdzFEWFBOMkxLamVTVksydTJKblNxVXZPYjhISHRzTDdmYWJVY2lU?= =?iso-2022-jp?B?dE51VlNhTzFWM3VrN0ZGZ0t1YUVPRi9oVXYrak5odkxrRkIyWHk4cnp5?= =?iso-2022-jp?B?WjljZVR1czdoZGg2QWhIZmtZVDRyWklUTFBXY21rQ1hwYTNJUUIzU0Q4?= =?iso-2022-jp?B?U1MvMmNEaTZJOGJ6Mzk0RzdSUUphTnY4NUVSYkMzZURrWE5tQ3R1a1hP?= =?iso-2022-jp?B?bGM2TDRRRXFmS1BqR3RpZUdwTkNjcnFxcEd5ZTFwWHVReFd4OWJ1SzBS?= =?iso-2022-jp?B?cGt6NmxDQ0gySXVSMFFEMHpDOUdhMVlnS0FHWUR2MGtWR05oOHJBUWNN?= =?iso-2022-jp?B?MFIxSjdwRU5jcGZRb2JnTjFtdjRYODBaTEVSTkE3a0dzVnJPVXpmbXFB?= =?iso-2022-jp?B?Z05xMGl4eXRTR0F1R1hyZWJHZzZBQ0R3ZDFIM3N2blBRUkEwU0ROWFc5?= =?iso-2022-jp?B?RHZHOEpsWG12SFZpUUs4MkhDeUFod21rdWpwSkZ4OFBmZ3c3U3JEMEE4?= =?iso-2022-jp?B?QXpkeU5HWW9Fc0g0NzFhMHBpdG9aZk80V2lORGlZL2w2T1VmODJvNmdj?= =?iso-2022-jp?B?MGhJaFkwTzZKS0NWNG4vWXV0QUtvemN6dldITVNDUjdPNmYyUGhxRkkv?= =?iso-2022-jp?B?Zk85ajlQejhBUzloN29vc3IxRWdGSERsZTBvZ1V6d25HeEc5UlRkaFJw?= =?iso-2022-jp?B?anBBREYzQUpPWk5JblI1cE9leXljQ3g2MzBwd0I2dW1WMlBub1dPL2Rk?= =?iso-2022-jp?B?UGRicnBwMGtyVmN5K0M5U1Bodm5VYllsOFpNRTZUeVByc3p3K1dxYlJv?= =?iso-2022-jp?B?Sm5pbUZUT1FvZ3hQUGhwSThpdDVYQ1VwRWhFbkl6MTZhWlF3enVkclJP?= =?iso-2022-jp?B?Q1ZTam92WUVFVGVHMWl3WU9mdnV3WDk1MXdROGxsZTdvNm9zTTgya1kw?= =?iso-2022-jp?B?U29iaGtDYnFOWDk2dWRHRHpaUnZZVVdvNWRMYzB4bjB0OUVXbTdDV2dI?= =?iso-2022-jp?B?WG5MNWlJbjJzbVJsR2xCU2ZMZjd0c2xqcHVxd3NCRDNaakN6c1NXNXFx?= =?iso-2022-jp?B?eGN4V0hKdmRucGk4Z29OYVhqVEtSMzlkamRzMzhCUnlsKzFPZUM1VVBR?= =?iso-2022-jp?B?UGRKRFRoVm5QS092dDRvUWo2cTFUQUk5RG8vQT09?= Content-Type: text/plain; charset="iso-2022-jp" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-Exchange-RoutingPolicyChecked: Gvz6IZVeuD0216nG+80GaD7rrseBTCnrXY7edtNPaocsdmA2jsV6obzdHnDa2/EPeb0vooW1N1jxL4nfu6syNGYXwLanyi2s9WGMUhMBlPcJBSvwt/ZYzFi4F8iAfxzFyRlpo17E23x0uVpFCxpOYGIpeaKohPpy9fNe+EjSNZe13tWGslT2fP6ZiY/xsWvHrcsV6FhkzL8gx82Mp31dteFE9BCqgsPqrbk0vKyIgpFmSgrAzFU417WVzb3oIVE43nK2pKD52Vt6X446gnBTZJcUxuwteWVzv1Ix07Le/bKrhx5af/DRlgQHzBIxfsQl9nkj/UaETc1QxmQvPLT4HQ== X-OriginatorOrg: fujitsu.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: OS3PR01MB8889.jpnprd01.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: 76a9906c-bfe8-4434-113f-08de80f519bf X-MS-Exchange-CrossTenant-originalarrivaltime: 13 Mar 2026 11:38:52.0132 (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: VX+uackA0c3xCCMkeHbRNIDPpXliioaHZA0/wNJSus4g7wDJe8jgMkou/ACpJEFGvb8fo/t5y2jLLlvPZtypDPuqtckQQwsO0sslc0BesrA= X-MS-Exchange-Transport-CrossTenantHeadersStamped: TY4PR01MB12926 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi On March 10th, the bgworker test "t/002_worker_terminate.pl" failed on the = Build Farm. https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=3Djay&dt=3D2026-03-= 10%2019%3A26%3A19 We are currently attempting to reproduce this issue and are considering a f= ix. According to the log, the test failed because the bgworker cannot be termin= ated within the time frame (5 seconds) when ALTER DATABASE RENAME is executed. So I suspect that there is a lock conflict. Log of Build Farm; 2026-03-10 21:08:33.103 CET [28076:4] 002_worker_terminate.pl LOG: stateme= nt: ALTER DATABASE testdb RENAME TO renameddb 2026-03-10 21:08:34.578 CET [28071:2] FATAL: terminating background worker= "worker_spi dynamic" due to administrator command 2026-03-10 21:08:38.109 CET [28076:5] 002_worker_terminate.pl ERROR: datab= ase "testdb" is being accessed by other users 2026-03-10 21:08:38.109 CET [28076:6] 002_worker_terminate.pl DETAIL: Ther= e is 1 other session using the database. 2026-03-10 21:08:38.109 CET [28076:7] 002_worker_terminate.pl STATEMENT: A= LTER DATABASE testdb RENAME TO renameddb 2026-03-10 21:08:38.229 CET [28076:8] 002_worker_terminate.pl LOG: disconn= ection: session time: 0:00:05.129 user=3Dbuildfarm database=3Dpostgres host= =3D[local] 2026-03-10 21:08:38.231 CET [28025:6] LOG: background worker "worker_spi d= ynamic" (PID 28071) exited with exit code 1 2026-03-10 21:08:38.234 CET [28025:7] LOG: received immediate shutdown req= uest 2026-03-10 21:08:38.241 CET [28025:8] LOG: database system is shut down If there is a lock conflict, we will come up with a solution. Regards, Aya Iwata