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 1mb7vY-00065G-15 for pgsql-hackers@arkaria.postgresql.org; Thu, 14 Oct 2021 21:06:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mb7vV-0002dC-KR for pgsql-hackers@arkaria.postgresql.org; Thu, 14 Oct 2021 21:06:09 +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 1mb7vU-0002bC-Vw for pgsql-hackers@lists.postgresql.org; Thu, 14 Oct 2021 21:06:09 +0000 Received: from mail-pj1-x102e.google.com ([2607:f8b0:4864:20::102e]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1mb7vR-0006yu-1m for pgsql-hackers@postgresql.org; Thu, 14 Oct 2021 21:06:07 +0000 Received: by mail-pj1-x102e.google.com with SMTP id q10-20020a17090a1b0a00b001a076a59640so6174433pjq.0 for ; Thu, 14 Oct 2021 14:06:04 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; h=mime-version:subject:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to; bh=vs6t8h6XXKSJAti7lyKS4KorNsyhObWtL3meDCZy90I=; b=V1ldGq0aQWLCM3oI47wdXsaF2bZkDORNDl37wQETxrgCwBeAA/X4nQm2WmZ0DUuO5m 1DUGDnPBlcbRUoGM29HvpU8rzvWgOEtYT5t7mf5s4dhkN9xNTbC15MAG6dgqVsCYI9f/ M863rbLYowSj7I+tGaetEfuVT/SqvxXCRqVlq7aWk1dXBsTXjMzt3jSORVoQOjig3u98 7dCeMSe0lw6jH3aREy34wdsyJkmU8XCzRpypidH+n+QhsZeLcW9HPfVTUEsJDfbZ8KKd o1CaCm6b8SZXNq6fXcBuv8GDbdEsWTlj2g5vCrSXjGlpapNkp5E3een95FG6cz24J8kp 4mGg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:mime-version:subject:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to; bh=vs6t8h6XXKSJAti7lyKS4KorNsyhObWtL3meDCZy90I=; b=JQmi+R7j2rYEe++nKuYb6dE6M5zD1GatC394k5DehE0sPAehSU84fmD4CDMFCXoMaM +YX11QonK+VwDBoMQjgBsUeNRvAGKBdGphdZ1uB+KHGmoMhYi6T4rIATpOXkBptd73Uk kD7uW1/PaOXQqWHq8wVxUEQEG55q6K6e7EB8PBySGHA3nvQZH6/qpYjPzgcmYu27Vw7u oCUDTaqRqoIWuEF3ItooyPOvTsvDp2M0hxcuZmMD5c7oM72yEBfm+rb0wLX7tWAp1keZ GwB8D3odDvd+KC7ByYMQxwESHiH1Qv6JVvDOTS4tioQrZWpOL8t9UytRkV+FM3Acywwu lblw== X-Gm-Message-State: AOAM531keV8kpLzk5IAlVRjA1hZuTlN9GrFoUylw8Ak1EFmv1u6BI0cw eY4SQplBuKPJTBwBLDs64hetTYeZwJUcqL6QpygfEQUn+YnRUxuLql9bD4q50/y9XxzLqYrNme0 ymhX1PWZw8l2+PJar68bAvN2CdtrUGATLqOCpPc0RbX+MansGkrkJE5+ZY8QJHudscqAqEvYciS K6CXlXZaxhURMok86JOPsvrJ6dtz6YURPUPc4E X-Google-Smtp-Source: ABdhPJzYlxjje87QbsuPAl9kZvxtWvUl2ixm2UGuWfLo7corj/JFOYbF0kTdJ/5Ej9OAIRMYLdls6Q== X-Received: by 2002:a17:902:a406:b029:12b:c50a:4289 with SMTP id p6-20020a170902a406b029012bc50a4289mr7154122plq.56.1634245562406; Thu, 14 Oct 2021 14:06:02 -0700 (PDT) Received: from laptop280-ma-us.hitronhub.home (24-113-193-150.wavecable.com. [24.113.193.150]) by smtp.gmail.com with ESMTPSA id b13sm10434040pjl.15.2021.10.14.14.06.01 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Thu, 14 Oct 2021 14:06:01 -0700 (PDT) Content-Type: text/plain; charset=utf-8 Mime-Version: 1.0 (Mac OS X Mail 13.4 \(3608.120.23.2.7\)) Subject: Re: BUG #17212: pg_amcheck fails on checking temporary relations From: Mark Dilger In-Reply-To: Date: Thu, 14 Oct 2021 14:06:00 -0700 Cc: Tom Lane , Peter Geoghegan , Robert Haas , Pavel Borisov , Alexander Lakhin , PostgreSQL-development Content-Transfer-Encoding: quoted-printable Message-Id: <02C6345B-D186-4F88-A976-A2CD1051CB93@enterprisedb.com> References: <17212-34dd4a1d6bba98bf@postgresql.org> <543F3BF3-EDED-4C52-AF05-623921B6C409@enterprisedb.com> <55A2BFE7-AAAF-4A64-BD3A-5C98EA982267@enterprisedb.com> <07159C9A-40DA-47BF-B2F4-! 203F5AC00890@enterprisedb.com> <40DB088B-C96F-49B2-BC84-BDC8D35C7E97@enterprisedb.com> <0B7DA7A4-2872-485B-BFDD-BF8E9BB07B26@enterprisedb.com> <726473.1634184950@sss.pgh.pa.us> To: Andrew Dunstan X-Mailer: Apple Mail (2.3608.120.23.2.7) X-CLOUD-SEC-AV-Info: enterprisedb,google_mail,monitor X-CLOUD-SEC-AV-Sent: true X-Gm-Spam: 0 X-Gm-Phishy: 0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > On Oct 14, 2021, at 1:50 PM, Andrew Dunstan = wrote: >=20 > Bowerbird is having similar issues, so I don't think this is just a > transient. The pg_amcheck patch Peter committed for me adds a new test, = src/bin/pg_amcheck/t/006_bad_targets.pl, which creates two PostgresNode = objects (a primary and a standby) and uses = PostgresNode::background_psql(). It doesn't bother to "finish" the = returned harness, which may be the cause of an installation hanging = around long enough to be in the way when another test tries to start. Assuming this is right, the fix is just one line. Thoughts?=20 =E2=80=94 Mark Dilger EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company