References: <CAAhFRxiQsRs2Eq5kCo9nXE3HTugsAAJdSQSmxncivebAxdmBjQ@mail.gmail.com>
 <CANNMO+LyVtwmYhzPX-A3G4EEi2OuD83zkyFndKD5gY8DWwdXaA@mail.gmail.com>
 <CAAhFRxg7p+Z=xAFAdPeuLeOvc+3DyKKJtg8PKfdE453yybfHMQ@mail.gmail.com>
 <20221207182337.sw37r7dd7fzrckva@awork3.anarazel.de>
 <CAAhFRxgP_w8ddYPJ3cJ4QZKQU7VWrH55MOYrxdceFBchDwuGrQ@mail.gmail.com>
 <CAAhFRxg9i6DrHT1cALBNztsnJ7OR3cawfCmyFA=J6=oDFX+h2Q@mail.gmail.com>
 <a906dea1-76a1-4f26-76c5-a7efad3ef5b8@oss.nttdata.com>
 <09C069FE-99D2-4298-B1A5-01058DE6CBF7@yandex-team.ru>
 <60ACCBF9-5BAD-457E-9EE9-CEC95A352EB0@gmail.com>
 <D40137D0-65E1-40C9-8C0C-820AF252BE31@yandex-team.ru>
 <ACC3312D-8218-4F30-8350-E8634BF1C5DC@yandex-team.ru>
 <SY8PR01MB9288C3D90276EB758E066694B68BA@SY8PR01MB9288.ausprd01.prod.outlook.com>
 <145F4741-008A-41BF-AE06-1BE1435DFB1A@yandex-team.ru>
 <SY8PR01MB9288F5CF03D38662BE59C628B68AA@SY8PR01MB9288.ausprd01.prod.outlook.com>
 <E751C6BA-6885-46B7-B62D-272C2A2A923D@yandex-team.ru>
 <SY8PR01MB9288335A3B81E8D6E121980FB68AA@SY8PR01MB9288.ausprd01.prod.outlook.com>
 <F6557898-D50E-4BD2-BE88-5A1A1785FB64@yandex-team.ru>
 <ME3P282MB3166E33F193D2E7B0CDB633FB692A@ME3P282MB3166.AUSP282.PROD.OUTLOOK.COM>
 <76472EBA-077B-4F6D-B84D-F0917A31CEDD@yandex-team.ru>
 <MEYP282MB316457B6810B840A012649AFB690A@MEYP282MB3164.AUSP282.PROD.OUTLOOK.COM>
 <7B300616-70CE-4CCB-A014-13BC0AF814CA@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: =?utf-8?B?6YKx5a6H6Iiq?= <iamqyh@gmail.com>, Fujii Masao
 <masao.fujii@oss.nttdata.com>,
 Andrey Borodin <amborodin86@gmail.com>, "Andres
 Freund" <andres@anarazel.de>, Michael Paquier <michael.paquier@gmail.com>,
 Nikolay Samokhvalov <samokhvalov@gmail.com>, pgsql-hackers
 <pgsql-hackers@postgresql.org>, "pgsql-hackers@lists.postgresql.org"
 <pgsql-hackers@lists.postgresql.org>
Subject: Re: Transaction timeout
In-reply-to: <7B300616-70CE-4CCB-A014-13BC0AF814CA@yandex-team.ru>
Date: Tue, 19 Dec 2023 09:25:27 +0800
Message-ID:
 <ME3P282MB316699E4C3A165983731076EB697A@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_|ME0P282MB4859:EE_
