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 1qiXQD-006lKL-4K for pgsql-bugs@arkaria.postgresql.org; Tue, 19 Sep 2023 09:53:33 +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 1qiXQB-008RyU-Dw for pgsql-bugs@arkaria.postgresql.org; Tue, 19 Sep 2023 09:53:31 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qiXQA-008RyD-Nc for pgsql-bugs@lists.postgresql.org; Tue, 19 Sep 2023 09:53:31 +0000 Received: from wout2-smtp.messagingengine.com ([64.147.123.25]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qiXQ7-0065Jh-7D for pgsql-bugs@lists.postgresql.org; Tue, 19 Sep 2023 09:53:30 +0000 Received: from compute3.internal (compute3.nyi.internal [10.202.2.43]) by mailout.west.internal (Postfix) with ESMTP id 196C6320090D; Tue, 19 Sep 2023 05:53:22 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute3.internal (MEProxy); Tue, 19 Sep 2023 05:53:24 -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=1695117202; x=1695203602; bh=q7 ODpse/udX0ytuRevLdch1OqGvLZmGdvVzZdO3HPCo=; b=aCFohrTmakwdM0Ij3P MBCAngJl6Oos/3QpJYxnYjO1HpjNHGRsRwRBPcVAKjzGwkbAm84ResB71AfMb5vI pGgIA3YHOTsNt9y9WGe3BIV+TQKNp/Fxo36aVQ7AsPvcEAeMUsixu+YiGmoQsyxd /VLs5csnUzIfRybZEQUqKNFGn8+bdGK7dnJ8zUXtfjHAkdBSAnolFe5C0qfWzSXG xU76dBoB1O4MQom0tg3ZlwScwzE6FmHkhUeelISHT35fjS1JXXUpX8xse/3U1WXV xCEfJr8cKBjEspAyVGZ2SaPSOLWlQbpSW4znj9WjtF2CkP/bKj9OGz6aiCrqX/Av dPcQ== 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=1695117202; x=1695203602; bh=q7ODpse/udX0y tuRevLdch1OqGvLZmGdvVzZdO3HPCo=; b=AlgoT+pEvmC0v0r4w8Ux70+Q9psjc d7mzoy7ynMlio9V5Y40VMPR+qfE88j0kreanxr6iuT2+9qL0I1NjEZ4JNPgpB38F A7xeggZVvCjA5HxqKY+NlWPYs+wOgrRfN1jFXxofGRu5jw+VnXBQQjXjSiEgGELM pmhiWfVe3kMu3x2XBGeEaOX+30AUmN3W5OTVXiao4eqFamA/OmIUJJ5zRn3sjmZh XgPGy1C1Nxd58cAX4m6mP1UxhrLnsIOnJgmsDUtlVKvdH1nIUMAjS0C5crF4mFk1 W0pJNtv2GTuL62EmzQiawikckjtiR6pmzX0TB8kYgE6TDXHW1PlBbhzHQ== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedviedrudektddgvdduucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne gfrhhlucfvnfffucdljedtmdenucfjughrpeffhffvvefukfhfgggtuggjsehgtderredt tddvnecuhfhrohhmpefoihgthhgrvghlucfrrghquhhivghruceomhhitghhrggvlhesph grqhhuihgvrhdrgiihiieqnecuggftrfgrthhtvghrnhepteelieefudffhffhtdetleeg geegfffhkeeuveetiefgudduvedutefggeeivdejnecuvehluhhsthgvrhfuihiivgeptd enucfrrghrrghmpehmrghilhhfrhhomhepmhhitghhrggvlhesphgrqhhuihgvrhdrgiih ii X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Tue, 19 Sep 2023 05:53:19 -0400 (EDT) Date: Tue, 19 Sep 2023 18:53:14 +0900 From: Michael Paquier To: Thomas Munro Cc: Alexander Lakhin , Sergei Kornilov , Noah Misch , Tom Lane , Kyotaro Horiguchi , 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="4zczwzTyHbZ8vN11" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --4zczwzTyHbZ8vN11 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Tue, Sep 19, 2023 at 09:25:34PM +1200, Thomas Munro wrote: > The problem was that the Perl functions advance_XXX() would sometimes > see an "unflushed" insert position caused by hint records and other > incidental stuff, and then we'd write our contrived header at a > disconnected location after a bunch of (unwritten) zeroes. The > solution in this version is to start each test with > emit_message($node, 0), which flushes a small record. Makes sense. Does this also address the other issue you've noticed on v12 when ICU is enabled (the one with the initial LSN changed after initdb)? -- Michael --4zczwzTyHbZ8vN11 Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmUJb4oACgkQnvQgOdby QH3qAhAAn3SlfGapNS62U2HtLzHc9QdHAvLWiV0jrQBq9g/U+pG8xuUskJCgfgz3 ShdiBJaqH5BovZlieFO4ho3LImzX6CzRV5WBxsSQw66ahE/c4+qAa8o6I2tESnyf rUfyw1VWYJVk9cBCIbOlS8Zo439cuSxQZrgrHPr4XNdrXf6Nj1EmltVRz6GbrxnB C+tyYbw+tSp7WV+96acvDuiN/jMPONY0Ejp03TIzxeK8wqLLOomGoR3fZ39k5096 7FjBNTHn4SJcTUufRw2HsquTv7IRphlc71k+8km/p+Of4hy2CuoGPXAFRTPSc6Pv B1WR1SMCgLb9GUJXNZf/Z0dB6xbP9tikVUR3eCN9BaCJ9m4s1Rdqw92Qa2p+w1d0 06ZcSSyhDdCs+gg1B6Yp3yRuVi5WOwCiebq2oib6cA9+UBUW2G7uiwPuihrlm7Ho Ju1zPSFWiIlJmnYZBvU/cFf/lO9g19dejE5b/ggvMy1ybC/zo0jQJ/h7NWgWJ0Rc ClPIkRhGRIhCtP0dJGHIUkO4rweWtbUEsd5yKaa1h9NsTCAfW0tBB+t1t0CcFBbB W9DBZ6aw/q0c4ElJTvql7omcxXMi6lhofVnqXFX+7w32/WC3lWoIHbIwSD4SXeuJ PZY2uSeOuy9mQ70mxjc0pd2E7YXvv5SNtES+HQiDheaX8Y29WJ8= =ycy8 -----END PGP SIGNATURE----- --4zczwzTyHbZ8vN11--