References: <F7EABA32-E0A7-4A3F-A953-2ECD4813F726@yandex-team.ru>
 <ME3P282MB3166A9BFA45239291EBC5F1CB667A@ME3P282MB3166.AUSP282.PROD.OUTLOOK.COM>
 <DD2C0791-FCDB-4073-848C-7107CAB55EAE@yandex-team.ru>
 <CAHut+PuOdzypMrK3HsSr0F2fyn8VO5z2+EZ=6Sz39QNbBrisHQ@mail.gmail.com>
 <4C30F833-C0F2-4664-B0FF-192FD8AB2E2E@yandex-team.ru>
 <ME3P282MB316697D91841CF4EE86CF882B6792@ME3P282MB3166.AUSP282.PROD.OUTLOOK.COM>
 <A8009945-7FB7-4E75-9239-CCC351F8050C@yandex-team.ru>
 <ME3P282MB3166A01CE3BC1B8B9C846A75B67C2@ME3P282MB3166.AUSP282.PROD.OUTLOOK.COM>
 <EBD6C037-8C85-4427-BC0C-B818D6036B89@yandex-team.ru>
 <CAPpHfds=ByL_MEZunF7P+AaDJ7xv7LD8kHcV9awWZx5fOJZBRw@mail.gmail.com>
 <20240215230856.pc6k57tqxt7fhldm@awork3.anarazel.de>
 <A738D5A4-23BA-4AD6-A01E-EF34A5A98C57@yandex-team.ru>
 <29FFC4CE-EFB3-4A72-B53A-ADAB2B5F66A9@yandex-team.ru>
User-agent: mu4e 1.4.15; emacs 28.1
From: Japin Li <japinli@hotmail.com>
To: "Andrey M. Borodin" <x4mmm@yandex-team.ru>
Cc: Alexander Korotkov <aekorotkov@gmail.com>, Peter Smith
 <smithpb2250@gmail.com>, Junwang Zhao <zhjwpku@gmail.com>, =?utf-8?B?6YKx?=
 =?utf-8?B?5a6H6Iiq?=
 <iamqyh@gmail.com>, Fujii Masao <masao.fujii@oss.nttdata.com>, Andrew
 Borodin <amborodin86@gmail.com>, Michael Paquier
 <michael.paquier@gmail.com>, Nikolay Samokhvalov <samokhvalov@gmail.com>,
 pgsql-hackers mailing list <pgsql-hackers@postgresql.org>, pgsql-hackers
 mailing list <pgsql-hackers@lists.postgresql.org>, Andres Freund
 <andres@anarazel.de>
Subject: Re: Transaction timeout
In-reply-to: <29FFC4CE-EFB3-4A72-B53A-ADAB2B5F66A9@yandex-team.ru>
Date: Mon, 19 Feb 2024 18:17:16 +0800
Message-ID:
 <ME3P282MB31662287F06AE5D788869D8DB6512@ME3P282MB3166.AUSP282.PROD.OUTLOOK.COM>
Content-Type: text/plain
MIME-Version: 1.0
X-MS-Exchange-MessageSentRepresentingType: 1
X-MS-PublicTrafficType: Email
X-MS-TrafficTypeDiagnostic: ME3P282MB3166:EE_|SYBP282MB4038:EE_
X-MS-Office365-Filtering-Correlation-Id: 526cc0fc-27d3-45cc-c8d4-08dc3133f750
X-Microsoft-Antispam: BCL:0;
X-Microsoft-Antispam-Message-Info:
	9LsTjjIGNjsZMPmYFF19ljJi8wgcT8MR07adTbwtu0PG6DZX49mNfnbH0xdj8I4r2vdwRwnQ7i9mE1QbTzH8++3tsmDJeT1bJ8L4iBEXWNoq8Eh7pGpWkI/xkKb5OH+dkTgFLwXCE8l2iNBLAh/CQobd/ozT5+BrUR3FSQ4dER07XTZTrjxhFTNCHoTZqXBq3giRXHTBJ1pGra+PzR4/l+tR5oyfTT1Ki1F+D5IIC03AhZGWO9YIAIzGMVIT6v9qlbt97MTC3+K3EfK0VVb/oc/iPz6MdIP0bQkO0rCiaEzx05g7nhcgijW8371sro4/MdzAFMmcmIYr2TzDAeDPrr0ISIA9FCsYDdxe+Hwh2ocZD+XomuBMJmXAu/DQFXb4hz3MuOG8bMrtlUph6uun41R6c0O5XDMd72VHaIKYCZ37Qe/h6RVkNXmv+iKHDnbccOIFE0NWHYd1AQAm9a7b0jbZc8QiFiTb6VM1FiG8RmI0Gv1SNXpw4Q30vVD+0bm9vq0r9tjYHnAMfvHy17e/FiHVvXwR7ibG0cLFDDSRhaoT0SaIqTPzJ4wLZUitGjrj
