Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gddxj-0002ar-Qx for pgsql-hackers@arkaria.postgresql.org; Sun, 30 Dec 2018 16:29:16 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gddxi-0004Vw-Hc for pgsql-hackers@arkaria.postgresql.org; Sun, 30 Dec 2018 16:29:14 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gddxi-0004PD-01 for pgsql-hackers@lists.postgresql.org; Sun, 30 Dec 2018 16:29:14 +0000 Received: from mail-io1-xd41.google.com ([2607:f8b0:4864:20::d41]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gddxe-0001K4-Vt for pgsql-hackers@postgresql.org; Sun, 30 Dec 2018 16:29:13 +0000 Received: by mail-io1-xd41.google.com with SMTP id f4so1835458ion.2 for ; Sun, 30 Dec 2018 08:29:10 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=leadboat.com; s=google; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to:user-agent; bh=ez4TJRhT8TCgFU8ZLVULF8uTkmwVAyW6xVzDtR02EVQ=; b=YgtY+SpSHPGU1FgWEsq4JvH1lHPekPYX4GWK8Bh3Kgvi2R4ihRccYmAT+rBnupV+LU OuyXkuf6shMqO8MUBOtg4F9VgDF7NHQF8N1HPdlgNIvnqm/oRWH1nH7d4lU7x8ytDi1q ZPgP7qvyyWoOV4qje2u6a6TYob043VROoGOLU= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:in-reply-to:user-agent; bh=ez4TJRhT8TCgFU8ZLVULF8uTkmwVAyW6xVzDtR02EVQ=; b=CRefopHuHJ+4wi7sM/r5+Tkd/uxm33o+raHMF0GiRBkT/aVKVeJ/mZuSsClizIezDz 4CGu4w0d95ZllVcbhMxDStLHD6EFVYw14P7/iFXfqnXU+7EHQV13LdW5cHVwgU7/TVUo BSra6OU++SHZ+py4Fv2HvBIlSm57+VZuw11zpea0P5JXJ6PtkePP920V7fpjVjF0Nq7d tzCZAXfH9tkPj0dLUuv/3HV0aqTwdrw5creBPxL7Yf7IqjImZOxMzNMf1l9ok583TwVp wrWiq+RUG6CS6qFIZBUfkWP4wxWGSLKQiiuBN8f/vpw+EEhfJx0Oig67dlW1DFLF6vSA QPag== X-Gm-Message-State: AJcUukeWsY0foBDgpL6uixSAEMM42RAe4GMR1MuzPisV2Ooh+BGUBv5e h54jSj3cnVHYlLTBmuNb7WjC+A== X-Google-Smtp-Source: ALg8bN4AOb/7S/RuLYFj3C1+D/8JOhSXJjmGWbI2vxee0nXqTwQg46beXZpdHEN/gRb3g6dzOI5emw== X-Received: by 2002:a6b:9355:: with SMTP id v82mr24609830iod.40.1546187347815; Sun, 30 Dec 2018 08:29:07 -0800 (PST) Received: from gust.leadboat.com ([172.243.182.239]) by smtp.gmail.com with ESMTPSA id e22sm20577138iod.47.2018.12.30.08.29.01 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Sun, 30 Dec 2018 08:29:06 -0800 (PST) Date: Sun, 30 Dec 2018 11:28:56 -0500 From: Noah Misch To: Andrew Dunstan Cc: Tom Lane , pgsql-hackers@postgresql.org Subject: Re: Move regression.diffs of pg_upgrade test suite Message-ID: <20181230162856.GA187973@gust.leadboat.com> References: <20181224034411.GA3224776@rfd.leadboat.com> <22708.1545861757@sss.pgh.pa.us> <20181226224428.GA3277716@rfd.leadboat.com> <37ead3b7-b4a9-5a1f-6a10-c6ab9eb0d2aa@2ndQuadrant.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <37ead3b7-b4a9-5a1f-6a10-c6ab9eb0d2aa@2ndQuadrant.com> User-Agent: Mutt/1.5.24 (2015-08-30) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Sun, Dec 30, 2018 at 10:41:46AM -0500, Andrew Dunstan wrote: > On 12/26/18 5:44 PM, Noah Misch wrote: > > On Wed, Dec 26, 2018 at 05:02:37PM -0500, Tom Lane wrote: > >> Andrew Dunstan writes: > >>> On 12/23/18 10:44 PM, Noah Misch wrote: > >>>> A disadvantage of any change here is that it degrades buildfarm reports, which > >>>> recover slowly as owners upgrade to a fixed buildfarm release. This will be > >>>> similar to the introduction of --outputdir=output_iso. On non-upgraded > >>>> animals, pg_upgradeCheck failures will omit regression.diffs. > >> Do we need to change anything in the buildfarm client to improve its > >> response to this? If so, seems like it might be advisable to make a > >> buildfarm release with the upgrade before committing the change. > >> Sure, not all owners will update right away, but if they don't even > >> have the option then we're not in a good place. > > > > It would have been convenient if, for each test target, PostgreSQL code > > decides the list of interesting log files and presents that list for the > > buildfarm client to consume. It's probably overkill to redesign that now, > > though. I also don't think it's of top importance to have unbroken access to > > this regression.diffs, because defects that cause this run to fail will > > eventually upset "install-check-C" and/or "check". Even so, it's fine to > > patch the buildfarm client in advance of the postgresql.git change: > > > > diff --git a/PGBuild/Modules/TestUpgrade.pm b/PGBuild/Modules/TestUpgrade.pm > I'll commit this or something similar, but I generally try not to make > new releases more frequently than once every 3 months, and it's only six > weeks since the last release. So unless there's a very good reason I am > not planning on a release before February. There's no rush; I don't recall other reports of the spurious failure described in the original post. I'll plan to push the postgresql.git change around 2019-03-31, so animals updating within a month of release will have no degraded pg_upgradeCheck failure reports.