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 1jR43L-0003cG-VE for pgsql-bugs@arkaria.postgresql.org; Wed, 22 Apr 2020 01:19:52 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jR43K-0008Av-EJ for pgsql-bugs@arkaria.postgresql.org; Wed, 22 Apr 2020 01:19:50 +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 1jR43I-0008An-PM for pgsql-bugs@lists.postgresql.org; Wed, 22 Apr 2020 01:19:50 +0000 Received: from out2-smtp.messagingengine.com ([66.111.4.26]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jR43E-0002bU-KM for pgsql-bugs@lists.postgresql.org; Wed, 22 Apr 2020 01:19:48 +0000 Received: from compute3.internal (compute3.nyi.internal [10.202.2.43]) by mailout.nyi.internal (Postfix) with ESMTP id 6E5B85C0140; Tue, 21 Apr 2020 21:19:42 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute3.internal (MEProxy); Tue, 21 Apr 2020 21:19:42 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= date:from:to:cc:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm1; bh=1rypOHW8dX+w5qi4lrYMM6bGkmb v3O7cRuyBLOdU5J0=; b=ObT4utm6mdxZSHYuG8DMxusqwezDyurcTdtWh9UKePt oTt/f2tMUqRUrU6XT6D66TGp6km+GxIK4OiFTrASOUxd/rsVvdJp+xTP3naciWCO cJJfVDF/EhBUzhuwmX95A1uuG+KPGZoTX3xorC7CkJstbqpMpOw8NRkbyzoYcuED phspBk4FQNX9yyiRCXn1bJZ7XDJ8O+0YeJVEMqHQl5rOuSMdvOUu10nqI6VfVYC7 fxO6zoqNRPySYSfzKNN49+OcDtQ76zmGMkIkVggxv3pNnrQzmw2sW79KDwkd2Q7k KqB76dh6sJ3JpAF+A1oT+FW0W8HYGiMDBcvPqjaWyUA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm2; bh=1rypOH W8dX+w5qi4lrYMM6bGkmbv3O7cRuyBLOdU5J0=; b=GR9pxHlD954+75eLdAtaOc eiYJonIzTw1ZWn1jsBYDrUnT9eeJit43QheFTHnmru0xtZDeJdu8aBK5Df3tSmAp aw/7ORn7aMrFtsyTyvgvMgkYQLOh3C3REW1goD+OlA+3LK63GjDdfqbqwWLshSb2 fNHrjdqgjdvxIjqiTXlbXW4QpG2W9YuVCKe44FRVVAaIlATTWog00SAJRiBHxB6g aq1YnBKVBk2V56AkJLG2uCNEtsJq33Yv9wHkbXl/lkh5UMz4qLKRMwMpZqQxMrSK LovnB7yqvwj8PZOBktWglG84Yzjo7hwpr4rqQLsJCUzWA9a+Y6DonVVflWFVmbVw == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduhedrgeeigdeggecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecufghrlhcuvffnffculdejtddmnecujfgurhepfffhvf fukfhfgggtuggjsehgtderredttddvnecuhfhrohhmpefoihgthhgrvghlucfrrghquhhi vghruceomhhitghhrggvlhesphgrqhhuihgvrhdrgiihiieqnecukfhppeduuddurddutd dvrddukedtrddukeehnecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghi lhhfrhhomhepmhhitghhrggvlhesphgrqhhuihgvrhdrgiihii X-ME-Proxy: Received: from paquier.xyz (ee0822lan1.rev.em-net.ne.jp [111.102.180.185]) by mail.messagingengine.com (Postfix) with ESMTPA id DB25A3065CA9; Tue, 21 Apr 2020 21:19:39 -0400 (EDT) Date: Wed, 22 Apr 2020 10:19:35 +0900 From: Michael Paquier To: Jehan-Guillaume de Rorthais 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: <20200422011935.GF33034@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> <20200422004121.516a5a32@firost> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="RMedoP2+Pr6Rq0N2" Content-Disposition: inline In-Reply-To: <20200422004121.516a5a32@firost> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --RMedoP2+Pr6Rq0N2 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Wed, Apr 22, 2020 at 12:41:21AM +0200, Jehan-Guillaume de Rorthais wrote: > 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? Please see 1a3d104. > Plus, the new line length overflow the 80-column, but I'm not sure where to > break this line. pgindent has been run on v8, and it did not complain. > 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 comment is > wrong. But I wonder if this whole block is really needed. Unfortunately I can't > test on MSWin32 :/ You are right here. The restriction can be removed, and I have checked that the test from v8 is able to pass on my Windows dev VM. -- Michael --RMedoP2+Pr6Rq0N2 Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAl6fm6cACgkQnvQgOdby QH25JxAAiXNDllOPRWVMsPzygzH6MXJL3BiR5/picEccRwkkm8cqB/5Q87ERdlgu IfhhRCNYVsHbnaqFTFSpKIYssfT6vxt5meROSsX8NZZJ0twchMlssLpUk7OviWlO j211u2lkNrjXfnxV5m55+84OulE/WwIvZRGgevkST0GRiTzCdb5S4nek5+NL9qhh czacojLEKcKEuLW28buUUzK8sd2Di/fVf9sJd7Ak8oDlFyK2U8HXmFwjYn6lO+4o uir++MbbNGYyAFCZcYdaMMWzHifb86VR7Ll1IE4H0ifuIgboqeSI/dSlOcQa5CJK YtJFPSzmoaNig9oAxoxY5OZUO7N7/6Rn9NIJxVLFFLu4MFKFU5DN0ySWjlkS103X HEQ12HtjOJ6RWmsQy5BIhPN/CsLQRUnE+R9/aDQiIrJiWXdrmq34PyFEou1A9T5w EeSt4BwHe7uetUShrq70JBSKhjDpVbMYcnClwvbPcttuT9hBH/B7IHyoP1EkMRra 9ixexDJygnaudNF9U8k7dXnvX3swEhQZfKrtODo6nW6ubhbqKYIJh9J0tGtca7xh co1+jNbbU/p+U5Tu3Xa9U1R8B1f6RASjRwdPjpLv5hsYIMpzu4Ad0qcxwDYJ9DkC /dJzC58w+TVk4Ynr2vsBVX4GaIbto3BPjuHDzlXqNS34UAma2VM= =P43P -----END PGP SIGNATURE----- --RMedoP2+Pr6Rq0N2--