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 1ktb0J-0006wc-KL for pgsql-bugs@arkaria.postgresql.org; Sun, 27 Dec 2020 18:42:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ktb0G-0000PK-R9 for pgsql-bugs@arkaria.postgresql.org; Sun, 27 Dec 2020 18:42:52 +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 1ktZhH-00053E-29 for pgsql-bugs@lists.postgresql.org; Sun, 27 Dec 2020 17:19:11 +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 1ktZhA-00088h-Qg for pgsql-bugs@lists.postgresql.org; Sun, 27 Dec 2020 17:19: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=LNb6TSMrybtZyyUIMC1J8VID7pSDqgidFL0hQl1mLps=; b=shQ6Al2o4I/GVaMOlYyhl4EqE2 ZYsPQTNV+PVWZ1fMzQDLZPy+L56wdH9YllfXaDIhjFo4VVgeheaKnxlLke1tAG0QDqZ8lpMt0XX/U qFNThFKYb7hr+BUHwYaf7ekWJ39jx8o916vIVPZE7ks8hIFuB6+2Q/iF/5iwPrsSvKK932AtQvNYz XMTMq57CefAMwz4pMNli4nhf0FeMzLMzeL+iMSTLbo6eTiQ+9vzqfd0zqLV60uZsx4WI6mOD6xb14 6buSmDnBO62wkIaOsM/VpAlc5gaPls8Jv+SXNt55QJeCu+s/vOBYuz98l7IOf2BJuhNijXJFGV7FQ XufxWvuA==; 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 1ktZh9-0000fE-Eo for pgsql-bugs@lists.postgresql.org; Sun, 27 Dec 2020 17:19:03 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ktZh8-0006CK-7u for pgsql-bugs@lists.postgresql.org; Sun, 27 Dec 2020 17:19:02 +0000 Content-Type: multipart/mixed; boundary="===============1474081416947059759==" MIME-Version: 1.0 Subject: BUG #16792: silent corruption of GIN index resulting in SELECTs returning non-matching rows To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: kudzia@gmail.com Reply-To: kudzia@gmail.com, pgsql-bugs@lists.postgresql.org Date: Sun, 27 Dec 2020 17:18:36 +0000 Message-ID: <16792-b1913b6b4e098331@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============1474081416947059759== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjc5MgpMb2dnZWQgYnk6ICAgICAgICAgIHBhd2VsIGt1ZHppYQpFbWFp bCBhZGRyZXNzOiAgICAgIGt1ZHppYUBnbWFpbC5jb20KUG9zdGdyZVNRTCB2ZXJzaW9uOiAxMS4x MApPcGVyYXRpbmcgc3lzdGVtOiAgIERlYmlhbiBCdXN0ZXIgeDg2XzY0CkRlc2NyaXB0aW9uOiAg ICAgICAgCgpJJ2QgbGlrZSB0byBhc2sgZm9yIGFkdmljZSBob3cgdG8gcHJvY2VlZCB3aXRoIHBp bi1wb2ludGluZyBjYXVzZSBvZiB0aGUKc2lsZW50IGNvcnJ1cHRpb24gb2YgR0lOIGluZGV4IHRo YXQgSSdtIGZhY2luZy4gDQoNClJlbGV2YW50IHBhcnQgb2YgdGhlIHRhYmxlIHN0cnVjdHVyZToN Cg0KQ1JFQVRFIFRBQkxFIHB1YmxpYy5lbnRpdHkgKA0KICAgIGVudGl0eV9pZCBiaWdpbnQgTk9U IE5VTEwsDQogICAgYXR0cmlidXRlX3ZhbHVlX2lkcyBpbnRlZ2VyW10gTk9UIE5VTEwsDQogICAg YXR0cmlidXRlX25hbWVfaWRzIGludGVnZXJbXSBOT1QgTlVMTCwNClsuLl0NCik7DQoNCkFMVEVS IFRBQkxFIE9OTFkgcHVibGljLmVudGl0eSBBREQgQ09OU1RSQUlOVCBlbnRpdHlfcGtleSBQUklN QVJZIEtFWQooZW50aXR5X2lkKTsNCkNSRUFURSBJTkRFWCBlbnRpdHlfYXR0cmlidXRlX25hbWVf aWRzX2dpbiBPTiBwdWJsaWMuZW50aXR5IFVTSU5HIGdpbgooYXR0cmlidXRlX25hbWVfaWRzIHB1 YmxpYy5naW5fX2ludF9vcHMpOw0KQ1JFQVRFIElOREVYIGVudGl0eV9hdHRyaWJ1dGVfdmFsdWVf aWRzX2dpbiBPTiBwdWJsaWMuZW50aXR5IFVTSU5HIGdpbgooYXR0cmlidXRlX3ZhbHVlX2lkcyBw dWJsaWMuZ2luX19pbnRfb3BzKTsNCg0KSG93IGRvZXMgdGhlIGlzc3VlIG1hbmlmZXN0Pw0KDQpR dWVyaWVzIHdoaWNoIHVzZSBHSU4gb24gaW50ZWdlcltdIGNvbHVtbiBvY2Nhc2lvbmFsbHkgcmV0 dXJuIHRvbyBtYW55IHJvd3MsCmluY2x1ZGluZyBvbmVzIHRoYXQgYWN0dWFsbHkgZG8gbm90IG1h dGNoIGNyaXRlcmlhIGV4cHJlc3NlZCBpbiBXSEVSRS4KUXVlcmllcyBsaWtlIGJlbG93IHNob3Vs ZCBuZXZlciByZXR1cm4gYW55IHJvd3MsIHlldCAtIG9jY2FzaW9uYWxseSB0aGV5IGRvCnJldHVy biBzb21lIHJlc3VsdHM6DQoNCmRhdGE9PiBTRUxFQ1QgZW50aXR5X2lkIEZST00gZW50aXR5IFdI RVJFICggYXR0cmlidXRlX25hbWVfaWRzICYmICd7NDk4MH0nICkKQU5EIE5PVCAoIChhdHRyaWJ1 dGVfbmFtZV9pZHN8fDApICYmICd7NDk4MH0nKSA7DQogZW50aXR5X2lkDQotLS0tLS0tLS0tLQ0K ICAzMTIxMzkyNA0KICAzMTE5NTExNw0KICAzMTIwOTE4NA0KKDMgcm93cykNCg0KUXVlcnkgcGxh bjoNCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBRVUVSWSBQTEFO DQotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQogQml0bWFwIEhlYXAg U2NhbiBvbiBlbnRpdHkgIChjb3N0PTUwLjM5Li4zMDY4LjExIHJvd3M9MjY5MjMgd2lkdGg9MjIp DQogICBSZWNoZWNrIENvbmQ6IChhdHRyaWJ1dGVfbmFtZV9pZHMgJiYgJ3s0OTgwfSc6OmludGVn ZXJbXSkNCiAgIEZpbHRlcjogKE5PVCAoKGF0dHJpYnV0ZV9uYW1lX2lkcyB8fCAwKSAmJiAnezQ5 ODB9Jzo6aW50ZWdlcltdKSkNCiAgIC0+ICBCaXRtYXAgSW5kZXggU2NhbiBvbiBlbnRpdHlfYXR0 cmlidXRlX25hbWVfaWRzX2dpbiAgKGNvc3Q9MC4wMC4uNTAuMzkKcm93cz0yNzA1OCB3aWR0aD0w KQ0KICAgICAgICAgSW5kZXggQ29uZDogKGF0dHJpYnV0ZV9uYW1lX2lkcyAmJiAnezQ5ODB9Jzo6 aW50ZWdlcltdKQ0KKDUgcm93cykNCg0KVGhlIHF1ZXJ5IHdhcyBjcmFmdGVkIGludGVudGlvbmFs bHkgdG8gbGV0IFBvc3RncmVTUUwgdXNlIEdJTiBpbmRleAplbnRpdHlfYXR0cmlidXRlX25hbWVf aWRzX2dpbiBbIGxlZnQgc2lkZSBvZiBBTkQgXSBhbmQgdGhlbiBmaWx0ZXIgb3V0IHJvd3MKdGhh dCBhZnRlciBpbnNwZWN0aW9uIG9mIHRoZWlyIHZhbHVlcyBkbyBub3QgYWN0dWFsbHkgbWF0Y2gg dGhhdCBjcml0ZXJpYS4NCg0KV2hhdCBoYXZlIEkgZG9uZSBzbyBmYXI/DQoNCk9yaWdpbmFsbHkg dGhlIHByb2JsZW0gd2FzIGRpc2NvdmVyZWQgd2hlbiBydW5uaW5nIFBvc3RncmVTUUwgMTEuNyBm cm9tCkRlYmlhbidzIHJlcG8uIEluIHRoZSBmaXJzdCBzdGVwIHdlJ3ZlIHVwZ3JhZGVkIHRvIFBv c3RncmVTUUwgMTEuOSBhbHNvIGZyb20KRGViaWFuJ3MgcmVwbyBhbmQgcnVuOg0KDQpyZWluZGV4 ICh2ZXJib3NlKSB0YWJsZSBlbnRpdHk7IHZhY3V1bSAodmVyYm9zZSwgZnVsbCwgYW5hbHl6ZSkg ZW50aXR5Ow0KDQpBZnRlciBmZXcgZGF5cyBvZiB1cGRhdGVzIHRoZSBwcm9ibGVtIHJldHVybmVk Lg0KDQpXZSd2ZSB1cGdyYWRlZCB0byBQb3N0Z3JlU1FMIDExLjEwIGZyb20gcG9zdGdyZXNxbC5v cmcgcmVwb3NpdG9yeSBmb3IgRGViaWFuCmFuZCByZWluZGV4ZWQgLyB2YWN1dW1lZCBhZ2Fpbi4g QWZ0ZXIgZmV3IHdlZWtzIG9mIHVwZGF0ZXMgcHJvYmxlbSByZXR1cm5lZAphZ2Fpbi4NCg0KT3Ro ZXIgaW5mb3JtYXRpb24gd29ydGggbm90aW5nOg0KKiB0YWJsZSBpbiBxdWVzdGlvbiBoYXMgMzhN IHJvd3MgYW5kIGlzIHRoZSBvbmx5IHRhYmxlIGNyZWF0ZWQgYWZ0ZXIKUG9zdGdyZVNRTCBpbnN0 YWxsYXRpb24NCiogc2VydmVyIGluIHF1ZXN0aW9uIGlzIG1hc3RlciBvZiBzdHJlYW1pbmcgcmVw bGljYXRpb247IGlzc3VlIG9jY3VycyBhbHNvCm9uIHRoZSBzbGF2ZSBzZXJ2ZXJzIC0gdGhpcyBz dWdnZXN0cyBjb3JydXB0aW9uIG9mIHRoZSBvbi1kaXNrIEdJTiBpbmRleApkYXRhDQoqIGp1c3Qg cmV3cml0aW5nIHJvd3MgZmFsc2VseSByZXR1cm5lZCBieSBzZWxlY3QgYWJvdmUgLSBVUERBVEUg ZW50aXR5IFNFVAphdHRyaWJ1dGVfbmFtZV9pZHMgPSd7Li4uLn0nIFdIRVJFIGVudGl0eV9pZD0x MjMgLSBmaXhlcyB0aGUgaXNzdWUNCiogd2UndmUgc2V0IHVwIHJ1ZGltZW50YXJ5IGNvbnNpc3Rl bmN5IGNoZWNrcyB0aGF0IGFsbG93IHRvIGNhdGNoIHNvbWUgb2YKdGhlIGNvcnJ1cHRpb25zIHdp dGhpbiAxaCBvZiBvY2N1cnJpbmcgLSBzbyBmYXIgY29ycnVwdGlvbnMgb25seSBoYXBwZW4gdG8K cm93cyB0aGF0IGhhdmUgYmVlbiB1cGRhdGVkIHNpbmNlIHRoZSBwcmV2aW91cyBjaGVjaw0KKiBz ZXJ2ZXIgaW4gcXVlc3Rpb24gaGFuZGxlcyBoZWF2eSByZWFkL3dyaXRlIHRyYWZmaWMNCiogUG9z dGdyZVNRTCBpbiBxdWVzdGlvbiBydW5zIGluIExYQyBjb250YWluZXIgd2l0aCBEZWJpYW4gQnVz dGVyIHJ1bm5pbmcgb24KdG9wIG9mIERlYmlhbiBCdXN0ZXIgcnVubmluZyBvbiB0b3Agb2YgYmFy ZS1tZXRhbCBzZXJ2ZXINCiogaXQncyBoaWdobHkgdW5saWtlbHkgdGhhdCBoYXJkd2FyZSBtYWxm dW5jdGlvbiBpcyB0byBiZSBibGFtZWQgLSB0aGUgc2FtZQpwaHlzaWNhbCBzZXJ2ZXIgaGFuZGxl cyBhbHNvIGZldyBNeVNRTCBpbnN0YW5jZXMgd2l0aCBodW5kcmVkcyBvZiBHQiBvZiBkYXRhCndp dGggaGVhdnkgY29uc2lzdGVuY3kgY2hlY2tzIGNyb3NzIGNoZWNraW5nIGNvbnRlbnQgb2YgTXlT UUwgd2l0aApQb3N0Z3JlU1FMLCB1bnBhY2tpbmcgZ3ppcCdlZCBibG9icyBzdG9yZWQgaW4gTXlT UUwgZGF0YWJhc2VzIGFuZApkZS1zZXJpYWxpemluZyBvYmplY3RzIHN0b3JlZCB0aGVyZS4gaWYg dGhlcmUgd2FzIGEgYml0LXJvdCAvIGJpdC1mbGlwIGluCm1lbW9yeSB3b3VsZCB0aGF0J3Mgbm90 IGRldGVjdGVkIG9yIGZpeGVkIGJ5IEVDQyAtIGhpZ2ggbGV2ZWwgY29uc2lzdGVuY3kKY2hlY2tz IHdvdWxkIHBpY2sgaXQuDQoqIGRlc3BpdGUgbnVtZXJvdXMgYXR0ZW1wdHMgaSBjYW5ub3QgcmVw cm9kdWNlIHRoZSBpc3N1ZSBpbiB0ZXN0CmVudmlyb25tZW50LCBwb3NzaWJseSBkdWUgdG8gbXVj aCBsb3dlciBsZXZlbCBvZiB3cml0ZSB0cmFmZmljLiBpdCB0YWtlcwpkYXlzIHRvIHdlZWtzIHRv IGhhdmUgaXQgcmUtb2NjdXIgb24gdGhlIHByb2R1Y3Rpb24gc2VydmVyLg0KDQpUaGFuayB5b3Ug aW4gYWR2YW5jZSBmb3IgeW91ciBzdWdnZXN0aW9ucyBob3cgdG8gdGFja2xlIHRoaXMuDQoNCmJl c3QgcmVnYXJkcywNClBhd2VsCgo= --===============1474081416947059759==--