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 1sMZX5-0036JU-7o for pgsql-committers@arkaria.postgresql.org; Wed, 26 Jun 2024 20:46:23 +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 1sMZX3-006fn8-M3 for pgsql-committers@arkaria.postgresql.org; Wed, 26 Jun 2024 20:46:21 +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 1sMZVz-006e8F-NA for pgsql-committers@lists.postgresql.org; Wed, 26 Jun 2024 20:45:16 +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.94.2) (envelope-from ) id 1sMZVw-003HSt-Da for pgsql-committers@lists.postgresql.org; Wed, 26 Jun 2024 20:45:14 +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 1sMZVv-00ALon-91 for pgsql-committers@lists.postgresql.org; Wed, 26 Jun 2024 20:45:11 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sMZVt-0038vp-Ac for pgsql-committers@lists.postgresql.org; Wed, 26 Jun 2024 20:45:10 +0000 Content-Type: multipart/mixed; boundary="===============5106725369637232310==" MIME-Version: 1.0 From: Heikki Linnakangas To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fix bugs in MultiXact truncation X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Wed, 26 Jun 2024 20:45:10 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============5106725369637232310== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Rml4IGJ1Z3MgaW4gTXVsdGlYYWN0IHRydW5jYXRpb24KCjEuIFRydW5jYXRlTXVsdGlYYWN0KCkg cGVyZm9ybXMgdGhlIFNMUlUgdHJ1bmNhdGlvbnMgaW4gYSBjcml0aWNhbApzZWN0aW9uLiBEZWxl dGluZyB0aGUgU0xSVSBzZWdtZW50cyBjYWxscyBGb3J3YXJkU3luY1JlcXVlc3QoKSwgd2hpY2gK d2lsbCB0cnkgdG8gY29tcGFjdCB0aGUgcmVxdWVzdCBxdWV1ZSBpZiBpdCdzIGZ1bGwKKENvbXBh Y3RDaGVja3BvaW50ZXJSZXF1ZXN0UXVldWUoKSkuIFRoYXQgaW4gdHVybiBhbGxvY2F0ZXMgbWVt b3J5LAp3aGljaCBpcyBub3QgYWxsb3dlZCBpbiBhIGNyaXRpY2FsIHNlY3Rpb24uIEJhY2t0cmFj ZToKCiAgICBUUkFQOiBmYWlsZWQgQXNzZXJ0KCJDcml0U2VjdGlvbkNvdW50ID09IDAgfHwgKGNv bnRleHQpLT5hbGxvd0luQ3JpdFNlY3Rpb24iKSwgRmlsZTogIi4uL3NyYy9iYWNrZW5kL3V0aWxz L21tZ3IvbWN4dC5jIiwgTGluZTogMTM1MywgUElEOiA5MjA5ODEKICAgIHBvc3RncmVzOiBhdXRv dmFjdXVtIHdvcmtlciB0ZW1wbGF0ZTAoRXhjZXB0aW9uYWxDb25kaXRpb24rMHg2ZSlbMHg1NjBh NTAxZTg2NmVdCiAgICBwb3N0Z3JlczogYXV0b3ZhY3V1bSB3b3JrZXIgdGVtcGxhdGUwKCsweDVk Y2UzZClbMHg1NjBhNTAyMTdlM2RdCiAgICBwb3N0Z3JlczogYXV0b3ZhY3V1bSB3b3JrZXIgdGVt cGxhdGUwKEZvcndhcmRTeW5jUmVxdWVzdCsweDhlKVsweDU2MGE0ZmZlYzk1ZV0KICAgIHBvc3Rn cmVzOiBhdXRvdmFjdXVtIHdvcmtlciB0ZW1wbGF0ZTAoUmVnaXN0ZXJTeW5jUmVxdWVzdCsweDJi KVsweDU2MGE1MDA5MWVlYl0KICAgIHBvc3RncmVzOiBhdXRvdmFjdXVtIHdvcmtlciB0ZW1wbGF0 ZTAoKzB4MTg3YjBhKVsweDU2MGE0ZmRjMmIwYV0KICAgIHBvc3RncmVzOiBhdXRvdmFjdXVtIHdv cmtlciB0ZW1wbGF0ZTAoU2xydURlbGV0ZVNlZ21lbnQrMHgxMDEpWzB4NTYwYTRmZGMyYWIxXQog ICAgcG9zdGdyZXM6IGF1dG92YWN1dW0gd29ya2VyIHRlbXBsYXRlMChUcnVuY2F0ZU11bHRpWGFj dCsweDJmYilbMHg1NjBhNGZkYmRlMWJdCiAgICBwb3N0Z3JlczogYXV0b3ZhY3V1bSB3b3JrZXIg dGVtcGxhdGUwKHZhY191cGRhdGVfZGF0ZnJvemVueGlkKzB4NGIzKVsweDU2MGE0ZmViZDJmM10K ICAgIHBvc3RncmVzOiBhdXRvdmFjdXVtIHdvcmtlciB0ZW1wbGF0ZTAoKzB4M2FkZjY2KVsweDU2 MGE0ZmZlOGY2Nl0KICAgIHBvc3RncmVzOiBhdXRvdmFjdXVtIHdvcmtlciB0ZW1wbGF0ZTAoQXV0 b1ZhY1dvcmtlck1haW4rMHgzZWQpWzB4NTYwYTRmZmU3YzJkXQogICAgcG9zdGdyZXM6IGF1dG92 YWN1dW0gd29ya2VyIHRlbXBsYXRlMCgrMHgzYjFlYWQpWzB4NTYwYTRmZmVjZWFkXQogICAgcG9z dGdyZXM6IGF1dG92YWN1dW0gd29ya2VyIHRlbXBsYXRlMCgrMHgzYjYyMGUpWzB4NTYwYTRmZmYx MjBlXQogICAgcG9zdGdyZXM6IGF1dG92YWN1dW0gd29ya2VyIHRlbXBsYXRlMCgrMHgzYjNmYmIp WzB4NTYwYTRmZmVlZmJiXQogICAgcG9zdGdyZXM6IGF1dG92YWN1dW0gd29ya2VyIHRlbXBsYXRl MCgrMHgyZjcyNGUpWzB4NTYwYTRmZjMyMjRlXQogICAgL2xpYi94ODZfNjQtbGludXgtZ251L2xp YmMuc28uNigrMHgyN2M4YSlbMHg3ZjYyY2M2NDJjOGFdCiAgICAvbGliL3g4Nl82NC1saW51eC1n bnUvbGliYy5zby42KF9fbGliY19zdGFydF9tYWluKzB4ODUpWzB4N2Y2MmNjNjQyZDQ1XQogICAg cG9zdGdyZXM6IGF1dG92YWN1dW0gd29ya2VyIHRlbXBsYXRlMChfc3RhcnQrMHgyMSlbMHg1NjBh NGZkMTZmMzFdCgpUbyBmaXgsIGJhaWwgb3V0IGluIENvbXBhY3RDaGVja3BvaW50ZXJSZXF1ZXN0 UXVldWUoKSB3aXRob3V0IGRvaW5nCmFueXRoaW5nLCBpZiBpdCdzIGNhbGxlZCBpbiBhIGNyaXRp Y2FsIHNlY3Rpb24uIFRoYXQgY292ZXJzIHRoZSBhYm92ZQpjYWxsIHBhdGgsIGFzIHdlbGwgYXMg YW55IG90aGVyIHNpbWlsYXIgY2FzZXMgd2hlcmUKUmVnaXN0ZXJTeW5jUmVxdWVzdCBtaWdodCBi ZSBjYWxsZWQgaW4gYSBjcml0aWNhbCBzZWN0aW9uLgoKMi4gQWZ0ZXIgZml4aW5nIHRoYXQsIGFu b3RoZXIgcHJvYmxlbSBiZWNhbWUgYXBwYXJlbnQ6IEF1dG92YWN1dW0KcHJvY2VzcyBkb2luZyB0 aGF0IHRydW5jYXRpb24gY2FuIGRlYWRsb2NrIHdpdGggdGhlIGNoZWNrcG9pbnRlcgpwcm9jZXNz LiBUcnVuY2F0ZU11bHRpWGFjdCgpIHNldHMgIk15UHJvYy0+ZGVsYXlDaGtwdEZsYWdzIHw9CkRF TEFZX0NIS1BUX1NUQVJUIi4gSWYgdGhlIHN5bmMgcmVxdWVzdCBxdWV1ZSBpcyBmdWxsIGFuZCBj YW5ub3QgYmUKY29tcGFjdGVkLCB0aGUgcHJvY2VzcyB3aWxsIHJlcGVhdGVkbHkgc2xlZXAgYW5k IHJldHJ5LCB1bnRpbCB0aGVyZSBpcwpyb29tIGluIHRoZSBxdWV1ZS4gSG93ZXZlciwgaWYgdGhl IGNoZWNrcG9pbnRlciBpcyB0cnlpbmcgdG8gc3RhcnQgYQpjaGVja3BvaW50IGF0IHRoZSBzYW1l IHRpbWUsIGFuZCBpcyB3YWl0aW5nIGZvciB0aGUgREVMQVlfQ0hLUFRfU1RBUlQKcHJvY2Vzc2Vz IHRvIGZpbmlzaCwgdGhlIHF1ZXVlIHdpbGwgbmV2ZXIgc2hyaW5rLgoKTW9yZSBjb25jcmV0ZWx5 LCB0aGUgYXV0b3ZhY3V1bSBwcm9jZXNzIGlzIHN0dWNrIGhlcmU6CgogICAgIzAgIDB4MDAwMDdm YzkzNDkyNmRjMyBpbiBlcG9sbF93YWl0ICgpIGZyb20gL2xpYi94ODZfNjQtbGludXgtZ251L2xp YmMuc28uNgogICAgIzEgIDB4MDAwMDU2MjIwYjI0MzQ4YiBpbiBXYWl0RXZlbnRTZXRXYWl0Qmxv Y2sgKHNldD0weDU2MjIwYzJlNGI1MCwgb2NjdXJyZWRfZXZlbnRzPTB4N2ZmZTc4NTZkMDQwLCBu ZXZlbnRzPTEsIGN1cl90aW1lb3V0PTxvcHRpbWl6ZWQgb3V0PikgYXQgLi4vc3JjL2JhY2tlbmQv c3RvcmFnZS9pcGMvbGF0Y2guYzoxNTcwCiAgICAjMiAgV2FpdEV2ZW50U2V0V2FpdCAoc2V0PTB4 NTYyMjBjMmU0YjUwLCB0aW1lb3V0PXRpbWVvdXRAZW50cnk9MTAsIG9jY3VycmVkX2V2ZW50cz08 b3B0aW1pemVkIG91dD4sIG9jY3VycmVkX2V2ZW50c0BlbnRyeT0weDdmZmU3ODU2ZDA0MCwgbmV2 ZW50cz1uZXZlbnRzQGVudHJ5PTEsCiAgICAgICAgd2FpdF9ldmVudF9pbmZvPXdhaXRfZXZlbnRf aW5mb0BlbnRyeT0xNTA5OTQ5NDkpIGF0IC4uL3NyYy9iYWNrZW5kL3N0b3JhZ2UvaXBjL2xhdGNo LmM6MTUxNgogICAgIzMgIDB4MDAwMDU2MjIwYjI0MzIyNCBpbiBXYWl0TGF0Y2ggKGxhdGNoPTxv cHRpbWl6ZWQgb3V0PiwgbGF0Y2hAZW50cnk9MHgwLCB3YWtlRXZlbnRzPXdha2VFdmVudHNAZW50 cnk9NDAsIHRpbWVvdXQ9dGltZW91dEBlbnRyeT0xMCwgd2FpdF9ldmVudF9pbmZvPXdhaXRfZXZl bnRfaW5mb0BlbnRyeT0xNTA5OTQ5NDkpCiAgICAgICAgYXQgLi4vc3JjL2JhY2tlbmQvc3RvcmFn ZS9pcGMvbGF0Y2guYzo1MzgKICAgICM0ICAweDAwMDA1NjIyMGIyNmNmNDYgaW4gUmVnaXN0ZXJT eW5jUmVxdWVzdCAoZnRhZz1mdGFnQGVudHJ5PTB4N2ZmZTc4NTZkMGEwLCB0eXBlPXR5cGVAZW50 cnk9U1lOQ19GT1JHRVRfUkVRVUVTVCwgcmV0cnlPbkVycm9yPXRydWUpIGF0IC4uL3NyYy9iYWNr ZW5kL3N0b3JhZ2Uvc3luYy9zeW5jLmM6NjE0CiAgICAjNSAgMHgwMDAwNTYyMjBhZjlkYjBhIGlu IFNscnVJbnRlcm5hbERlbGV0ZVNlZ21lbnQgKGN0bD1jdGxAZW50cnk9MHg1NjIyMGI3YmViNjAg PE11bHRpWGFjdE1lbWJlckN0bERhdGE+LCBzZWdubz1zZWdub0BlbnRyeT0xMTM1MCkgYXQgLi4v c3JjL2JhY2tlbmQvYWNjZXNzL3RyYW5zYW0vc2xydS5jOjE0OTUKICAgICM2ICAweDAwMDA1NjIy MGFmOWRhYjEgaW4gU2xydURlbGV0ZVNlZ21lbnQgKGN0bD1jdGxAZW50cnk9MHg1NjIyMGI3YmVi NjAgPE11bHRpWGFjdE1lbWJlckN0bERhdGE+LCBzZWdubz1zZWdub0BlbnRyeT0xMTM1MCkgYXQg Li4vc3JjL2JhY2tlbmQvYWNjZXNzL3RyYW5zYW0vc2xydS5jOjE1NjYKICAgICM3ICAweDAwMDA1 NjIyMGFmOThlMWIgaW4gUGVyZm9ybU1lbWJlcnNUcnVuY2F0aW9uIChvbGRlc3RPZmZzZXQ9PG9w dGltaXplZCBvdXQ+LCBuZXdPbGRlc3RPZmZzZXQ9PG9wdGltaXplZCBvdXQ+KSBhdCAuLi9zcmMv YmFja2VuZC9hY2Nlc3MvdHJhbnNhbS9tdWx0aXhhY3QuYzozMDA2CiAgICAjOCAgVHJ1bmNhdGVN dWx0aVhhY3QgKG5ld09sZGVzdE11bHRpPW5ld09sZGVzdE11bHRpQGVudHJ5PTMyMjEyMjU0NzIs IG5ld09sZGVzdE11bHRpREI9bmV3T2xkZXN0TXVsdGlEQkBlbnRyeT00KSBhdCAuLi9zcmMvYmFj a2VuZC9hY2Nlc3MvdHJhbnNhbS9tdWx0aXhhY3QuYzozMjAxCiAgICAjOSAgMHgwMDAwNTYyMjBi MDk4MzAzIGluIHZhY190cnVuY2F0ZV9jbG9nIChmcm96ZW5YSUQ9NzQ5LCBtaW5NdWx0aT08b3B0 aW1pemVkIG91dD4sIGxhc3RTYW5lRnJvemVuWGlkPTc0OSwgbGFzdFNhbmVNaW5NdWx0aT0zMjIx MjI1NDcyKSBhdCAuLi9zcmMvYmFja2VuZC9jb21tYW5kcy92YWN1dW0uYzoxOTE3CiAgICAjMTAg dmFjX3VwZGF0ZV9kYXRmcm96ZW54aWQgKCkgYXQgLi4vc3JjL2JhY2tlbmQvY29tbWFuZHMvdmFj dXVtLmM6MTc2MAogICAgIzExIDB4MDAwMDU2MjIwYjFjM2Y3NiBpbiBkb19hdXRvdmFjdXVtICgp IGF0IC4uL3NyYy9iYWNrZW5kL3Bvc3RtYXN0ZXIvYXV0b3ZhY3V1bS5jOjI1NTAKICAgICMxMiAw eDAwMDA1NjIyMGIxYzJjM2QgaW4gQXV0b1ZhY1dvcmtlck1haW4gKHN0YXJ0dXBfZGF0YT08b3B0 aW1pemVkIG91dD4sIHN0YXJ0dXBfZGF0YV9sZW49PG9wdGltaXplZCBvdXQ+KSBhdCAuLi9zcmMv YmFja2VuZC9wb3N0bWFzdGVyL2F1dG92YWN1dW0uYzoxNTY5CgphbmQgdGhlIGNoZWNrcG9pbnRl ciBpcyBzdHVjayBoZXJlOgoKICAgICMwICAweDAwMDA3ZmM5MzQ4ZWJmOTMgaW4gY2xvY2tfbmFu b3NsZWVwICgpIGZyb20gL2xpYi94ODZfNjQtbGludXgtZ251L2xpYmMuc28uNgogICAgIzEgIDB4 MDAwMDdmYzkzNDhmZTM1MyBpbiBuYW5vc2xlZXAgKCkgZnJvbSAvbGliL3g4Nl82NC1saW51eC1n bnUvbGliYy5zby42CiAgICAjMiAgMHgwMDAwNTYyMjBiNDBlY2I0IGluIHBnX3VzbGVlcCAobWlj cm9zZWM9bWljcm9zZWNAZW50cnk9MTAwMDApIGF0IC4uL3NyYy9wb3J0L3Bnc2xlZXAuYzo1MAog ICAgIzMgIDB4MDAwMDU2MjIwYWZiNDNjMyBpbiBDcmVhdGVDaGVja1BvaW50IChmbGFncz1mbGFn c0BlbnRyeT0xMDgpIGF0IC4uL3NyYy9iYWNrZW5kL2FjY2Vzcy90cmFuc2FtL3hsb2cuYzo3MDk4 CiAgICAjNCAgMHgwMDAwNTYyMjBiMWM2ZTg2IGluIENoZWNrcG9pbnRlck1haW4gKHN0YXJ0dXBf ZGF0YT08b3B0aW1pemVkIG91dD4sIHN0YXJ0dXBfZGF0YV9sZW49PG9wdGltaXplZCBvdXQ+KSBh dCAuLi9zcmMvYmFja2VuZC9wb3N0bWFzdGVyL2NoZWNrcG9pbnRlci5jOjQ2NAoKVG8gZml4LCBh ZGQgQWJzb3JiU3luY1JlcXVlc3RzKCkgdG8gdGhlIGxvb3BzIHdoZXJlIHRoZSBjaGVja3BvaW50 ZXIKd2FpdHMgZm9yIERFTEFZX0NIS1BUX1NUQVJUIG9yIERFTEFZX0NIS1BUX0NPTVBMRVRFIG9w ZXJhdGlvbnMgdG8KZmluaXNoLgoKQmFja3BhdGNoIHRvIHYxNC4gQmVmb3JlIHRoYXQsIFNMUlUg ZGVsZXRpb24gZGlkbid0IGNhbGwKUmVnaXN0ZXJTeW5jUmVxdWVzdCwgd2hpY2ggYXZvaWRlZCB0 aGlzIGZhaWx1cmUuIEknbSBub3Qgc3VyZSBpZiB0aGVyZQphcmUgb3RoZXIgc2ltaWxhciBzY2Vu YXJpb3Mgb24gb2xkZXIgdmVyc2lvbnMsIGJ1dCB3ZSBoYXZlbid0IGhhZAphbnkgc3VjaCByZXBv cnRzLgoKRGlzY3Vzc2lvbjogaHR0cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcvbWVzc2FnZS1pZC9j Y2M2NjkzMy0zMWMxLTRmNmEtYmY0Yi00NWZlZjBkNGYyMmVAaWtpLmZpCgpCcmFuY2gKLS0tLS0t ClJFTF8xNF9TVEFCTEUKCkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9y Zy9wZy9jb21taXRkaWZmLzRjOGUwMGFlOWFlM2I1M2MwOGE1NmI1ODRlMWIxODU2NjhhMmFmZjUK Ck1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCnNyYy9iYWNrZW5kL2FjY2Vzcy90cmFuc2Ft L3hsb2cuYyAgICAgfCA3ICsrKysrKysKc3JjL2JhY2tlbmQvcG9zdG1hc3Rlci9jaGVja3BvaW50 ZXIuYyB8IDQgKysrKwoyIGZpbGVzIGNoYW5nZWQsIDExIGluc2VydGlvbnMoKykKCg== --===============5106725369637232310==--