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 1mVulv-0003PP-5N for pgsql-hackers@arkaria.postgresql.org; Thu, 30 Sep 2021 12:02:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mVulu-0002NS-3E for pgsql-hackers@arkaria.postgresql.org; Thu, 30 Sep 2021 12:02:42 +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 1mVult-0002NK-1i for pgsql-hackers@lists.postgresql.org; Thu, 30 Sep 2021 12:02:41 +0000 Received: from out2-smtp.messagingengine.com ([66.111.4.26]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mVulp-0005xu-Jc for pgsql-hackers@lists.postgresql.org; Thu, 30 Sep 2021 12:02:40 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.nyi.internal (Postfix) with ESMTP id 2FC385C0116; Thu, 30 Sep 2021 08:02:35 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute4.internal (MEProxy); Thu, 30 Sep 2021 08:02:35 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :date:from:in-reply-to:message-id:mime-version:subject:to :x-me-proxy:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s= fm3; bh=wqppw+KtynC9OFv6U62UHgSp0BOviZ9tIxE9K8xkjS0=; b=d8swcXHn QZV2XdhnBP9hAkkQC+Jq2XWBr3inGbBNByI3VFVTX4G6PtUDcF38G5ANkTF7UB9w 2r35uWl1K29fYuTyV0hNTbK0blG7QjefAivjGMfc9DeC65zfZIIdDKrYCZg+nFY2 RyLePlv0TYwTGLOV0rfp4Gsyalq7QTjYoCaCuxhSv7R8O91El1u4nSr+MZ3BMlfW IjujknRzGfuN+iduvYY5qDvGpvMV/O+mYXoxapK7D/c/FKB8SMR2JKi/G0GuqWi1 +McQSZ9Yjal5rhosqGbnpUcgznCmWMVfzhBnC5ttkMMOo4o7uZWtH+MaQ3Ypc2Ma Mi8hce0n0BaCTg== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvtddrudekgedggeeiucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepfffhvffukfggtggugfgjsehtkeertddttdejnecuhfhrohhmpeetlhhvrghr ohcujfgvrhhrvghrrgcuoegrlhhvhhgvrhhrvgesrghlvhhhrdhnohdqihhprdhorhhgqe enucggtffrrghtthgvrhhnpedujeevjeffjeevuddutedvkeeiueeitddvieelfeekveej udefgeeuvdejhfeuleenucffohhmrghinhepvghnthgvrhhprhhishgvuggsrdgtohhmne cuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomheprghlvhhh vghrrhgvsegrlhhvhhdrnhhoqdhiphdrohhrgh X-ME-Proxy: Received: by mail.messagingengine.com (Postfix) with ESMTPA; Thu, 30 Sep 2021 08:02:33 -0400 (EDT) Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id EED562A06AB; Thu, 30 Sep 2021 09:02:30 -0300 (-03) Date: Thu, 30 Sep 2021 09:02:30 -0300 From: Alvaro Herrera To: Andres Freund Cc: Andrew Dunstan , Tom Lane , "Bossart, Nathan" , Kyotaro Horiguchi , "masao.fujii@oss.nttdata.com" , "pgsql-hackers@lists.postgresql.org" , "mengjuan.cmj@alibaba-inc.com" , "Jakub.Wartak@tomtom.com" , Ryo Matsumura Subject: Re: prevent immature WAL streaming Message-ID: <202109301202.auuu5xbsvkut@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <20210930075152.wqu6q4pqkoospsyq@alap3.anarazel.de> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hello On 2021-Sep-30, Andres Freund wrote: > FWIW, with that fixed I see the test hanging (e.g. [1]): > > can't unlink c:/cirrus/src/test/recovery/tmp_check/t_026_overwrite_contrecord_primary2_data/archives/000000010000000000000008.fail: Permission denied at t/026_overwrite_contrecord.pl line 189. > ### Stopping node "primary2" using mode immediate > # Running: pg_ctl -D c:/cirrus/src/test/recovery/tmp_check/t_026_overwrite_contrecord_primary2_data/pgdata -m immediate stop > waiting for server to shut down........................................................................................................................... failed > pg_ctl: server does not shut down > Bail out! command "pg_ctl -D c:/cirrus/src/test/recovery/tmp_check/t_026_overwrite_contrecord_primary2_data/pgdata -m immediate stop" exited with value 1 > Warning: unable to close filehandle GEN6 properly: Bad file descriptor during global destruction. > > The hang seems to be fixed by uncommenting the $h->finish(). Was there a > reason you commented that out? Hmm, no -- I was experimenting to see what effect it had, and because I saw none, I left it like that. Let me fix both things and see what happens next. > THe test still fails, but at least it doesn't hang anymore. I'll try and get it fixed, but ultimately we can always "fix" this test by removing it. It is only in 14 and master; the earlier branches only have the first part of this test file. (That's because I ran out of patience trying to port it to versions lacking LSN operators and such.) I think the second half doesn't provide all that much additional coverage anyway. -- Álvaro Herrera Valdivia, Chile — https://www.EnterpriseDB.com/ "Ellos andaban todos desnudos como su madre los parió, y también las mujeres, aunque no vi más que una, harto moza, y todos los que yo vi eran todos mancebos, que ninguno vi de edad de más de XXX años" (Cristóbal Colón)