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 1l5Tpx-0000GL-3y for pgsql-bugs@arkaria.postgresql.org; Fri, 29 Jan 2021 13:29:21 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1l5Tpw-0001Gc-3H for pgsql-bugs@arkaria.postgresql.org; Fri, 29 Jan 2021 13:29:20 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l5Tpv-0001GV-Qn for pgsql-bugs@lists.postgresql.org; Fri, 29 Jan 2021 13:29:19 +0000 Received: from mout.gmx.net ([212.227.15.19]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l5Tpp-0005IJ-K1 for pgsql-bugs@lists.postgresql.org; Fri, 29 Jan 2021 13:29:19 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=gmx.net; s=badeba3b8450; t=1611926951; bh=rHg18WiySYK2SF6YrENOBGjFsFAODXFDd1zzFVXhFSI=; h=X-UI-Sender-Class:From:To:Cc:Subject:Date:In-Reply-To:References; b=SdWjdb5xt9LvAsxXUF5AC0pdB3nuZxCiY9kXIqhtXCd+A9OnQY+xwAxd7lYkJQNuB JnV0frH1b9kfp192a7ZbI1+RyUhwtAxGHqWkIyJjV9fgc01KYzBj2RbTmqZ+CBjCLp Pzv+D+bG1BLjAQsLAKde2asOeTrtvOu+0mgsQC/U= X-UI-Sender-Class: 01bb95c1-4bf8-414a-932a-4f6e2808ef9c Received: from wolfclan.ang.de ([87.191.134.178]) by mail.gmx.net (mrgmx005 [212.227.17.190]) with ESMTPSA (Nemesis) id 1MbAh0-1lh0Rj1UXQ-00bbuE; Fri, 29 Jan 2021 14:29:11 +0100 From: linreg@gmx.net To: Bruce Momjian , Tom Lane Cc: pgsql-bugs@lists.postgresql.org Subject: Re: BUG #16843: pg_upgrade from 12.5 to 13.1 with extension plperlu failed Date: Fri, 29 Jan 2021 14:29:09 +0100 Message-ID: <4111314.ejJDZkT8p0@wolfclan.ang.de> In-Reply-To: <20210128155644.GB14227@momjian.us> References: <16843-174d3e5b66729a60@postgresql.org> <2547214.1611848625@sss.pgh.pa.us> <20210128155644.GB14227@momjian.us> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="nextPart3431176.R56niFO833" Content-Transfer-Encoding: 7Bit X-Provags-ID: V03:K1:kbdAlq+2A3LUb4r5Yxpnc39RBAqTU3vJUjs6zQIZ3vq3rasMZ6M HRI1SNFsStulJ5QTgLbk9lITtuUEfno4EO/bYW3LR+vxSMaKkyDQP1fuxG/IgWzPJGzy2nN qm1jAcP/hxIXDcfehz3jHH0EM3PjOB0wVOI5p11A1aqDqBOGVkk8H/pDnQk7sqEGnQe2iQW f4R694ghvbWNLc6m/mPUg== X-Spam-Flag: NO X-UI-Out-Filterresults: notjunk:1;V03:K0:43Pl0BRQcm4=:033ZB5lQb+ykoQ6hbVJ38C iaTH5CBKvOw6tYq0Rfma8l1WmyUHYcpV3DzZuiCJPfjopEDiPohNrerI9o1uFB84Z1V17RfL4 qTl4kEK8NxILKu2zZtrz+xPbLQKnhoFl1AWNiJ3FM+N/95F0ToBkIUWAC8NFZ1CBoAypg8XRY y6p+nc5m4O5pHcfkP0mRYGoTs+pV/3UI3gIT/fTXxzzNW+a4QwOCOmRY60OxnuFaY3MQ/orpm YiRISt/DHExU3deKjOSUTpFWCNFV8JhZeZdAeAjkSyMFekRM7RPxQTKmSNml5XHVASOPxm8B1 9iXHVp5Gi4VVYAaHui6pFkzjY9kjZqAugBFcz0KEXhf65XPNg513KoihnlIXFjn6wQpxrLSey nZcwzjITNLIxtG3jevI/7qdrbgWPvGSFHocMvKinNOS/U6DzgWxx2vL5Bk2ZqsHqcI6LahGdp /igvzqNhtC/PXUxYOMIZYt48063BHfpRsEWCScAb82PLAWywoUNNUR2201FmiqsmlfHXvBVV0 d2SDcmBkpMOH4Uz0RNgP9jDkOUKmeN39k08DEXw/k9+FRues344bmqpMIXsE2G7dIeFD4hEs4 oa7Amzwa+U0myLUET1iDcoduXAdoyjOAYx4MkQ5XljBQf/gspd8sF1+TD5BlMWg75UlusNxyA lNzCroJrk3gCnjQBnccNOs/InYJtLpauWwXegkTQpbnLrB843I1WBqSAuR5DJ2DaavoqM+4cV OBBz6c1igcL434Ef0SYsIiNVoHlTIagaIsW53/0uYQ+zmKYjhX03THcq4hg7PrBD0ibuGEwel aJmkrDPrTpTyNoMVQckfOo0gp5tpEaUN4LGyp0lLEDU2VBY6RH7HlI16KWVwK06T5miqJF2H5 3GES6mUK3i9NpgXqomzA== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --nextPart3431176.R56niFO833 Content-Type: multipart/alternative; boundary="nextPart2086516.Mh6RI2rZIc" Content-Transfer-Encoding: 7Bit This is a multi-part message in MIME format. --nextPart2086516.Mh6RI2rZIc Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset="iso-8859-1" Am Donnerstag, 28. Januar 2021, 16:56:44 CET schrieben Sie: > On Thu, Jan 28, 2021 at 10:43:45AM -0500, Tom Lane wrote: > > Bruce Momjian writes: > > > On Thu, Jan 28, 2021 at 10:34:46AM -0500, Tom Lane wrote: > > >> PG Bug reporting form writes: > > >>> pg_restore: Error: could not execute query: ERROR: Language =BBplp= erlu=AB > > >>> does > > >>> not exist > > >>> The statement was: CREATE OR REPLACE PROCEDURAL LANGUAGE "plperlu"; > > >>=20 > > >> It looks like you neglected to install the plperlu package > > >> (it's probably named something like postgresql-plperl). > > >=20 > > > Yeah, I am confused why this was not reported clearly to the user. > >=20 > > It is odd that pg_upgrade's checks didn't catch it earlier. But > > we can't investigate without more info about exactly what Postgres > > packages are present on the OP's system. >=20 > Yes, usually the error report is very clear, we would need to see > _exactly_ what they saw. Hello, to clearify,=20 =2D plperl package is already installed (see below). =2D command 'CREATE OR REPLACE PROCEDURAL LANGUAGE "plperlu";' doesn't crea= te a=20 language object, but just an extension object (see below) Please note the attached upgrade log file from pg_upgrade "pg_upgrade_dump_= 16401.log". OS Packages: *postgresql*-llvmjit-13-lp152.3.1.noarch *postgresql*12-pldebugger-1.0+git13.ddbce7b-lp152.1.4.x86_64=20 *postgresql*12-llvmjit-12.5-lp152.34.1.x86_64 *postgresql*-13-lp152.3.1.noarch=20 *postgresql*12-docs-12.5-lp152.34.1.noarch=20 *postgresql*12-contrib-12.5-lp152.34.1.x86_64=20 *postgresql*13-plperl-13.1-lp152.16.1.x86_64=20 *postgresql*12-server-12.5-lp152.34.1.x86_64=20 *postgresql*-docs-13-lp152.3.1.noarch=20 *postgresql*12-12.5-lp152.34.1.x86_64=20 *postgresql*12-pg_qualstats-2.0.2-lp152.2.3.x86_64=20 *postgresql*12-ip4r-2.4.1+git1.5f9ce88-lp152.8.2.x86_64=20 *postgresql*-server-13-lp152.3.1.noarch=20 *postgresql*12-pg_qualstats-llvmjit-2.0.2-lp152.2.3.x86_64=20 *postgresql*13-docs-13.1-lp152.16.1.noarch=20 *postgresql*13-server-13.1-lp152.16.1.x86_64=20 *postgresql*-contrib-13-lp152.3.1.noarch=20 *postgresql*12-ip4r-llvmjit-2.4.1+git1.5f9ce88-lp152.8.2.x86_64 *postgresql= *13-13.1- lp152.16.1.x86_64 *postgresql*13-llvmjit-13.1-lp152.16.1.x86_64=20 *postgresql*-plperl-13-lp152.3.1.noarch *postgresql*12-pldebugger-llvmjit-1.0+git13.ddbce7b-lp152.1.4.x86_64 *postg= resql*13- contrib-13.1-lp152.16.1.x86_64 Output from failed database upgrade: botdb=3D# \dL=20 --nextPart2086516.Mh6RI2rZIc Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="iso-8859-1"

Am Donnerstag, 28. Januar 2021, 16:56:44 CET schrieben Sie:

>= ; On Thu, Jan 28, 2021 at 10:43:45AM -0500, Tom Lane wrote:

>= ; > Bruce Momjian <bruce@momjian.us> writes:

>= ; > > On Thu, Jan 28, 2021 at 10:34:46AM -0500, Tom Lane wrote:

>= ; > >> PG Bug reporting form <noreply@postgresql.org> writes= :

>= ; > >>> pg_restore: Error: could not execute query: ERROR:=A0 L= anguage =BBplperlu=AB

>= ; > >>> does

>= ; > >>> not exist

>= ; > >>> The statement was: CREATE OR REPLACE PROCEDURAL LANGUAG= E "plperlu";

>= ; > >>

>= ; > >> It looks like you neglected to install the plperlu package<= /p>

>= ; > >> (it's probably named something like postgresql-plperl).

>= ; > >

>= ; > > Yeah, I am confused why this was not reported clearly to the us= er.

>= ; >

>= ; > It is odd that pg_upgrade's checks didn't catch it earlier.=A0 But

>= ; > we can't investigate without more info about exactly what Postgres

>= ; > packages are present on the OP's system.

>= ;

>= ; Yes, usually the error report is very clear, we would need to see

>= ; _exactly_ what they saw.

=  

Hel= lo,

=  

to = clearify,

- p= lperl package is already installed (see below).

- c= ommand 'CREATE OR REPLACE PROCEDURAL LANGUAGE "plperlu";' doesn't= create a language object, but just an extension object (see below)

=  

Ple= ase note the attached upgrade log file from pg_upgrade "pg_upgrade_dum= p_16401.log".

=  

OS = Packages:

postgresql-llvmjit-13-lp152.3.1.noarch

 postgr= esql12-pldebugger-1.0+git13.= ddbce7b-lp152.1.4.x86_64

 postgresql12-llvmjit-12.5-lp152.34.1.x86_64

 postgresql-13-lp152.3.1.noarch

 postgresql12-docs-12.5-lp152.34.1.noarch

 postgresql12-contrib-12.5-lp152.34.1.x86_64

 postgresql13-plperl-13.1-lp152.16.1.x86_64

 postgresql12-server-12.5-lp152.34.1.x86_64

 postgresql-docs-13-lp152.3.1.noarch

 postgresql12-12.5-lp152.34.1.x86_64

 postgresql12-pg_qualstats-2.0.2-lp152.2.3.x86_64=

 postgresql12-ip4r-2.4.1+git1.5f9ce88-lp152.8.2.x= 86_64

 postgresql-server-13-lp152.3.1.noarch

 postgresql12-pg_qualstats-llvmjit-2.0.2-lp152.2.= 3.x86_64

 postgresql13-docs-13.1-lp152.16.1.noarch

 postgresql13-server-13.1-lp152.16.1.x86_64

 postgresql-contrib-13-lp152.3.1.noarch

 postgresql12-ip4r-llvmjit-2.4.1+git1.5f9ce88-lp1= 52.8.2.x86_64 postgresql13-13.1-lp152.16.1.x86_64

 postgresql13-llvmjit-13.1-lp152.16.1.x86_64

 postgresql-plperl-13-lp152.3.1.noarch

 postgresql12-pldebugger-llvmjit-1.0+git13.ddbce7= b-lp152.1.4.x86_64 postgresql= 13-contrib-13.1-lp152.16.1.x= 86_64


Output from failed database upgrade:

bot= db=3D# \dL

 

=  

--nextPart2086516.Mh6RI2rZIc-- --nextPart3431176.R56niFO833 Content-Disposition: attachment; filename="pg_upgrade_dump_16401.log" Content-Transfer-Encoding: quoted-printable Content-Type: text/x-log; charset="utf-8"; name="pg_upgrade_dump_16401.log" command: "/usr/lib/postgresql13/bin/pg_dump" --host /var/lib/pgsql --port 5= 0432 --username postgres --schema-only --quote-all-identifiers --binary-upg= rade --format=3Dcustom --file=3D"pg_upgrade_dump_16401.custom" 'dbname=3Db= otdb' >> "pg_upgrade_dump_16401.log" 2>&1 command: "/usr/lib/postgresql13/bin/pg_dump" --host /var/lib/pgsql --port 5= 0432 --username postgres --schema-only --quote-all-identifiers --binary-upg= rade --format=3Dcustom --file=3D"pg_upgrade_dump_16401.custom" 'dbname=3Db= otdb' >> "pg_upgrade_dump_16401.log" 2>&1 command: "/usr/lib/postgresql13/bin/pg_restore" --host /var/lib/pgsql --por= t 50432 --username postgres --create --exit-on-error --verbose --dbname tem= plate1 "pg_upgrade_dump_16401.custom" >> "pg_upgrade_dump_16401.log" 2>&1 pg_restore: verbinde mit der Datenbank zur Wiederherstellung pg_restore: erstelle DATABASE =C2=BBbotdb=C2=AB pg_restore: verbinde mit neuer Datenbank =C2=BBbotdb=C2=AB pg_restore: erstelle DATABASE PROPERTIES =C2=BBbotdb=C2=AB pg_restore: verbinde mit neuer Datenbank =C2=BBbotdb=C2=AB pg_restore: erstelle pg_largeobject =C2=BBpg_largeobject=C2=AB pg_restore: erstelle SCHEMA =C2=BBcallbot=C2=AB pg_restore: erstelle SCHEMA =C2=BBcrm_test=C2=AB pg_restore: erstelle SCHEMA =C2=BBfirmenbots=C2=AB pg_restore: erstelle SCHEMA =C2=BBgeo=C2=AB pg_restore: erstelle SCHEMA =C2=BBimmo=C2=AB pg_restore: erstelle SCHEMA =C2=BBlassi=C2=AB pg_restore: erstelle SCHEMA =C2=BBmieten_kataster=C2=AB pg_restore: erstelle SCHEMA =C2=BBmy_cam_bot=C2=AB pg_restore: erstelle EXTENSION =C2=BBpg_cron=C2=AB pg_restore: erstelle COMMENT =C2=BBEXTENSION "pg_cron"=C2=AB pg_restore: erstelle SCHEMA =C2=BBpgcron=C2=AB pg_restore: erstelle COMMENT =C2=BBSCHEMA "pgcron"=C2=AB pg_restore: erstelle EXTENSION =C2=BBhstore=C2=AB pg_restore: erstelle COMMENT =C2=BBEXTENSION "hstore"=C2=AB pg_restore: erstelle EXTENSION =C2=BBpg_http=C2=AB pg_restore: erstelle COMMENT =C2=BBEXTENSION "pg_http"=C2=AB pg_restore: erstelle SCHEMA =C2=BBpghttp=C2=AB pg_restore: erstelle EXTENSION =C2=BBpg_mqtt=C2=AB pg_restore: erstelle COMMENT =C2=BBEXTENSION "pg_mqtt"=C2=AB pg_restore: erstelle SCHEMA =C2=BBpgmqtt=C2=AB pg_restore: erstelle SCHEMA =C2=BBplaner=C2=AB pg_restore: erstelle SCHEMA =C2=BBprivatebots=C2=AB pg_restore: erstelle SCHEMA =C2=BBreplication=C2=AB pg_restore: erstelle EXTENSION =C2=BBpg_reporting=C2=AB pg_restore: erstelle COMMENT =C2=BBEXTENSION "pg_reporting"=C2=AB pg_restore: erstelle SCHEMA =C2=BBreporting=C2=AB pg_restore: erstelle SCHEMA =C2=BBtaskbot=C2=AB pg_restore: erstelle SCHEMA =C2=BBteams=C2=AB pg_restore: erstelle SCHEMA =C2=BBtelegram=C2=AB pg_restore: erstelle SCHEMA =C2=BBwebsites=C2=AB pg_restore: erstelle EXTENSION =C2=BBplperlu=C2=AB pg_restore: erstelle COMMENT =C2=BBEXTENSION "plperlu"=C2=AB pg_restore: erstelle PROCEDURAL LANGUAGE =C2=BBplperlu=C2=AB pg_restore: in Phase PROCESSING TOC: pg_restore: in Inhaltsverzeichniseintrag 2151; 2612 16427 PROCEDURAL LANGUA= GE plperlu postgres pg_restore: Fehler: could not execute query: FEHLER: Sprache =C2=BBplperlu= =C2=AB existiert nicht Die Anweisung war: CREATE OR REPLACE PROCEDURAL LANGUAGE "plperlu"; =2D- For binary upgrade, handle extension membership the hard way ALTER EXTENSION "plperlu" ADD LANGUAGE "plperlu"; --nextPart3431176.R56niFO833--