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 1no5ny-0000pI-EQ for pgsql-bugs@arkaria.postgresql.org; Mon, 09 May 2022 16:00:14 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1no5nx-0005Ln-B5 for pgsql-bugs@arkaria.postgresql.org; Mon, 09 May 2022 16:00:13 +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 1no5Js-0007S9-1M for pgsql-bugs@lists.postgresql.org; Mon, 09 May 2022 15:29:08 +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 1no5Jp-0005d7-TW for pgsql-bugs@lists.postgresql.org; Mon, 09 May 2022 15:29: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=6uo3ubkvXUgu3xiX10DwsZmsPlOiF5zZlIIfVdUFAHs=; b=MZbCUAJmTC/qndrGfMIMT4MaUX f7hefPDbVblekW2S+oRRfWnJW3+tSTROb1qW+KwTzZpuiLHHxS6OsIrpR4S+MuMvbMyxPYnYmDZMc 2HC1T0VodYPT9PJsyOm3KlBY0KsPNH8ny2TnuHLKwjLQdvd8JbehsjV5QvHrPICFiVcTpicUsIu0S 8omDrgEiV1v6TFV3ZAHw8/Rce5yUZSDai/rRgKcIbV2F+uawep3d09fvx8l1kH8NAxXuq+oxTnLkt OoBGwOx+rZtre8eUH7lFZn8OKfcVkY1Gps8vM9ryTb9RdXpr3iG6SmfJ+VWtwPAZ8mkdlRf3yfssw U/3KWB7w==; 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 1no5Jo-0000qL-JF for pgsql-bugs@lists.postgresql.org; Mon, 09 May 2022 15:29: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 1no5Jn-002xMP-J1 for pgsql-bugs@lists.postgresql.org; Mon, 09 May 2022 15:29:02 +0000 Content-Type: multipart/mixed; boundary="===============8627181758100971523==" MIME-Version: 1.0 Subject: BUG #17478: Missing documents in the index after CREATE INDEX CONCURRENTLY (but existing in the table) To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: spastrilov@gmail.com Reply-To: spastrilov@gmail.com, pgsql-bugs@lists.postgresql.org Date: Mon, 09 May 2022 15:28:12 +0000 Message-ID: <17478-c422e68d010b951d@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 --===============8627181758100971523== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzQ3OApMb2dnZWQgYnk6ICAgICAgICAgIFN0ZWZhbiBQYXN0cmlsb3YK RW1haWwgYWRkcmVzczogICAgICBzcGFzdHJpbG92QGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNp b246IDE0LjEKT3BlcmF0aW5nIHN5c3RlbTogICBVYnVudHUgMjAuMDQKRGVzY3JpcHRpb246ICAg ICAgICAKCkhlbGxvLA0KDQpXZeKAmXJlIG9ic2VydmluZyBhIHN0cmFuZ2UgYnVnLCBhY2NvcmRp bmcgdG8gbWUuIFdl4oCZdmUgZ290IG5hdGl2ZSBsb2dpY2FsCnJlcGxpY2F0aW9uIHdoZXJlIHRo ZSBtYXN0ZXIgaG9zdCBpcyBydW5uaW5nIG9uIFBvc3RncmVTUUwgMTMuMyBhbmQgdGhlCmxvZ2lj YWwgcmVwbGljYSBob3N0IGlzIHJ1bm5pbmcgb24gUG9zdGdyZVNRTCAxNC4xLiBBbmQgdGhlIHBy b2JsZW0gaXM6DQogIHdoZW4gd2Ugc3RhcnQgdG8gcmVpbmRleCBjb25jdXJyZW50bHkgdGhlIHBy aW1hcnkga2V5IG9mIGFuIDgwME0gaGVhdmlseQppbnNlcnRlZC91cGRhdGVkKG9uIHRoZSBtYXN0 ZXIpdGFibGUgb24gdGhlIGxvZ2ljYWwgcmVwbGljYSBkYXRhYmFzZSwKc2V2ZXJhbCBkb2N1bWVu dHMgdGhhdCBoYXZlIGJlZW4gaW5zZXJ0ZWQgYW5kIGV4aXN0aW5nIGluIHRoZSBtYXN0ZXIKZGF0 YWJhc2UgZHVyaW5nIHRoZSBpbmRleCByZWJ1aWxkIG9uIHRoZSByZXBsaWNhLCBhcmUgbWlzc2lu ZyBmcm9tIHRoZSBpbmRleApzdHJ1Y3R1cmUgb24gdGhlIHJlcGxpY2EgaG9zdC4gV2hhdCBkbyBJ IG1lYW4/IElmIHlvdSB0cnkgdG8gc2VhcmNoIHRoZW0gYnkKd2hlcmUgaWQgPSA1IHRoZSBpbmRl eCByZXR1cm5zIG5vIHJlY29yZHMsIGJ1dCB3aGVuIHlvdSBmb3JjZSBhIHNlcXVlbnRpYWwKc2Nh biAod2hlcmUgaWQgKyAwID0gNSl0aGUgcm93IGlzIHJldHVybmVkLiBVc3VhbGx5LCB3ZeKAmXJl IG1lc3NpbmcgYXJvdW5kCjEwLTEwMCBkb2N1bWVudHMgZnJvbSB0aGUgaW5kZXggYWZ0ZXIgZWFj aCBjb25jdXJyZW50IHJlLWluZGV4LiBXaGVuIHdlCnJlYnVpbGQgdGhlIGluZGV4IGFnYWluLCB0 aGV5IGFyZSBmb3VuZCBieSBhbiBpbmRleCBsb29rLXVwLCBidXQgYSBuZXcgc2V0Cm9mIGlkcyBh cmUgbWlzc2luZy4gU28gdGhlIHByb2JsZW0gaXMgZWFzaWx5IHJlcHJvZHVjaWJsZSwgYnV0IHlv dSBzaG91bGQKaGF2ZSBhIGhlYXZpbHkgbG9hZGVkIHRhYmxlLiBEbyB5b3UgaGF2ZSBhbnkgaWRl YXMgYWJvdXQgdGhpcz8gVGhlIG5ld2x5CmNyZWF0ZWQgaW5kZXggaXMgdmFsaWQgYW5kIGZ1bGx5 IGZ1bmN0aW9uYWwsIHdpdGggbm8gc2lnbnMgb2YgYSBjb3JydXB0ZWQKb25l4oCmDQoNClRvIGJl IGNsZWFyLCB0aGUgaW5kZXggcmVidWlsZCBpcyBkb25lIG9uIHRoZSBzdWJzY3JpYmVkIHRhYmxl KHNsYXZlCmhvc3QpLg0KDQptYXN0ZXIgaG9zdDoNClBvc3RncmVTUUwgMTMuMyAoVWJ1bnR1IDEz LjMtMS5wZ2RnMjAuMDQrMSkgb24geDg2XzY0LXBjLWxpbnV4LWdudSwgY29tcGlsZWQKYnkgZ2Nj IChVYnVudHUgOS4zLjAtMTd1YnVudHUxfjIwLjA0KSA5LjMuMCwgNjQtYml0DQpzbGF2ZSBob3N0 Og0KUG9zdGdyZVNRTCAxNC4xIChVYnVudHUgMTQuMS0yLnBnZGcyMC4wNCsxKSBvbiB4ODZfNjQt cGMtbGludXgtZ251LCBjb21waWxlZApieSBnY2MgKFVidW50dSA5LjMuMC0xN3VidW50dTF+MjAu MDQpIDkuMy4wLCA2NC1iaXQKCg== --===============8627181758100971523==--