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 1rGvoE-000Fmb-QH for pgsql-hackers@arkaria.postgresql.org; Sat, 23 Dec 2023 06:48:31 +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 1rGvoA-00G4Is-Am for pgsql-hackers@arkaria.postgresql.org; Sat, 23 Dec 2023 06:48:26 +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 1rGvo9-00G4Fe-Gy for pgsql-hackers@lists.postgresql.org; Sat, 23 Dec 2023 06:48:26 +0000 Received: from mail-me3aus01olkn2144.outbound.protection.outlook.com ([40.92.63.144] helo=AUS01-ME3-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 1rGvo6-00BmgS-Dr for pgsql-hackers@lists.postgresql.org; Sat, 23 Dec 2023 06:48:24 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=FrDaxGqiMhjCcdRcEK9U0kSIW/8l7YYA2gbcLdqopiuL6rG9XhoLEPJDQsgLsIqG2OuiXsSKCQzeMGYpZTZlY2wOX8W0RfV6y7KkQPSg7ix+yaaNmU1a6rUrb2gMqPwxb/uu22hjJf5hQSKLlci1G6fzqd4wnPEWOvf8mHgw5cYQlstCKS2Et9YbAYBwNwGvacqcsHShOo5wM7mBqZ+UxFO+j45OMHQuYRQ+AUW5P02l1I/6oYqZpH2/gtAS1j3J6NpUrnC2adtmqrz969wVNBtvoFT29VOUbFpxGcWoKZ6znWVsWs/UkUgh0keZD20uYNEunKlR3EBdLL2GxhKFPg== 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=FmVc/3aMwn7qBHppu65uiBEdm8zJRtr0pNgjvj1RZgQ=; b=PsaX+yUtTVlifdyCIefnMOWrynfB/UfFCsIvoZzPLP8nHT0wk9TkFqoXnTVxVeJdIH56EHDkNR6kITMu5ukmyJDnu0rUIgoggBpn8QSqo3FmYe23AMUf//VdqI+7z0wDCUoM1U9G52zbEoPcVbgdhTMSWVEOnDEKTJfx0T+O3rvTw24hm218ChpUDkXerPrR6R6Csgr4ktpFpltebjuqRWqjzlEFz5NVqKhKqbV1rV2ZD7qeOeuEuzdqIlT59OcaysBr0QEcKtUg83ku630sh7V4//Ymf7dxj5twTFSl4rouTpuUvww6xVGnq8tBXFuOkm5U9hxW9xKDsDelFrsilQ== 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=FmVc/3aMwn7qBHppu65uiBEdm8zJRtr0pNgjvj1RZgQ=; b=j1Qzz4tcu5pVajGVedRmZ27RHOmY30HdKsQ7DYWFR01xKW3VuL7owwB2HfZV0Mf6/N3ge4b9pzIeOFjbn1Dt1UZlkAp1MVDvYQYiGzSVd1LIFltUQMo+oPFn4iVRd/s/9Z2SzktbSPNwmsdUPjMdPPK0oSkJk/4kB+CgDYJne1GfhCHOX8wSnZNL66qPn+s4TqsFf3ngxwyNh7/J5Qr3uGoL3aw1+57O+h3NcnsItR6zqrPJ9IEXX4a4b/QbmAPtNHnnGQwBLs8Gws7aeAZ59V/eFXZ1Hm3jqZ/giCqkKVOGyiMftKzi0RA12eGhSNQb9CdfqKHBcrnMEdge09+GoA== Received: from ME3P282MB3166.AUSP282.PROD.OUTLOOK.COM (2603:10c6:220:147::21) by SY8P282MB4742.AUSP282.PROD.OUTLOOK.COM (2603:10c6:10:255::5) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.7113.24; Sat, 23 Dec 2023 06:48:14 +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.023; Sat, 23 Dec 2023 06:48:14 +0000 From: Li Japin To: Junwang Zhao CC: "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 Thread-Topic: Transaction timeout Thread-Index: AQHZBtbEi18WhSnmHUO+KUfgnUVw0q5bu9gAgACzTwCABlU3gIAANCYAgBE/YICBmu8+AIAANteAgHVY+QCAEJppgIAJKtMAgADwIgCAAJsmAIABQ9IAgAAj8QCAAAXkgIAK9dOAgAD9dYCAA3XUgIAAPk0AgAACR4CAAQgDgIAAdZKAgAAh2ICAAD0ugIAEKV6AgAByswCAACBQgIAAA10AgAAB5oCAAAz8AIAAl0sAgAAjywCAAApBAIAABQuAgAA16EM= Date: Sat, 23 Dec 2023 06:48:14 +0000 Message-ID: References: <76472EBA-077B-4F6D-B84D-F0917A31CEDD@yandex-team.ru> <7B300616-70CE-4CCB-A014-13BC0AF814CA@yandex-team.ru> <459C55FE-F49A-4D9A-8C98-F4AEB47B68D7@yandex-team.ru> In-Reply-To: Accept-Language: zh-CN, en-US Content-Language: zh-CN X-MS-Has-Attach: X-MS-TNEF-Correlator: x-ms-exchange-messagesentrepresentingtype: 1 x-tmn: [IT2wRnbMe3nJ4/hsw0bxmLFh7ejT+26F] x-ms-publictraffictype: Email x-ms-traffictypediagnostic: ME3P282MB3166:EE_|SY8P282MB4742:EE_ x-ms-office365-filtering-correlation-id: 8e70fd8a-23bb-4221-3f8f-08dc038322e3 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: AlEArS2BhEuOG4me7+0JqiCoIGiobkUKBroKSsK1WEM515HBO9KlbUcYiLQLBi8c/mHru8/IYiIU1A5AnOwKZ8FUXDfJQQC6OZTL1iBSk2uMagiKGOuM6KQsPvb5Lkm6WjK5BGu+fgW+uxafoXOnwX2h9P/hmKXzANJTT4QPDdFTXpqMYC8O6auUGGZHyS6azJDBo+L7llygkQQ2ChQ0KoQpAwMOh+jSDOIoj64aDKqvWoWv1CFuhSDAnb9ab54WBO7QaBpcbVAQAp00OsS0aonKkbvc8bH6RoGMxmqsfy/wLwIY73b0LsdMZ+M46sE2uJUSqy2M4SeFyeUFABGpINQOKjyWnTqH1KdhfJs5GYzfPsAcxoGrzce+6LvPn9wgO2fatiR3KWfiQc1njvLP0QwcmhDX2LTLTHZ5TsgoEtU/3yWCrlT9G/WoWu7kNLECL9Eo60E80R2aLCthBSmpSANLhcnCv6SGBNUxgvD5jtzTUEYNy/p1Asni3ULkaJjRVNkPq+K+TCeye2sHdgOUwogvG5eK64Uc4mwNukWyQ6keFtVxyjGWkO7xL39M0d1yqdsksRutULuhGP5/oeadHB78QLBfuvzVbfBs6tGy/HQ= x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?utf-8?B?OXBZb3BqbUZ1U09aZTBmQWV0Um84M3ExZEhDeThuNE9RUWd5WnB0eTVvK3ZB?= =?utf-8?B?YnJNQ2VIand6SmVSZmRKVUtaWGxNRXRERlIwOHRHNnFXOEZ1elNQcjN6MWd3?= =?utf-8?B?WE8zbThYUXFxYyttUE83UVlBRHNpSzVMSXpteGtZZVZ1MzMwLzNvdEFlL0dj?= =?utf-8?B?OGtnOGJzdnpzL1lqN0lYcE5ad1FBQ2pyakloRzhTS2JsZk5uNzY2V1d1V2Vv?= =?utf-8?B?THp3RGErRDB3NDNlaTIvMmVHSzBzZlBWcmpvQmM2TTF2clNTU0ZYM0hkSXg3?= =?utf-8?B?cXlPOEl1czZUZDQ4ZTVheERTUTZ6ZlQ0ZENCQk0vc2YwTEhTZDcyYXF0SzEv?= =?utf-8?B?M1JVTCt0bU82SmRDSGNyT3QwM2JKdXd6UmpXZndnL2pibGRlVXNpTnlscnZ0?= =?utf-8?B?UGdTYU8wTEhaUjM0Mk04QWhHcnYxOHVIZXNmQTBuVGRWdFJUQnMzOTJKTFQ1?= =?utf-8?B?NHFudHJ3THBoVDd4czdzMnNEQlgvMlV0SHExa0M0Tnk1aCtXZzhSekxXK0lp?= =?utf-8?B?aGxQR2xwZDZxejZYYUxBdlM3ZnhIU3pKOEcyaG9NcnFqd0ViRnAvUngya2xp?= =?utf-8?B?em1CSGcrb2s0SmxmYXJ2R091dVBkZit3bm9rWmprTndSTlBRS0F0dmJyWGps?= =?utf-8?B?R3ZGdUVHY2h1UHYwY3NnNFFKRVpNamIwTW8wL0xoWkYwcisyOEtwQmRjeGZW?= =?utf-8?B?cm5mRVc0WkY2VXpDWWh6aE1qMWFjSlVIYVhzT05jMEZ5b3hNbjhya3o1QTYw?= =?utf-8?B?QW9Zanlsbmp5MXNZWmtXUDFhaEo1b3FWT0ovOU4xcmpORjMvUXlEc3Y0MFRa?= =?utf-8?B?cGVJZFZmdU45Ly94VVI1K1FNV2I3TEZjVHNmelRlVVh6YnZQSGtaYUJrNVBG?= =?utf-8?B?Y2o2MjNyMThDZjk1bWg5MHltRG93dE1RaFVsdHlwMDF4a0F5Vmd6azFSUUsx?= =?utf-8?B?ak1TWVpqM3JXYlpiV01nMDFJMnNnWGN3M29wRTNHbWd0SDlJdFNDT1Q5TzBz?= =?utf-8?B?UlFyZllFZkFrckNsNnFVZjVZNnZnNG1WMS96Q1NkM0prTjR5ZjN4b1F6NGpn?= =?utf-8?B?RkJ5cFlRYkF2Y0tOeEE1a3dwdmE5Y09xcWkvTXVta0hQR1JIVkJsRElnMFVU?= =?utf-8?B?TFJ1TXpYV2VRcXVNNlJYcW03VWlSdHgzdU5abzMzR0ttZm8rM3ZwSjN5cG5K?= =?utf-8?B?bWhBK3hiNlN6aTk5WHhyWjBJK3JLcHg1ZFY4MDA1RHdDNmVhTW5xMjJhVG1S?= =?utf-8?B?dWVBN1Nmb3AxNERKUFAvTldNYngraUl3K3k0Yyt6dnJxRFpNQkRYaGh0bUI0?= =?utf-8?B?WVRoZzVvdTdJLzJFZXl6dXpKbnBqQndRRFJFT2R2RzFiOS9QbGt6M0s4MXVC?= =?utf-8?B?cmUyekl2R0hSVEt6c3ROV1l6VHFXdDBOcytsWmljS0c0bTVQcGZXT2tUNXM1?= =?utf-8?B?R1NlbXhaaWNOZ2w4RXdVaElhMTBRMDRadmtnbWxJZk9pcUJRQXJPTjE5eFMx?= =?utf-8?B?QVVxNmZEaTgrL2s1RHVjcnBNeDV1Y1htSDZOOFRmc3RYWHZQdnNBYkY1QWcv?= =?utf-8?B?T0pUbHJHOEliYTZnTzhMN01iclVpbVdoa2F6QThwWDVneW5aZFpLT2tsakYy?= =?utf-8?B?NTlESEE3Y3VvTTk4Q1M3MDFUb2NYa3c9PQ==?= Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-OriginatorOrg: sct-15-20-4755-11-msonline-outlook-746f3.templateTenant X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: ME3P282MB3166.AUSP282.PROD.OUTLOOK.COM X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-CrossTenant-Network-Message-Id: 8e70fd8a-23bb-4221-3f8f-08dc038322e3 X-MS-Exchange-CrossTenant-rms-persistedconsumerorg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-CrossTenant-originalarrivaltime: 23 Dec 2023 06:48:14.0545 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa X-MS-Exchange-Transport-CrossTenantHeadersStamped: SY8P282MB4742 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk DQoNCj4g5ZyoIDIwMjPlubQxMuaciDIz5pel77yMMTE6MzXvvIxKdW53YW5nIFpoYW8gPHpoandw a3VAZ21haWwuY29tPiDlhpnpgZPvvJoNCj4gDQo+IO+7v09uIFNhdCwgRGVjIDIzLCAyMDIzIGF0 IDExOjE34oCvQU0gSmFwaW4gTGkgPGphcGlubGlAaG90bWFpbC5jb20+IHdyb3RlOg0KPj4gDQo+ PiBhDQo+Pj4gT24gU2F0LCAyMyBEZWMgMjAyMyBhdCAxMDo0MCwgSmFwaW4gTGkgPGphcGlubGlA aG90bWFpbC5jb20+IHdyb3RlOg0KPj4+IE9uIFNhdCwgMjMgRGVjIDIwMjMgYXQgMDg6MzIsIEph cGluIExpIDxqYXBpbmxpQGhvdG1haWwuY29tPiB3cm90ZToNCj4+Pj4gT24gRnJpLCAyMiBEZWMg MjAyMyBhdCAyMzozMCwgSnVud2FuZyBaaGFvIDx6aGp3cGt1QGdtYWlsLmNvbT4gd3JvdGU6DQo+ Pj4+PiBPbiBGcmksIERlYyAyMiwgMjAyMyBhdCAxMDo0NOKAr1BNIEphcGluIExpIDxqYXBpbmxp QGhvdG1haWwuY29tPiB3cm90ZToNCj4+Pj4+PiANCj4+Pj4+PiANCj4+Pj4+PiBPbiBGcmksIDIy IERlYyAyMDIzIGF0IDIyOjM3LCBKdW53YW5nIFpoYW8gPHpoandwa3VAZ21haWwuY29tPiB3cm90 ZToNCj4+Pj4+Pj4gT24gRnJpLCBEZWMgMjIsIDIwMjMgYXQgMTA6MjXigK9QTSBKYXBpbiBMaSA8 amFwaW5saUBob3RtYWlsLmNvbT4gd3JvdGU6DQo+Pj4+Pj4+PiBJIHRyeSB0byBzZXQgaWRsZV9p bl90cmFuc2FjdGlvbl9zZXNzaW9uX3RpbWVvdXQgYWZ0ZXIgYmVnaW4gdHJhbnNhY3Rpb24sDQo+ Pj4+Pj4+PiBpdCBjaGFuZ2VzIGltbWVkaWF0ZWx5LCBzbyBJIHRoaW5rIHRyYW5zYWN0aW9uX3Rp bWVvdXQgc2hvdWxkIGFsc28gYmUgdGFrZQ0KPj4+Pj4+Pj4gaW1tZWRpYXRlbHkuDQo+Pj4+Pj4+ IA0KPj4+Pj4+PiBBaCwgcmlnaHQsIGlkbGVfaW5fdHJhbnNhY3Rpb25fc2Vzc2lvbl90aW1lb3V0 IGlzIHNldCBhZnRlciB0aGUgc2V0DQo+Pj4+Pj4+IGNvbW1hbmQgZmluaXNoZXMgYW5kIGJlZm9y ZSB0aGUgYmFja2VuZCBzZW5kICpyZWFkeSBmb3IgcXVlcnkqDQo+Pj4+Pj4+IHRvIHRoZSBjbGll bnQsIHNvIHRoZSB2YWx1ZSBvZiB0aGUgR1VDIGlzIGFscmVhZHkgc2V0IGJlZm9yZQ0KPj4+Pj4+ PiBuZXh0IGNvbW1hbmQuDQo+Pj4+Pj4+IA0KPj4+Pj4+IA0KPj4+Pj4+IEkgbWVhbiwgaXMgaXQg cG9zc2libGUgdG8gc2V0IHRyYW5zYWN0aW9uX3RpbWVvdXQgYmVmb3JlIG5leHQgY29tYW5kPw0K Pj4+Pj4+IA0KPj4+Pj4gWWVhaCwgaXQncyBwb3NzaWJsZSwgc2V0IHRyYW5zYWN0aW9uX3RpbWVv dXQgaW4gdGhlIHdoZW4gaXQgZmlyc3QNCj4+Pj4+IGdvZXMgaW50byAqaWRsZSBpbiB0cmFuc2Fj dGlvbiogbW9kZSwgc2VlIHRoZSBhdHRhY2hlZCBmaWxlcy4NCj4+Pj4+IA0KPj4+PiANCj4+Pj4g VGhhbmtzIGZvciB1cGRhdGluZyB0aGUgcGF0Y2gsIExHVE0uDQo+Pj4gDQo+Pj4gU29ycnkgZm9y IHRoZSBub2lzZSENCj4+PiANCj4+PiBSZWFkIHRoZSBwcmV2aW91cyB0aHJlYWRzLCBJIGZpbmQg d2h5IHRoZSBhdXRob3IgZW5hYmxlIHRyYW5zYWN0aW9uX3RpbWVvdXQNCj4+PiBpbiBzdGFydF94 YWN0X2NvbW1hbmQoKS4NCj4+PiANCj4+PiBUaGUgdjE1IHBhdGNoIGNhbm5vdCBoYW5kbGUgQ09N TUlUIEFORCBDSEFJTiwgc2VlIFsxXS4gRm9yIGV4YW1wbGU6DQo+Pj4gDQo+Pj4gU0VUIHRyYW5z YWN0aW9uX3RpbWVvdXQgVE8gJzJzJzsgQkVHSU47IFNFTEVDVCAxLCBwZ19zbGVlcCgxKTsgQ09N TUlUIEFORCBDSEFJTjsgU0VMRUNUIDIsIHBnX3NsZWVwKDEpOyBDT01NSVQ7DQo+Pj4gDQo+Pj4g VGhlIHRyYW5zYWN0aW9uX3RpbWVvdXQgZG8gbm90IHJlc2V0IHdoZW4gZXhlY3V0aW5nIENPTU1J VCBBTkQgQ0hBSU4uDQo+Pj4gDQo+Pj4gWzFdIGh0dHBzOi8vd3d3LnBvc3RncmVzcWwub3JnL21l c3NhZ2UtaWQvYTkwNmRlYTEtNzZhMS00ZjI2LTc2YzUtYTdlZmFkM2VmNWI4JTQwb3NzLm50dGRh dGEuY29tDQo+PiANCj4+IEF0dGFjaCB2MTYgdG8gc29sdmUgdGhpcy4gQW55IHN1Z2dlc3Rpb25z Pw0KPiANCj4gSSd2ZSBjaGVja2VkIHRoaXMgd2l0aCAqQ09NTUlUIEFORCBDSEFJTiogYW5kICpB Qk9SVCBBTkQgQ0hBSU4qLA0KPiBib3RoIHdvcmsgYXMgZXhwZWN0ZWQuIFRoYW5rcyBmb3IgdGhl IHVwZGF0ZS4NCj4gDQoNClRoYW5rcyBmb3IgeW91ciB0ZXN0aW5nIGFuZCByZXZpZXdpbmch