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 1oEvNZ-0001oV-DL for pgsql-admin@arkaria.postgresql.org; Fri, 22 Jul 2022 16:19:53 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oEvNY-00024q-7W for pgsql-admin@arkaria.postgresql.org; Fri, 22 Jul 2022 16:19:52 +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 1oEvNX-00024h-Nl for pgsql-admin@lists.postgresql.org; Fri, 22 Jul 2022 16:19:51 +0000 Received: from mail-dm3gcc02on2091.outbound.protection.outlook.com ([40.107.91.91] helo=GCC02-DM3-obe.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oEvNT-0002mM-HV for pgsql-admin@postgresql.org; Fri, 22 Jul 2022 16:19:51 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=Ab7/8kHP7UpvOOg4Fc2+RzU/F6Jp1TYri6O0X+kncJnPYxCNGFHnAqkh96KAHMag0MAP6LrBMhrRGriidrP96nXY0fk3ShdIQwIam5tyNOlrPF7pP/MAe9NqPG/NkzvPC2RPcsgp16E1mMX1YWfukkJZPGa4VfhIwvnmoAH1Js5kV+Jv56lRsZAuAstsiaMlIQc4t1jGpP5tZEbosjldFpKeMiYM/ALVOdMTAyo3CWibvngBeCLbtsSGPSCfrzxzsmYdoM+obRIuOA59iOuDKlvRjYuGqDnDaGYRW9mlYFFW3yJRMYoUIg1yPbsfYD3w6rTwfvqYIGqZ5PBYY4sLCA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=elGtilxnq0nzwcNKL9BWWEuLLjUTBZuwocvcHIhotro=; b=aRuaP+rzp3uVhVP2Wy2+nAwVqzcJlyg/ANlIN1RCzz3rHGCzUzO0XiKXnOLuZi4gSy1atg88sTO+N2aOxy6uhop01E4LPVZkVgIByRyPy/uay6QhYuMuA3gC5bWrJJGw6DPPMhmGgEUhB094f9HSqypRE49W/+Y735G/o0S5qUuKTykTrrOWcjS+fTo36VGBPZ+woCJKcYvr4MOJQ4EupKG+S7lB8XayzSPsWcaTvsl8u1bZJ/7mHTB41BfDu58FHb+9kl/+87vFGPj83cRHNVjaRz5ORhXkyaxjN0963MWN8ogVcBVi1IXwLs3Sug0SIjVNLQlpSsCwT2EHKkZJfg== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=fnal.gov; dmarc=pass action=none header.from=fnal.gov; dkim=pass header.d=fnal.gov; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=fermicloud.onmicrosoft.com; s=selector2-fermicloud-onmicrosoft-com; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=elGtilxnq0nzwcNKL9BWWEuLLjUTBZuwocvcHIhotro=; b=AK3j7z8EZLIvwaX5RJKPEaILt2GyvLyhtUD1hg0yyLysw3anusAr6oBw+PO1fOuzHtdrvcI5YonpJoZF+eMJvr2Bgdui7iNzH0SJEZUnUZV1bdxRDscTzHvgO4GE4KP7vaWzsh6evafBMEwPm312Ectbn/lxMBUW9T6gjZ8Ot30= Received: from DM8PR09MB6677.namprd09.prod.outlook.com (2603:10b6:5:2ee::12) by SA0PR09MB7226.namprd09.prod.outlook.com (2603:10b6:806:ab::12) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.5458.18; Fri, 22 Jul 2022 16:19:42 +0000 Received: from DM8PR09MB6677.namprd09.prod.outlook.com ([fe80::e004:52df:4c6e:b94f]) by DM8PR09MB6677.namprd09.prod.outlook.com ([fe80::e004:52df:4c6e:b94f%7]) with mapi id 15.20.5458.019; Fri, 22 Jul 2022 16:19:42 +0000 From: Murthy Nunna To: "'pgsql-admin@postgresql.org'" Subject: pg_upgrade failure upgrading from v10.8 to v14.4 Thread-Topic: pg_upgrade failure upgrading from v10.8 to v14.4 Thread-Index: Adid5QDE5BAKc2ISQ/KMoY+kuXqqcQ== Date: Fri, 22 Jul 2022 16:19:42 +0000 Message-ID: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: authentication-results: dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=fnal.gov; x-ms-publictraffictype: Email x-ms-office365-filtering-correlation-id: 7a5c4be0-3e2e-49e5-05b0-08da6bfdfbe9 x-ms-traffictypediagnostic: SA0PR09MB7226:EE_ x-fermilab-sender-location: inside x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: w/4lPGle2jn/oZuJ3kX6x5Cs/xb+TPHiuOXyn0b5uRPcX4SpbKuvfptRc7frhtxVMnnQq4ufrrmi53WHu4KxQodTPZ7l8Pc+jePD5IMjns9OfXXlivnET/sesX9G0cFSvS72VveudtmUmV7HxUk0MWjTC6USF9HwKdndLZpnyXutfJphsyhA3juOtj0Vuq0tLIBgpfOAL6wBXMURZSNMt51ZJOQ3uWDzOcT5Ka4XZZDjz8J1gbpQQZzWoXidZSwycMITT+0fRqo4M6hdKs+I6p0Vj9sIY0JU60Gt7KmuGiJeHmME55c5IbW4UebFH//F0tt+XQNrQ4xWmXIaAGMeyIab4G5fwlCndMfzCU1q8C5AOUQ2SKmp8vlKuFZXfg23vqM2mE2lSXDkUhGpOwoepEC5qyRhAXcZuDw3BDS6yvpysBbF7teEyd6avWQkOQMrXKZBXbwD3mqXXK3Gco3mfDfGQ/eF0KzU5vxDvjspTaR9VPHcrS4Nn3HPSSafWrKudZYzNUGazpBLFLnD7Or/S4JGlImSnKhM5ccVSw50rw21qamsaWgkJ7i6a4fSBqhMBubPxZeFKnV9NCnbKndf3JqyFmujTABoVbzfUoe6oHFOw90wSYP7A4KWmYf8JzWdxHbCKMIF5TzJpCtpNG+7gTByyJ4aqPwqqkMgBEo4XQHJ6LZE0OrvkBDOOx98zsN6k+durLld3ZJexAttMuOPz/1QQgjOkENRIZYvbc7qMegBuriFzRTQd6g8BZfozu6iaSW4KtghG+RePCS0Vb9lekRbudKlCoTUZLNkiaK6jBcdFRJBA0VOmvcU9zwHyAlOSsz69p0lfmK0klozvSV4uA== x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:DM8PR09MB6677.namprd09.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230016)(366004)(186003)(64756008)(38070700005)(86362001)(66446008)(9686003)(6916009)(8676002)(76116006)(66946007)(4744005)(66556008)(498600001)(71200400001)(55016003)(38100700002)(2906002)(82960400001)(122000001)(26005)(7696005)(5660300002)(33656002)(66476007)(83380400001)(52536014)(6506007)(8936002)(491001);DIR:OUT;SFP:1102; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?us-ascii?Q?oWfO1d9mJ+r3w0qWPJ/gYpLDz9XEcfv091Q2wqgFB3gi3w9S7tCCQ6imBVga?= =?us-ascii?Q?YlOHdzTFHhjvKdpQOohKaCt7iO/RhxUwX6j/QV3Dkl0DxhOIrY3M1l2ZP4UO?= =?us-ascii?Q?Mfx0ahi/s9sOnRgUbRdImzVqLy4uHUppNJ/HdqLHnYvc/R1Qj8pm9IFG8h/B?= =?us-ascii?Q?UkmUlGFEitaA5zv4kHNCbK+As1wnwi1QZcOh4yGZboHFRm/M2jh0/bQhbPF9?= =?us-ascii?Q?38ZmslwCqyULawXCdE1lKFVLtSO1MAhYt5pBEOyq4yqaWhaDvTydBpmvofsz?= =?us-ascii?Q?HDpKe9Wg8w6pDWSTKYjsQcTX0vdNeLqhKcQLVQoGJ0LluRSwIDQ9ANaVcNMg?= =?us-ascii?Q?6UQTkcCdHkhdgLJqA5v22cUKLgne8JT9MCl/gQ1ZsDHvL0VtCHwYXdxRN5Mf?= =?us-ascii?Q?aGZJs6cU3caNYDD/yYY9iGjM9NLPJWq+7vTAcLJNH+4J/aauqhekqE+/xrc9?= =?us-ascii?Q?8d5t/sr16Clxxh3prL7Ql8p/EWG3XPVGtRhmdCK1gi0rOvF/rwVLFzLWUGuo?= =?us-ascii?Q?k9fTnytl6CLNe1uahV+ZpRbREUTVmvguEn/LMX01TEYJRXWJWuLv4GAGjS1O?= =?us-ascii?Q?juvLEFkpZ+9Cxy+wvN+ASKf9noBNWVh87I43TK+dXWqJVp46vX73VarTKtuK?= =?us-ascii?Q?P3h2oQUG60ctRwsgZj47MhzmIGGuECi+ZtHlfBXfIJIo+MzRU10iy5I2CuVZ?= =?us-ascii?Q?THZQKANaqopVXHMhFOTQq/uO/Y/UzPpT4eiqq73J/u8ur1U3Ja5mmfYQD3bn?= =?us-ascii?Q?lqmhDHHqOK6MDPhE2gSESEC/JDs3oRMPs58OjpbDVmTJtpzVrUc1qTSoPWUg?= =?us-ascii?Q?/qFhMhhYAVbYi2OcmZTnm0dMs6bfjQL2rMbGg0ht5Ap6BR+Y8b/qOQz9piko?= =?us-ascii?Q?8iEiyXGPxlao1Fv35uFBOw8EUl2xsUft4UovHpix1kTnz/8efT3VJx5xRSvD?= =?us-ascii?Q?gO+eP3fr3OMFks18DTYpPdkMRhFTNX2kYWunT5sa8128F4tkvV6T1b6QC9CP?= =?us-ascii?Q?ystlagO+9P4cYRPNko6SxnfQWzM/JC9rbQVWoKGcdFyYjBkrI+Ejvh0NhYzq?= =?us-ascii?Q?qjIsppqlszbPLoZkVWvl+l+3BKQehuV7774Un3T+zk8kc2Sb+Di6/+XgGNpJ?= =?us-ascii?Q?k8F9fkyBavcMnSU+30LejQblGna8O8SKDCQK1ciR+3KQZvwRSoISug6HZ/8D?= =?us-ascii?Q?CrAinhzl2nlRpxqhr0+8BNAVzJAAklRx3TfJQqYsLx+HGBZrv4EZr6bt3duP?= =?us-ascii?Q?g+F5DqUom+fgnRerw5S977j43N/DPRC9Uyti75wSeM3p2SM252Kby6ttsYv6?= =?us-ascii?Q?kJ21y4+0fovrBGTssDq+gJ5y1qbryUdq5Hl+0tv6xgyTi2reMO14bf5XVgkl?= =?us-ascii?Q?tXe2JpMycDKdfapjBgNhXWy1YbUYUx6oGPQRnFXwBaRHJLICJFDHtlbjALAD?= =?us-ascii?Q?+KwMjcpaxSMFteca1YCe7XSkYPIuVQq24A7s7bVgZQv+6sNqmIYh/GrkLhdI?= =?us-ascii?Q?tUL3xh6Yb8GZPZWM54KPBfHxPpQB6lD2ukrreWVbGwXs4akPpr8boqftBc9P?= =?us-ascii?Q?5f+S7wLo0EbzTqYBiatWu/nqpp8q9DG1vkIrjdat?= Content-Type: multipart/alternative; boundary="_000_DM8PR09MB667740FCD23BCFECA20E8A3CB8909DM8PR09MB6677namp_" MIME-Version: 1.0 X-OriginatorOrg: fnal.gov X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: DM8PR09MB6677.namprd09.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: 7a5c4be0-3e2e-49e5-05b0-08da6bfdfbe9 X-MS-Exchange-CrossTenant-originalarrivaltime: 22 Jul 2022 16:19:42.3440 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 9d5f83d3-d338-4fd3-b1c9-b7d94d70255a X-MS-Exchange-Transport-CrossTenantHeadersStamped: SA0PR09MB7226 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_DM8PR09MB667740FCD23BCFECA20E8A3CB8909DM8PR09MB6677namp_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Folks, I am testing upgrade of my cluster from version 10.8 to 14.4 I encountered following error. Any help or insight is much appreciated. Thanks. *failure* Consult the last few lines of "pg_upgrade_dump_16400.log" for the probable cause of the failure. Last few lines of pg_upgrade_dump_16400.log: pg_restore: error: could not execute query: ERROR: column c.relhaspkey doe= s not exist LINE 19: "c"."relhaspkey" AS "haspkey", ^ Command was: -- For binary upgrade, must preserve pg_type oid SELECT pg_catalog.binary_upgrade_set_next_pg_type_oid('16681'::pg_catalog.o= id); -- For binary upgrade, must preserve pg_type array oid SELECT pg_catalog.binary_upgrade_set_next_array_pg_type_oid('16680'::pg_cat= alog.oid); -- For binary upgrade, must preserve pg_class oids SELECT pg_catalog.binary_upgrade_set_next_heap_pg_class_oid('16679'::pg_cat= alog.oid); CREATE VIEW "public"."all_tables" AS SELECT ((("n"."nspname")::"text" || '.'::"text") || ("c"."relname")::"text"= ) AS "tablename", --_000_DM8PR09MB667740FCD23BCFECA20E8A3CB8909DM8PR09MB6677namp_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Folks,

 

I am testing upgrad= e of my cluster from version 10.8 to 14.4

 

I encountered follo= wing error. Any help or insight is much appreciated.

 

Thanks.<= /span>

 

 

*failure*

Consult the last fe= w lines of "pg_upgrade_dump_16400.log" for

the probable cause = of the failure.

 

 

Last few lines of p= g_upgrade_dump_16400.log:

 

pg_restore: error: = could not execute query: ERROR:  column c.relhaspkey does not exist

LINE 19:  = ;   "c"."relhaspkey" AS "haspkey",<= o:p>

   &= nbsp;         ^

Command was:

-- For binary upgra= de, must preserve pg_type oid

SELECT pg_catalog.b= inary_upgrade_set_next_pg_type_oid('16681'::pg_catalog.oid);

 

 

-- For binary upgra= de, must preserve pg_type array oid

SELECT pg_catalog.b= inary_upgrade_set_next_array_pg_type_oid('16680'::pg_catalog.oid);

 

 

-- For binary upgra= de, must preserve pg_class oids

SELECT pg_catalog.b= inary_upgrade_set_next_heap_pg_class_oid('16679'::pg_catalog.oid);

 

CREATE VIEW "p= ublic"."all_tables" AS

SELECT ((("n&q= uot;."nspname")::"text" || '.'::"text") || (&= quot;c"."relname")::"text") AS "tablename&quo= t;,

 

 

--_000_DM8PR09MB667740FCD23BCFECA20E8A3CB8909DM8PR09MB6677namp_--