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 1mqJY0-000349-EL for pgsql-hackers@arkaria.postgresql.org; Thu, 25 Nov 2021 18:32:40 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mqJXz-0001iR-31 for pgsql-hackers@arkaria.postgresql.org; Thu, 25 Nov 2021 18:32:39 +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 1mqJXy-0001iD-PS for pgsql-hackers@lists.postgresql.org; Thu, 25 Nov 2021 18:32:38 +0000 Received: from new2-smtp.messagingengine.com ([66.111.4.224]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mqJXv-0005hT-Kv for pgsql-hackers@lists.postgresql.org; Thu, 25 Nov 2021 18:32:38 +0000 Received: from compute3.internal (compute3.nyi.internal [10.202.2.43]) by mailnew.nyi.internal (Postfix) with ESMTP id 7F95F5806BC; Thu, 25 Nov 2021 13:32:34 -0500 (EST) Received: from mailfrontend2 ([10.202.2.163]) by compute3.internal (MEProxy); Thu, 25 Nov 2021 13:32:34 -0500 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= fm1; bh=nbAiA+aQggyake5Jq2uoyohHnvIWfZTOmX1EjmQvC0M=; b=kr8ZrTmh rGxuOZDM1ju37vn6A9tfjeENDR00t8rJfld+SBSLCYzUnfc+uK1YjlcP91H1pTIF TvzUoRbrZXDXADRWJoY2Hs+AiKUtgBPU5wHLNawWDABZTdpCe5rnv6amTZRHiSG/ m5FNqDF3sJkZVO9NBLONq2uLTjcFt2y5A7F2JgxCBi9HAoQf25wa+sLj3Xknc3tL h9PVyNE/Kh41oQY11CbVr1YrUfInuyRHEOIaLswpGvn6faoatBu4XcWT7UVhbfgX KtAwx3b40p8YuGm3j2xM0eMIR88udhGcXXVKIEiUeRYIfzEoTTvOtTw3Zz3Hl/DN YcWueISpCW8f4Q== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvuddrhedtgdduudefucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepfffhvffukfggtggugfgjsehtkeertddttdejnecuhfhrohhmpeetlhhvrghr ohcujfgvrhhrvghrrgcuoegrlhhvhhgvrhhrvgesrghlvhhhrdhnohdqihhprdhorhhgqe enucggtffrrghtthgvrhhnpedujeevjeffjeevuddutedvkeeiueeitddvieelfeekveej udefgeeuvdejhfeuleenucffohhmrghinhepvghnthgvrhhprhhishgvuggsrdgtohhmne cuvehluhhsthgvrhfuihiivgepudenucfrrghrrghmpehmrghilhhfrhhomheprghlvhhh vghrrhgvsegrlhhvhhdrnhhoqdhiphdrohhrgh X-ME-Proxy: Received: by mail.messagingengine.com (Postfix) with ESMTPA; Thu, 25 Nov 2021 13:32:33 -0500 (EST) Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id 2BA5B2A07F5; Thu, 25 Nov 2021 15:32:31 -0300 (-03) Date: Thu, 25 Nov 2021 15:32:31 -0300 From: Alvaro Herrera To: Amul Sul Cc: Tom Lane , Andres Freund , Andrew Dunstan , "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: <202111251832.22chedo6btui@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <202111251830.w6jpp6h5t2eu@alvherre.pgsql> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Oh, but also I think I should push a mitigation in case a production system hits this problem: maybe reduce the message from FATAL to WARNING if the registered LSN is at a page boundary. -- Álvaro Herrera Valdivia, Chile — https://www.EnterpriseDB.com/ "Entristecido, Wutra (canción de Las Barreras) echa a Freyr a rodar y a nosotros al mar"