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 1oJxDh-0004R5-Hj for pgsql-bugs@arkaria.postgresql.org; Fri, 05 Aug 2022 13:18:29 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oJxDg-0005Hp-9g for pgsql-bugs@arkaria.postgresql.org; Fri, 05 Aug 2022 13:18:28 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oJkUd-0002Yz-Lo for pgsql-bugs@lists.postgresql.org; Thu, 04 Aug 2022 23:43:07 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oJkUb-0006K1-Bl for pgsql-bugs@lists.postgresql.org; Thu, 04 Aug 2022 23:43:07 +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=2/bmH9JKCGRjflfjpxi5nYGXTMs3LyH2B3anjZpfFJw=; b=AgK81/oy0ZT2QPSrBtGKcInd24 eTTwOmQBk8Vi175AN+MCfzyu/7XH1q7v91dsU7KcMmQcXCVRBt8uE+OsjMvdknIgybZBGV1croPpa Rx+8k+eUgwFZkdtljayIkD/Hv890qYS9lsybnrhwk+nXCcnjPkcRujgO6JqtAx8om4gH38LFGZsjk VqPQCI3EhC/Kmwl5C+5YKtHJKbxN/2THcWQ/I7gwemg5VeriKoglo9X7e7SnAposPFh3dmMh1wFk3 hVPp1N1CKg/PkzjwiA+xcRh6QBD3jrtLDZty1aEnq2X+uT9RYW0t1Vt5b8eMACDGeHQHJ62Na7K2J bAnIutlw==; 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 1oJkUZ-0004kY-Qc for pgsql-bugs@lists.postgresql.org; Thu, 04 Aug 2022 23:43:03 +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 1oJkUY-001S4n-Dv for pgsql-bugs@lists.postgresql.org; Thu, 04 Aug 2022 23:43:02 +0000 Content-Type: multipart/mixed; boundary="===============5512841502473441921==" MIME-Version: 1.0 Subject: BUG #17574: Attaching an invalid index to partition head make head index invalid forever To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: maxim.boguk@gmail.com Reply-To: maxim.boguk@gmail.com, pgsql-bugs@lists.postgresql.org Date: Thu, 04 Aug 2022 23:42:54 +0000 Message-ID: <17574-0e82148f7b16e7d4@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 --===============5512841502473441921== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzU3NApMb2dnZWQgYnk6ICAgICAgICAgIE1heGltIEJvZ3VrCkVtYWls IGFkZHJlc3M6ICAgICAgbWF4aW0uYm9ndWtAZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lvbjog MTQuNApPcGVyYXRpbmcgc3lzdGVtOiAgIExpbnV4CkRlc2NyaXB0aW9uOiAgICAgICAgCgpJZiB5 b3UgKG9wZXJhdG9yIGVycm9yIG9yIHNjcmlwdCBlcnJvcikgYXR0YWNoIGFuIGludmFsaWQgaW5k ZXggdG8gaGVhZCBvZgpwYXJ0aXRpb24gaW5kZXggLSBpdCB3aWxsIG1ha2UgcGFydGl0aW9uIGhl YWQgaW5kZXggaW52YWxpZCBmb3J2ZXIuDQpJIGZvdW5kIG5vIHdheSB0byBmaXggc2l0dWF0aW9u IGV4Y2VwdCBjcmVhdGUgY29tcGxldGVseSBuZXcgaGVhZCBpbmRleCBhbmQKYnVpbGQvYXR0YWNo IG5ldyBpbmRleGVzIG9uIGFsbCBwYXJ0aXRpb25zLg0KDQpNaW5pbWFsIHRlc3QgY2FzZToNCi0t cHJlcGFyZSBkYXRhDQpjcmVhdGUgdGFibGUgdGVzdCAoaWQgaW50ZWdlcikgcGFydGl0aW9uIGJ5 IHJhbmdlKGlkKTsNCmNyZWF0ZSB0YWJsZSB0ZXN0X3BhcnRfMTAwMDAwMCBwYXJ0aXRpb24gb2Yg dGVzdCBmb3IgdmFsdWVzIGZyb20gKDApIHRvCigxMDAwMDAwKTsNCmluc2VydCBpbnRvIHRlc3Rf cGFydF8xMDAwMDAwIHNlbGVjdCAocmFuZG9tKCkqOTk5OTk5KTo6aW50ZWdlciBmcm9tCmdlbmVy YXRlX3NlcmllcygxLCAxMDAwMDAwMCk7DQpjcmVhdGUgaW5kZXggdGVzdF9pZF9rZXkgb24gb25s eSB0ZXN0KGlkKTsNCg0KLS1zbyBmYXIgb2sgaW5kZXggaW52YWxpZA0KXGQrIHRlc3QNCiAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIFBhcnRpdGlvbmVkIHRhYmxlICJwdWJsaWMu dGVzdCINCiBDb2x1bW4gfCAgVHlwZSAgIHwgQ29sbGF0aW9uIHwgTnVsbGFibGUgfCBEZWZhdWx0 IHwgU3RvcmFnZSB8IENvbXByZXNzaW9uIHwKU3RhdHMgdGFyZ2V0IHwgRGVzY3JpcHRpb24gDQot LS0tLS0tLSstLS0tLS0tLS0rLS0tLS0tLS0tLS0rLS0tLS0tLS0tLSstLS0tLS0tLS0rLS0tLS0t LS0tKy0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLQ0KIGlkICAgICB8 IGludGVnZXIgfCAgICAgICAgICAgfCAgICAgICAgICB8ICAgICAgICAgfCBwbGFpbiAgIHwgICAg ICAgICAgICAgfAogICAgICAgICAgICAgfCANClBhcnRpdGlvbiBrZXk6IFJBTkdFIChpZCkNCklu ZGV4ZXM6DQogICAgInRlc3RfaWRfa2V5IiBidHJlZSAoaWQpIElOVkFMSUQNClBhcnRpdGlvbnM6 IHRlc3RfcGFydF8xMDAwMDAwIEZPUiBWQUxVRVMgRlJPTSAoMCkgVE8gKDEwMDAwMDApDQoNCi0t bWFrZSBhbiBpbnZhbGlkIGluZGV4IG9uIHBhcnRpdGlvbW4NCmNyZWF0ZSBpbmRleCBDT05DVVJS RU5UTFkgdGVzdF9wYXJ0XzEwMDAwMDBfaWRfa2V5IG9uCnRlc3RfcGFydF8xMDAwMDAwKGlkKTsN Cl5DQ2FuY2VsIHJlcXVlc3Qgc2VudA0KRVJST1I6ICBjYW5jZWxpbmcgc3RhdGVtZW50IGR1ZSB0 byB1c2VyIHJlcXVlc3QNCg0KLS1hdHRhY2ggYW4gaW52YWxpZCBpbmRleCA/Pz8gb2svbm90IG9r PyBpcyBpdCBzaG91bGQgYmUgYWxsb3dlZCBhdCBhbGw/DQphbHRlciBpbmRleCB0ZXN0X2lkX2tl eSBhdHRhY2ggcGFydGl0aW9uIHRlc3RfcGFydF8xMDAwMDAwX2lkX2tleTsNCg0KLS10ZXN0X2lk X2tleSBpbnZhbGlkIChleHBlY3RlZCkNCnBvc3RncmVzPSMgXGQrIHRlc3QNCiAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgIFBhcnRpdGlvbmVkIHRhYmxlICJwdWJsaWMudGVzdCIN CiBDb2x1bW4gfCAgVHlwZSAgIHwgQ29sbGF0aW9uIHwgTnVsbGFibGUgfCBEZWZhdWx0IHwgU3Rv cmFnZSB8IENvbXByZXNzaW9uIHwKU3RhdHMgdGFyZ2V0IHwgRGVzY3JpcHRpb24gDQotLS0tLS0t LSstLS0tLS0tLS0rLS0tLS0tLS0tLS0rLS0tLS0tLS0tLSstLS0tLS0tLS0rLS0tLS0tLS0tKy0t LS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLQ0KIGlkICAgICB8IGludGVn ZXIgfCAgICAgICAgICAgfCAgICAgICAgICB8ICAgICAgICAgfCBwbGFpbiAgIHwgICAgICAgICAg ICAgfAogICAgICAgICAgICAgfCANClBhcnRpdGlvbiBrZXk6IFJBTkdFIChpZCkNCkluZGV4ZXM6 DQogICAgInRlc3RfaWRfa2V5IiBidHJlZSAoaWQpIElOVkFMSUQNClBhcnRpdGlvbnM6IHRlc3Rf cGFydF8xMDAwMDAwIEZPUiBWQUxVRVMgRlJPTSAoMCkgVE8gKDEwMDAwMDApDQoNCi0tdHJ5IHRv IGZpeA0KcmVpbmRleCBpbmRleCBDT05DVVJSRU5UTFkgdGVzdF9pZF9rZXk7DQoNCi0tbm8gZWZm ZWN0IHN0aWxsIGludmFsaWQNCnBvc3RncmVzPSMgXGQrIHRlc3QNCiAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgIFBhcnRpdGlvbmVkIHRhYmxlICJwdWJsaWMudGVzdCINCiBDb2x1 bW4gfCAgVHlwZSAgIHwgQ29sbGF0aW9uIHwgTnVsbGFibGUgfCBEZWZhdWx0IHwgU3RvcmFnZSB8 IENvbXByZXNzaW9uIHwKU3RhdHMgdGFyZ2V0IHwgRGVzY3JpcHRpb24gDQotLS0tLS0tLSstLS0t LS0tLS0rLS0tLS0tLS0tLS0rLS0tLS0tLS0tLSstLS0tLS0tLS0rLS0tLS0tLS0tKy0tLS0tLS0t LS0tLS0rLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLQ0KIGlkICAgICB8IGludGVnZXIgfCAg ICAgICAgICAgfCAgICAgICAgICB8ICAgICAgICAgfCBwbGFpbiAgIHwgICAgICAgICAgICAgfAog ICAgICAgICAgICAgfCANClBhcnRpdGlvbiBrZXk6IFJBTkdFIChpZCkNCkluZGV4ZXM6DQogICAg InRlc3RfaWRfa2V5IiBidHJlZSAoaWQpIElOVkFMSUQNClBhcnRpdGlvbnM6IHRlc3RfcGFydF8x MDAwMDAwIEZPUiBWQUxVRVMgRlJPTSAoMCkgVE8gKDEwMDAwMDApDQoNCi0tdHJ5IHRvIGZpeCBl dmVuIG1vcmUgc2VyaW91c2x5DQpyZWluZGV4IGluZGV4IHRlc3RfaWRfa2V5Ow0KDQotLXN0aWxs IGludmFsaWQNCnBvc3RncmVzPSMgXGQrIHRlc3QNCiAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgIFBhcnRpdGlvbmVkIHRhYmxlICJwdWJsaWMudGVzdCINCiBDb2x1bW4gfCAgVHlw ZSAgIHwgQ29sbGF0aW9uIHwgTnVsbGFibGUgfCBEZWZhdWx0IHwgU3RvcmFnZSB8IENvbXByZXNz aW9uIHwKU3RhdHMgdGFyZ2V0IHwgRGVzY3JpcHRpb24gDQotLS0tLS0tLSstLS0tLS0tLS0rLS0t LS0tLS0tLS0rLS0tLS0tLS0tLSstLS0tLS0tLS0rLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0rLS0t LS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLQ0KIGlkICAgICB8IGludGVnZXIgfCAgICAgICAgICAg fCAgICAgICAgICB8ICAgICAgICAgfCBwbGFpbiAgIHwgICAgICAgICAgICAgfAogICAgICAgICAg ICAgfCANClBhcnRpdGlvbiBrZXk6IFJBTkdFIChpZCkNCkluZGV4ZXM6DQogICAgInRlc3RfaWRf a2V5IiBidHJlZSAoaWQpIElOVkFMSUQNClBhcnRpdGlvbnM6IHRlc3RfcGFydF8xMDAwMDAwIEZP UiBWQUxVRVMgRlJPTSAoMCkgVE8gKDEwMDAwMDApDQoNCi0tdHJ5IG90aGVyIHdheSBhcm91bmQN CnJlaW5kZXggaW5kZXggdGVzdF9wYXJ0XzEwMDAwMDBfaWRfa2V5Ow0KLS1hbmQgYWdhaW4gaW52 YWxpZCBvbiBoZWFkDQpwb3N0Z3Jlcz0jIFxkKyB0ZXN0DQogICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICBQYXJ0aXRpb25lZCB0YWJsZSAicHVibGljLnRlc3QiDQogQ29sdW1uIHwg IFR5cGUgICB8IENvbGxhdGlvbiB8IE51bGxhYmxlIHwgRGVmYXVsdCB8IFN0b3JhZ2UgfCBDb21w cmVzc2lvbiB8ClN0YXRzIHRhcmdldCB8IERlc2NyaXB0aW9uIA0KLS0tLS0tLS0rLS0tLS0tLS0t Ky0tLS0tLS0tLS0tKy0tLS0tLS0tLS0rLS0tLS0tLS0tKy0tLS0tLS0tLSstLS0tLS0tLS0tLS0t Ky0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0NCiBpZCAgICAgfCBpbnRlZ2VyIHwgICAgICAg ICAgIHwgICAgICAgICAgfCAgICAgICAgIHwgcGxhaW4gICB8ICAgICAgICAgICAgIHwKICAgICAg ICAgICAgIHwgDQpQYXJ0aXRpb24ga2V5OiBSQU5HRSAoaWQpDQpJbmRleGVzOg0KICAgICJ0ZXN0 X2lkX2tleSIgYnRyZWUgKGlkKSBJTlZBTElEDQoNClBTOiBXaGF0IGhhcHBlbiBpbiBwcmFjdGlj ZSAtIGF0dGFjaGluZyBpbnZhbGlkIGluZGV4IHRvIGhlYWQgb2YgaHVnZSAobWFueQpUQikgcGFy dGl0aW9uZWQgdGFibGUuDQoNClJlZ2FyZHMsDQpNYXhpbQoK --===============5512841502473441921==--