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 1lI1ni-0005fI-Kl for pgsql-hackers@arkaria.postgresql.org; Fri, 05 Mar 2021 04:10:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lI1nh-000535-Gl for pgsql-hackers@arkaria.postgresql.org; Fri, 05 Mar 2021 04:10:53 +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 1lI1nh-00052y-A5 for pgsql-hackers@lists.postgresql.org; Fri, 05 Mar 2021 04:10:53 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lI1nf-0004Rv-A4 for pgsql-hackers@lists.postgresql.org; Fri, 05 Mar 2021 04:10:52 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 1254AjVl1437805; Thu, 4 Mar 2021 23:10:45 -0500 From: Tom Lane To: Peter Geoghegan cc: Kyotaro Horiguchi , PostgreSQL Hackers , Craig Ringer , Robert Haas Subject: Re: 011_crash_recovery.pl intermittently fails In-reply-to: <1437508.1614916929@sss.pgh.pa.us> References: <20210305.115011.558061052471425531.horikyota.ntt@gmail.com> <1436448.1614915141@sss.pgh.pa.us> <1437508.1614916929@sss.pgh.pa.us> Comments: In-reply-to Tom Lane message dated "Thu, 04 Mar 2021 23:02:09 -0500" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <1437803.1614917445.1@sss.pgh.pa.us> Date: Thu, 04 Mar 2021 23:10:45 -0500 Message-ID: <1437804.1614917445@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk I wrote: > I'd be kind of inclined to remove this test script altogether, on the > grounds that it's wasting cycles on a function that doesn't really > do what is claimed (and we should remove the documentation claim, too). Alternatively, maybe we can salvage the function's usefulness by making it flush WAL before returning? If we go that route, then we have the opposite problem with respect to the test script: rather than trying to make it paper over the function's problems, we ought to try to make it reliably fail with the code as it stands. regards, tom lane