Re: pg_upgrade from 12 to 13 failes with plpython2

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Marcin Giedz <marcin(dot)giedz(at)arise(dot)pl>
Cc: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, Magnus Hagander <magnus(at)hagander(dot)net>, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, Devrim Gündüz <devrim(at)gunduz(dot)org>, pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: pg_upgrade from 12 to 13 failes with plpython2
Date: 2020-11-18 19:54:00
Message-ID: 999795.1605729240@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Marcin Giedz <marcin(dot)giedz(at)arise(dot)pl> writes:
> anyway got this from your query:

> 16402 | plpython_call_handler | 11 | 10 | 13 | 1 | 0 | 0 | - | f | f | f | f | f | v | u | 0 | 0 | 2280 | | | | | | | plpython_call_handler | $libdir/plpython2 | |
> 16403 | plpython_inline_handler | 11 | 10 | 13 | 1 | 0 | 0 | - | f | f | f | t | f | v | u | 1 | 0 | 2278 | 2281 | | | | | | plpython_inline_handler | $libdir/plpython2 | |
> 16404 | plpython_validator | 11 | 10 | 13 | 1 | 0 | 0 | - | f | f | f | t | f | v | u | 1 | 0 | 2278 | 26 | | | | | | plpython_validator | $libdir/plpython2 | |

Uh-huh, so there you have it. These must be leftovers from some
pre-extension incarnation of plpython that was never cleaned up
properly. Try

DROP FUNCTION pg_catalog.plpython_call_handler();
DROP FUNCTION pg_catalog.plpython_inline_handler(internal);
DROP FUNCTION pg_catalog.plpython_validator(oid);

It'll be interesting to see if there are any dependencies.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marcin Giedz 2020-11-18 19:59:58 Re: pg_upgrade from 12 to 13 failes with plpython2
Previous Message Marcin Giedz 2020-11-18 19:42:16 Re: pg_upgrade from 12 to 13 failes with plpython2