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 1oVZ3r-0001fC-7o for pgsql-hackers@arkaria.postgresql.org; Tue, 06 Sep 2022 13:56:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oVZ3o-00061n-Kh for pgsql-hackers@arkaria.postgresql.org; Tue, 06 Sep 2022 13:56:16 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oVZ3o-00061e-2A for pgsql-hackers@lists.postgresql.org; Tue, 06 Sep 2022 13:56:16 +0000 Received: from meldrar.postgresql.org ([2a02:c0:301:0:ffff::31]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oVZ3l-00089K-6Y for pgsql-hackers@postgresql.org; Tue, 06 Sep 2022 13:56:15 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Content-Type:In-Reply-To:From:References:Cc: To:Subject:MIME-Version:Date:Message-ID:Sender:Reply-To: Content-Transfer-Encoding:Content-ID:Content-Description; bh=Dn86/FJpaUWpUAG27rE9F6+ZOAqVvQXTOaHNHqKuT7k=; b=EIDDVZNFI1PXrNlFDRewTOFamG orX92QQiGFAhkkZX20OxklMCjk1IzjnopvqP1zQRenLbzdlsMeVR2Gi5CL54Xul3/yUtFjEbnaZcO lLgS5YHtyqDPdh0biWpk7rm3Gew0EafUm0Jp3DRqgT1cDl6YhT6WAl7PgeLoi6K4HtgYLV8blR9Qx OZvGiRTlIVEeqJptnDD6k+sNzOaDBdJZtwgXtohiArhawAmX6dALGxvAvK/xJro8pyOUGwyS94HKE 68aCPzAYoU83bl+NYfWrmnoYNGUOHrnQpcZLqwuosWs/AGcjoss3c1kzcr4nOezVdK0luY1IjTk2N u2AfcqOg==; Received: from [52.119.84.106] (helo=[192.168.88.177]) by meldrar.postgresql.org with esmtpsa (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1oVZ3Y-0000yk-FI; Tue, 06 Sep 2022 13:56:02 +0000 Message-ID: <3f2c09a6-0b7d-7004-3356-b2f3f520f3ce@postgresql.org> Date: Tue, 6 Sep 2022 09:55:52 -0400 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:91.0) Gecko/20100101 Thunderbird/91.13.0 Subject: Re: pg15b3: recovery fails with wal prefetch enabled Content-Language: en-US To: Thomas Munro , Tom Lane Cc: Kyotaro Horiguchi , Justin Pryzby , "Shinoda, Noriyoshi (PN Japan FSIP)" , Tomas Vondra , Stephen Frost , Andres Freund , Alvaro Herrera , Tomas Vondra , Dmitry Dolgov <9erthalion6@gmail.com>, David Steele , pgsql-hackers References: <20220905.143436.1254379754225361598.horikyota.ntt@gmail.com> <7b52105d-b1ae-1c51-1794-2280e7c8cf06@postgresql.org> <3012983.1662429098@sss.pgh.pa.us> From: "Jonathan S. Katz" In-Reply-To: Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------uxoweJfvXqpmpzNFfRuveibd" X-Host-Lookup-Failed: Reverse DNS lookup failed for 52.119.84.106 (failed) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --------------uxoweJfvXqpmpzNFfRuveibd Content-Type: multipart/mixed; boundary="------------icJhBT1GxiJJPzw01bfz2pOT"; protected-headers="v1" From: "Jonathan S. Katz" To: Thomas Munro , Tom Lane Cc: Kyotaro Horiguchi , Justin Pryzby , "Shinoda, Noriyoshi (PN Japan FSIP)" , Tomas Vondra , Stephen Frost , Andres Freund , Alvaro Herrera , Tomas Vondra , Dmitry Dolgov <9erthalion6@gmail.com>, David Steele , pgsql-hackers Message-ID: <3f2c09a6-0b7d-7004-3356-b2f3f520f3ce@postgresql.org> Subject: Re: pg15b3: recovery fails with wal prefetch enabled References: <20220905.143436.1254379754225361598.horikyota.ntt@gmail.com> <7b52105d-b1ae-1c51-1794-2280e7c8cf06@postgresql.org> <3012983.1662429098@sss.pgh.pa.us> In-Reply-To: --------------icJhBT1GxiJJPzw01bfz2pOT Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 T24gOS81LzIyIDEwOjAzIFBNLCBUaG9tYXMgTXVucm8gd3JvdGU6DQo+IE9uIFR1ZSwgU2Vw IDYsIDIwMjIgYXQgMTo1MSBQTSBUb20gTGFuZSA8dGdsQHNzcy5wZ2gucGEudXM+IHdyb3Rl Og0KPj4gIkpvbmF0aGFuIFMuIEthdHoiIDxqa2F0ekBwb3N0Z3Jlc3FsLm9yZz4gd3JpdGVz Og0KPj4+IE9uIDkvNS8yMiA3OjE4IFBNLCBUaG9tYXMgTXVucm8gd3JvdGU6DQo+Pj4+IFdl bGwgSSB3YXMgYWJvdXQgdG8gY29tbWl0IHRoaXMsIGJ1dCBiZXRhNCBqdXN0IGdvdCBzdGFt cGVkIChidXQgbm90DQo+Pj4+IHlldCB0YWdnZWQpLiAgSSBzZWUgbm93IHRoYXQgSm9uYXRo YW4gKHdpdGggUk1UIGhhdCBvbiwgQ0MnZCkgbWVhbnQNCj4+Pj4gY29tbWl0cyBzaG91bGQg YmUgaW4gYnkgdGhlICpzdGFydCogb2YgdGhlIDV0aCBBb0UsIG5vdCB0aGUgZW5kLiAgU28N Cj4+Pj4gdGhlIHByb2NlZHVyYWwvUk1UIHF1ZXN0aW9uIGlzIHdoZXRoZXIgaXQncyBzdGls bCBwb3NzaWJsZSB0byBjbG9zZQ0KPj4+PiB0aGlzIGl0ZW0gaW4gYmV0YTQuDQo+Pg0KPj4+ IFByZXN1bWFibHkgYmVjYXVzZSBUb20gc3RhbXBlZCBpdCwgdGhlIHJlbGVhc2VkIGlzIHdy YXBwZWQgc28gaXQNCj4+PiB3b3VsZG4ndCBtYWtlIEJldGEgNCwgYnV0IEkgZGVmZXIgdG8g aGltIHRvIHNlZSBpZiBpdCBjYW4gYmUgaW5jbHVkZWQNCj4+PiB3aXRoIHRoZSB0YWcuDQo+ Pg0KPj4gSSBhbHJlYWR5IG1hZGUgdGhlIHRhcmJhbGxzIGF2YWlsYWJsZSB0byBwYWNrYWdl cnMsIHNvIGFkZGluZyB0aGlzDQo+PiB3b3VsZCBpbnZvbHZlIGEgcmUtd3JhcCBhbmQgZ3Jl YXQgY29uZnVzaW9uLiAgSW4gYW55IGNhc2UsIEknbSBub3QNCj4+IGEgZmFuIG9mIHB1c2hp bmcgZml4ZXMgd2l0aGluIGEgZGF5IG9yIHR3byBvZiB0aGUgd3JhcCBkZWFkbGluZSwNCj4+ IGxldCBhbG9uZSBhZnRlciBpdDsgeW91IGdldCBpbmFkZXF1YXRlIGJ1aWxkZmFybSBjb3Zl cmFnZSB3aGVuIHlvdQ0KPj4gY3V0IGNvcm5lcnMgdGhhdCB3YXkuICBJIHRoaW5rIHRoaXMg b25lIG1pc3NlZCB0aGUgYm9hdC4NCj4gDQo+IEdvdCBpdC4gIFllYWggSSBrbmV3IGl0IHdh cyBnb2luZyB0byBiZSBhIGNsb3NlIHRoaW5nIHdpdGggYSBwcm9ibGVtDQo+IGRpYWdub3Nl ZCBvbiBUaHVyc2RheS9GcmlkYXkgYmVmb3JlIGEgTW9uZGF5IHdyYXAsIGV2ZW4gYmVmb3Jl IEkNCj4gbWFuYWdlZCB0byBjb25mdXNlIG15c2VsZiBhYm91dCBkYXRlcyBhbmQgdGltZXMu ICBUaGFua3MgYm90aC4NCg0KVG8gY2xvc2UgdGhpcyBsb29wLCBJIGFkZGVkIGEgc2VjdGlv biBmb3IgImZpeGVkIGJlZm9yZSBSQzEiIHRvIE9wZW4gDQpJdGVtcyBzaW5jZSB0aGlzIGlz IHByZXN1bWFibHkgdGhlIG5leHQgcmVsZWFzZS4gV2UgY2FuIGluY2x1ZGUgaXQgdGhlcmUg DQpvbmNlIGNvbW1pdHRlZC4NCg0KSm9uYXRoYW4NCg== --------------icJhBT1GxiJJPzw01bfz2pOT-- --------------uxoweJfvXqpmpzNFfRuveibd Content-Type: application/pgp-signature; name="OpenPGP_signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="OpenPGP_signature" -----BEGIN PGP SIGNATURE----- wsF5BAABCAAjFiEE+oS2la8r95ogZD/x8QSccp8cZScFAmMXUWgFAwAAAAAACgkQ8QSccp8cZSea 8g//QL4Hm6TBKvtOK0V+P2d8P/DbuNl4nsCXDP7NYhajUUbRNFqaz6qd0mO+eK42NFQmrRaNuo5H pDMYVF8eOEsmnDZHIyLoe9HKwQreNe1p5H4sSSt7rofebLWfusd6JXsFYVkrYJ8TWCOYjSk2lO77 LVf+YsoKb1cdaUAbfb2N5fZt7MbJYECPLiIQJjH4G12ep5IfxcosLs44spyAxkkKJnUuJVwEr7dR s0/0wkbLBFbLtP5+husYJ3QsjE2Ev/ekI9tMBjB6RXFVHx20Ur+gLtSpvYCbSbAZ2JvjqO//OOTX nf58RBoTntj+3872omAnCe2vAVgok/Xb0velpQUf+vuXqnTmnS7X6lWQGtyqFfi6LP1Twv6kOPon C1rmlFjHK6QYoXr4aWeBrQzR4MJ5cVvWJseQbKyH4BgUCBnFbRD+xKQ4JMZ67+oqTJasZ7xEIbHJ AyXg5MNeYn8iyGLg2H+V+S0KXF6BoF+a4Q/c4bc3er0+L4CYX4msgqO1lbtP4gXUKCWqVwmRkbQy V28f75KpPBJxJCtiNA+SQhhkKPGxIiXxMgSvqpMofxGnxcSw324Xc8Jfp7PO4alLaIFCzxZX4fMw w4x3juuWxEPRulykEFfFyqN5DSzAHqsAQ7nImay6atCT1OUW6YESmmYhriwrAlRLqblvvBnaTRUU 5B0= =QP67 -----END PGP SIGNATURE----- --------------uxoweJfvXqpmpzNFfRuveibd--