Warning: mysqli::__construct(): (HY000/1203): User howardkn already has more than 'max_user_connections' active connections in D:\Inetpub\vhosts\howardknight.net\al.howardknight.net\includes\artfuncs.php on line 21
Failed to connect to MySQL: (1203) User howardkn already has more than 'max_user_connections' active connections
Warning: mysqli::query(): Couldn't fetch mysqli in D:\Inetpub\vhosts\howardknight.net\al.howardknight.net\index.php on line 66
Article <mailman.3.1725902969.31645.python-list@python.org>
Deutsch   English   Français   Italiano  
<mailman.3.1725902969.31645.python-list@python.org>

View for Bookmarking (what is this?)
Look up another Usenet article

Path: ...!weretis.net!feeder9.news.weretis.net!feeder8.news.weretis.net!fu-berlin.de!uni-berlin.de!not-for-mail
From: Karsten Hilbert <Karsten.Hilbert@gmx.net>
Newsgroups: comp.lang.python
Subject: Re: psycopg2 positioning of .commit() (Posting On Python-List
 Prohibited)
Date: Mon, 9 Sep 2024 19:29:27 +0200
Lines: 12
Sender: <karsten.hilbert@gmx.net>
Message-ID: <mailman.3.1725902969.31645.python-list@python.org>
References: <Zty7ZCMwKQl4C4Id@hermes.hilbert.loc>
 <4a1b12fc-24b7-4c7e-b1f2-6ec9c5f341c2@aklaver.com>
 <ZtzDubguRDWXwV-t@hermes.hilbert.loc>
 <mailman.46.1725744071.2917.python-list@python.org>
 <lk4ajkFbbnrU1@mid.individual.net>
 <slrnvdr13p.4dt.jon+usenet@raven.unequivocal.eu>
 <vbl2ig$222n3$2@dont-email.me>
 <slrnvdtf24.4dt.jon+usenet@raven.unequivocal.eu>
 <vbmge5$2c7jr$1@dont-email.me>
 <slrnvdthpa.4dt.jon+usenet@raven.unequivocal.eu>
 <Zt8wd9ltA1hhU9F-@hermes.hilbert.loc>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: quoted-printable
X-Trace: news.uni-berlin.de erFIj2HbTIHERKk/e1CxeAf9Ewo+l19Qid9APieN7syg==
Cancel-Lock: sha1:7hDtVF1XZhiJ4I++Rx0/NGgjB/Q= sha256:/0h+9jfVjw14rXuJiIwd9nlZjvNs7BzVixig5Ui2rs8=
Return-Path: <karsten.hilbert@gmx.net>
X-Original-To: python-list@python.org
Delivered-To: python-list@mail.python.org
Authentication-Results: mail.python.org; dkim=pass
 reason="2048-bit key; unprotected key"
 header.d=gmx.net header.i=karsten.hilbert@gmx.net
 header.b=TdSmvW6D; dkim-adsp=pass; dkim-atps=neutral
X-Spam-Status: OK 0.031
X-Spam-Evidence: '*H*': 0.95; '*S*': 0.01; 'thread': 0.05;
 'received:212.227': 0.07; 'gpg': 0.09; 'karsten': 0.09; 'schrieb':
 0.09; 'subject:Python': 0.12; '1713': 0.16; '2024': 0.16; 'pool':
 0.16; 'python': 0.16; 'to:addr:python-list': 0.20; 'exception':
 0.22; 'returns': 0.22; 'code': 0.23; 'execution': 0.32; 'sep':
 0.32; 'header:In-Reply-To:1': 0.34; 'mon,': 0.36; 'connection':
 0.61; 'received:212': 0.62; 'received:91': 0.62; 'transaction':
 0.64; 'subject:List': 0.71; 'database': 0.80; 'jon': 0.84;
 'subject: \n ': 0.84; 'subject:Posting': 0.84
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmx.net;
 s=s31663417; t=1725902967; x=1726507767; i=karsten.hilbert@gmx.net;
 bh=mazSFoRhVcBIl0Ip/kC9IHYlj1FZXmgLjh0zU6HAJVA=;
 h=X-UI-Sender-Class:Date:From:To:Subject:Message-ID:References:
 MIME-Version:Content-Type:In-Reply-To:Content-Transfer-Encoding:
 cc:content-transfer-encoding:content-type:date:from:message-id:
 mime-version:reply-to:subject:to;
 b=TdSmvW6DeAGjTN9UYDQ2sfLXHWdhkYYv1jdUxpOfFMKUHBylmOJ+1S04fR3Nz0Qv
 hYH3duQqVZWgszOhtOmeh5S+jwk5ulYBQ3mxqnVehI+TmrTlxo+JOw+QBY3lSX2Fq
 HVaK/G2xCr63E+WvAu5aipYj8JjI6+e6RYN4/uU4H5wPFEdN3khxTFRplnuTbRvb2
 GsvVhlBtU+YuXZKQItaTULjLNqskSluqRd70FuFp/kDT63ef8uaSlj/KoYSET/55D
 G0Gno0z8GW3Pma0cK9EG0fUJCw+8+KZNqnlyXmkEqkgvaQbhQdbkPuToZEBHi0J0i
 XPCYOF6UQdyg2h3ygQ==
