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 1nHXcb-0000eZ-2S for pgsql-bugs@arkaria.postgresql.org; Tue, 08 Feb 2022 21:01:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nHXcY-00011k-Af for pgsql-bugs@arkaria.postgresql.org; Tue, 08 Feb 2022 21:01:54 +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 1nHXJQ-0002l6-GC for pgsql-bugs@lists.postgresql.org; Tue, 08 Feb 2022 20:42: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 1nHXJN-0004jj-9l for pgsql-bugs@lists.postgresql.org; Tue, 08 Feb 2022 20:42:08 +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=Vu8Lo0MIG5MHLsuxVYZ9EfubwlhWFNdh6DMHQU6GYTc=; b=Okds9jR1gxrPTJ9wMZUpM16/ab 1XNMdjV7j59YnhWArKzxqAFe6/DT2kpDfqOQ6CmKIiIq42nlxAKSOR4KFPMdOB0zoMflTpLsqcCTg xK8d3Np1lt+n/ad8R14+4CKNkEtnwC9VxIrGgcAZysE2pTWkHIqNPyEUR1NuUV7n+cuzEDhf50XsB Y4osZAy2Qbr3gNhYp7zMb3eof/WN2lVM/xCUy7gyiKvGQGpHxwNFlonwGb9N4XZzsZbWzozY+G0Yh G47PVhYPINfb25H5H/17/j1+SBeJqE0DFSOtYygRJdmF9I2F1ye3b/X8HMKiNbpb5RquoYhBW3hWR /YxyzMlA==; 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 1nHXJL-00065t-TZ for pgsql-bugs@lists.postgresql.org; Tue, 08 Feb 2022 20:42: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 1nHXJK-0002CU-In for pgsql-bugs@lists.postgresql.org; Tue, 08 Feb 2022 20:42:02 +0000 Content-Type: multipart/mixed; boundary="===============6173036590745347803==" MIME-Version: 1.0 Subject: BUG #17401: REINDEX TABLE CONCURRENTLY creates a race condition on a streaming replica To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: bench@silentmedia.com Reply-To: bench@silentmedia.com, pgsql-bugs@lists.postgresql.org Date: Tue, 08 Feb 2022 20:41:54 +0000 Message-ID: <17401-9df851bb16dde397@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 --===============6173036590745347803== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzQwMQpMb2dnZWQgYnk6ICAgICAgICAgIEJlbiBDaG9ib3QKRW1haWwg YWRkcmVzczogICAgICBiZW5jaEBzaWxlbnRtZWRpYS5jb20KUG9zdGdyZVNRTCB2ZXJzaW9uOiAx Mi45Ck9wZXJhdGluZyBzeXN0ZW06ICAgTGludXggKFVidW50dSkKRGVzY3JpcHRpb246ICAgICAg ICAKClRoaXMgYnVnIGlzIGlzIGFsbW9zdCBpZGVudGljYWwgdG8gQlVHICMxNzM4OSwgd2hpY2gg SSBmaWxlZCBibGFtaW5nCnBnX3JlcGFjazsgaG93ZXZlciwgZnVydGhlciB0ZXN0aW5nIHNob3dz IHRoZSBzYW1lIHN5bXB0b21zIHVzaW5nIHZhbmlsbGEKUkVJTkRFWCBUQUJMRSBDT05DVVJSRU5U TFkuDQoNCjEuIFB1dCBzb21lIGRhdGEgaW4gYSB0YWJsZSB3aXRoIGEgc2luZ2xlIGJ0cmVlIGlu ZGV4Og0KY3JlYXRlIHRhYmxlIHB1YmxpYy5zaW1wbGVfdGVzdCAoaWQgaW50IHByaW1hcnkga2V5 KTsNCmluc2VydCBpbnRvIHB1YmxpYy5zaW1wbGVfdGVzdChpZCkgKHNlbGVjdCBnZW5lcmF0ZV9z ZXJpZXMoMSwxMDAwKSk7DQoNCjIuIFNldCB1cCBzdHJlYW1pbmcgcmVwbGljYXRpb24gdG8gYSBz ZWNvbmRhcnkgZGIuDQoNCjMuIEluIGEgbG9vcCBvbiB0aGUgcHJpbWFyeSwgY29uY3VycmVudGx5 IFJFSU5ERVggdGhhdCB0YWJsZToNCndoaWxlIGB0cnVlYDsgZG8gcHNxbCAtdEFjICJzZWxlY3Qg bm93KCkscmVsZmlsZW5vZGUgZnJvbSBwZ19jbGFzcyB3aGVyZQpyZWxuYW1lPSdzaW1wbGVfdGVz dF9wa2V5JyIgPj4gbG9nOyBwc3FsIC10QWMgInJlaW5kZXggdGFibGUgY29uY3VycmVudGx5CnB1 YmxpYy5zaW1wbGVfdGVzdCI7IGRvbmUNCg0KNC4gSW4gYSBsb29wIG9uIHRoZSBzZWNvbmRhcnks IGhhdmUgcHNxbCBxdWVyeSB0aGUgc2Vjb25kYXJ5IGRiIGZvciBhbgppbmRleGVkIHZhbHVlIG9m IHRoYXQgdGFibGU6DQp3aGlsZSBgdHJ1ZWA7IGRvIHBzcWwgLXRBYyAic2VsZWN0IGNvdW50KCop IGZyb20gc2ltcGxlX3Rlc3Qgd2hlcmUgaWQ9JzMnOwpzZWxlY3QgcmVsZmlsZW5vZGUgZnJvbSBw Z19jbGFzcyB3aGVyZSByZWxuYW1lPSdzaW1wbGVfdGVzdF9wa2V5JyIgfHwgYnJlYWs7CmRvbmU7 IGRhdGUNCg0KV2l0aCB0aG9zZSA0IHN0ZXBzLCB0aGUgY2xpZW50IG9uIHRoZSByZXBsaWNhIHdp bGwgcmVsaWFibHkgZmFpbCB0byBvcGVuIHRoZQpPSUQgb2YgdGhlIGluZGV4IHdpdGhpbiAzMCBt aW51dGVzIG9mIGxvb3BpbmcuICgiRVJST1I6ICBjb3VsZCBub3Qgb3BlbgpyZWxhdGlvbiB3aXRo IE9JRCA2NzE1ODI3IikgV2hlbiB3ZSBydW4gdGhlIHNhbWUgY2xpZW50IGxvb3Agb24gdGhlIHBy aW1hcnkKaW5zdGVhZCBvZiB0aGUgcmVwbGljYSwgb3IgaWYgd2UgcmVpbmRleCB3aXRob3V0IHRo ZSBDT05DVVJSRU5UTFkgY2xhdXNlLAp0aGVuIHRoZSBjbGllbnQgbG9vcCB3aWxsIHJ1biBmb3Ig aG91cnMgd2l0aG91dCBmYWlsLCBidXQgbmVpdGhlciBvZiB0aG9zZQp3b3JrYXJvdW5kcyBhcmUg b3B0aW9ucyBmb3IgdXMgaW4gcHJvZHVjdGlvbi4NCg0KTGlrZSBJIHNhaWQgYmVmb3JlLCB0aGlz IGlzbid0IGEgbmV3IHByb2JsZW0gLSB3ZSd2ZSBzZWVuIGl0IHNpbmNlIGF0IGxlYXN0CjkuNSAt IGJ1dCBwcmUtMTIgd2Ugc2F3IGl0IHVzaW5nIHBnX3JlcGFjaywgd2hpY2ggaXMgYW4gZWFzeSAo YW5kCnJlYXNvbmFibGUpIHNjYXBlZ29hdC4gQnV0IG5vdyB0aGF0IHdlJ3ZlIHVwZ3JhZGVkIHRv IDEyIGFuZCBhcmUgc3RpbGwKc2VlaW5nIGl0IHVzaW5nIHZhbmlsbGEgY29uY3VycmVudCByZWlu ZGV4aW5nLCBpdCBzZWVtcyBtb3JlIGNsZWFyIHRoaXMgaXMKYW4gYWN0dWFsIHBvc3RncmVzIGJ1 Zz8KCg== --===============6173036590745347803==--