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 1paOdi-00078V-4E for pgsql-committers@arkaria.postgresql.org; Thu, 09 Mar 2023 22:21:34 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1paOdg-0004uE-1w for pgsql-committers@arkaria.postgresql.org; Thu, 09 Mar 2023 22:21:32 +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 1paOdf-0004u4-NJ for pgsql-committers@lists.postgresql.org; Thu, 09 Mar 2023 22:21:31 +0000 Received: from mail-pl1-x631.google.com ([2607:f8b0:4864:20::631]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1paOdY-0008RE-7X for pgsql-committers@lists.postgresql.org; Thu, 09 Mar 2023 22:21:31 +0000 Received: by mail-pl1-x631.google.com with SMTP id y11so3607522plg.1 for ; Thu, 09 Mar 2023 14:21:23 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=j-davis-com.20210112.gappssmtp.com; s=20210112; t=1678400482; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=mKv2uqi5BJxZI8sAnPd5fJCR0n6+gK0rCaa1h+cT44Y=; b=iJXlvlXW45YAbHiOiKHIAzOMsLYRVG86XziRy/TJLSP50wRiqcQ95eE6WpKAiMB0uh hYXt1rigkDm5bXGrld+hnbYMxt5eimF+Y6tumUigQZqBn2zOlSLzrM6/sBnTXA84vSp8 xV+LyMnoSSm+Lc4Gw5tyIm11D7I04QEzr231Nr46y9eHoJrH76fBkXeN+93rODLoWlSb j1FfL+yAJy8BTlVlS56Ct6dtewDgT5MZmCCBgfVLOWHi0rm/wVu2dYQ7Aaxf+P1jhcz1 k1RmhUnkRJ8kDBVkWwG1Y4Aso8IJUtcado+8U56A4802q53Y6KpAx0vW5PTD6to/nZLV KXMg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; t=1678400482; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=mKv2uqi5BJxZI8sAnPd5fJCR0n6+gK0rCaa1h+cT44Y=; b=SqDW9NVDLWhXTeO6bH+MbLb453/YhImkj8ckuOhkjFxVzg2NvoJKv5aQW/xKCVg7vp MNImbuOooSCkrIf7xUHgKaYUDdsOktIV2PzO74jy2gCWFvpeFvN0mehE27nPM11ch22l cpKXeLYs5LPl3GqsnWkrUaXGLAQ5PI0sIMllV5zRpEETJxqx51EHIyAlub15Oa5Rndqe foShrK8N+/PZ6Tm5eZxT2CEVTZEERBq5jtMNcRH8XBGJPAaXS+aCkepqCB6zvbmeWzOt WjeETfDP0hLVB3c37hdQxWxAW6jSLk45eWqMcx6CqoACCllzMXZiL9lDezx8az720moj OCiw== X-Gm-Message-State: AO0yUKXTz+0dmfzSANfrK0Ls1sPIHRtKCSRiD7j2Ai9yCaInvaoYg1jS ZZ+I3oDsrHiz6xmWOliLLtv8ZA== X-Google-Smtp-Source: AK7set+Ps4l09B/HA7zV/fYF0Gsx0GwjAy6NYFkx4XX3l47nmNlbIJP2/tdzBHwMbmgZaRnFp9H60g== X-Received: by 2002:a17:90b:4a8e:b0:234:156:dda7 with SMTP id lp14-20020a17090b4a8e00b002340156dda7mr24498324pjb.28.1678400482206; Thu, 09 Mar 2023 14:21:22 -0800 (PST) Received: from jeff-laptop.lan (c-73-231-146-4.hsd1.ca.comcast.net. [73.231.146.4]) by smtp.gmail.com with ESMTPSA id v4-20020a654604000000b004fb5f4bf585sm77223pgq.78.2023.03.09.14.21.21 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 09 Mar 2023 14:21:21 -0800 (PST) Message-ID: <3db075bb0327c0ebbca130692eb47dc1376c4766.camel@j-davis.com> Subject: Re: pgsql: pg_upgrade: copy locale and encoding information to new cluster. From: Jeff Davis To: Andrew Dunstan , Jeff Davis , pgsql-committers@lists.postgresql.org Date: Thu, 09 Mar 2023 14:21:20 -0800 In-Reply-To: References: <0a364430-266e-1e1a-d5d8-1a5273c9ddb6@dunslane.net> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.44.4-0ubuntu1 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, 2023-03-09 at 09:35 -0800, Jeff Davis wrote: > On Thu, 2023-03-09 at 12:21 -0500, Andrew Dunstan wrote: > > This looks like it broke cross version upgrade testing. Old > > versions > > don't have datlocprovider. >=20 > Thank you, fixing. Just waiting for some CI tests. I fixed most of the problems, but I'm still seeing a failure on crake: https://buildfarm.postgresql.org/cgi-bin/show_stage_log.pl?nm=3Dcrake&dt=3D= 2023-03-09%2019%3A37%3A04&stg=3Dxversion-upgrade-REL9_4_STABLE-HEAD It seems only the 94 upgrade is failing, and the message seems unrelated to my change: "could not load library "$libdir/uuid-ossp": ERROR: could not access file "$libdir/uuid-ossp": No such file or directory In database: contrib_regression_uuid-ossp" Is that a transient failure? I tried locally testing the upgrades, but it seems like the version of master before my change (8dff2f224f) also fails the pg_upgrade test for all versions earlier than 10. I assume there are some extra steps to make the test work for earlier versions, but I haven't looked deeply yet. Regards, Jeff Davis