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 1k6gqy-0006Df-Mt for pgsql-bugs@arkaria.postgresql.org; Fri, 14 Aug 2020 21:03:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1k6gqx-0001DR-JV for pgsql-bugs@arkaria.postgresql.org; Fri, 14 Aug 2020 21:03:07 +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 1k6gfK-0000au-Qw for pgsql-bugs@lists.postgresql.org; Fri, 14 Aug 2020 20:51:06 +0000 Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1k6gfH-0006Z3-Of for pgsql-bugs@lists.postgresql.org; Fri, 14 Aug 2020 20:51:06 +0000 Content-Type: multipart/mixed; boundary="===============0260600168844633039==" MIME-Version: 1.0 Subject: BUG #16582: Logical index corruption leading to apparent index scan infinite loop To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: jlucasdba@gmail.com Reply-To: jlucasdba@gmail.com, pgsql-bugs@lists.postgresql.org Date: Fri, 14 Aug 2020 20:50:49 +0000 Message-ID: <16582-4945b19d95e41c46@postgresql.org> X-Auto-Response-Suppress: All List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============0260600168844633039== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjU4MgpMb2dnZWQgYnk6ICAgICAgICAgIEphbWVzIEx1Y2FzCkVtYWls IGFkZHJlc3M6ICAgICAgamx1Y2FzZGJhQGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246IDEx LjUKT3BlcmF0aW5nIHN5c3RlbTogICBDZW50b3MgNwpEZXNjcmlwdGlvbjogICAgICAgIAoKSSBo YXZlIGFuIDExLjUgZGF0YWJhc2Ugd2l0aCBhIGRlY2xhcmF0aXZlbHkgcGFydGl0aW9uZWQgdGFi bGUuICBUaGUgdGFibGUKaGFzIGFyb3VuZCA0MCBwYXJ0aXRpb25zLiAgV2UgYmVnYW4gb2JzZXJ2 aW5nIGEgbnVtYmVyIG9mIGxvbmcgcnVubmluZwpzZXNzaW9ucyAob3ZlciBhIHdlZWspLCBhbGwg ZXhlY3V0aW5nIHRoZSBzYW1lIHNlbGVjdCBxdWVyeSBhZ2FpbnN0IHRoaXMKdGFibGUuIEF0dGVt cHRpbmcgdG8ga2lsbCB0aGUgc2Vzc2lvbnMgd2l0aCBwZ190ZXJtaW5hdGVfYmFja2VuZCBoYXMg bm8KZWZmZWN0Lg0KDQpJIHB1bGxlZCBzZXZlcmFsIHN0YWNrIHRyYWNlcyBhZ2FpbnN0IHRoZSBi YWNrZW5kIHByb2Nlc3NlcyBleGVjdXRpbmcgdGhpcwpxdWVyeSBhbmQgdHJhY2VkIHRoZSBpc3N1 ZSBiYWNrIHRvIHRoZSBfYnRfbW92ZXJpZ2h0IGZ1bmN0aW9uIGluCnNyYy9iYWNrZW5kL2FjY2Vz cy9uYnRyZWUvbmJ0c2VhcmNoLmMuICBUaGlzIGZ1bmN0aW9uIGFwcGVhcnMgdG8gYmUKaW1wbGVt ZW50ZWQgYXMgYW4gaW5maW5pdGUgbG9vcCwgd2hpY2ggYnJlYWtzIHdoZW4gaXQgZmluZHMgYSBw YWdlIHRoYXQKbWF0Y2hlcyB3aGF0IGl0J3MgbG9va2luZyBmb3IuICBTbyBteSB3b3JraW5nIHRo ZW9yeSBpcyB0aGF0IEkgaGF2ZSBhCmNvcnJ1cHQgaW5kZXggd2hlcmUgdGhhdCBjb25kaXRpb24g aXMgbmV2ZXIgcHJvcGVybHkgc2F0aXNmaWVkLCByZXN1bHRpbmcgaW4KYW4gZW5kbGVzcyBsb29w Lg0KDQpJIGZvdW5kIGEgdGhyZWFkIGluIHRoZSBtYWlsaW5nIGxpc3QgYXJjaGl2ZSBhYm91dCBh IHNpbWlsYXIgaXNzdWUgaW4gb25lIG9mCnRoZSBvdGhlciBmdW5jdGlvbnMgaW4gdGhpcyBmaWxl CihodHRwczovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9tZXNzYWdlLWlkL2ZsYXQvQ0FNM1NXWlQ3ZENl cyUzRHVPQTNOQUhZQkExa3RoJTNEYjRwWGtzek5MTVBWdE5BQVlVcF93ZyU0MG1haWwuZ21haWwu Y29tI2U5YmYxNjNkYThmNTBmMGYyODQ1YjU5MjUwZGE2YWI1KS4KIFRoZSBfYnRfbW92ZXJpZ2h0 IGZ1bmN0aW9uIGRvZXMgbm90IGhhdmUgQ0hFQ0tfRk9SX0lOVEVSUlVQVFMgaW4gaXRzIGxvb3As CndoaWNoIHdvdWxkIGV4cGxhaW4gd2h5IHRoZSBzZXNzaW9ucyBkb24ndCByZXNwb25kIHRvCnBn X3Rlcm1pbmF0ZV9iYWNrZW5kLg0KDQpUaGUgdGFibGUgaGFzIHR3byBpbmRleGVzLCBzbyBJIGRl Y2lkZWQgdG8gc2NhbiBib3RoIGluZGV4ZXMgb24gYWxsCnBhcnRpdGlvbnMgd2l0aCB0aGUgYnRf aW5kZXhfY2hlY2sgZnVuY3Rpb24gZnJvbSB0aGUgYW1jaGVjayBleHRlbnNpb24uICBJCmlkZW50 aWZpZWQgb25lIHBhcnRpdGlvbiB3aGVyZSBib3RoIGluZGV4ZXMgdGhyb3cgdGhlIGZvbGxvd2lu ZyByZXN1bHQ6DQpFUlJPUjogY3Jvc3MgcGFnZSBpdGVtIG9yZGVyIGludmFyaWFudCB2aW9sYXRl ZCBmb3IgaW5kZXggInh4eHh4Ig0KREVUQUlMOiBMYXN0IGl0ZW0gb24gcGFnZSB0aWQoeHgseHgp IHBhZ2UgbHNuPXh4eHh4eHh4eHgNCg0KU2luY2UgYm90aCBpbmRleGVzIGFwcGVhciB0byBoYXZl IHRoZSBzYW1lIGlzc3VlLCBpdCBzdWdnZXN0cyB0byBtZQpzb21ldGhpbmcgYWJvdXQgdGhpcyB0 YWJsZS9kYXRhIG1heSBiZSB0cmlnZ2VyaW5nIGEgYnVnLiAgSSBoYXZlIG5vdCB5ZXQKdHJpZWQg cmVpbmRleGluZy4gIEkgZGlkIHBnX2R1bXAvcGdfcmVzdG9yZSB0aGUgZW50aXJlIHRhYmxlIChh bGwKcGFydGl0aW9ucykgdG8gYW5vdGhlciBzeXN0ZW0gKGFsc28gMTEuNSksIGFuZCB0aGUgaW5k ZXhlcyBidWlsdCB0aGVyZSB0ZXN0Cm9rYXkuDQoNCk90aGVyIHBvc3NpYmx5IHJlbGV2YW50IGlu Zm9ybWF0aW9uOiAgVGhlIHRhYmxlIGlzIHJhbmdlIHBhcnRpdGlvbmVkIG9uIGFuCmluc2VydCB0 aW1lc3RhbXAgKHRpbWVzdGFtcCgwKSB3aXRob3V0IHRpbWV6b25lKS4gIFRoZSB0d28gaW5kZXhl cyBpbnZvbHZlZAphcmUgYm90aCBjb21wb3NpdGUgaW5kZXhlcywgb3ZlciBjb2x1bW5zIG9mIHR5 cGVzIChudW1lcmljLCBudW1lcmljLApudW1lcmljKSBhbmQgKG51bWVyaWMsIHRpbWVzdGFtcCg2 KSB3aXRob3V0IHRpbWUgem9uZSkuICBUaGUgcGFydGl0aW9uIGtleQppcyBub3QgY292ZXJlZCBi eSBlaXRoZXIgaW5kZXguICBUaGVyZSBpcyBhbHNvIG5vIHByaW1hcnkga2V5Lg0KDQpJIHJlYWxp emUgaXQgbWF5IG5vdCBiZSBwb3NzaWJsZSB0byByZW1vdGUgZGlhZ25vc2UgdGhlIHJvb3QgY2F1 c2Ugb2YgdGhlCmluZGV4IGlzc3VlcywgYnV0IGZpZ3VyZWQgaXQgd2FzIHdvcnRoIHJlcG9ydGlu Zy4gIE15IG5leHQgc3RlcHMgd291bGQKcHJvYmFibHkgYmUgdG8gdHJ5IHJlaW5kZXhpbmcgdGhl IGFmZmVjdGVkIHBhcnRpdGlvbi4gIElmIHRoYXQgZG9lc24ndCB3b3JrLAppdCBzZWVtcyBsaWtl IGVpdGhlciBhIHZhY3V1bSBmdWxsIG9yIHBnX2R1bXAvcGdfcmVzdG9yZSB3b3VsZCBiZSB0aGUg bmV4dApzdGVwLiAgQW55IG90aGVyIHN1Z2dlc3Rpb25zIGFwcHJlY2lhdGVkLg0KDQpUaGFua3Ms DQpKYW1lcwoK --===============0260600168844633039==--