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 1qjHt2-00A8pp-0P for pgsql-bugs@arkaria.postgresql.org; Thu, 21 Sep 2023 11:30:24 +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 1qjHt0-00BW9e-Hx for pgsql-bugs@arkaria.postgresql.org; Thu, 21 Sep 2023 11:30:22 +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 1qjHPk-00BFlu-1R for pgsql-bugs@lists.postgresql.org; Thu, 21 Sep 2023 11:00:08 +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 1qjHPh-005nUy-7x for pgsql-bugs@lists.postgresql.org; Thu, 21 Sep 2023 11:00:06 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=mLv7RGXbeiVuX1BqXAxuRlOhs2UAah+AiVNt6W72JMY=; b=xJ+WgC6gHnmZnoTX0eVFB387HN nMn7ZAKpRBc/qJboZyD/V5eANnRf5Tj9Wm0Oskr+AVm0KyKan3OY9b0eErWHtRWIjwKoYFgGiGBXB 2LuP+qFiLLpt5bNZWOndB85LUWnXJYr4fXmioPaTAevs5/2fMVMExqkhRay7ubJ++LvSE6fMSz5I2 l5NUUk1VnGI7u4B8HWg29DCMA2VfDZE1FxyqqAWHrcAMMdvdx3N24SMT4p2uqJXB04XLlOybB6Xmk QYaVPFvj3IC51gjQEVKV/K0t8NJuBDIU5VbJtdHN5EhdkOoBOJ5b+5m+WJ1O4vV3PidYrpG8z2GR8 KnI82gUQ==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qjHPg-0002Kr-KX for pgsql-bugs@lists.postgresql.org; Thu, 21 Sep 2023 11:00:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qjHPe-001reX-Sp for pgsql-bugs@lists.postgresql.org; Thu, 21 Sep 2023 11:00:03 +0000 Content-Type: multipart/mixed; boundary="===============1182132419631725929==" MIME-Version: 1.0 Subject: BUG #18127: Assertion HaveRegisteredOrActiveSnapshot failed on REINDEX CONCURRENTLY when blocksize=1 To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: exclusion@gmail.com Reply-To: exclusion@gmail.com, pgsql-bugs@lists.postgresql.org Date: Thu, 21 Sep 2023 11:00:01 +0000 Message-ID: <18127-fe54b6a667f29658@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============1182132419631725929== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODEyNwpMb2dnZWQgYnk6ICAgICAgICAgIEFsZXhhbmRlciBMYWtoaW4K RW1haWwgYWRkcmVzczogICAgICBleGNsdXNpb25AZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lv bjogMTYuMApPcGVyYXRpbmcgc3lzdGVtOiAgIFVidW50dSAyMi4wNApEZXNjcmlwdGlvbjogICAg ICAgIAoKQSBzZXJ2ZXIgY29tcGlsZWQgLS13aXRoLWJsb2Nrc2l6ZT0xIHByb2R1Y2VzIGFuIGFz c2VydGlvbiBmYWlsdXJlIG9uDQpgbWFrZSBjaGVja2AuIE1vcmUgc3BlY2lmaWNhbGx5LCB0aGUg ZmFpbHVyZSB0cmlnZ2VyZWQgb24gYSBxdWVyeSBsaWtlOg0KQ1JFQVRFIFRBQkxFIGNvbmN1cl9y ZWluZGV4X3RhYiAoYzEgaW50IFBSSU1BUlkgS0VZKTsNCkNSRUFURSBUQUJMRSBjb25jdXJfcmVp bmRleF90YWIyIChjMSBpbnQgUkVGRVJFTkNFUyBjb25jdXJfcmVpbmRleF90YWIpOw0KUkVJTkRF WCBJTkRFWCBDT05DVVJSRU5UTFkgY29uY3VyX3JlaW5kZXhfdGFiX3BrZXk7DQoNCkNvcmUgd2Fz IGdlbmVyYXRlZCBieSBgcG9zdGdyZXM6IGxhdyByZWdyZXNzaW9uIFtsb2NhbF0gUkVJTkRFWCAg ICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgJy4NClByb2dyYW0gdGVybWluYXRl ZCB3aXRoIHNpZ25hbCBTSUdBQlJULCBBYm9ydGVkLg0KDQp3YXJuaW5nOiBTZWN0aW9uIGAucmVn LXhzdGF0ZS8zNzM4NDY3JyBpbiBjb3JlIGZpbGUgdG9vIHNtYWxsLg0KIzAgIF9fcHRocmVhZF9r aWxsX2ltcGxlbWVudGF0aW9uIChub190aWQ9MCwgc2lnbm89NiwKdGhyZWFkaWQ9MTM5ODY4NzAx ODUzNTA0KQ0KICAgIGF0IC4vbnB0bC9wdGhyZWFkX2tpbGwuYzo0NA0KNDQgICAgICAuL25wdGwv cHRocmVhZF9raWxsLmM6IE5vIHN1Y2ggZmlsZSBvciBkaXJlY3RvcnkuDQooZ2RiKSBidA0KIzAg IF9fcHRocmVhZF9raWxsX2ltcGxlbWVudGF0aW9uIChub190aWQ9MCwgc2lnbm89NiwKdGhyZWFk aWQ9MTM5ODY4NzAxODUzNTA0KSBhdCAuL25wdGwvcHRocmVhZF9raWxsLmM6NDQNCiMxICBfX3B0 aHJlYWRfa2lsbF9pbnRlcm5hbCAoc2lnbm89NiwgdGhyZWFkaWQ9MTM5ODY4NzAxODUzNTA0KSBh dAouL25wdGwvcHRocmVhZF9raWxsLmM6NzgNCiMyICBfX0dJX19fcHRocmVhZF9raWxsICh0aHJl YWRpZD0xMzk4Njg3MDE4NTM1MDQsIHNpZ25vPXNpZ25vQGVudHJ5PTYpIGF0Ci4vbnB0bC9wdGhy ZWFkX2tpbGwuYzo4OQ0KIzMgIDB4MDAwMDdmMzViN2FmMDQ3NiBpbiBfX0dJX3JhaXNlIChzaWc9 c2lnQGVudHJ5PTYpIGF0Ci4uL3N5c2RlcHMvcG9zaXgvcmFpc2UuYzoyNg0KIzQgIDB4MDAwMDdm MzViN2FkNjdmMyBpbiBfX0dJX2Fib3J0ICgpIGF0IC4vc3RkbGliL2Fib3J0LmM6NzkNCiM1ICAw eDAwMDA1NTljZDYxMTgxMzEgaW4gRXhjZXB0aW9uYWxDb25kaXRpb24gKGNvbmRpdGlvbk5hbWU9 MHg1NTljZDYxYTU0NzAKIkhhdmVSZWdpc3RlcmVkT3JBY3RpdmVTbmFwc2hvdCgpIiwgZmlsZU5h bWU9MHg1NTljZDYxYTUwYzAKInRvYXN0X2ludGVybmFscy5jIiwgbGluZU51bWJlcj02NzApIGF0 IGFzc2VydC5jOjY2DQojNiAgMHgwMDAwNTU5Y2Q1OWFkN2ZmIGluIGluaXRfdG9hc3Rfc25hcHNo b3QKKHRvYXN0X3NuYXBzaG90PTB4N2ZmZGY5MWI0ZDAwKSBhdCB0b2FzdF9pbnRlcm5hbHMuYzo2 NzANCiM3ICAweDAwMDA1NTljZDU5YWQyMmMgaW4gdG9hc3RfZGVsZXRlX2RhdHVtIChyZWw9MHg3 ZjM1Yjg0NjZjNTgsCnZhbHVlPTEzOTg2ODUyNDM0MTE4OSwgaXNfc3BlY3VsYXRpdmU9ZmFsc2Up IGF0IHRvYXN0X2ludGVybmFscy5jOjQyOQ0KIzggIDB4MDAwMDU1OWNkNWE2MjVlMCBpbiB0b2Fz dF90dXBsZV9jbGVhbnVwICh0dGM9MHg3ZmZkZjkxYjRlNTApIGF0CnRvYXN0X2hlbHBlci5jOjMw OQ0KIzkgIDB4MDAwMDU1OWNkNWEwYzMxYyBpbiBoZWFwX3RvYXN0X2luc2VydF9vcl91cGRhdGUg KHJlbD0weDdmMzViODQ2NmM1OCwKbmV3dHVwPTB4NTU5Y2Q2OWRhZTE4LCBvbGR0dXA9MHg3ZmZk ZjkxYzI0NDAsIG9wdGlvbnM9MCkgYXQKaGVhcHRvYXN0LmM6MzMzDQojMTAgMHgwMDAwNTU5Y2Q1 OWY3NDE4IGluIGhlYXBfdXBkYXRlIChyZWxhdGlvbj0weDdmMzViODQ2NmM1OCwKb3RpZD0weDU1 OWNkNjlkYWUxYywgbmV3dHVwPTB4NTU5Y2Q2OWRhZTE4LCBjaWQ9MCwgY3Jvc3NjaGVjaz0weDAs CndhaXQ9dHJ1ZSwgdG1mZD0weDdmZmRmOTFjMjRkMCwgbG9ja21vZGU9MHg3ZmZkZjkxYzI0Yzgs CnVwZGF0ZV9pbmRleGVzPTB4N2ZmZGY5MWMyNTJjKSBhdCBoZWFwYW0uYzozNTk1DQojMTEgMHgw MDAwNTU5Y2Q1OWY4MTA5IGluIHNpbXBsZV9oZWFwX3VwZGF0ZSAocmVsYXRpb249MHg3ZjM1Yjg0 NjZjNTgsCm90aWQ9MHg1NTljZDY5ZGFlMWMsIHR1cD0weDU1OWNkNjlkYWUxOCwgdXBkYXRlX2lu ZGV4ZXM9MHg3ZmZkZjkxYzI1MmMpIGF0CmhlYXBhbS5jOjQwNTMNCiMxMiAweDAwMDA1NTljZDVh ZDNiNDUgaW4gQ2F0YWxvZ1R1cGxlVXBkYXRlIChoZWFwUmVsPTB4N2YzNWI4NDY2YzU4LApvdGlk PTB4NTU5Y2Q2OWRhZTFjLCB0dXA9MHg1NTljZDY5ZGFlMTgpIGF0IGluZGV4aW5nLmM6MzIyDQoj MTMgMHgwMDAwNTU5Y2Q1YWNlZGE2IGluIGluZGV4X2NvbmN1cnJlbnRseV9zd2FwIChuZXdJbmRl eElkPTIwMzMwLApvbGRJbmRleElkPTIwMjk5LCBvbGROYW1lPTB4NTU5Y2Q2OWRjMzY4ICJjb25j dXJfcmVpbmRleF9pbmQxX2Njb2xkIikgYXQKaW5kZXguYzoxNjU5DQojMTQgMHgwMDAwNTU5Y2Q1 YmUyNTczIGluIFJlaW5kZXhSZWxhdGlvbkNvbmN1cnJlbnRseSAocmVsYXRpb25PaWQ9MjAyOTks CnBhcmFtcz0weDdmZmRmOTFjMmI2OCkgYXQgaW5kZXhjbWRzLmM6NDA4OA0KIzE1IDB4MDAwMDU1 OWNkNWJkZmUzYSBpbiBSZWluZGV4SW5kZXggKGluZGV4UmVsYXRpb249MHg1NTljZDY5MWExMDAs CnBhcmFtcz0weDdmZmRmOTFjMmI2OCwgaXNUb3BMZXZlbD10cnVlKSBhdCBpbmRleGNtZHMuYzoy ODA5DQojMTYgMHgwMDAwNTU5Y2Q1YmRmYzdhIGluIEV4ZWNSZWluZGV4IChwc3RhdGU9MHg1NTlj ZDZjM2FlMjgsCnN0bXQ9MHg1NTljZDY5MWExNTAsIGlzVG9wTGV2ZWw9dHJ1ZSkgYXQgaW5kZXhj bWRzLmM6MjczOQ0KIzE3IDB4MDAwMDU1OWNkNWYzOGI3YyBpbiBzdGFuZGFyZF9Qcm9jZXNzVXRp bGl0eSAocHN0bXQ9MHg1NTljZDY5MWEyYTAsCnF1ZXJ5U3RyaW5nPTB4NTU5Y2Q2OTE5NmU4ICJS RUlOREVYIElOREVYIENPTkNVUlJFTlRMWQpjb25jdXJfcmVpbmRleF9pbmQxOyIsIHJlYWRPbmx5 VHJlZT1mYWxzZSwgY29udGV4dD1QUk9DRVNTX1VUSUxJVFlfVE9QTEVWRUwsCnBhcmFtcz0weDAs IHF1ZXJ5RW52PTB4MCwgDQogICAgZGVzdD0weDU1OWNkNjkxYTU2MCwgcWM9MHg3ZmZkZjkxYzMw MTApIGF0IHV0aWxpdHkuYzo5NjQNCiMxOCAweDAwMDA1NTljZDVmMzdlN2QgaW4gUHJvY2Vzc1V0 aWxpdHkgKHBzdG10PTB4NTU5Y2Q2OTFhMmEwLApxdWVyeVN0cmluZz0weDU1OWNkNjkxOTZlOCAi UkVJTkRFWCBJTkRFWCBDT05DVVJSRU5UTFkKY29uY3VyX3JlaW5kZXhfaW5kMTsiLCByZWFkT25s eVRyZWU9ZmFsc2UsIGNvbnRleHQ9UFJPQ0VTU19VVElMSVRZX1RPUExFVkVMLApwYXJhbXM9MHgw LCBxdWVyeUVudj0weDAsIA0KICAgIGRlc3Q9MHg1NTljZDY5MWE1NjAsIHFjPTB4N2ZmZGY5MWMz MDEwKSBhdCB1dGlsaXR5LmM6NTMwDQojMTkgMHgwMDAwNTU5Y2Q1ZjM2NzRmIGluIFBvcnRhbFJ1 blV0aWxpdHkgKHBvcnRhbD0weDU1OWNkNjk4YzhmOCwKcHN0bXQ9MHg1NTljZDY5MWEyYTAsIGlz VG9wTGV2ZWw9dHJ1ZSwgc2V0SG9sZFNuYXBzaG90PWZhbHNlLApkZXN0PTB4NTU5Y2Q2OTFhNTYw LCBxYz0weDdmZmRmOTFjMzAxMCkgYXQgcHF1ZXJ5LmM6MTE1OA0KIzIwIDB4MDAwMDU1OWNkNWYz NjljNiBpbiBQb3J0YWxSdW5NdWx0aSAocG9ydGFsPTB4NTU5Y2Q2OThjOGY4LAppc1RvcExldmVs PXRydWUsIHNldEhvbGRTbmFwc2hvdD1mYWxzZSwgZGVzdD0weDU1OWNkNjkxYTU2MCwKYWx0ZGVz dD0weDU1OWNkNjkxYTU2MCwgcWM9MHg3ZmZkZjkxYzMwMTApIGF0IHBxdWVyeS5jOjEzMTUNCiMy MSAweDAwMDA1NTljZDVmMzVlMTAgaW4gUG9ydGFsUnVuIChwb3J0YWw9MHg1NTljZDY5OGM4Zjgs CmNvdW50PTkyMjMzNzIwMzY4NTQ3NzU4MDcsIGlzVG9wTGV2ZWw9dHJ1ZSwgcnVuX29uY2U9dHJ1 ZSwKZGVzdD0weDU1OWNkNjkxYTU2MCwgYWx0ZGVzdD0weDU1OWNkNjkxYTU2MCwgcWM9MHg3ZmZk ZjkxYzMwMTApIGF0CnBxdWVyeS5jOjc5MQ0KIzIyIDB4MDAwMDU1OWNkNWYyZWIxZiBpbiBleGVj X3NpbXBsZV9xdWVyeSAocXVlcnlfc3RyaW5nPTB4NTU5Y2Q2OTE5NmU4CiJSRUlOREVYIElOREVY IENPTkNVUlJFTlRMWSBjb25jdXJfcmVpbmRleF9pbmQxOyIpIGF0IHBvc3RncmVzLmM6MTI3NA0K IzIzIDB4MDAwMDU1OWNkNWYzM2I4ZCBpbiBQb3N0Z3Jlc01haW4gKGRibmFtZT0weDU1OWNkNjk1 MGFjOCAicmVncmVzc2lvbiIsCnVzZXJuYW1lPTB4NTU5Y2Q2OTE1OWM4ICJsYXciKSBhdCBwb3N0 Z3Jlcy5jOjQ2MzcNCiMyNCAweDAwMDA1NTljZDVlNTRiZjMgaW4gQmFja2VuZFJ1biAocG9ydD0w eDU1OWNkNjk0NTJmMCkgYXQKcG9zdG1hc3Rlci5jOjQ0NjQNCiMyNSAweDAwMDA1NTljZDVlNTQ0 N2YgaW4gQmFja2VuZFN0YXJ0dXAgKHBvcnQ9MHg1NTljZDY5NDUyZjApIGF0CnBvc3RtYXN0ZXIu Yzo0MTkyDQojMjYgMHgwMDAwNTU5Y2Q1ZTUwN2M0IGluIFNlcnZlckxvb3AgKCkgYXQgcG9zdG1h c3Rlci5jOjE3ODINCiMyNyAweDAwMDA1NTljZDVlNTAwNmUgaW4gUG9zdG1hc3Rlck1haW4gKGFy Z2M9OCwgYXJndj0weDU1OWNkNjkxMzg1MCkgYXQKcG9zdG1hc3Rlci5jOjE0NjYNCiMyOCAweDAw MDA1NTljZDVkMDQ2ZjkgaW4gbWFpbiAoYXJnYz04LCBhcmd2PTB4NTU5Y2Q2OTEzODUwKSBhdCBt YWluLmM6MTk4DQoNCihnZGIpIGZyYW1lIDEwDQojMTAgMHgwMDAwNTU5Y2Q1OWY3NDE4IGluIGhl YXBfdXBkYXRlIChyZWxhdGlvbj0weDdmMzViODQ2NmM1OCwKb3RpZD0weDU1OWNkNjlkYWUxYywg DQogICAgbmV3dHVwPTB4NTU5Y2Q2OWRhZTE4LCBjaWQ9MCwgY3Jvc3NjaGVjaz0weDAsIHdhaXQ9 dHJ1ZSwKdG1mZD0weDdmZmRmOTFjMjRkMCwgDQogICAgbG9ja21vZGU9MHg3ZmZkZjkxYzI0Yzgs IHVwZGF0ZV9pbmRleGVzPTB4N2ZmZGY5MWMyNTJjKSBhdApoZWFwYW0uYzozNTk1DQozNTk1ICAg ICAgICAgICAgICAgICAgICAgICAgICAgIGhlYXB0dXAgPQpoZWFwX3RvYXN0X2luc2VydF9vcl91 cGRhdGUocmVsYXRpb24sIG5ld3R1cCwgJm9sZHR1cCwgMCk7DQooZ2RiKSBwIG5lZWRfdG9hc3QN CiQxID0gdHJ1ZQ0KKGdkYikgcCBuZXd0dXBzaXplDQokMiA9IDI1Ng0KDQooZ2RiKSBmcmFtZSA2 DQojNiAgMHgwMDAwNTU5Y2Q1OWFkN2ZmIGluIGluaXRfdG9hc3Rfc25hcHNob3QKKHRvYXN0X3Nu YXBzaG90PTB4N2ZmZGY5MWI0ZDAwKSBhdCB0b2FzdF9pbnRlcm5hbHMuYzo2NzANCjY3MCAgICAg ICAgICAgICBBc3NlcnQoSGF2ZVJlZ2lzdGVyZWRPckFjdGl2ZVNuYXBzaG90KCkpOw0KKGdkYikg cCBSZWdpc3RlcmVkU25hcHNob3RzDQokNCA9IHtwaF9jb21wYXJlID0gMHg1NTljZDYxNzc1ZTAg PHhtaW5fY21wPiwgcGhfYXJnID0gMHgwLCANCiAgcGhfcm9vdCA9IDB4NTU5Y2Q2NGUzNWE4IDxD YXRhbG9nU25hcHNob3REYXRhKzcyPn0NCihnZGIpICBwICpSZWdpc3RlcmVkU25hcHNob3RzLnBo X3Jvb3QNCiQ1ID0ge2ZpcnN0X2NoaWxkID0gMHgwLCBuZXh0X3NpYmxpbmcgPSAweDAsIHByZXZf b3JfcGFyZW50ID0gMHgwfQ0KKGdkYikgcCBBY3RpdmVTbmFwc2hvdA0KJDYgPSAoQWN0aXZlU25h cHNob3RFbHQgKikgMHgwDQoNCkkgdGhpbmsgdGhhdCB0aGUgYmxvY2tzaXplIG1hdHRlcnMgaGVy ZSBqdXN0IGJlY2F1c2UgaXQgYWxsb3dzIHRvIHJlYWNoDQp0b2FzdF9kZWxldGVfZGF0dW0oKSBp bnNpZGUgaW5kZXhfY29uY3VycmVudGx5X3N3YXAoKS4gUGVyaGFwcyB0aGUgc2FtZQ0KZWZmZWN0 IGNvdWxkIGJlIHNlZW4gd2l0aCB0aGUgZGVmYXVsdCBibG9jayBzaXplLCBidXQgd2l0aCBsYXJn ZXIgdHVwbGVzDQppbiBwZ19jb25zdHJhaW50IChJIGhhdmVuJ3QgdHJpZWQgdG8gY29uc3RydWN0 IHN1Y2ggdHVwbGVzIHlldCkuDQoNClRoaXMgaXNzdWUgaXMgbm90IHRoZSBzYW1lIGFzIFsxXSwg YmVjYXVzZSBpbiB0aGlzIGNhc2UgSSByZWFsbHkgc2VlIG5vDQpyZWdpc3RlcmVkIG9yIGFjdGl2 ZSBzbmFwc2hvdHMuDQoNClJlcHJvZHVjZWQgb24gUkVMXzE1X1NUQUJMRSAuLiBtYXN0ZXIuDQoN ClsxXQpodHRwczovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9tZXNzYWdlLWlkL2RjOWRkMjI5LWVkMzAt NmM2Mi00YzQxLWQ3MzNmZmZmNzc2YiU0MHhzNGFsbC5ubAoK --===============1182132419631725929==--