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 1mqKGR-0005Ns-Em for pgsql-hackers@arkaria.postgresql.org; Thu, 25 Nov 2021 19:18:35 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mqKGQ-0003Li-7k for pgsql-hackers@arkaria.postgresql.org; Thu, 25 Nov 2021 19:18:34 +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 1mqKGP-0003LZ-UP for pgsql-hackers@lists.postgresql.org; Thu, 25 Nov 2021 19:18:33 +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 1mqKGN-00061h-Mk for pgsql-hackers@lists.postgresql.org; Thu, 25 Nov 2021 19:18:33 +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 1APJIKpj313646; Thu, 25 Nov 2021 14:18:20 -0500 From: Tom Lane To: Alvaro Herrera cc: Amul Sul , 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 In-reply-to: <202111251915.zme6752ri4w3@alvherre.pgsql> References: <202111251915.zme6752ri4w3@alvherre.pgsql> Comments: In-reply-to Alvaro Herrera message dated "Thu, 25 Nov 2021 16:15:48 -0300" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <313644.1637867900.1@sss.pgh.pa.us> Date: Thu, 25 Nov 2021 14:18:20 -0500 Message-ID: <313645.1637867900@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Alvaro Herrera writes: > On 2021-Nov-25, Tom Lane wrote: >> Uh, why? The fix should remove the problem, and if it doesn't, we're >> still looking at inconsistent WAL aren't we? > The problem is that the bug occurs while writing the WAL record. Fixed > servers won't produce such records, but if you run an unpatched server > and it happens to write one, without a mitigation you cannot get away > from FATAL during replay. Really? AFAICS the WAL record contains the correct value, or at least we should define that one as being correct, for precisely this reason. regards, tom lane