Re: BUG #16843: pg_upgrade from 12.5 to 13.1 with extension plperlu failed

From: GMX LINREG <linreg(at)gmx(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Bruce Momjian <bruce(at)momjian(dot)us>, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #16843: pg_upgrade from 12.5 to 13.1 with extension plperlu failed
Date: 2021-02-01 15:23:47
Message-ID: 4296093.LvFx2qVVIh@wolfclan.ang.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Am Freitag, 29. Januar 2021, 18:55:42 CET schrieb Tom Lane:
> GMX LINREG <linreg(at)gmx(dot)net> writes:
> > output from source database:
> > botdb=# \dx+ plperlu
> > Objekte in Erweiterung »plperlu«
> >
> > Objektbeschreibung
> >
> > --------------------
> >
> > language plperlu
>
> Yeah, that's definitely broken: it should look like
>
> \dx+ plperlu
> Objects in extension "plperlu"
> Object description
> -------------------------------------------
> function plperlu_call_handler()
> function plperlu_inline_handler(internal)
> function plperlu_validator(oid)
> language plperlu
> (4 rows)
>
> Offhand I think that completely explains pg_dump's failure: it relies on
> the dependency-membership entries to decide that it ought to dump the
> language support functions, so if they're not there, this is what you get.
>
> It's possible that the entries *are* there but they're not being found due
> to index corruption. You could try "REINDEX TABLE pg_depend" and see if
> the \dx+ output changes. I don't have a lot of hope for that though.
>
> The next easiest fix would be to see if you have any plperlu functions
> to worry about, and if not, just drop the busted extension.
>
> If you do have some such functions, the best bet might be to dump
> them separately, go ahead and DROP CASCADE the busted extension,
> then upgrade; and restore the plperlu functions separately afterwards.
>
> It'd be kind of interesting to figure out why those pg_depend entries
> are missing, but I suppose the evidence is long gone :-(
>
> regards, tom lane
Hello,

after "REINDEX TABLE pg_depend" the problem still persists.
So I agree "the evidence is long gone";

I will perfrom a pg_dump/psql combo to restore and upgrade the database to
main version 13. Since version 9.6 we have had a lot of pg_upgrades.

Thank you very much.
Best regards from Germany

Thomas Steffen

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2021-02-01 23:57:55 BUG #16848: psqlodbc_13_00_0000-x64 used for Linked Server is displaying linked server password in the DSN logs
Previous Message PG Bug reporting form 2021-02-01 13:50:18 BUG #16847: Problem with reinstalling Postgres. Data folder