Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qhMgv-002FHX-0w for pgsql-bugs@arkaria.postgresql.org; Sat, 16 Sep 2023 04:13:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qhMgt-0067Nu-0K for pgsql-bugs@arkaria.postgresql.org; Sat, 16 Sep 2023 04:13:55 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qhMgr-0067Ix-Jr for pgsql-bugs@lists.postgresql.org; Sat, 16 Sep 2023 04:13:54 +0000 Received: from wout2-smtp.messagingengine.com ([64.147.123.25]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qhMgj-004pgh-1v for pgsql-bugs@lists.postgresql.org; Sat, 16 Sep 2023 04:13:52 +0000 Received: from compute5.internal (compute5.nyi.internal [10.202.2.45]) by mailout.west.internal (Postfix) with ESMTP id 2C3033200920; Sat, 16 Sep 2023 00:13:41 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute5.internal (MEProxy); Sat, 16 Sep 2023 00:13:42 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:cc:content-type:content-type:date:date:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:sender :subject:subject:to:to; s=fm2; t=1694837620; x=1694924020; bh=SU 87m1TMx3UCnpNuoeqybDHl67D3rSceSwlDIjdaiMI=; b=ENtksfTUKW+lzJNvCz 3YzOKvjEEaU7k8YzzCMsg7urVhmRW9M4msYsxxX26wfwlyohPEQo2NhxO9B8Wghl 4thCZDOcdjx42GYVx2BKa1zGd1bL8dmV8RzuycVVh38m0lOuRHrpmEv/i4A4vikp VWVgcPZ6WADqC9yhaItjyQlkcxPAaSEKsN3GU0Xej79zYWh1lB7iN7Oh1LrMMktu AFwlEgvjgrRy0Jw9I7SYZ/K56u3iXG+Rfa8vXGVAaOXcTxgda7Y/FcuXytaKQXyj Cd2Yvr07wkeQeh8LN1KPzfZl1ahUhzMIevehPT5wwpP4ITPU2QcRurNq2kNV7ktC 3TNA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:sender:subject :subject:to:to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender :x-sasl-enc; s=fm2; t=1694837620; x=1694924020; bh=SU87m1TMx3UCn pNuoeqybDHl67D3rSceSwlDIjdaiMI=; b=VtAo9zgdneIPMAJ1sMHBWNYKZC2NV 8wFCN7uznF7GejQ6caIirUVtzrRX9nOH4DQP3yXVA4/lkEXRl5scCXqPj6DNV3m8 L2fiYWvM89JpYo0k4Smv+/yH2r/d9PojPDvO4x7cbpcCvZye14s2tRAtK5gxWFK2 UPXZ7bEnSSXDDjmvGc2ckQT6eL76FZSdX+HbO5ulgUflTNzY43dSQBhXEa+3/yjb n3gwdsgXHc/y3tRjSfFsJANlFz6UQn4rEedpD5uI5tDP2dh6Rm6UhUKDdJh2NJiV ewAMonLUxpQzHi5Dp4lwRIQTa7vsPVdzJldtpwIKsbjRkNzH53BQ807qA== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedviedrudejfedgkedtucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne gfrhhlucfvnfffucdljedtmdenucfjughrpeffhffvvefukfhfgggtuggjsehgtderredt tddvnecuhfhrohhmpefoihgthhgrvghlucfrrghquhhivghruceomhhitghhrggvlhesph grqhhuihgvrhdrgiihiieqnecuggftrfgrthhtvghrnhepteelieefudffhffhtdetleeg geegfffhkeeuveetiefgudduvedutefggeeivdejnecuvehluhhsthgvrhfuihiivgeptd enucfrrghrrghmpehmrghilhhfrhhomhepmhhitghhrggvlhesphgrqhhuihgvrhdrgiih ii X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Sat, 16 Sep 2023 00:13:37 -0400 (EDT) Date: Sat, 16 Sep 2023 13:13:33 +0900 From: Michael Paquier To: Thomas Munro Cc: Sergei Kornilov , Noah Misch , Tom Lane , Kyotaro Horiguchi , exclusion@gmail.com, pgsql-bugs@lists.postgresql.org, Fujii Masao Subject: Re: BUG #17928: Standby fails to decode WAL on termination of primary Message-ID: References: MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="b1p3mHWw+xlyJMCG" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --b1p3mHWw+xlyJMCG Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Sat, Sep 16, 2023 at 12:20:36PM +1200, Thomas Munro wrote: > It has to do with initial WAL position after initdb, because I get > this only on Debian, on REL_12_STABLE (with the commit listed above on > my public fix-12 branch) and only with --with-icu, but not without it, > and I can't repro it on my other local OSes. That's close to my dev environment, with SID and x64 and the only difference your branch and my local branch is a rename of the TAP file, and I cannot see the problem. Some random thoughts: perhaps reducing $page_threshold would help with more records inserted to get to the limit of a page, reducing noise? Or perhaps skipping a few pages would? -- Michael --b1p3mHWw+xlyJMCG Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmUFK20ACgkQnvQgOdby QH3zrQ//QkWSw2lse0JBW9QsA7p9B6p9LpOurZ+12/ndI5dQZwwYgVt74pU2K+it IqlqSpgt2G5OpkyVkd2dDQ7GrCaqQIndcWyr5g02D7kidxPliWTjhB8VwmsFU884 +H5L40cqXJkr9WXDrO3xfGxLUfWgGliMjO84BY1ojEHK9sncVZenoJ1FHABzNtiA A5EyczKbaGh/9bb2xqK3GC8Bn+GlbGnDsnyjr2x+paZfygEtUNCCohDHRVWBmbGo qvY4PXs5VbsXFveMxgeGclq8gfszJMe+nI2TQjYZoMF2NPLHNEbTUNHu6yWo1mvg KY5HQ6RKkd6is6DucRfpLolJkDCS4v3O1oHsC8pG4hawr9HtmQcowtQBiwt8kfOU HnPoRsG14gQoTYrMaa61LtdL3zV8OehtaauBH+ANexvlZqnGBXPEj+riAu3TAZq9 ytaceOwL8e75JbwvAAbM02NFyuY8iyZlB/AjMfW4qU7QjphfH4Q8nQy73S1eUeID f+IXihayLrs189OyF00W048VNj2vJdaFI6dovg3thB+UnmX53zXnFnaFQQsoeEN6 N2KPsB7NNkoDdOYz+UCINLvBsnfNkLYEnbjCnhxGAA/o3bNCn3gk6Y42AM+1THyp j2cc9SvO6ClNywDXjgiUcSV5631yGG6hqIhQhRI8YOv0aFlkb7o= =FO9T -----END PGP SIGNATURE----- --b1p3mHWw+xlyJMCG--