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-00ES68-41 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-St 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 1twQKV-003gbW-Si for pgsql-committers@lists.postgresql.org; Sun, 23 Mar 2025 18:45:51 +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-000iSB-2U for pgsql-committers@lists.postgresql.org; Sun, 23 Mar 2025 18:45:50 +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-00BohK-O4 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-000eUN-2U for pgsql-committers@lists.postgresql.org; Sun, 23 Mar 2025 18:45:45 +0000 Content-Type: multipart/mixed; boundary="===============6319228610860180141==" 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 --===============6319228610860180141== 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 cGF4JTQwaDdvN21mZzV6bWRqCgpCcmFuY2gKLS0tLS0tCm1hc3RlcgoKRGV0YWlscwotLS0tLS0t Cmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvMjgxNzUyNWYwZDU2MDc1 ZTFmM2ExNGMwZGM2YTE4MGIzMzdkOGFlZAoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0K c3JjL2JhY2tlbmQvc3RvcmFnZS9pcGMvcHJvY2FycmF5LmMgfCAyNCArKysrKysrKysrKysrKysr KysrKysrKysKMSBmaWxlIGNoYW5nZWQsIDI0IGluc2VydGlvbnMoKykKCg== --===============6319228610860180141==--