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 1twQNa-00ES66-39 for pgsql-committers@arkaria.postgresql.org; Sun, 23 Mar 2025 18:49:02 +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 1twQNY-003lBX-Rw for pgsql-committers@arkaria.postgresql.org; Sun, 23 Mar 2025 18:49:00 +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 1twQKU-003gUE-Q0 for pgsql-committers@lists.postgresql.org; Sun, 23 Mar 2025 18:45:50 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1twQKR-000iS8-2M for pgsql-committers@lists.postgresql.org; Sun, 23 Mar 2025 18:45:49 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1twQKQ-00BohL-PT for pgsql-committers@lists.postgresql.org; Sun, 23 Mar 2025 18:45:46 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1twQKO-000eUP-2e for pgsql-committers@lists.postgresql.org; Sun, 23 Mar 2025 18:45:45 +0000 Content-Type: multipart/mixed; boundary="===============4469608029916202579==" MIME-Version: 1.0 From: Heikki Linnakangas To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fix rare assertion failure in standby, if primary is restarted X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Sun, 23 Mar 2025 18:45:45 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============4469608029916202579== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Rml4IHJhcmUgYXNzZXJ0aW9uIGZhaWx1cmUgaW4gc3RhbmRieSwgaWYgcHJpbWFyeSBpcyByZXN0 YXJ0ZWQKCkR1cmluZyBob3Qgc3RhbmRieSwgRXhwaXJlQWxsS25vd25Bc3NpZ25lZFRyYW5zYWN0 aW9uSWRzKCkgYW5kCkV4cGlyZU9sZEtub3duQXNzaWduZWRUcmFuc2FjdGlvbklkcygpIGZ1bmN0 aW9ucyBtYXJrIG9sZCB0cmFuc2FjdGlvbnMKYXMgbm8tbG9uZ2VyIHJ1bm5pbmcsIGJ1dCB0aGV5 IGZhaWxlZCB0byB1cGRhdGUgeGFjdENvbXBsZXRpb25Db3VudAphbmQgbGF0ZXN0Q29tcGxldGVk WGlkLiBBRkFJQ1MgaXQgd291bGQgbm90IGxlYWQgdG8gaW5jb3JyZWN0IHF1ZXJ5CnJlc3VsdHMs IGJlY2F1c2UgdGhvc2UgZnVuY3Rpb25zIGVmZmVjdGl2ZWx5IHR1cm4gaW4tcHJvZ3Jlc3MKdHJh bnNhY3Rpb25zIGludG8gYWJvcnRlZCB0cmFuc2FjdGlvbnMgYW5kIGFuIE1WQ0Mgc25hcHNob3Qg Y29uc2lkZXJzCmJvdGggYXMgIm5vdCB2aXNpYmxlIi4gQnV0IGl0IGNvdWxkIHN1cnByaXNlIEdl dFNuYXBzaG90RGF0YVJldXNlKCkKYW5kIHRyaWdnZXIgdGhlICJUcmFuc2FjdGlvbklkUHJlY2Vk ZXNPckVxdWFscyhUcmFuc2FjdGlvblhtaW4sClJlY2VudFhtaW4pKSIgYXNzZXJ0aW9uIGluIGl0 LCBpZiB0aGUgYXBwYXJlbnQgeG1pbiBpbiBhIGJhY2tlbmQgd291bGQKbW92ZSBiYWNrd2FyZHMu IFdlIHNhdyB0aGlzIGhhcHBlbiB3aGVuIEdldENhdGFsb2dTbmFwc2hvdCgpIHdvdWxkCnJldXNl IGFuIG9sZGVyIGNhdGFsb2cgc25hcHNob3QsIHdoZW4gR2V0VHJhbnNhY3Rpb25TbmFwc2hvdCgp IGhhZAphbHJlYWR5IGFkdmFuY2VkIFRyYW5zYWN0aW9uWG1pbi4KClRoZSBidWcgZ29lcyBiYWNr IGFsbCB0aGUgd2F5IHRvIGNvbW1pdCA2MjNhOWJhNzliIGluIHYxNCB0aGF0CmludHJvZHVjZWQg dGhlIHNuYXBzaG90IHJldXNlIG1lY2hhbmlzbSwgYnV0IGl0IHN0YXJ0ZWQgdG8gaGFwcGVuIG1v cmUKZnJlcXVlbnRseSB3aXRoIGNvbW1pdCA5NTIzNjVjZGVkNiB3aGljaCByZW1vdmVkIGEKR2V0 VHJhbnNhY3Rpb25TbmFwc2hvdCgpIGNhbGwgZnJvbSBiYWNrZW5kIHN0YXJ0dXAuIFRoYXQgbWFk ZSBpdCBtb3JlCmxpa2VseSBmb3IgRXhwaXJlT2xkS25vd25Bc3NpZ25lZFRyYW5zYWN0aW9uSWRz KCkgdG8gYmUgY2FsbGVkIGJldHdlZW4KR2V0Q2F0YWxvZ1NuYXBzaG90KCkgYW5kIHRoZSBmaXJz dCBHZXRUcmFuc2FjdGlvblNuYXBzaG90KCkgaW4gYQpiYWNrZW5kLgoKQW5kcmVzIEZyZXVuZCBm aXJzdCBzcG90dGVkIHRoaXMgYXNzZXJ0aW9uIGZhaWx1cmUgb24gYnVpbGRmYXJtIG1lbWJlcgon c2tpbmsnLiBSZXByb2R1Y3Rpb24gYW5kIGFuYWx5c2lzIGJ5IFRvbWFzIFZvbmRyYS4KCkJhY2tw YXRjaC10aHJvdWdoOiAxNApEaXNjdXNzaW9uOiBodHRwczovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9t ZXNzYWdlLWlkL29leTI0Nm1jdzQzY3k0cXcyaHFqbXVyYmQ2MmxmZHBjdXh5cWl1N2JvdHgzdHlw cGF4JTQwaDdvN21mZzV6bWRqCgpCcmFuY2gKLS0tLS0tClJFTF8xN19TVEFCTEUKCkRldGFpbHMK LS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmLzMwMmNlNWJk OTNiNDg1NDliZjY3MTc1MTJlYTkyMjUyMzE5ZGM5NDQKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0t LS0tLS0tCnNyYy9iYWNrZW5kL3N0b3JhZ2UvaXBjL3Byb2NhcnJheS5jIHwgMjQgKysrKysrKysr KysrKysrKysrKysrKysrCjEgZmlsZSBjaGFuZ2VkLCAyNCBpbnNlcnRpb25zKCspCgo= --===============4469608029916202579==--