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 1qhImM-001zRq-U4 for pgsql-bugs@arkaria.postgresql.org; Sat, 16 Sep 2023 00:03:19 +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 1qhImL-0049po-K3 for pgsql-bugs@arkaria.postgresql.org; Sat, 16 Sep 2023 00:03:17 +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 1qhImK-0049pH-Nh for pgsql-bugs@lists.postgresql.org; Sat, 16 Sep 2023 00:03:17 +0000 Received: from wout5-smtp.messagingengine.com ([64.147.123.21]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qhImG-005LSq-OH for pgsql-bugs@lists.postgresql.org; Sat, 16 Sep 2023 00:03:16 +0000 Received: from compute5.internal (compute5.nyi.internal [10.202.2.45]) by mailout.west.internal (Postfix) with ESMTP id C2F1F3200035; Fri, 15 Sep 2023 20:03:07 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute5.internal (MEProxy); Fri, 15 Sep 2023 20:03:08 -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=1694822587; x=1694908987; bh=T8 GaxrP0zQdrKNV4zfH1Iykxzo1ZGz0kigcAGFV/K6g=; b=xcMnFhizkeMo7NGJWH 40PLW9CZO2QErAk+miC/1YoarTAOOf014IGioPyF3NzQ2ltTxbav2dKJhYFcV9Lk pwd5varv24YmlQWNgyps3MACFkGVZTLZhjMK+mNaDekPLMkON0m5A06zR+wJI1Fi xqFOWFIA4jgmLIhI7YTTNi1N59KXZdaJFBmJ05cR5aWw0rwrsHt8a7A47DQkbGpJ FOTra7JA+qxxGzz0S3N6pQzHuyrqWj8mtwV0HjZdlIC6kBc7rFoJ+QHGfJfCcgnF 7EJCQ4j9Zfi1p2bUlYvQgO14wdb2SFdSIaxTiIkQYNagCCdFW2mb8ibkBVR28UXp Y8ig== 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=1694822587; x=1694908987; bh=T8GaxrP0zQdrK NV4zfH1Iykxzo1ZGz0kigcAGFV/K6g=; b=Ck6z/XKcgD1Nw3+UOK+0EJ425Vop+ TGjio+CDouNgdDdi/O6bGcPB+j4qVLENXLntY3z2/671DKLXrYsACtJ+hLTKgsHO oY3wcAc3gJBVKPDfsctdI75FjUa8bQq+BL/FPtEZmDsd1/E9frQgTcR6tTNsLt/7 M6en79u/9YnMYWyZUH7zcySt+ASZG8qx7vyU2nZSNpoQNK+Mvy/zNOYoWTnzRqFc hpkUBhBpE0pJUKbyZQFTBWyTjTp3xt15buRxmkroE+EYf/V8V7EHvi5GImAbxG+4 YhZlvkuI7YJYYGsc7mriTWuqljZ/mbh+BNeHXCihG+Kxe9ZvdE920Nzng== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedviedrudejfedgvdelucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne gfrhhlucfvnfffucdlfeehmdenucfjughrpeffhffvvefukfhfgggtuggjsehgtderredt tddvnecuhfhrohhmpefoihgthhgrvghlucfrrghquhhivghruceomhhitghhrggvlhesph grqhhuihgvrhdrgiihiieqnecuggftrfgrthhtvghrnhepjeejtdelleeggeelffduhfej tdeuvdekkeethffhuedvvdeuudeugeefudevtdeinecuffhomhgrihhnpehgihhthhhusg drtghomhenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhm pehmihgthhgrvghlsehprghquhhivghrrdighiii X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Fri, 15 Sep 2023 20:03:03 -0400 (EDT) Date: Sat, 16 Sep 2023 09:02:57 +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="vjmwTFmdKT2qlImD" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --vjmwTFmdKT2qlImD Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Sat, Sep 16, 2023 at 10:07:30AM +1200, Thomas Munro wrote: > I rebased (bumped the test number 038 -> 039), updated the commit > message[1], tested on a big endian machine (AIX/POWER), but then I > found there is something not quite right or stable with the WAL > positioning logic. On one of my machines, but not another, the > back-patch to 12 fails in one of the tests unless I hack it to insert > a bit more WAL, and I think that's telling me that Perl code to > control the insertion point is not quite bullet proof enough yet. > I'll need to dig into this some more on Monday. >=20 > [1] https://github.com/macdice/postgres/commits/fix-12 Hmm. What was the test that failed? -- Michael --vjmwTFmdKT2qlImD Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmUE8LEACgkQnvQgOdby QH0BRQ//Ro2l/DPaVI4DbIVYzDc7dB03G9YD4eq9vGa8ulcI/qLx3MZz/fcjIEIF +37UM35kX0mF3HmOa1YZPSmbqePXTFvWTEVoaKbZSnQTtyFM+Pz22KbDYQlEuuwb Qoco9mgRTxoqg1JOuU+bYNzc6cmGricBgk+RSuP7nLDT56K9GFw80+IgvPHV/DJ/ KtRbRQkDFoWriwCTgF/l9KSe5/4YKgrR+BYh/l+wDXphbUwyQPUTTtDl4CcO+pmm akyIplgOdcMJxu2JxLlZ8tKufmJYuVPB/E+LIAjjFRny1alkCU3cjB4jQVVAp/he Wenvit8tHs8I00P51XeuyLxx8t4tcFyj/MwvueRqhXab72O79AT40WEymmAkh091 pi2KWO2wVI5Y0HsFfEWTXge8czBRVty+C+BJ18zUTyKJm0SlmYKHtnMTmZFNRlCq ClxC1SpgUCY9sVlEXImth/1k8d/GfvtCZHvnL8q1JiP4m0CC2q5SvPuiU1nHD8fI k/7GKr5qOdP+YotjjF2c5DGmq7e8uWVol2ua4zucevbDlVpzxgx3tC9mgkYpJdIH UKLw1oPVOXfUQiFOwYd9EdOgVp0vUgaRZCmllDQyaPZM10aaA68mE9pRo+SO/3Qc 5hDCFPcbjoikmeOkOqaZz/cJNon+he6IGI3248i6mBcglDQ7zIU= =ejSu -----END PGP SIGNATURE----- --vjmwTFmdKT2qlImD--