X-MS-Office365-Filtering-Correlation-Id: e434a275-1c09-46de-05f6-08dc003164cf
X-Microsoft-Antispam: BCL:0;
X-Microsoft-Antispam-Message-Info:
	7uo5zLft5MkTPU6i0IiGFE1rViF9Fooo86pTTJON4miu7+W9VMcNlP7lzMnt7BrOtmqXT8OkEm/RmJEA0KqNS99trwcIBEJ4lNC4pS2+thZKlaHjsWEVCqbe1aw/ZIJ36xpAqKjIfSk8TZPD2ifP8w+MVAf7rD8aXTb/R28Mo0yIDplqLhoRLvPgsl5YG65rNhyll006E+O00vVhVKXDYxvWT6pK7PWsCbXqiRtPB1CkLJwaCOPi7ECoab1HMFFtXXYjEkmjJGZjpqjMNOKcmph6/jGd6MZ4EBmBWwNJvD3jRLyD1bxjXlN6EvOKUtPPsyu4+MnDCSSA+KrDx8IA5WC4iBr0JtWgHRUTLcXwc6MEq+Y08ZT4FT70w2j6NFylhz0e+TWI6MMKk2Re0BfyFo6wqu4NWPg8xebMTV1Ti1jXZrxf5zHkO82p4wCLFtL2R0UDBuktjHu6FQQVJbUa542Rg3vFDYtoJ+xX4HNwzud+7XnYLWwEXUIs+Ys4KfTwcpZmJx5wXeBAaFkLwWeaEmGH+p7ON1IK4Bxg7tsYRLFbZo/7W1me/vh6/cNtfyag
X-MS-Exchange-AntiSpam-MessageData-ChunkCount: 1
X-MS-Exchange-AntiSpam-MessageData-0:
	=?us-ascii?Q?P2XRxdfFI0QJtp3XTCKpFNi+xnZozUJ6G8YECPUZ7fs+ux19cPnbkDdTxWfp?=
 =?us-ascii?Q?oAMfP0F9je2TamcAUw2HJVd1AXE+Ee//z1lgVv9WgujEVS4/K7Jd4TJL3Ioj?=
 =?us-ascii?Q?TNxlDB6A/px0Xqm4/oPY8oMKgnJAD7xiMlnlZ7SI5gdIKvgZtNfJAqfaq1CS?=
 =?us-ascii?Q?kIQt0ArKj7k1EEygJPbs/5Z+oC8H4zULzJn4pQDyLKOZIH9zX7yy2+30cfmO?=
 =?us-ascii?Q?wBIQu2yRSk4VBRl7Yvg4ZaSuIHvi1TjGMkvPgIr2QsHvKc9lJihbwLuginhO?=
 =?us-ascii?Q?kSaUCO0o4k4dK84hj+e3Puq26m82usCWMbh7sJk37lyb9gv9o76JWENFXH1U?=
 =?us-ascii?Q?O2bRMDGMo2uO9eTMWN+ZQJ/jWaqcZWalZ0lkA0WL7JFl4qUXIVrwQw9+1l+X?=
 =?us-ascii?Q?dIM0b4XajM7bR8w14lJT8XtH8zjg8ETs8Y7kFdRlkqwBxMdPjQx4IiXVoUf+?=
 =?us-ascii?Q?d+npv/FlEK1s+n1Wq8TEPPZ2e54On21JDgYa5bCOm+9Ai4UTLfccAqyj1WUO?=
 =?us-ascii?Q?H3TobO0rYwb0WLLm57La2igG3UMVSa1TIyfy8QEEyU2Gh6e71XzkyyxrT4ms?=
 =?us-ascii?Q?rl3Acwe3bwoUk9THJ7O+a+tA6D7hQGWjopLZvjMqbfKv22OrhIBOPbRGNs4F?=
 =?us-ascii?Q?sPwTlv9PeYS4KMdIbmL5O3tqleulMtZQ2k7A8h8xg9WliuT+ZiuslN3ONCVb?=
 =?us-ascii?Q?qLPWnRwclF/CNFNSlOPNfm3rwDlGufyKACtvkMV1YI6Yv0T0cHE22Jho2tYM?=
 =?us-ascii?Q?9H7z5KHJFgwxE/IicC1feuhJF6/slxEu5snNuPGs6H3QEBtqWx8r6rEd629i?=
 =?us-ascii?Q?SkMfNZOBvCAOb/n0Yc3+bWUCI48JWjAWLXP+I3T4WJamEai0vzQh4aK9GkKA?=
 =?us-ascii?Q?b7S0FnMIWnS+YcW7+prqold+37BA4cfBfCZ2mJUqIwIYzbPUFNgh4HZUyFlD?=
 =?us-ascii?Q?xxRESlxMw4uZxy3/0NEykleOA/n7XuAfCWdEPcNSZbnin1zBV/IigqNaxk0G?=
 =?us-ascii?Q?qnVEjOxfBU7eXHaRyafcgzCuWg0E4/g1ecaBIzFnQaH3kSznYdwk3MyuFVKi?=
 =?us-ascii?Q?9TurnpYADrGJoRVPR/vnbARYHW2x9JBKW8DJOGEEktmRAjM5HZ0IeCPcd4ec?=
 =?us-ascii?Q?1RPo25hzpjf4Xkl/K/Y3OxEJKQP2pW/7In6ZvNtEwUDWaK2KWFqfP028nMna?=
 =?us-ascii?Q?x5enbWouYBJmk3yBtUeVJa2zqJ4gdYWvLIS1QA=3D=3D?=
