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 1l6b3W-0006AT-Tk for pgsql-bugs@arkaria.postgresql.org; Mon, 01 Feb 2021 15:23:59 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1l6b3V-0005Bn-Pe for pgsql-bugs@arkaria.postgresql.org; Mon, 01 Feb 2021 15:23:57 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l6b3V-0005Bg-HK for pgsql-bugs@lists.postgresql.org; Mon, 01 Feb 2021 15:23:57 +0000 Received: from mout.gmx.net ([212.227.17.20]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l6b3R-00054l-BI for pgsql-bugs@lists.postgresql.org; Mon, 01 Feb 2021 15:23:55 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=gmx.net; s=badeba3b8450; t=1612193029; bh=rBqmav1lxPl9dAviw1WCfkwEuCJ8wBKWI0fAI+cnSYg=; h=X-UI-Sender-Class:From:To:Cc:Subject:Date:In-Reply-To:References; b=GstmQHCQjUWRZqNw6UwMlaCa1mOPHfn5OhHk8h+yW5CB1xp0LGzseW6eh8oX3wn0A pY/l9bcuzLrXmf2t+/Y25KONtxGU0bzE2DPJRKGLEY34AlL08VfM/hO7B7sR5e3vq6 GrXQ8z0Yp+CstL2CjJgdnpe0YWj8EX+cjm7ByZUY= X-UI-Sender-Class: 01bb95c1-4bf8-414a-932a-4f6e2808ef9c Received: from wolfclan.ang.de ([87.191.134.178]) by mail.gmx.net (mrgmx104 [212.227.17.168]) with ESMTPSA (Nemesis) id 1MwQXN-1lyyBt3ZcT-00sLZi; Mon, 01 Feb 2021 16:23:48 +0100 From: GMX LINREG To: Tom Lane Cc: Bruce Momjian , pgsql-bugs@lists.postgresql.org Subject: Re: BUG #16843: pg_upgrade from 12.5 to 13.1 with extension plperlu failed Date: Mon, 01 Feb 2021 16:23:47 +0100 Message-ID: <4296093.LvFx2qVVIh@wolfclan.ang.de> In-Reply-To: <2816651.1611942942@sss.pgh.pa.us> References: <16843-174d3e5b66729a60@postgresql.org> <5448993.DvuYhMxLoT@wolfclan.ang.de> <2816651.1611942942@sss.pgh.pa.us> MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset="iso-8859-1" X-Provags-ID: V03:K1:3CEV2qG0nMk04C+wJdVAAofzv+wZBVfnNNlqy0CsGe+OtRude2T wzo9eKzKxGV97UtEoGyUrQydgR2+LYjz74+270KGuVPAxzPwo66vnDN+mnnBiBJ8GGI6HWB EzNBEoe4OVDynH9Rkm5tkubGQvdWjjFt+QVdk8wgdoZ363oqUQlY8i3lNzrXtFm3wqNkIdY 4TpvnLRCVVLqxc223s7CQ== X-Spam-Flag: NO X-UI-Out-Filterresults: notjunk:1;V03:K0:ELFiNEJM0Zo=:4VilJM4qQh04hLcGuPJ1j5 gQXZH7brkF7SMVwmLg/OPeQb0zGK160SsuzPjt4vC453gFReJpTuQMwNdhv8EhegzuoO6JZn/ qcna3hYjl6yPJ2+w60+xhgG70PKZRjGLTU69GKDXjYYyUXqMDu1ofg9GaaqLkSliJpXGp8M7y TO17aAcpaZh/zJJZENaFtnj+z/ohOFEAM7tBDhfFFE6gpiIO8QCgS42F/YuVvm+BaeWXtzrbN wsjCu4zr6CODPA9sOR/vMrmxMGXbE81OsLWQ3fgu/zhUyJ22ztZc1kqYErluWMGfRFr5i0UPZ 1esXiF9GP9MqvTc83+DScofXXNMs72mJ3qzAxjE/t7blQ6jwsPH577/Ivm6Dv84jVDqxl3ntC GelZexbkQnOT+SY/Pu096jktdmZBehk3svaN4/VeGUv1eJZsE2NuuHQb2/2bJym+HbSnmUAkZ oX7zVjHTo5RASmTDbqpC5VkqH0w2BCd+937BWPXyMCk+AASyOSDovybMbjRiiEeGHPenoYF86 ZWTMB+vcV8yy71aValnfsd8FQTHn6RqdsmWpLh6Q8ODTg1gkcbYFFeBWZZnqlES8RVyGp67jc dt0U1qcVysabYif+4yWpyT8Be/mLAZNL5F55mBpso/qImtze/tRtv/zpPtUFFdL2im4GZEHqI 2SIphGpmTPcvPwJcC9AJcgtvatMC/ykdh2bB2ifQ2Uvj43q6BU2f8TXU/NHp8fQxrqBt14eRL UijpTOngP6zqVJLIEvHERlvc8cIQu4vHG4JxxitLkE9dDAxe0QtkfnXihWwdA4ZhYaggu/8Gu 52P50/km1z5CDrizltLhndEKsrVo39xZT2RBMQ2tfB4Dsjq2/igtjEgUQsLKtgRBwuoN0Zxih xVxqiKJMWzzNlcsx6fVg== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Am Freitag, 29. Januar 2021, 18:55:42 CET schrieb Tom Lane: > GMX LINREG writes: > > output from source database: > > botdb=3D# \dx+ plperlu > > Objekte in Erweiterung =BBplperlu=AB > >=20 > > Objektbeschreibung > >=20 > > -------------------- > >=20 > > language plperlu >=20 > Yeah, that's definitely broken: it should look like >=20 > \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) >=20 > 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. >=20 > 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. >=20 > 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. >=20 > 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. >=20 > It'd be kind of interesting to figure out why those pg_depend entries > are missing, but I suppose the evidence is long gone :-( >=20 > 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= =20 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