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 1rGrwZ-00HXbC-Cm for pgsql-hackers@arkaria.postgresql.org; Sat, 23 Dec 2023 02:40:51 +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 1rGrwX-00E7ob-EJ for pgsql-hackers@arkaria.postgresql.org; Sat, 23 Dec 2023 02:40:49 +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 1rGrwW-00E7l3-BN for pgsql-hackers@lists.postgresql.org; Sat, 23 Dec 2023 02:40:49 +0000 Received: from mail-sy4aus01olkn2176.outbound.protection.outlook.com ([40.92.62.176] helo=AUS01-SY4-obe.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rGrwS-00Bl5U-U6 for pgsql-hackers@lists.postgresql.org; Sat, 23 Dec 2023 02:40:46 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=Ydve3CdYdmmvTyaovTbq4Mh3fbPSCKbNvtCfw6H/VG4VCQCPgwKBA8irmFbFfNpcz5+K+gN06oZ0vrRs1MBgJTGn6PAjytkJQvnem85lpRygHZ1z9CO1DAxFvTT2VUP15B0f0Ml+XI8sGH6Nnme0Me+aNtsBJXMhYlj8L8J0Te21jmFqplnzO2wJ5wSiumHWvA4q6gUHuRIwmpu9y8uRy1Dhl3t247zgDV/PSyq05brW7qSx0r5RBBU8KMErFM+Aaz4zhSEY2n1esfg580u1wxf1F1/pMvmAy0S0RZgsyXawTOktAcHx1VsrvGoJ4kficOATV/+eqgtWcC0MuPLtFQ== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; 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=3Tdb7I2Nj7lx1hRXFKTEAG3A8b58EbuhfLsQf23Ldr4=; b=A+4gyPPkgCgH+tsZmpMjedd3XlwlHGuNf/HnT3Egw2JDiilamEwVk/3lSRShwN0u2Qf8wdOCHzgNM5p5rhIgzEa4y8QCyA4RHVvddXJRyqOTe2SeH4A8laXv9CeMg8PHRF9vVKVsFKEKsfEjZa0plXT9Myz0vSMXyBoKLoYXMSfuEVrALeWUmQCJw1H2jFL29IijWiSxDHcY2w/UqjhFE3TGmH1ebP21iDft2Iim8IMQVaI5eNUUKFm2ysET7NLBdJ4C741LY4IM1TF2A11bJFW6v7pRVw41FOoy9SNKXrbvJ4eEFxtk6F7hCMbdfXWt//twhJtB4LuxSQ5FQQvJUA== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=none; dmarc=none; dkim=none; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=hotmail.com; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=3Tdb7I2Nj7lx1hRXFKTEAG3A8b58EbuhfLsQf23Ldr4=; b=hd2U4iym2eg2ZQmgEqK5nHfoc9UQsMjeiBD1Q7I9z7UZRm5t/YXLTH8OovWsIe9dZjsovz84K+lW7Xt/kccDp2Gy9ko/gAqld7w32kapOuQBkVBK86lw3dHkW4/aDhwAae8f41s5gHzqxHkjHXVTVQtaivLmAOm4h3FcN/gOlkD4glwTq5jDP6Z22PfyWiVHB98dI/ZCB9tjv+undhA5yGikg8Dz/Hg062iRZZk8lXGA5zrxJs9YeDyHsQjpWoLMFqXjUYAEqq5noXGkRYA7XaESIWypkpZtAQXT07vkAFxqcBIK7e3y502NSRNqKKcjkyn+fQ4I685NxJsTLKgASA== Received: from ME3P282MB3166.AUSP282.PROD.OUTLOOK.COM (2603:10c6:220:147::21) by MEYP282MB4044.AUSP282.PROD.OUTLOOK.COM (2603:10c6:220:170::6) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.7113.22; Sat, 23 Dec 2023 02:40:37 +0000 Received: from ME3P282MB3166.AUSP282.PROD.OUTLOOK.COM ([fe80::3a9:3f12:f758:103f]) by ME3P282MB3166.AUSP282.PROD.OUTLOOK.COM ([fe80::3a9:3f12:f758:103f%3]) with mapi id 15.20.7113.022; Sat, 23 Dec 2023 02:40:37 +0000 References: <145F4741-008A-41BF-AE06-1BE1435DFB1A@yandex-team.ru> <76472EBA-077B-4F6D-B84D-F0917A31CEDD@yandex-team.ru> <7B300616-70CE-4CCB-A014-13BC0AF814CA@yandex-team.ru> <459C55FE-F49A-4D9A-8C98-F4AEB47B68D7@yandex-team.ru> User-agent: mu4e 1.4.15; emacs 28.1 From: Japin Li To: Japin Li Cc: Junwang Zhao , "Andrey M. Borodin" , =?utf-8?B?6YKx5a6H6Iiq?= , Fujii Masao , Andrey Borodin , Andres Freund , "Michael Paquier" , Nikolay Samokhvalov , pgsql-hackers , pgsql-hackers@lists.postgresql.org Subject: Re: Transaction timeout In-reply-to: Date: Sat, 23 Dec 2023 10:40:32 +0800 Message-ID: Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-TMN: [XnH0xWOQC0eFY/ByEUV09WNt5VckXA1F] X-ClientProxiedBy: SG2P153CA0048.APCP153.PROD.OUTLOOK.COM (2603:1096:4:c6::17) To ME3P282MB3166.AUSP282.PROD.OUTLOOK.COM (2603:10c6:220:147::21) X-Microsoft-Original-Message-ID: <865y0phc9r.fsf@hotmail.com> MIME-Version: 1.0 X-MS-Exchange-MessageSentRepresentingType: 1 X-MS-PublicTrafficType: Email X-MS-TrafficTypeDiagnostic: ME3P282MB3166:EE_|MEYP282MB4044:EE_ X-MS-Office365-Filtering-Correlation-Id: 54580e89-a591-4c61-cb24-08dc03608b73 X-Microsoft-Antispam: BCL:0; X-Microsoft-Antispam-Message-Info: nZXlGfPeXwVr392z1NJbS4pGjvQhNDwmzg/NmQTF40OjsBR3YretRpJuOUvyB9jOv2OcaVROTkOnH2e7YGwlkOGz4cs2C4iRqPXY+XJoNPdLVHfDxPuSJzlkngW40pvHBJpEN0SzSAZLUiZIiNN11/wDMALynlU1i0N4y6JFplAmFelsotrUG0DlJvDID43BMvreCnf1XupVG9YQmp3KhgDoYTvYrgzOg6h/rykL33IpWIvt/1DvLRHfTwtEjCSiz15gvm5P/T+bcJWCUB+q5W03RLozoYSP8rsQRNkFQnjIpgi7+OJKPRQ2cXvjVH6O9i0aYiwrRpS8YHeDdieGRnU6jZeqYWv534nYZBECWCY64aXnu/a9sI7my9IN7ULT3X2GrFXoehW88N2ZPVXbfSApbV2+PZc5HUYAp4fd8EPtOYTuKt/M3QQjEYhSj3S+iBkHFGhkH+3i0KvN2u2FM28tKd8La99pnTCbzlQ2bSBc9ciYo2Gh8/hJRMqfkTWg1tYhMvOrYLgcHqzXYTKw2j1D2fkAXgqT2ekONAlsWkrns2McbypyGkH3yJ2YNnUZGU8RlcrnY6hjoqDBENjin1rru7zpo5lD+ebI4QyER2jnJ8Xgva/VP4dHLwczi4yx X-MS-Exchange-AntiSpam-MessageData-ChunkCount: 1 X-MS-Exchange-AntiSpam-MessageData-0: =?utf-8?B?dERQS25IRlBSY3p5VkZXQVI0TWdRV2xDUHZKNjJBa0IxcWdsWjJ6MXVuYkl0?= =?utf-8?B?KzgvVHMrelhwaTdNVXZjN25Uc0NpdmJrS2I2UDdCYVdjcXY4YmJWYnYyMlJV?= =?utf-8?B?eGZFOUk4VGFLWE9UK0QwY1VVRVRQRFdFR1RVK3FwNHZVK0NuaDNyaUJSdGs5?= =?utf-8?B?b24zSnptY3Z1Z1huTmthWlpva1pjSkZKbVViekNMU0s5TjdYbnNMdHRkdkJw?= =?utf-8?B?M2JtZjY0L1lNZTg4RC83RlNkaXRST2d5U29YUjdYc1MzUTZjRW5aZkZhaTUw?= =?utf-8?B?enBYUkZ4bVNKWTJ2RDJjWmpsOWYwOERVbXFzNkVNVThLTlZiVWZncTFGWmZL?= =?utf-8?B?RThIanRKZ3hkYUJkNTE3OUNWM1V0TXJ6aldjV2h1anRlODZ0Z2V0amFDQ21z?= =?utf-8?B?WE5jZ1BZeThWY09FM2R0Ykc3TGRTTkFsYU1TdXlSUXM0SVVGb1pvR2o5T0U3?= =?utf-8?B?eDBKZE5XR096aUNqRUIvakwvQm1za29GalZ3bXZ2eEFlRm5HbVNTRTc5R0JU?= =?utf-8?B?YlpvRWdHOU1odC9oMU1BRndIK0RJWjJsbzJoQ1BMaGtSVmFVbzJ3QlE4eGpB?= =?utf-8?B?TndOMWErVWh5dXk5WFZVQUNTMUY3RFM0aUhDNUUzZ3h1cEtwUFlqMDlTRitv?= =?utf-8?B?M2JTTkNRVi9MSkNoSVV1eVo2WHZLOG5tZGFleFV0MjhIZ3liTmxzT211OXRU?= =?utf-8?B?b2FlSUJVTkZLTUYxclovOHJ2dENJZU4yNitsZ09YQ2pOWjBNVnE3ZFVPVEtW?= =?utf-8?B?amYwUnRRdTM0U2h0ZHg1aWhEM1ZQOHpkVzFwbmZzcjNGTmpnL0VVQVpLQXN0?= =?utf-8?B?YUFwc0lJaGVBUHlvemFiK0dKK1hqdXMxU2tTNllib2lTcUwzd3dHM2JDekRl?= =?utf-8?B?aXI3NGYwcGVVSjVodHRVWC9PZkFzc3g4WmorbGxSR0YvbUl0TkdiQ0Q1Mmpw?= =?utf-8?B?N1AvUW9hUnFFTGM0aHp2bmwvMjlqcjR6dm5CM0JDcDgvQVMyZVZqWk9ncnJJ?= =?utf-8?B?UG1US0w0SkZNNzJQVGMvdjgwdDRRQjVhVWVrcjcvcUF4akZWL2t0b1NaQ3hX?= =?utf-8?B?VnprZkMzMGNCVUh0blhLZTY1Q1dPd2IwQURyQ004M3BLMGl0VlFZQUY3N1ZG?= =?utf-8?B?ME1HZDF3UncwSVRUdlhQZVVwT0V3VDMwRVJ4YzBIeVAxWkN2aHNtQkZ1UHRt?= =?utf-8?B?eFJiS1JDbEE5V2ltbDQ4c1Nwc0tOM1MwYTExRVZFT1ZMeEZTR2hCSjJzd1c1?= =?utf-8?B?VHl4MkV1ek1sK2NZVUhmVlU4WW12cDA0WFArcWF0bWsxeEN3T3ZZK2ZlcC9x?= =?utf-8?B?OHBKNi9nYS81SkJOZkVhVzAzVkVibm9FWVVHanZCSkV4WXVHM0lyWW53UnNI?= =?utf-8?B?UHVuZXgzOUh4cHJ3UTJiTzh0QjRTNWxtQTRzUmw2RHdycEgwMTY1czNLc0dI?= =?utf-8?B?SXluQVlJbHJBTXFGeVZHUkFKcnJjS3o3RVJmZnBqblBtK0M4MHJyK3BQUXQw?= =?utf-8?B?REJjRW5SUnlQMTh3VDBSQnE5WDViNEkxUmlXRFZVTmg3RzNZempsOEd0LzNi?= =?utf-8?B?ZCs2VVhLY2dPenpWYmdtKzlqaFcxUWI2eUNEcDBqNHErbEVwcXhEeWplb3p6?= =?utf-8?B?UU5ud2h1eENzVDVTcDVTYkt2emRFb3c9PQ==?= X-OriginatorOrg: sct-15-20-4755-11-msonline-outlook-746f3.templateTenant X-MS-Exchange-CrossTenant-Network-Message-Id: 54580e89-a591-4c61-cb24-08dc03608b73 X-MS-Exchange-CrossTenant-AuthSource: ME3P282MB3166.AUSP282.PROD.OUTLOOK.COM X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-OriginalArrivalTime: 23 Dec 2023 02:40:37.4666 (UTC) X-MS-Exchange-CrossTenant-FromEntityHeader: Hosted X-MS-Exchange-CrossTenant-Id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-Transport-CrossTenantHeadersStamped: MEYP282MB4044 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Sat, 23 Dec 2023 at 08:32, Japin Li wrote: > On Fri, 22 Dec 2023 at 23:30, Junwang Zhao wrote: >> On Fri, Dec 22, 2023 at 10:44=E2=80=AFPM Japin Li = wrote: >>> >>> >>> On Fri, 22 Dec 2023 at 22:37, Junwang Zhao wrote: >>> > On Fri, Dec 22, 2023 at 10:25=E2=80=AFPM Japin Li wrote: >>> >> I try to set idle_in_transaction_session_timeout after begin transac= tion, >>> >> it changes immediately, so I think transaction_timeout should also b= e take >>> >> immediately. >>> > >>> > Ah, right, idle_in_transaction_session_timeout is set after the set >>> > command finishes and before the backend send *ready for query* >>> > to the client, so the value of the GUC is already set before >>> > next command. >>> > >>> >>> I mean, is it possible to set transaction_timeout before next comand? >>> >> Yeah, it's possible, set transaction_timeout in the when it first >> goes into *idle in transaction* mode, see the attached files. >> > > Thanks for updating the patch, LGTM. Sorry for the noise! Read the previous threads, I find why the author enable transaction_timeout in start_xact_command(). The v15 patch cannot handle COMMIT AND CHAIN, see [1]. For example: SET transaction_timeout TO '2s'; BEGIN; SELECT 1, pg_sleep(1); COMMIT AND C= HAIN; SELECT 2, pg_sleep(1); COMMIT; The transaction_timeout do not reset when executing COMMIT AND CHAIN. [1] https://www.postgresql.org/message-id/a906dea1-76a1-4f26-76c5-a7efad3ef= 5b8%40oss.nttdata.com -- Regrads, Japin Li ChengDu WenWu Information Technology Co., Ltd.