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 1uzhU1-006HIO-GT for pgsql-novice@arkaria.postgresql.org; Fri, 19 Sep 2025 20:13:30 +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 1uzhU0-009Gde-2W for pgsql-novice@arkaria.postgresql.org; Fri, 19 Sep 2025 20:13:28 +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 1uzhTz-009GdM-Ce for pgsql-novice@lists.postgresql.org; Fri, 19 Sep 2025 20:13:27 +0000 Received: from fhigh-b6-smtp.messagingengine.com ([202.12.124.157]) by makus.postgresql.org with smtp (Exim 4.96) (envelope-from ) id 1uzhTw-001KMa-18 for pgsql-novice@postgresql.org; Fri, 19 Sep 2025 20:13:26 +0000 Received: from phl-compute-09.internal (phl-compute-09.internal [10.202.2.49]) by mailfhigh.stl.internal (Postfix) with ESMTP id 37D957A01CB; Fri, 19 Sep 2025 16:13:23 -0400 (EDT) Received: from phl-imap-16 ([10.202.2.88]) by phl-compute-09.internal (MEProxy); Fri, 19 Sep 2025 16:13:23 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=de.me.tz; h=cc :cc:content-transfer-encoding:content-type:content-type:date :date:from:from:in-reply-to:message-id:mime-version:reply-to :subject:subject:to:to; s=fm2; t=1758312803; x=1758399203; bh=9t flf5qZO3l4RHCBHWrWsEaQth7ADgbnUeHDkXIgF0Q=; b=IxoyjyEW5eRm7bgtDb WzmVeA/ZJ0tbDJ/k0J6iGfeGOyb7kXg+38+iN8oCkofTgR/yBVG2e9mA1B63eT9K RyOILSfleS3UbxnH0xYkQkNh20Oyvhw3Vev/42Wj6KnNRTeBJgm/n/CEzufA5XnU eoSiEv0T1JkhHAQigM14PKAUDjF+rWwmmhs6b/L6nphkz3OH65AHGVAAxgp3Pknc r82n2QXnZCfTx2J5hazKE7ZpDnE9RihEjqIQswF9cSB3jorIr5Vr0/dbLxtXQkid 3IkgIuEAQymidlch91SVbEM2eXdM7jtCl1+jOATcKlMz43qP0eVfC2rm/Jd08hoQ MTvQ== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:message-id:mime-version:reply-to:subject :subject:to:to:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s= fm1; t=1758312803; x=1758399203; bh=9tflf5qZO3l4RHCBHWrWsEaQth7A DgbnUeHDkXIgF0Q=; b=LPEjqfKW4Ogw+83MAn+4pJF2AaD6wPV46AV+XImFYOwg u3lHOPkn67MwSgPNoD6ELbqJdoOnWrLT5i1eldmPc5nqtXLGf5DbIvWltuXW2L28 i4N+xZ4ALqN60aAT5paKSLLmC1ZpjTL85OcdKVeN2pTQHh4vOuOCa3fVywwpo9CR EWkW5XEHcka/ZhkQNOrAJ1yBf01042emPQPeYzBGx0epAek/vOQCG4mde9O22bhn XeFe4DRV6HgvqI5iTK4y7tRXd0NUePcN750400S9/n88JcsK7fD7C9C1ZDkoJ8m9 tWzgZIgb24YByrcstw6bLvlEzaYmjO88OrzQX9xS2Q== X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeffedrtdeggdehtddugecutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpuffrtefokffrpgfnqfghnecuuegr ihhlohhuthemuceftddtnecunecujfgurhepofggfffhvfevkffutgfgsehtjeertdertd dtnecuhfhrohhmpedfsfhuvghnthhinhcuuggvucfovghtiidfuceoqhhuvghnthhinhes uggvrdhmvgdrthiiqeenucggtffrrghtthgvrhhnpedvudefkeefjedtgeeigffgueejte dvudeujefhhedtgeethfekudetfedtkeegkeenucevlhhushhtvghrufhiiigvpedtnecu rfgrrhgrmhepmhgrihhlfhhrohhmpehquhgvnhhtihhnseguvgdrmhgvrdhtiidpnhgspg hrtghpthhtohephedpmhhouggvpehsmhhtphhouhhtpdhrtghpthhtoheprghmsghorhho ughinhesrggtmhdrohhrghdprhgtphhtthhopegrvghkohhrohhtkhhovhesghhmrghilh drtghomhdprhgtphhtthhopeiihhhjfihpkhhusehgmhgrihhlrdgtohhmpdhrtghpthht ohepjhgrphhinhhliheshhhothhmrghilhdrtghomhdprhgtphhtthhopehpghhsqhhlqd hnohhvihgtvgesphhoshhtghhrvghsqhhlrdhorhhg X-ME-Proxy: Feedback-ID: i7a6842ed:Fastmail Received: by mailuser.phl.internal (Postfix, from userid 501) id 98E272CC0088; Fri, 19 Sep 2025 16:13:22 -0400 (EDT) X-Mailer: MessagingEngine.com Webmail Interface MIME-Version: 1.0 X-ThreadId: AB6uwmaXg6vF Date: Fri, 19 Sep 2025 22:12:59 +0200 From: "Quentin de Metz" To: pgsql-novice@postgresql.org Cc: amborodin@acm.org, aekorotkov@gmail.com, japinli@hotmail.com, zhjwpku@gmail.com Message-Id: <554670a7-7560-4d18-8ecb-8518fddf2b9d@app.fastmail.com> Subject: SET transaction_timeout inside a transaction Content-Type: text/plain Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hello, It appears that changing the transaction_timeout when inside a transaction does not work as expected. Running the following script on master: SET transaction_timeout = '1s'; BEGIN; SET transaction_timeout = '3s'; SELECT pg_sleep(2); Fails with the following: FATAL: terminating connection due to transaction timeout server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. A workaround is to "SET transaction_timeout = 0" before each override. But this resets the timer, which may not be aligned with this parameter's intention. Thank you, Best regards, Quentin de Metz