X-OriginatorOrg: sct-15-20-4755-11-msonline-outlook-746f3.templateTenant
X-MS-Exchange-CrossTenant-Network-Message-Id: e434a275-1c09-46de-05f6-08dc003164cf
X-MS-Exchange-CrossTenant-AuthSource: ME3P282MB3166.AUSP282.PROD.OUTLOOK.COM
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-OriginalArrivalTime: 19 Dec 2023 01:25:33.0281
 (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: ME0P282MB4859
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/ME3P282MB316699E4C3A165983731076EB697A%40ME3P282MB3166.AUSP282.PROD.OUTLOOK.COM>
Precedence: bulk


On Mon, 18 Dec 2023 at 17:40, Andrey M. Borodin <x4mmm@yandex-team.ru> wrote:
>> On 18 Dec 2023, at 14:32, Japin Li <japinli@hotmail.com> wrote:
>>
>>
>> Thanks for updating the patch
>
> Sorry for the noise, but commitfest bot found one more bug in handling statement timeout. PFA v11.
>

On Windows, there still have an error:

diff -w -U3 C:/cirrus/src/test/isolation/expected/timeouts.out C:/cirrus/build/testrun/isolation/isolation/results/timeouts.out
--- C:/cirrus/src/test/isolation/expected/timeouts.out	2023-12-18 10:22:21.772537200 +0000
+++ C:/cirrus/build/testrun/isolation/isolation/results/timeouts.out	2023-12-18 10:26:08.039831800 +0000
@@ -103,24 +103,7 @@
     0
 (1 row)

-step stt2_check: SELECT 1;
-FATAL:  terminating connection due to transaction timeout
-server closed the connection unexpectedly
+PQconsumeInput failed: server closed the connection unexpectedly
 	This probably means the server terminated abnormally
 	before or while processing the request.

-step itt4_set: SET idle_in_transaction_session_timeout = '1ms'; SET statement_timeout = '10s'; SET lock_timeout = '10s'; SET transaction_timeout = '10s';
-step itt4_begin: BEGIN ISOLATION LEVEL READ COMMITTED;
-step sleep_there: SELECT pg_sleep(0.01);
-pg_sleep
---------
-
-(1 row)
-
-step stt3_check_itt4: SELECT count(*) FROM pg_stat_activity WHERE application_name = 'isolation/timeouts/itt4' <waiting ...>
-step stt3_check_itt4: <... completed>
-count
------
-    0
-(1 row)
-


--
Regrads,
Japin Li
ChengDu WenWu Information Technology Co., Ltd.