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 1lNDQq-0000sR-Ks for pgsql-bugs@arkaria.postgresql.org; Fri, 19 Mar 2021 11:36:45 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lNDQo-0000ND-M9 for pgsql-bugs@arkaria.postgresql.org; Fri, 19 Mar 2021 11:36: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 1lNDQn-0000N6-AN for pgsql-bugs@lists.postgresql.org; Fri, 19 Mar 2021 11:36:42 +0000 Received: from [66.111.4.29] (helo=out5-smtp.messagingengine.com) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lNDQj-0003hl-9m for pgsql-bugs@lists.postgresql.org; Fri, 19 Mar 2021 11:36:40 +0000 Received: from compute3.internal (compute3.nyi.internal [10.202.2.43]) by mailout.nyi.internal (Postfix) with ESMTP id 6EA555C0048; Fri, 19 Mar 2021 07:36:25 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute3.internal (MEProxy); Fri, 19 Mar 2021 07:36:25 -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=4JracVH8Ie906muZrGViwoyvM3c 97lF3rt8ChiFXZbg=; b=lIiyMupja/VyEX8S6jktWPm6woySjCvWjtX3X/AoGq6 zKgIro9fNozpJwCti+ms2cX5E9piZkOLwLFA3SYkXt3uvmcLW0tM4WPKKFmOcNCN E8DMSrf/9nlxmMn/V4cuSkkMBh2tXFrE8z4H3SB9WRbQnk1x1t69bf581vlqeP4X TYkewXrwB5KhDRaZIayVQUHTMpAd/+ZE+eMunUBalyfEYeyI2I5kddeyZHEerOgE +FugiqHVB/UTATmOv6mI1KPUNuUTVNfYJFJfspOsyTCJK/yMyKgPUUeoAZlHP9Ab x2+TE5UEsEJcnAZBlp6PqDWA6cs6JvQQWQuFWG7FULg== 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=4JracV H8Ie906muZrGViwoyvM3c97lF3rt8ChiFXZbg=; b=CRuhBFLdpVIlk1p43lnGaM 0N/RRdnUKqyMtVFjqa7MNELMw41xkl5U1ZWFUpruR3/b7YN8C3m8H+IuPwINvIgH og5rPyamt7CedGCQPUD9J7qBmEgxCbMphiIknkfjmnnpLmpDG9qov2D7a6diNBa5 WCCeUdi0QLKAI71MilkKve64+O+LbCcrl8nK10P+Lk2apHGBSyErMQpvdFcRBtWo 8Y5EKsdaVZOk+EwvmrEzpNnHEpQl1NG58qHSEeWtl/cpkB8POd0bskfZrfyHpL5L J4XSPx39YysCsT6HDoSHJTq/8NE03kxuiXEsvBG0YSgBR9vyVh9l+lP1G3X7AJCg == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduledrudefkedgfeduucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne gfrhhlucfvnfffucdlfeehmdenucfjughrpeffhffvuffkfhggtggujgesghdtreertddt jeenucfhrhhomhepofhitghhrggvlhcurfgrqhhuihgvrhcuoehmihgthhgrvghlsehprg hquhhivghrrdighiiiqeenucggtffrrghtthgvrhhnpeeukeeutddtledvvdefjeehffel ueffkeetlefguefffeetieegheekgeeufeelgfenucffohhmrghinhepphhoshhtghhrvg hsqhhlrdhorhhgnecukfhppeduuddurddutddvrddukedtrddukeehnecuvehluhhsthgv rhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomhepmhhitghhrggvlhesphgrqh huihgvrhdrgiihii 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 57174240069; Fri, 19 Mar 2021 07:36:23 -0400 (EDT) Date: Fri, 19 Mar 2021 20:36:19 +0900 From: Michael Paquier To: =?utf-8?B?0K/RgNC+0YHQu9Cw0LIg0J/QsNGI0LjQvdGB0LrQuNC5?= Cc: Postgres bugs Subject: Re: BUG #16927: Postgres can`t access WAL files Message-ID: References: MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="02TQ5lReykuzVNdE" Content-Disposition: inline In-Reply-To: X-Host-Lookup-Failed: Reverse DNS lookup failed for 66.111.4.29 (deferred) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --02TQ5lReykuzVNdE Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Fri, Mar 19, 2021 at 11:04:14AM +0200, =D0=AF=D1=80=D0=BE=D1=81=D0=BB=D0= =B0=D0=B2 =D0=9F=D0=B0=D1=88=D0=B8=D0=BD=D1=81=D0=BA=D0=B8=D0=B9 wrote: > I didn't quite understand you here, is " aaaef7a " stands for patch name? There was a typo in one of my previous messages. What I was referring to is aaa3aedd. That's a commit of the Postgres code tree, if you are not familiar with git, here is a link to the code change: https://git.postgresql.org/gitweb/?p=3Dpostgresql.git;a=3Dcommit;h=3Daaa3ae= dd >> " How much did you test the unpatched builds by the way? " > On cluster where load was caused by pgbench I met wal file access error > after about 1 hour, but on developer server with real load (usually up to > 100 connections) the error occurred after 2.5-3 hours. OK, thanks. My environments are not that sensitive to the issue, unfortunately. -- Michael --02TQ5lReykuzVNdE Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmBUjLMACgkQnvQgOdby QH13Ug/+MeZAJR49QNgZB4LtmUs0in/8OmO+/je0O8VBP12SCBRO1bVP663HK/a9 gXUzNCVYm90fXk1Fxp1uh+nmrYnImtZisiKISirh1gpFZ01jOwyZk9dVccKE6C60 t8lWKkXKCwoNnk5xvdm2J7q/6sBLfT8H849VNewtKARVh5a+kdNE7dxvd8zvn2q1 f6l6mp0CQTv2sPyEG8ZgkvRGA6ERFtSy4gDjbkZMWNK9berdjbypDwK/1ZbaIhPf IICI+H6Jkxe+TOVQ9tT3aNJfSuXstEHxLdjRHgvCJUsuwKC9keQjg0HCxYWqhDgK ZgwTHj9IImBvtW0a6UFYbxj6dRFRzVDeVfJGoILNvu0ZQzxasvnT3RVkRyt4qPFt 9S2BbRkVSBK/93EsRkO4dDZj9wNGYFoeQkWsG6obsH4Ih0SRDInyrm8jbIwRFeKZ 4QtPCNahgImZK+Hq6oePIbSR2mUX3SXXFFmIQvqXXUpLlQ20ijJQ9gfGrfI1mIcq ic0CA6I6UuZN8w6uwoYbgHFotZhNBtra5NQEojtNgRyI0050kaByGgRQ8BokTH1P rOzP0fh6W2Yq89PpajRRevml1Zn3rtIcJlIDMKXL4hBxVEgtw/NKeNtdPSPw/8f4 KHPMxOplkjVgcrrGDGcZEasUQ6TH3NSxThcIJ5mfApEliSOsSGo= =NR7P -----END PGP SIGNATURE----- --02TQ5lReykuzVNdE--