Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qsGj9-007MoD-55 for pgsql-hackers@arkaria.postgresql.org; Mon, 16 Oct 2023 06:05:18 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qsGj6-00G9dD-H7 for pgsql-hackers@arkaria.postgresql.org; Mon, 16 Oct 2023 06:05:17 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qsGj6-00G9d4-7C for pgsql-hackers@lists.postgresql.org; Mon, 16 Oct 2023 06:05:16 +0000 Received: from mail-yw1-x112e.google.com ([2607:f8b0:4864:20::112e]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qsGj4-000hpW-EX for pgsql-hackers@lists.postgresql.org; Mon, 16 Oct 2023 06:05:15 +0000 Received: by mail-yw1-x112e.google.com with SMTP id 00721157ae682-5a7b3d33663so56005377b3.3 for ; Sun, 15 Oct 2023 23:05:14 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=leadboat.com; s=google; t=1697436314; x=1698041114; darn=lists.postgresql.org; h=user-agent:in-reply-to:content-disposition:mime-version:references :message-id:subject:cc:to:from:date:from:to:cc:subject:date :message-id:reply-to; bh=hRxwBc6mJk2i+gaNisCoxymnK18Ot4LEBtDTnbJl86Y=; b=QotmstMxogZcChyoYQdIVDroTjhvgtSzLnMsdUz0OfMus/2kwkh+p6SMDIi3PWJrLt RQjp81oEP5i2uebtvStkBzaXOXuZDaxGLhiWlTAepkD0vX5lxPnqfNQ97cvtFdGbl5Oa wkA+8CrQ3cc+DagjTYmj4nrpZIIUzMl6Kn5LM= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1697436314; x=1698041114; h=user-agent:in-reply-to:content-disposition:mime-version:references :message-id:subject:cc:to:from:date:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=hRxwBc6mJk2i+gaNisCoxymnK18Ot4LEBtDTnbJl86Y=; b=WVO80VwcvwUkKzThk/TORaiPy2eKGBrKJJ9XogEAhvmGP/x//1NnjCVcWSy2GsGNyW sVMwp9p+ZW9GcalaBN1YeMXX8GwndFDMe0tJPkK8z4N56Y1witImKM/ubkdmf5fkbGzR 5+zPdaDNUc6t6/EZm3ti9gSkGIfLXED5a2Y08S/+zGP6GyOTujmjlmxJ/ecVPa8Le7b3 IJjPVH0EI7JKi6osvGFA2vlww1Z9wa5uz3cKEL5ovmmM4BHqdO3FsVV5FfX2NpXKyeOm yuFSc3P9l0qgSnkD1H03JG/+WCdo3PpjvduTjx6QBChTcQiB7LIND5OpR8zzrvw+LLfM wWlg== X-Gm-Message-State: AOJu0Yyp93+A8+kL92u++/8yze4o7qBx4UFbrhuciypveavj/CTmu0nk cLKsBpnufiPPnwHOdr1fm47u2Q== X-Google-Smtp-Source: AGHT+IGEiRFGI4ShLKvTycgCAs3troqX+Rimr3k789Am1C96N6JrclFtuBTN/f6lwVovb1jWmnTyJw== X-Received: by 2002:a81:53c2:0:b0:594:e2e6:25e8 with SMTP id h185-20020a8153c2000000b00594e2e625e8mr31472852ywb.48.1697436313788; Sun, 15 Oct 2023 23:05:13 -0700 (PDT) Received: from rfd.leadboat.com ([2600:1702:a20:5750::2e]) by smtp.gmail.com with ESMTPSA id r7-20020a0dcf07000000b005950e1bbf11sm1933849ywd.60.2023.10.15.23.05.12 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Sun, 15 Oct 2023 23:05:13 -0700 (PDT) Date: Sun, 15 Oct 2023 23:05:10 -0700 From: Noah Misch To: Tom Lane Cc: Thomas Munro , Michael Paquier , Vik Fearing , cary huang , pgsql-hackers@lists.postgresql.org Subject: Re: Add support for AT LOCAL Message-ID: <20231016060510.72@rfd.leadboat.com> References: <2188264.1697425365@sss.pgh.pa.us> <2191749.1697427017@sss.pgh.pa.us> <20231016045804.c0@rfd.leadboat.com> <20231016055051.3a@rfd.leadboat.com> <2208907.1697435663@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <2208907.1697435663@sss.pgh.pa.us> User-Agent: Mutt/2.2.12 (2023-09-09) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, Oct 16, 2023 at 01:54:23AM -0400, Tom Lane wrote: > Noah Misch writes: > > On Sun, Oct 15, 2023 at 09:58:04PM -0700, Noah Misch wrote: > >> Works for me. I've started a test run with the xlc version change. > > > It failed similarly: > > > + 23:59:00-07 | 4294966103:4294967295:00+00 | 4294966103:4294967295:00+00 | 4294966103:4294967295:00+00 > > + 23:59:59.99-07 | 4294966103:00:00.01+00 | 4294966103:00:00.01+00 | 4294966103:00:00.01+00 > > Ugh. So if the failure is robust enough to persist across > several major xlc versions, why couldn't Thomas reproduce it? Beats me. hornet wipes its starting environment down to OBJECT_MODE=32_64 PERL5LIB=/home/nm/sw/cpan64/lib/perl5 SPECIES=xlc64 PATH=/usr/bin, then applies all the environment settings seen in buildfarm logs.