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 1ll6eK-0002Ov-1E for pgsql-hackers@arkaria.postgresql.org; Mon, 24 May 2021 09:13:26 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ll6eI-0001jq-T7 for pgsql-hackers@arkaria.postgresql.org; Mon, 24 May 2021 09:13:22 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ll6eB-0001ez-Jy for pgsql-hackers@lists.postgresql.org; Mon, 24 May 2021 09:13:22 +0000 Received: from mail-io1-xd32.google.com ([2607:f8b0:4864:20::d32]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1ll6dp-0001V6-Nh for pgsql-hackers@lists.postgresql.org; Mon, 24 May 2021 09:13:08 +0000 Received: by mail-io1-xd32.google.com with SMTP id d25so15337702ioe.1 for ; Mon, 24 May 2021 02:12:53 -0700 (PDT) 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:content-transfer-encoding:in-reply-to :user-agent; bh=2H0dbbtZiAZyJmEIbkKFaCO09w/ipjGpuwpJCAJciDY=; b=GZwjwh6Wfv2hmG8d/JVHD6vfwFTliCm1mwcDdDGHmOIPqZ9Va+fk/z5i72ISiBI90P ehfmD46Psp47pBtVRjspTVxTC4lwf3EwXNLJ9FacYs5gBUTOrR3H0cVfj2Hgr4yvcSKH BarqITNz7sRP2Hr5eUbMxccn8rtNzvqVRi+Bw= 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:content-transfer-encoding :in-reply-to:user-agent; bh=2H0dbbtZiAZyJmEIbkKFaCO09w/ipjGpuwpJCAJciDY=; b=sDYhAQMnTJwIK9TZNC/jH43yL2P+Ep0JDLo6ln5jd2fCIHlKCqvVuPkgUXg4IbQPuJ YEbtLY1zQEa+zGKpqydJIPNcnqV8uiFCCu0VjR/pWmUDpZcAAFpY/E7FGMVORbmwhy3R 4XRiD6ZmbxyIkIHFvs8fKyJ7ufDG83I9PNvZmhgp0Dtw6hwMYTuFYUx+uRPRB2lljM4z 8rByCIdYF7Y3CZMaFivachFXGBSWsPL0G1oPTJt4mjmnVy5WffuA59XBzXj1MFppu9QC rqkDngsdukn6WUTxbbNA0l23yy3zj+nk8tRe/WiPA+wlSIx/vbeiTEE0oDrxw+lHYkvi O89g== X-Gm-Message-State: AOAM530prtDYCxdObCsmT+KfniAaDM1wkR7/SHDr0YGMoP4hph1rb5Il b9lH5RSBM1JEjOUiWQXJOjNqISnR1CJUNw== X-Google-Smtp-Source: ABdhPJwtRduETbwwtSvTfcqHSEngaV7Z5LPPfQODzd7C7cbiG/JRS9saszX2b9uS+cINgVTWpouSeg== X-Received: by 2002:a63:fe03:: with SMTP id p3mr12402584pgh.27.1621847236321; Mon, 24 May 2021 02:07:16 -0700 (PDT) Received: from rfd.leadboat.com ([2600:1702:a20:5750::46]) by smtp.gmail.com with ESMTPSA id t25sm10457650pfl.68.2021.05.24.02.07.14 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Mon, 24 May 2021 02:07:15 -0700 (PDT) Date: Mon, 24 May 2021 02:07:12 -0700 From: Noah Misch To: Alvaro Herrera Cc: Amit Langote , Justin Pryzby , Tom Lane , PostgreSQL Hackers Subject: Re: ALTER TABLE .. DETACH PARTITION CONCURRENTLY Message-ID: <20210524090712.GA3771394@rfd.leadboat.com> References: <20210421004649.GA1951@alvherre.pgsql> <20210421203855.GA19814@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <20210421203855.GA19814@alvherre.pgsql> User-Agent: Mutt/1.5.24 (2015-08-30) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, Apr 21, 2021 at 04:38:55PM -0400, Alvaro Herrera wrote: [fix to let CLOBBER_CACHE_ALWAYS pass] > Barring objections, I will get this pushed early tomorrow. prairiedog and wrasse failed a $SUBJECT test after this (commit 8aba932). Also, some non-CLOBBER_CACHE_ALWAYS animals failed a test before the fix. These IsolationCheck failures match detach-partition-concurrently[^\n]*FAILED: sysname │ snapshot │ branch │ bfurl ────────────┼─────────────────────┼────────┼──────────────────────────────────────────────────────────────────────────────────────────────── hyrax │ 2021-03-27 07:29:34 │ HEAD │ http://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=hyrax&dt=2021-03-27%2007%3A29%3A34 topminnow │ 2021-03-28 20:37:38 │ HEAD │ http://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=topminnow&dt=2021-03-28%2020%3A37%3A38 trilobite │ 2021-03-29 18:14:24 │ HEAD │ http://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=trilobite&dt=2021-03-29%2018%3A14%3A24 hyrax │ 2021-04-01 07:21:10 │ HEAD │ http://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=hyrax&dt=2021-04-01%2007%3A21%3A10 dragonet │ 2021-04-01 19:48:03 │ HEAD │ http://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=dragonet&dt=2021-04-01%2019%3A48%3A03 avocet │ 2021-04-05 15:45:56 │ HEAD │ http://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=avocet&dt=2021-04-05%2015%3A45%3A56 hyrax │ 2021-04-06 07:15:16 │ HEAD │ http://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=hyrax&dt=2021-04-06%2007%3A15%3A16 hyrax │ 2021-04-11 07:25:50 │ HEAD │ http://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=hyrax&dt=2021-04-11%2007%3A25%3A50 hyrax │ 2021-04-20 18:25:37 │ HEAD │ http://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=hyrax&dt=2021-04-20%2018%3A25%3A37 wrasse │ 2021-04-21 10:38:32 │ HEAD │ http://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=wrasse&dt=2021-04-21%2010%3A38%3A32 prairiedog │ 2021-04-25 22:05:48 │ HEAD │ http://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=prairiedog&dt=2021-04-25%2022%3A05%3A48 wrasse │ 2021-05-11 03:43:40 │ HEAD │ http://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=wrasse&dt=2021-05-11%2003%3A43%3A40 (12 rows)