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 1mebrN-0001rt-NK for pgsql-bugs@arkaria.postgresql.org; Sun, 24 Oct 2021 11:40:17 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mebrM-0003xT-Fl for pgsql-bugs@arkaria.postgresql.org; Sun, 24 Oct 2021 11:40:16 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1meboO-0002q7-1H for pgsql-bugs@lists.postgresql.org; Sun, 24 Oct 2021 11:37:12 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1meboG-0004zA-Tn for pgsql-bugs@lists.postgresql.org; Sun, 24 Oct 2021 11:37:10 +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=vVgBCMcT0CaKXQxBoVoyyJ1WmqR4um6B/PMOQTtgrFQ=; b=m8HCg3hkg4Dc+jph18PbxZoocy KElp4NobmeGoeGy2uFt3afMze3Yk3oTM1xCUAL2ZWelb0mnFAHfY7FlywpmWkGCXS8xBevQzmOPNn ordpeASYpWzu+32oOinKkOAtcQPIZohF3opYvDgu2Y3omyBC1offOiZZjwjSQjEje6NqQZDpdcNsX 9XTGyNtnJP9yUPA6cOSPyvhbeo7Tx7wgKVMN1jBXamcHgKrrr2XVKo7hgBGpHv9mu4+Zae+38+NQJ lJBENiIWEBleCywmf4afIlE/xmjc029wonNSqwAkln+CSRhZrtE7+HiaOBn+bcHgnDABU9OFVfXrz LWg6YE4Q==; 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 1meboF-00059C-Pb for pgsql-bugs@lists.postgresql.org; Sun, 24 Oct 2021 11:37:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1meboE-00018E-51 for pgsql-bugs@lists.postgresql.org; Sun, 24 Oct 2021 11:37:02 +0000 Content-Type: multipart/mixed; boundary="===============5299276104005040504==" MIME-Version: 1.0 Subject: BUG #17245: Index corruption involving deduplicated entries To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: andrew@tao11.riddles.org.uk Reply-To: andrew@tao11.riddles.org.uk, pgsql-bugs@lists.postgresql.org Date: Sun, 24 Oct 2021 11:36:58 +0000 Message-ID: <17245-ddf06aaf85735f36@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 --===============5299276104005040504== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzI0NQpMb2dnZWQgYnk6ICAgICAgICAgIEFuZHJldyBHaWVydGgKRW1h aWwgYWRkcmVzczogICAgICBhbmRyZXdAdGFvMTEucmlkZGxlcy5vcmcudWsKUG9zdGdyZVNRTCB2 ZXJzaW9uOiAxNC4wCk9wZXJhdGluZyBzeXN0ZW06ICAgRnJlZUJTRCAxMy4wLVJFTEVBU0UKRGVz Y3JpcHRpb246ICAgICAgICAKCkZyb20gYSByZXBvcnQgZnJvbSBJUkMsIGZyb20gYSB1c2VyIHJ1 bm5pbmcgYSBtZWRpYXdpa2kgaW5zdGFuY2Ugb24gUEc6DQoNCnNlbGVjdCBjdGlkLCBwYWdlX3Rp dGxlIGZyb20gInBhZ2UiIFdIRVJFIHBhZ2VfdGl0bGUgPSAnSXNva2F6ZScgYW5kCnBhZ2VfbmFt ZXNwYWNlID0gMDsNCg0KcmV0dXJuZWQgdHdvIHJvd3MgcmF0aGVyIHRoYW4gdGhlIGV4cGVjdGVk IDE6DQoNCiAgKDE4MSw1MykgfCBZaW5nX1N3ZWkNCiAgKDcyMiwzKSAgfCBJc29rYXplDQoNCkRp c2FibGluZyBpbmRleCBzY2FucyByZXN0b3JlZCB0aGUgZXhwZWN0ZWQgb3V0cHV0IG9mIDEgcm93 Lg0KDQpJbnNwZWN0aW5nIHRoZSBpbmRleCByZXZlYWxlZCB0aGlzOg0KDQowMDAxMTRhMDogMmY0 NyA2MTZjIDZjNjUgNzI3OSAwMDAwIDEwMDAgMDMyMCAyODYwICAvR2FsbGVyeS4uLi4uIChgDQow MDAxMTRiMDogMTE0OSA3MzZmIDZiNjEgN2E2NSAwMDAwIDc2MDAgMTgwMCAwMDAwICAuSXNva2F6 ZS4udi4uLi4uDQowMDAxMTRjMDogYjUwMCAwOTAwIDAwMDAgZDIwMiAzODAwIDAwMDAgMDAwMCAw MDAwICAuLi4uLi4uLjguLi4uLi4uDQowMDAxMTRkMDogMDAwMCBjNTAxIDJkMDAgMTg0MCAxNzQ5 IDczNjUgMmY1MSA3NTZmICAuLi4uLS4uQC5Jc2UvUXVvDQoNCndoaWNoIGFwcGVhcnMgdG8gbWUg dG8gYmUgYSBkZWR1cGxpY2F0ZWQgaW5kZXggZW50cnkgcG9pbnRpbmcgdG8gaGVhcCByb3dzCigx ODEsOSkgYW5kICg3MjIsNTYpLiBJbnNwZWN0aW5nIHRoZSBoZWFwIHNob3dlZCB0aGF0IGJvdGgg b2YgdGhvc2UgY3RpZHMKYXJlIGp1c3QgcG9pbnRlciBlbnRyaWVzLCB0byAoMTgxLDUzKSBhbmQg KDcyMiwzKSByZXNwZWN0aXZlbHksIHdoaWNoCmV4cGxhaW5zIHRoZSAyIHJvdyByZXN1bHQuIFdo YXQgSSBkb24ndCBrbm93IGlzIGhvdyB0aGlzIGNvdWxkIGhhdmUgaGFwcGVuZWQKaW4gdGhlIGZp cnN0IHBsYWNlLg0KDQpUaGUgZGVmaW5pdGlvbiBvZiB0aGUgYWZmZWN0ZWQgaW5kZXggaXM6DQoN CkNSRUFURSBJTkRFWCBwYWdlX21haW5fdGl0bGUgT04gbWVkaWF3aWtpLnBhZ2UgVVNJTkcgYnRy ZWUgKHBhZ2VfdGl0bGUKdGV4dF9wYXR0ZXJuX29wcykgV0hFUkUgKHBhZ2VfbmFtZXNwYWNlID0g MCk7DQoNClRoZSByZWFsIGVudHJpZXMgZm9yICdZaW5nX1N3ZWknIGluIHRoZSBpbmRleCBhcmUg bm90IGluIHRoZSBzYW1lIHBhZ2Ugb3IKZXZlbiBhbnkgbmVhcmJ5IHBhZ2UsIGFuZCBpdCBzZWVt cyB1bmxpa2VseSB0aGF0IHRoZSBwYWdlX3RpdGxlIHdhcwp1cGRhdGVkLg0KDQpUaGUgb3JpZ2lu YWwgcmVwb3J0ZXIgKHdobyBJIHdpbGwgQ0Mgb24gYSBmb2xsb3d1cCBtZXNzYWdlKSBzdGlsbCBo YXMgYQpzbmFwc2hvdCBvZiB0aGUgY29ycnVwdCBkYXRhLiAoQSBSRUlOREVYIG5hdHVyYWxseSBm aXhlZCB0aGUgZGF0YSkuCgo= --===============5299276104005040504==--