Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p1QSi-00064u-Js for pgsql-general@arkaria.postgresql.org; Sat, 03 Dec 2022 11:13:40 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1p1QSh-0002eh-GQ for pgsql-general@arkaria.postgresql.org; Sat, 03 Dec 2022 11:13:39 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p11fW-0000r1-7P for pgsql-general@lists.postgresql.org; Fri, 02 Dec 2022 08:45:14 +0000 Received: from sonic315-8.consmr.mail.gq1.yahoo.com ([98.137.65.32]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1p11fT-0006RO-JM for pgsql-general@postgresql.org; Fri, 02 Dec 2022 08:45:13 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1669970707; bh=x4YN1Pf99+0dt+1c9daSIGlrmcyOlmHD83ly81FLDcI=; h=Date:From:To:Subject:References:From:Subject:Reply-To; b=Qh+SFfdqwjqkzttvVyLbxDBu5uk1LUUcQtq/F9uvm3tZQ9Jaj9ov4wvSrhQBIiCNXYS47iSONlB8Rn+EdJJeXheBuuBNPVyQOEcCo8q7em6qrVVMZ4iZosdvYV7gCVPcw4bRjdaXU6XPjM5QLENyipssDbZiM3rVl8j3nmeyjqVyIOVT9J/VzHbyjTXevjM7Q0eE/TwS+6QFofyZ94hEvIqrEiWy97kUKvLo7kTZwWqbp2Rd0sw5n4T6058AJm+Rcf9yvJIXJiDHEbnHQI9pZk5ss90R7QoQuq7enw5LWI36rbUOCz8bsiYG4gzecFsU43NeMvu0batM14/eJuCEDg== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1669970707; bh=dVEFTm6GHPz44fBKBqNf6hOmMe+wJslGyc1agpaWxn3=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=QvJ7GAvpjtD9MOrcqArotem38bzR7c4pazKHl7CtqMhB4Nw+UJn18/85TVe9FG162kAdCVdJ+rn3fGON4eNQxJvgrtkmjsguJ5/siT853ohh5AAhNDhkkd44V5Mwqk0/1kWFH0rrrz/Idsq4FNypkEoIDb7eg9M96d0QjiweCoC926rrJy59nrBRELZsEgy7TaljNHMCGhihSGYJKKSKuF2DSsZPqyuwn52kV+VQLHZ159o631Unw9ilDgsHQ7nAp9Y+HbxrTwgO/tJwGs7hN+na0UTwVexVij2Wk3SrzRP6ID6rIIblLmgEyNdyU83HA5AEC7ZRNph3KzsrlnCCnQ== X-YMail-OSG: Kwkq9PsVM1ldB25gavvsqAhs2mijEcUGfH83Hwo9XEO7CbXeQr2CyFbLvgdTIRJ 75dxqSMnuZgjBIMp_uPfo1zo4kKMT9HpKtKakomR7QhMQ6ycOXm8RMyPlgYoTgefS1wQgr0t3W8r v8CJteQwLReP_BqwwG6fEH_mtestTPVuJj_RV57brAfNpwbYgwL.sif8CDdbePI8523Bl3.kxOfJ kqllL3jyQ7UISYobnZmR9iM8Syy_.SdhqFjipFI71TOv0KocYe3wVwQLksI0XiQBNi5A0yKz57Ga Zax4P69_KCFjxPA86jw9ThN3I28_HhlltD0qSgBW1qIyNk6nFKEtjCZQVS5hx4._Z2mzlgnPkSEf zF2q0rbk5sB_uA51hWvfP8kxs4hZgQJGgsERI938bY13J9kA5IPdPaU5lySFTVbuN.ZFAgWBzIK4 oGhlOBf5Mx.2YwuAT8uwSRD81V20KLmdBsX23JrSkMOPm7hz4TBfkpoyiw6dWQPpQ1scOK2NlNe3 zgEP3XMxW2JRC2pAD_14hkeX16rSHe8S4alE9s8P.xMlbrtTnpOgWOhEHgsPik9VjAx6H8jNT.Lv 6pkJNNSHk5IDcy_QW_NftgdhBUuPF5rHQFE0WF7QlCuF2wN0sVIRlADfNxIzebDgXTAEv8m.MgDr y4bo2jHszyxjsG0A2rzl4uiCu4._T3dM5bN13EFkUFlJwApCJzIc1izGmpqigvQXwKFAweP0qJic JnxcE0OzWax28Iyn8pgKNOmy_78bZ4e8o_3PWyjHJsbT_mLTyFF1YEgteRcsujgNmDPhitgpte_Z Z2Xj.0CnqPW13Fht7vwv2rryg5Hb7Jpz1PTEp62h1mxm9SQJgKGzmwTM4jxMkTHppwQ0TwE_WPMI h_Wgu7C7NQuq_zdqvisf2ARFsAqVuUTNLPKssq.Yyx9uErB4m53Jlp3G8yDBbijJrewVxzHCC0nG _QpcrG83xUzuSTQ50qWpRBcg2Qm2hgMPV75i2QYcWXt8.uiAdRIQDDZKwT3a6e7yUSOQSbwXv3zq V.C.dZxQsof67Vky_8Y3Mm5UrDunxwvhSmO8YiZ_qsXTH9JmXs.6RITiFFHLyKN__h21t9IaUdar QUf1lbrq2o5hDqltdc2l7CYCGNa16TKCIHaou_wBohwaV6GIuznvsOCUClWARu25b1afXvl6tWft JounBfO0gHIb1zko0CW__ZsqktOU6EccmhbXqlo.B4LT0MYslSY75xYq5FVTMDyz.tYasEWiYbFA 8Oyys7WuulFmQf8yuArR4H4J17Dhc.OnouykX5YH1BjljaeX2BVKNeZiYzyJTLH5hbLK.wWmJbmK 7v.u3.JXs6.xEpsr7BmCkvMn82M1y5oE6YUMgbIM9Dk3PTUMPKDNDYlG9ZW8rEFBtri1lmnbp408 h3NnGs9FV7S4.AKWaeRUDF1io.m3hegGF2i76od9BvCDFowPzSlfCsyKRFBAvwyOPtb9_n4xgFm3 y015T00uhjy8iLOs61kwatFkC9HhO8iKQhbC_quK_1_AXPChSz3jBFmTnNStubHI3xaDzzzt7U2O 6TREy_NRJFgbkY1jCY8b8CCRZMsakE3r3OfOFkSXENWLirruFqEKkDv1kMfJLVMN7tBpO22h95je x5QU_wAmf8N7oHzqQNFFRJF1y2t2FRoa10DcNx7AqZoBVMi21_.uxAzjKVjENWvyF3kn8J_2XR2n Qs9xXpFirGJ0dqsoQjUlVUpJuV6vkHO6EGR1k5ZJtK_IXoWXPNZtJVPJm8gh7dn6AsO649oLcjaA 5ZKn5Thy13uhDOV.Xqte_d0AfUCFTkuFhllr0eqaLs3dky8KcFl_xS.Eef3RJSH87AGW_4Ov2ymd RqVgvmCaBAKzK9QDqVky4S5lTMAaymdCwiTZpcSno.s49ncqTNdp5ZIB7yWBn6isQQl.5N3StolJ FkX12f1EYbVCt2o0jZDAVKZJdROEZ1gi5Rs9BEHDeHEDpspuTwcMnMAYxzhVF5dCeU6ufNDtdkXv kXXDGmpcNOjqrKN8iroCHUx._WxhpoNcmR3PDQ7epOA.t48cj3EBgacdU7Ky3ETd21u.ON_oYHg3 Z6IGVPjI1HgVollrUL6EYLP7PfjWltMTaSmyiyhLLAESlVsKuXhocF5VItMER5kqIkpD3H6Z3byu l6sU2KwEi.1UfMqR3hSCZNDNC12VoNl.ta60wwq0EN8t_oeYLKqRnC_YVTSrUAXdAWM3BykFB4Q- - X-Sonic-MF: Received: from sonic.gate.mail.ne1.yahoo.com by sonic315.consmr.mail.gq1.yahoo.com with HTTP; Fri, 2 Dec 2022 08:45:07 +0000 Date: Fri, 2 Dec 2022 08:45:06 +0000 (UTC) From: Ludwig Isaac Lim To: "pgsql-general@postgresql.org" Message-ID: <1061909348.200334.1669970706749@mail.yahoo.com> Subject: ERROR : cannot commit while a portal is pinned from plpython MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable References: <1061909348.200334.1669970706749.ref@mail.yahoo.com> X-Mailer: WebService/1.1.20926 YMailNorrin Content-Length: 1931 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hello: I noticed the following lines in my PostgreSQL log file today: 2022-12-01 14:16:54.517 UTC [10073] ERROR:=C2=A0 cannot commit while a port= al is pinned 2022-12-01 14:16:54.517 UTC [10073] STATEMENT:=C2=A0 call p_annotate_db_sta= ts() The process ID can be traced to plpython procedure call. What is baffling is there's no commit (or rollback) inside the stored proce= dure call. The notable changes I made to the stored procedure is: adding this block of code try: =C2=A0 =C2=A0 =C2=A0 --processing stuff except: =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 exc_type, exc_value, tb =3D sys.exc_in= fo() =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 if tb is None: =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0print("No exception / traceback information", file=3Dsys.stderr) =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0sys.exit(-1) =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 prev =3D tb =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 curr =3D tb.tb_next =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 while curr is not None: =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0prev =3D curr =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0curr =3D curr.tb_next =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 print(prev.tb_frame.f_locals, file=3Ds= ys.stderr) =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 traceback.print_exception(*sys.exc_inf= o()) =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 print("Exiting", file=3Dsys.stderr) The stored procedure is executed via psql call using the following command = in bash: =C2=A0 nohup psql -c "call p_annotate_db_stats()" & Postgresql version :=C2=A0=C2=A0PostgreSQL 14.6 on aarch64-unknown-linux-gn= u, compiled by gcc (GCC) 7.3.1 20180712 (Red Hat 7.3.1-15), 64-bit Python version :=C2=A0Python 3.7.10 What could be the cause of the error? Thank you. Regards, Ludwig Lim