public inbox for [email protected]  
help / color / mirror / Atom feed
From: Adrian Klaver <[email protected]>
To: Jeff Ross <[email protected]>
To: [email protected]
Subject: Re: After 10 -> 15 upgrade getting "cannot commit while a portal is pinned" on one python function
Date: Thu, 21 Mar 2024 09:30:55 -0700
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>

On 3/21/24 09:06, Jeff Ross wrote:
> Greetings!
> 
> I posted a version of this to the pgsql-general mailing list yesterday.  
> Since then I've narrowed down the error to this line:
> 
> prod_database_connection.commit()
> 
> so I believe this is psycopg2 related.

Does it work outside of plpython3u?

> 
> This is on CentOS 7 and I'm using python3-psycopg2.x86_64 2.8.6-1.rhel7 
> installed from yum.

psycopg2 is up to 2.9.9. You are missing ~3 years of fixes.

> 
> makes me wonder if this error is specific to plpython3?

Hard to say as the other bug report you linked to seemed to refer to 
plpythonu.


> Jeff
> 
> 

-- 
Adrian Klaver
[email protected]







view thread (2+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: After 10 -> 15 upgrade getting "cannot commit while a portal is pinned" on one python function
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox