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 1uzhcE-006Ib5-4J for pgsql-novice@arkaria.postgresql.org; Fri, 19 Sep 2025 20:21:58 +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 1uzhcC-009LPh-QD for pgsql-novice@arkaria.postgresql.org; Fri, 19 Sep 2025 20:21:56 +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 1uzhcC-009LPZ-F6 for pgsql-novice@lists.postgresql.org; Fri, 19 Sep 2025 20:21:56 +0000 Received: from mout.gmx.net ([212.227.17.22]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1uzhc9-001KR9-2v for pgsql-novice@lists.postgresql.org; Fri, 19 Sep 2025 20:21:55 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmx.com; s=s31663417; t=1758313312; x=1758918112; i=lazyvirus@gmx.com; bh=bm/57VjAWT7iZHZRCDisYp4SbeKZYxBh92cPFndKcvg=; h=X-UI-Sender-Class:Date:From:To:Subject:Message-ID:In-Reply-To: References:Content-Type:Content-Transfer-Encoding:cc: content-transfer-encoding:content-type:date:from:message-id: mime-version:reply-to:subject:to; b=sqOCiwUiZUKxOODFwUbzxXIF/FFf3pdgZPCmD4i+HeDYL7YYIa3Q0bOk7ebXN58t 7hi0WoW8t1qHOLMLfgU/TnDw2REtKgeCt7vztD2bV3MfV8WgSex7FePJRnK4etdOd 9rY2WFOzkuGN3Rc8ky3GjyEe5CjqqQOUCX4V7gFmTQOh15YSEWV9Em6KU2fb7vMh5 jJSqlxWo5DCIG/j60su1qH6itOtoYqgBBr5ULN2jU4/f5K7fY7RpT+Oovg27y8atS wWG4sdSH27x5ENTiL/r+qc8pAuxyctQHF5C3kmcQUfR4BHlmfWscCl1aTJXYdkvx3 RMNL1IcS1MpWnK9e0A== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from mail.defcon1.lan ([93.15.31.113]) by mail.gmx.net (mrgmx105 [212.227.17.174]) with ESMTPSA (Nemesis) id 1MjS9C-1uXTLJ3WkU-00kNgA for ; Fri, 19 Sep 2025 22:21:51 +0200 Date: Fri, 19 Sep 2025 22:21:49 +0200 From: Bzzzz To: pgsql-novice@lists.postgresql.org Subject: Re: SET transaction_timeout inside a transaction Message-ID: <20250919222149.27ab94c8@msi> In-Reply-To: <554670a7-7560-4d18-8ecb-8518fddf2b9d@app.fastmail.com> References: <554670a7-7560-4d18-8ecb-8518fddf2b9d@app.fastmail.com> Organization: Anyone, anywhere but in banana demokratik republik of france or uerSS. Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable X-Provags-ID: V03:K1:9OW1053c0e0K1Tzw7Cm1RgJbfqJ5VxFbasn71kSfpozfEJlZ1Fc MZ51lLVDhkZrmr2QMH6pCMrCX3ZSAv5JzOyhnZT1/sbFH6ouppldkO9TffKrAOCHogJdxTE VvEsDFCWoKyre1eWM+3OA9yPlFwMyT6Vl/JNWTtTTkgVAjhHXq2kZkZ57XnukafK+eMKsMJ LvHFr72OrtcTjdTMGs8kQ== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:5jI9YhRuRw0=;f+K73O4G+75QqSp92WH/iFMCwiO apXe3c3IHQ7B8BZ5laURWXiwbwSAaem7B8HD36PuLRHB2HcLhjEfAP77/Ntn9/3WwkTUwsbSn 5SpF+3ypOYz//Qrao//J+EvMtFj78SIoRg3k9cRC+2NxylRoqQWle2bX5KvIWLWt1HEyaS4gj CLEGfX/eAkVClHnCivltovDIuBNIHlfBkz9bHDMWkbiglG6dXws5/ixF3WTINyVw7dPgJukTV 2Pzxc8cQQXtMEhBEBoNIouwX4GxIRcjrnjBvt+Nq+j93pSoN0T2kYDsO4ZYa6tQiil9uNRu7D 7qU8zoB3R5x9on5KAfhrwzNMwbnREEYmG/tWTHuBD7Ht7xRKjKzppctTe+syRfkYcogLUHK9s qptxuZXMiLCZ6RJN4ZuIVOAM+I2kSKEf3fATw5qaaJ8EAUEr+XUhDOPDDH1v0Ba26JH8jbEQU gKjGpDmrfefak8y5+78/Nsif3PnrT+XsXXBI9DWTsXBnnVHJXLl08gG+SX+KmzH+QEIHaaCo/ oDpZvgyJECkRYoE1KVhxaw1jc8PXE6bgKiTOk5V3n/f8jydt9vl2wWeQYJ7KtRKM7cVyf05Ao nTUprZmx6gX0HQJljFJHD0Wdtqybdci4SOrLe/Nn+tOn1UjWveFMt2qoIDE1BEB22DE+Yj2hT qJeSlBGwWHf8YRfLF4Jjy2o07EV95hq3zJjU/PNU8wLWfgByjZLQ+eS9HQMuQ/DS8506GRYiB abEtahF1C3UY0yIg8b3vPfZKDE1isReV7z2XchevLl+azkwzHpAAQR8JXDZqAw/Jd0g16aT6x iQeqeBGgzfSUrUXHipLndXds1lSREnZrEY3g6QSKMeNYBmjHJQYjusqsQkwUBl4/Gbhi7VrDz Bc/XL28n0TULvxfLx//kAfRDA51aLEyNNiRZT0WWcsnPy0UghF2CRuWNmBTJNfxM4oyX7jOIO cJC2N7oYj+NeB9cf/YbA6wtsaKcTKTJC2edf+1A96HVmss1kHp3EsI4F6n5huE0zMhhZq+4ZS gvLAOcNIaa4ce48gLMj1Reeeh/2f7XCylRiUc5XQRdF6NkYODz/Kt1T4cuVEPtToj7qWE0UpE GW8RsSIm0hIoGjLdt8yzSep/JROv9ev0i+iAtxqGnoH3xsmKYnqTW+jQbaSS7gw4EDtMaPDch 60rAdz6Lhmy+iN84IVxEiZOFRskW0DDLWcCuGKJ01g1In59U5DhPHQirlAok2kuccdsLQGge2 +bzlBmBfNWJiIqqtTrvupbvK9Y1KHqUDe1J8qfamv1xh+35GvvIZsXS2PxJP7ew2XYrfqirYd V1vc/I7pUvW6QE6LEvBFpwCKe4BOOLx3NMUE01BY9J5u3VKOIoVUoL1t5i5dTLtn8yvA+V4jU FmlDEWzlGD6EHAylxYVB4rn/xU5nnO/sBMNIA6aigAcs/satZIn6kPwiDoqQFk5syFkX18Hlc vl7n744Euvp2f6wKnJ/eKZ6mRx7GOYW8jR8tDrS09JreuS/RPNqiGyT0kZCQnlgth8aYCgel5 qDRNubSivymFeGIyt/wrh3zqp14/y4F/DqsvlYWRGEwc3lQDx2F23DWfCgWkhjRGVFb9qb6VM wVj8iW6gtg8htHE6UHVSksUoqxCDxh5YTD3A6YzfBfubIC8gKJYXXnLOarK20sF7IiQ+tTVv4 dYTVZdvJIHgB/80jF9rb9HdKY8sI9Os+hSEXfcMGfUHjhDRYMCjqC12nVi5JdZIhmGSaDLLUj JRWO6uH8PEZ66znrXMueLMhwG/2fNcW8g3gf2nQ+yAltXz2zXtnF/FM+JZbFAATabjq+iyUiu XW2tsjQfepMv2WR2loaFVfFgqkst6guk7qtrPmFwtVoFp+yjIO092rsoiaFNlPOK3r5CVU2G2 R/3Z9NQWCmyO0ipShO/lrEYxIla0gs9RabcINJ3pSoIJJ7937N8/YGsZMdOrBjhKOdIGCUSQ6 Ei2ptXjI0qfOC05qgo9AARhs8UFnZfJk28c3kTEtT0EAbEmlYAMs0wAO6NbpC705ZgdQQrpt2 5MOa0ctf4CtWOdw1rM86WktqZ2aki1vF/6liqJDp0AxEgAVySqXKJAqkdoHrpVntITDXT5tCB iz/RH9MGCdyLXmPtCVwT3/x4gS0YFkgUjVzJt+DGXtSPVZPHKXoNbD6Qp/GOSkj/SXYT5YpWH 52akEZca9/UImr/w+sfNUksekNOEEAaZ/xIAEOr4uDU2xAPAqyVtKiHZv+l3JNBciNDNNbzqh 1NsjevYMTFk96+5txfNp5WEMLOiLbBYUZFGCy2knmL/diVc35Sh9qSpk2pAy8PBBLP6m22DjM 6nHhIN10k1eg+IFhA84+hKxY2oY7kjYUtu93yZJ7AGvjDrc4VHpLZTUcN4LKnE1Eg4iMOQltj jj/TveE+x9lKRuY4UP0z/IV6izjTDs8KPOA5i5bFRSE2USv0njfSAynNe5CErdLkkMggu2ylY UBLobBXKj5GL4VBkuEHECtY/I5k4Xpn9CXgiPLeDzMwqtjD9HdiuTAR8ovjeRpX0xU77dOAiw EZkox1sHiTnRgY93c/MQlY9aoe07LyDBtzl5zUSx2g3Jk08Kwu06M7RmqbgXOGl5Uq5hb3s3H milBtT5i+ba33ovOjJFqVNh1Lkkj3w2fsQbaMMEWDCqj8obuw6er1/L69tZbwecTx8H07PSsk c7m3OjgimvMifAHCKBz9kjyHuuXmgdp9hbxMGLmGV/dgbRVERHddXsjgwl32xN8o9SIj8xDG5 EwWq++csqr36Ih9sdduE2RgIS5+4cleNjw2iIolENc1iO3e2v0e4HzO10PXSWrPxKDXSX2GNM eg54AC2FjwqQ8YH8ooRHci9KLlp6A7r1JwG0sWKrzaYYcL7ZSelnp8AoGmOKMp9dY9igwtzoA RBjX7BPaGutrKe/ml/1KrCQ6Y2EsDahhNYHeZCV+QRWvAFCEkR74MkXFNELqTlBdg9JthKSEU 1+zxeRl6t2sEFFiQXM4WmyCP43nCa7b/zNdyD8uiX3VzOSnfcbW49e2qTpz0Ty9H2qPLrCkAL y1WUy0xFc/djdjXEa95aKpBXZw2LZVJQKU+g/Tr8787HBItCKQoXfA53rwco2y33kXsQDDS8I N1oRmrGs9zrGs8jNgiZ/jZA5+RDOrmsxkoyhXFXnNX7vr8kqpg9TOpSKfavaPC+whCXEPlubE B8Wf7M4owCNzw4jj7WuDeM9/32WNzU2oRhvqJpNjHQfYAVp2h6ZIAFmdaZFgKqfcMAszKUVzM YkDxhZwCz/YTCBfGNJw1aoVCqdFE502C3NgdPSTfG6U1fNj9rnE7LVCpJ2CO8OQnCAmB47iS+ S/geCkl+zjJsS2R1WaYIkuigXU5t5df9njtFExFvOJ49sUlvdlSjpLkze9Jpn64DSJQRfhJ1z A5HWgewC2f+FfElQAscsNMU37Ub94vyo5qOqyUQQQEqjNrSfoY2VYkTzY1OyXI7QT+i2WptP2 pPnlO+CJWe1rUVHAb496PCFbrA0tqYMdXezouAXRcjwOTQryze2btLYq6Qi6jeD4k/mZu3mGe Ed5aBARobOJkhzVSd0C1v7ZviuYmwbQ9zJ8k4xPvmGrkauiDvjj/nHSVXKc/LNLRS0toYWNyk b1UCy6VfcCQ3QB11+1NUZRb3MihziywNxKvMpfsvuZlVkLho+7keP2lLNUMzOmXGxXwFErKkE usc6v8vgPiUvoN589d0P9FicE+WNtX69LtF0T71qMu/NPlmAhfIYSICNGIjJoNntiGi5cIm83 EmCJJsvmASCW8uzVtzZqhptOT0BdGXM8NBbvH3xvQEogVlBiMIDrx65aXSx7vhiDv7XeyyDPO T5oC5zfOtr2BHsO6Z1qSHOnA3mDqOBXoaGekuaDPNEGN+7HzxaI9xdri1jroBq611E0yIwP0O rZ+gr0fFe0+VJcVI1UB/FeY7b9ihTsRTtsEco1stjdY7CtAXBHB7QjJOM4bQy3iloil2BR+RZ f0Yt4hE1WW5X+CIna8RY+gZBxV8CX0G8QXQ7jor0eTqbJWGprbj0LD009IwZxdHMje1+Wuqt4 2qrAsBrey4LcxBqyiSGpBmeHSPDh01XBjk+K6khz3z8iz39PqWqShwEtrnVeEgwOwhLDz5L/f oOuubMBvkwytJZFSGUhpv3hQ1qJNopovLbvzuqZHiTvacoqs1zoeDgzrBbVaqh4lFbI9gtF4b nt6aEzmKZYzjqrZDQK0tf4cuTR1wGGut0tKZf9Hf+6OGLLXJgHnBnltW+QBCC0gEVSWgmKInX cf6v75zTgoxWqfgxrd+4lmjokRCp3qnZmL5vBCjpAYrE+6Jig3FB/0j9V0PgC/0Yt8qQtGEyv buRWhU9k3Tg0RDBsWJBiIFjdrAkrN1kRsWSxB7fZ6obCMhm1aDeVVYAkpZCIiRcWOuM3NI98b F6kveov3Q8LdVQO/pZNNDkvS6yftpK/0kEYyDzjLVzow+V8BfynsclvUguevkee8JLGsuUU1y e4Xi4Knfm2YTikrm4h7PvNMfUXCkj68jC70Uix/t6UxlK3UH/WU+8wF96yLfvP+pEM3l290ie eTgvxRPmL+OcQnxp5xGTZ1FIjoP5W/c2AoPOszyyS8obMdrPFB4MJ+wVpyfjCSIDinMCqtGua b4tVLACIA77Bq7Bz1qjXVVWP8zsABB+vbXs196EATp7tBCV3vdijpYQX64Q== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, 19 Sep 2025 22:12:59 +0200 "Quentin de Metz" wrote: > Hello, Hi, > It appears that changing the transaction_timeout when inside a > transaction does not work as expected. >=20 > Running the following script on master: >=20 > SET transaction_timeout =3D '1s'; > BEGIN; > SET transaction_timeout =3D '3s'; > SELECT pg_sleep(2); >=20 > Fails with the following: >=20 > 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. >=20 > A workaround is to "SET transaction_timeout =3D 0" before each > override. But this resets the timer, which may not be aligned with > this parameter's intention. You'll see what others will say, but it looks pretty logical to me to forbid an action on the one parameter your transaction directly depends on when inside it. Jean-Yves =2D-=20