X-MS-Exchange-AntiSpam-MessageData-ChunkCount: 1
X-MS-Exchange-AntiSpam-MessageData-0:
	=?us-ascii?Q?st0u61AoXAIq6DfoB2bZWYvAvvV1yA/UWU9n7lXrS9tlWZm8AWaWpeog+wEy?=
 =?us-ascii?Q?0EXj5SPnncMRcPfFjkoilnlftT130aj8KK0MCJQg/ALEvIzg3C8C0Rgvfte6?=
 =?us-ascii?Q?QJ9D2iLTk52d7ZdlG0hHW2oKKqGxiOVLM3pojhWFqsnDeYnzGcBgn2qqpSbq?=
 =?us-ascii?Q?wgQvGLTIF8GE9wUHDb7XpxpW89+e33qzHb68bzVWIEEhhicFGeGOZkdQQerC?=
 =?us-ascii?Q?gUx0qoUc7af2euB51VYtlVoR5E3YpXnfdIoRQbkCbPLZ4rP3UjCtwsOofepM?=
 =?us-ascii?Q?vpzkjuhf9Ohd2h9cGoXjW05moelqwmoV5CLGJLPqEt4qe7JhdWBELK3vluBq?=
 =?us-ascii?Q?rt+DDfEUl+WFkVZcGgiwaqIMLk5h7NxUTvwkJB2DfODD7s/9e2DW9FRTu2Ij?=
 =?us-ascii?Q?g9KFnQwueEahH/Xzg5fu4o0awOCxtCmHK/hRhyMYg/0AAejwyrQ8FcRfti3j?=
 =?us-ascii?Q?hTIdBL3uL2sWVW65RiE+n19I5zJnvp9QmQZ9U4JfrEbo+Tio/OK/O5DUtyYt?=
 =?us-ascii?Q?vwh3nJadF/PmmsgOP3MDzrS7GdBZbTVjrhM91o/6ie5es3dIR+0CfvxSIyy6?=
 =?us-ascii?Q?7oQ4Wh0BVO3OOxxALMNipbsBCdekLlmpGK8K3w+vHO72l57VOZpXVtQEJP81?=
 =?us-ascii?Q?iZSz7VqAiItPP5ksYRjwYS8oDx2eBGvRYEFtN9RZcjfGKQ53SHSInVnpf7cX?=
 =?us-ascii?Q?F5q8RnbTK6f8s28DKLO5xCoclHeP+u7REB1Doqq+NdB5ZTgsmqEj0up/rfFj?=
 =?us-ascii?Q?GyhNwfKCjwS7ktklvGrYnnK9YcAPjwCjGAUMnvO/6xBexgEZJbnlmdd5egJs?=
 =?us-ascii?Q?xtyuxom2Lq7FXY7FLZvfmmUsNC2k5/o46bVtMc61zwqve0ueMjX+JBTz7l0x?=
 =?us-ascii?Q?Avwwm/kXFXmDWWK5XzfNCONKOEGK7XToRpT1glMfzC+EOdcKb9hdxbGI9L1F?=
 =?us-ascii?Q?UjYpdWTQLrlbbjDTW3zMQuuj4HZhg089/0epVrPWiKYpfnMNOwfQwUyM5EAl?=
 =?us-ascii?Q?WHCCgjxQsP8L91k/m7T2T8/HMP/Lt4ZIxEtxKE0PKeTJJdmc2kGIgEpy3xGL?=
 =?us-ascii?Q?IMFYnElCcFBmAR3RtgdxKKuQlS2B/XgjAAODKDmgMcDjFntXq4lw5NFQWYkD?=
 =?us-ascii?Q?8RcriG4fDqwtGvRyAmf1tF8Z5klu8iM4iEV3Rz76TZWhNXnz1EfErMAwwZsA?=
 =?us-ascii?Q?gpyzDSmZZiqyPbP0BFdqAiTTcRw9URYRIQ/bvShMhMTSLzdxTa3YS6u/TIg?=
 =?us-ascii?Q?=3D?=
X-OriginatorOrg: sct-15-20-4755-11-msonline-outlook-746f3.templateTenant
X-MS-Exchange-CrossTenant-Network-Message-Id: 526cc0fc-27d3-45cc-c8d4-08dc3133f750
X-MS-Exchange-CrossTenant-AuthSource: ME3P282MB3166.AUSP282.PROD.OUTLOOK.COM
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-OriginalArrivalTime: 19 Feb 2024 10:17:24.4928
 (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: SYBP282MB4038
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Archived-At: <https://www.postgresql.org/message-id/ME3P282MB31662287F06AE5D788869D8DB6512%40ME3P282MB3166.AUSP282.PROD.OUTLOOK.COM>
Precedence: bulk


On Mon, 19 Feb 2024 at 17:14, Andrey M. Borodin <x4mmm@yandex-team.ru> wrote:
>> On 18 Feb 2024, at 22:16, Andrey M. Borodin <x4mmm@yandex-team.ru> wrote:
>>
>> But it seems a little strange that session 3 did  not fail at all
> It was only coincidence. Any test that verifies FATALing out in 100ms can fail, see new failure here [0].
>
> In a nearby thread Michael is proposing injections points that can wait and be awaken. So I propose following course of action:
> 1. Remove all tests that involve pg_stat_activity test of FATALed session (any permutation with checker_sleep step)
> 2. Add idle_in_transaction_session_timeout, statement_timeout and transaction_timeout tests when injection points features get committed.
>

+1

> Alexander, what do you think?
>