X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a
Content-Disposition: inline
In-Reply-To: <slrnvdthpa.4dt.jon+usenet@raven.unequivocal.eu>
Ma_X_il-Followup-to: d
Re_X_turn-receipt-to: Karsten.Hilbert@gmx.net
Di_X_sposition-Notification-To: Karsten.Hilbert@gmx.net
X-Confi_X_rm-Reading-To: Karsten.Hilbert@gmx.net
X-Pri_X_ority: 2 (High)
X-Provags-ID: V03:K1:iMfjhIe4agvphxYgxHeY85UcB75JBurL+Jofyw8tPFtpY+oC3nA
 1Ufq07BqUZr04fOUxKlqdpU2zmmBBXjcUxzI1/dRsJ7BtZ+LrOdE15sDNb6VxR5fumUJKOs
 qLaJvlUnKtIY0eKbteC9Yt6aCkCxhC8fbE9bCKSRmAdBCp6++3+80E0gwedoy5Q8nepi8au
 rEs/zVJBVbBZ+rHZpwAFQ==
X-Spam-Flag: NO
UI-OutboundReport: notjunk:1;M01:P0:xUTL3WnGMNs=;c88n+mGSiBJzZQUmVUg8Qj7sXQn
 d0G2B8jjR4GeTAKFTXL4zdDnykMM845yJhgfiVh8y4H4lD3i2BfRmZ+E3NIU7momedqb4R2jS
 z0tKWLlpRSDx/rLjZN2MYOFjwsQzAvu8P9QG7jlx3OzQc6Ylv423zTmLzlruXyYDFom5j8uHn
 PiRSGag86K9kkssHBnl6vVOJefgV+//tTTEgy+s8yrbDK3MiPtZUNtgUZ9rdVD65ZCO4W7VKJ
 qyIQoJoXoYgXCf/4yG8EFZgllERlTGS/Di+u1K9rgR+lU6pbaSRhiJnEBMsV+GlCi3+/DfgbH
 5jaNBaYDhhaUaqYbIFqH99tgjG329hW36a+Surxb5TQj3itVLZ4iM1HrLnkhJ5VUegw2P0oc+
 ikyKSwSlH5Cm0PoRzX5/jCDtxnt8jyjHKcSgxd3IF+Pk03/NtmotHc1hQujjmzsFXzyPdhNCL
 Y8FsUaz2AoZzKBiA8QZdDHgDd829mYhPTRHl1xUx2ocjRnXHgZFWMMcqeIbZh8vipDOkV4A3M
 UwnjI0xgvax8Cwjda+kionUyZw+jtL6NQwUkHQKSaCc0V8f6l1/Bxrid5VXmTkoXeVysUJjTt
 lVfzhEKAAxO/dNYdTa8XhlnY9Rji1zjvQLV/VXJ7JwN8V+0644wOlC/bRkfYZbyOHBTylUsnz
 AD1b64Z7l2TDgGhNZFpefvoQm7C4Tawjxm+oO1bNdVF0ZGPIQU+Tcy0JNvMB50GX+AiClTRmR
 w/WQ9SXeUmwusrSTvA32ZIsUYzljzayJSGmKLHGLp3dyHCy0V6s7s3bb0y2+lyLTNX1Vtu6KM
 QV9z9Gb104CgtmMUQx1IV+EQ==
X-BeenThere: python-list@python.org
X-Mailman-Version: 2.1.39
Precedence: list
List-Id: General discussion list for the Python programming language
 <python-list.python.org>
List-Unsubscribe: <https://mail.python.org/mailman/options/python-list>,
 <mailto:python-list-request@python.org?subject=unsubscribe>
List-Archive: <https://mail.python.org/pipermail/python-list/>
List-Post: <mailto:python-list@python.org>
List-Help: <mailto:python-list-request@python.org?subject=help>
List-Subscribe: <https://mail.python.org/mailman/listinfo/python-list>,
 <mailto:python-list-request@python.org?subject=subscribe>
X-Mailman-Original-Message-ID: <Zt8wd9ltA1hhU9F-@hermes.hilbert.loc>
X-Mailman-Original-References: <Zty7ZCMwKQl4C4Id@hermes.hilbert.loc>
 <4a1b12fc-24b7-4c7e-b1f2-6ec9c5f341c2@aklaver.com>
 <ZtzDubguRDWXwV-t@hermes.hilbert.loc>
 <mailman.46.1725744071.2917.python-list@python.org>
 <lk4ajkFbbnrU1@mid.individual.net>
 <slrnvdr13p.4dt.jon+usenet@raven.unequivocal.eu>
 <vbl2ig$222n3$2@dont-email.me>
 <slrnvdtf24.4dt.jon+usenet@raven.unequivocal.eu>
 <vbmge5$2c7jr$1@dont-email.me>
 <slrnvdthpa.4dt.jon+usenet@raven.unequivocal.eu>
Bytes: 6068

Am Mon, Sep 09, 2024 at 10:00:11AM -0000 schrieb Jon Ribbens via Python-li=
st:

> So the Python code is half-way through a transaction when it throws
> a (non-database-related) exception and that thread of execution is
> aborted. The database connection returns to the pool,

How does it return to the pool ?

Karsten
=2D-
GPG  40BE 5B0E C98E 1713 AFA6  5BC0 3BEA AC80 7D4F C89B