Re: After 10 -> 15 upgrade getting "cannot commit while a portal is pinned" on one python function

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Jeff Ross <jross(at)openvistas(dot)net>, psycopg(at)lists(dot)postgresql(dot)org
Subject: Re: After 10 -> 15 upgrade getting "cannot commit while a portal is pinned" on one python function
Date: 2024-03-21 16:30:55
Message-ID: a27826a2-9f22-4a5c-a0f2-cfe5dbc156c4@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: psycopg

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
adrian(dot)klaver(at)aklaver(dot)com

In response to

Browse psycopg by date

  From Date Subject
Next Message Aryeh Leib Taurog 2024-04-08 16:49:42 pgcopy 1.6.0 release announcement
Previous Message Jeff Ross 2024-03-21 16:06:03 After 10 -> 15 upgrade getting "cannot commit while a portal is pinned" on one python function