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 1jR1a5-0006pw-Ps for pgsql-bugs@arkaria.postgresql.org; Tue, 21 Apr 2020 22:41:30 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jR1a4-00070n-F0 for pgsql-bugs@arkaria.postgresql.org; Tue, 21 Apr 2020 22:41:28 +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 1jR1a4-0006zt-0F for pgsql-bugs@lists.postgresql.org; Tue, 21 Apr 2020 22:41:28 +0000 Received: from mail.dalibo.com ([212.85.157.172]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jR1a1-0001D1-Bu for pgsql-bugs@lists.postgresql.org; Tue, 21 Apr 2020 22:41:26 +0000 Received: from firost (larco.ioguix.net [82.66.0.6]) by mail.dalibo.com (Postfix) with ESMTPSA id 075D8205BD; Wed, 22 Apr 2020 00:41:22 +0200 (CEST) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=dalibo.com; s=a; t=1587508882; bh=uiWQuqn1/cfahNchaZiNN4zp0pxW+U5n+0fzwpYHfyA=; h=Date:From:To:Cc:Subject:In-Reply-To:References:From; b=ffLADLNqql5gaBOaM4sjtIbzwykBfEYdHJOAUsc8+qmk2jpRhhiO5MYI9QZIdI88C QxzejlljkpxT99JORcTD55EWDuFnLWGViHmvTRCN7lGs69gFgysY+I1XSl4PjIojoE iZ3KMO86FLEXQRS7oi143UoQe/sy6fanHSEcpoDs= Date: Wed, 22 Apr 2020 00:41:21 +0200 From: Jehan-Guillaume de Rorthais To: Michael Paquier Cc: Kyotaro Horiguchi , masao.fujii@oss.nttdata.com, pgsql-bugs@lists.postgresql.org Subject: Re: [BUG] non archived WAL removed during production crash recovery Message-ID: <20200422004121.516a5a32@firost> In-Reply-To: <20200421021501.GE77439@paquier.xyz> References: <20200417065043.GC350229@paquier.xyz> <20200417153304.01a226cc@firost> <20200418092611.GD350229@paquier.xyz> <20200420.160231.719176619682386260.horikyota.ntt@gmail.com> <20200420073444.GA77439@paquier.xyz> <20200420142235.1536a73b@firost> <20200421021501.GE77439@paquier.xyz> Organization: Dalibo MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Hello, I did another round of review of v8. - LocalRecoveryInProgress =3D xlogctl->SharedRecoveryInProgress; + LocalRecoveryInProgress =3D (xlogctl->SharedRecoveryState !=3D RECOVERY_STATE_DONE); Do we need to acquire info_lck to look at the state here, as we do in GetRecoveryState()? Why is it missing from previous code where SharedRecoveryInProgress was protected by info_lck as well? Plus, the new line length overflow the 80-column, but I'm not sure where to break this line. +if ($Config{osname} eq 'MSWin32') +{ + + # some Windows Perls at least don't like IPC::Run's start/kill_kill regime. + plan skip_all =3D> "Test fails on Windows perl"; +} In fact, this was inherited from 011_crash_recovery.pl where I originally added some tests. As 020_archive_status.pl doesn't use IPC::Run, the commen= t is wrong. But I wonder if this whole block is really needed. Unfortunately I c= an't test on MSWin32 :/ On Tue, 21 Apr 2020 11:15:01 +0900 Michael Paquier wrote: > > Indeed, Beno=C3=AEt Lobr=C3=A9au reported this behavior to me. =20 >=20 > Noted. Thanks for the information. I don't think that I have ever > met Beno=C3=AEt in person, do I? I don't think so. > Tell him that I owe him one beer or a beverage of his choice when we meet > IRL, and that he had better use this message-id to make me keep my promis= e :) I told him (but I'm sure he was reading anyway :)). Regards,