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 1nEeCA-00052v-Pk for pgsql-bugs@arkaria.postgresql.org; Mon, 31 Jan 2022 21:26:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nEeC9-0004Uk-G7 for pgsql-bugs@arkaria.postgresql.org; Mon, 31 Jan 2022 21:26:41 +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 1nEZHl-00056U-NK for pgsql-bugs@lists.postgresql.org; Mon, 31 Jan 2022 16:12:09 +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 1nEZHg-0006cQ-7O for pgsql-bugs@lists.postgresql.org; Mon, 31 Jan 2022 16:12: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=yalUOzc183YwA2k0m5zMJAcR+Ea1f47UJQtjQXLF7rQ=; b=iWB2OGda4BqJzS+jIM931HLvZ4 v0MJSKd6aYL0KiuHb8RpWwjSxMDn0umbroXdyEZ4zT1OZJzwqrYdMY6k0abBMHt0soss0Ha0W9WE+ mM0JaIVXgTZNRRMPrjslDvBYMJntiYDx+RssyVup9slITWoE+ryb3rObMZ+kRnZDVOqhPBO8IiOl6 gxlUE/Xc693aC1G3m4eN/rv2USqdcdQvl+rvYZekjtIqc6W5NQFbDQLcZ9PUwXsJ3ZOc1rSngSGVA S9sq7aoJq8FaH40w3qzCzx30rCCHtLhjiaSyJ6fvszXJn2tdUWHdRjaG3rsmjRdMcVQDrlqUye3ot GOLYAYuw==; 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 1nEZHf-00050r-Gj for pgsql-bugs@lists.postgresql.org; Mon, 31 Jan 2022 16:12: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 1nEZHe-0000S8-Cp for pgsql-bugs@lists.postgresql.org; Mon, 31 Jan 2022 16:12:02 +0000 Content-Type: multipart/mixed; boundary="===============6594302189133236997==" MIME-Version: 1.0 Subject: BUG #17389: pg_repack creates race conditions on streaming replicas 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: Mon, 31 Jan 2022 16:11:15 +0000 Message-ID: <17389-c866083cf152593e@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 --===============6594302189133236997== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzM4OQpMb2dnZWQgYnk6ICAgICAgICAgIEJlbiBDaG9ib3QKRW1haWwg YWRkcmVzczogICAgICBiZW5jaEBzaWxlbnRtZWRpYS5jb20KUG9zdGdyZVNRTCB2ZXJzaW9uOiAx Mi45Ck9wZXJhdGluZyBzeXN0ZW06ICAgTGludXggKFVidW50dSkKRGVzY3JpcHRpb246ICAgICAg ICAKCldlJ3ZlIG5vdGljZWQgdGhhdCBhdCBsZWFzdCBzaW5jZSA5LjUsIHJ1bm5pbmcgcGdfcmVw YWNrIGNhdXNlcyBhIHJhY2UKY29uZGl0aW9ucyBvbiBvdXIgc3RyZWFtaW5nIHJlcGxpY2FzLCBi dXQgX25vdF8gb24gdGhlIHByaW1hcnkgd2hlcmUKcGdfcmVwYWNrIGlzIHJ1bm5pbmcuIFRoaXMg bWFuaWZlc3RzIGl0c2VsZiBhcyBhIGNsaWVudCBicmllZmx5IHVuYWJsZSB0bwpvcGVuIHRoZSBy ZWxhdGlvbiBnZXR0aW5nIHJlcGFja2VkIC0gYnV0LCBpbiBvdXIgdGVzdGluZyBhbmQgZXhwZXJp ZW5jZSwKb25seSBvbiB0aGUgcmVwbGljYS4gSSB3b3VsZCBibGFtZSBwZ19yZXBhY2sgLSBpdHMg d2hvbGUgcHVycG9zZSBmb3IgYmVpbmcKaXMgdG8gdHJhbnNwYXJlbnRseSByZW1ha2UgdGFibGVz LCBhbmQgcXVpdGUgcG9zc2libHkgaXQgZ290IHNvbWUgb2YgdGhlCmRldGFpbHMgd3JvbmcgLSBl eGNlcHQgdGhhdCBpZiBpdHMgYmVoYXZpb3IgYXBwZWFycyBhdG9taWMgdG8gY2xpZW50cyBvbiB0 aGUKcHJpbWFyeSwgdGhlbiBzdXJlbHkgaXQgc2hvdWxkIG9uIHRoZSByZXBsaWNhcyB0b28/DQoN ClVzaW5nIHRoZXNlIHN0ZXBzIGJlbG93LCBJIGNhbiByZWxpYWJseSBnZXQgdGhlIGNsaWVudCBv biB0aGUgcmVwbGljYSB0bwpoYXZlIGFuIE9JRCBlcnJvciB3aXRoaW4gMzAgbWludXRlcy4gVGhl IHNhbWUgc3RlcHMgZmFpbCB0byBnZW5lcmF0ZSBhbgplcnJvciB3aGVuIEkgcXVlcnkgaW4gYSBs b29wIG9uIHRoZSBwcmltYXJ5Lg0KDQoxLiBQdXQgc29tZSBkYXRhIGluIGEgdGFibGUgd2l0aCBh IHNpbmdsZSBidHJlZSBpbmRleCBvbiBhIHByaW1hcnkgZGI6DQpjcmVhdGUgdGFibGUgcHVibGlj LnNpbXBsZV90ZXN0IChpZCBpbnQgcHJpbWFyeSBrZXkpOw0KaW5zZXJ0IGludG8gcHVibGljLnNp bXBsZV90ZXN0KGlkKSAoc2VsZWN0IGdlbmVyYXRlX3NlcmllcygxLDEwMDApKTsNCg0KMi4gU2V0 IHVwIHN0cmVhbWluZyByZXBsaWNhdGlvbiB0byBhIHNlY29uZGFyeSBkYi4NCg0KMy4gQWRkIHBn X3JlcGFjaw0KY3JlYXRlIGV4dGVuc2lvbiBwZ19yZXBhY2sgOw0KDQo0LiBJbiBhIGxvb3Agb24g dGhlIHByaW1hcnksIGhhdmUgcGdfcmVwYWNrIHJlcGFjayB0aGUgaW5kaWNlcyBvZiB0aGF0CnRh YmxlOg0Kd2hpbGUgYHRydWVgOyBkbyBwc3FsIC1kIGNhbnZhcyAtdEFjICJzZWxlY3Qgbm93KCks cmVsZmlsZW5vZGUgZnJvbSBwZ19jbGFzcwp3aGVyZSByZWxuYW1lPSdzaW1wbGVfdGVzdF9wa2V5 JyIgPj4gbG9nOwovdXNyL2xpYi9wb3N0Z3Jlc3FsLzEyL2Jpbi9wZ19yZXBhY2sgLWQgY2FudmFz IC14IC10IHB1YmxpYy5zaW1wbGVfdGVzdDsKZG9uZQ0KDQo1LiBJbiBhIGxvb3Agb24gdGhlIHNl Y29uZGFyeSwgaGF2ZSBwc3FsIHF1ZXJ5IHRoZSBzZWNvbmRhcnkgZGIgZm9yIGFuCmluZGV4ZWQg dmFsdWUgb2YgdGhhdCB0YWJsZToNCndoaWxlIGB0cnVlYDsgZG8gcHNxbCAtdEFjICJzZWxlY3Qg Y291bnQoKiksbm93KCkgZnJvbSBzaW1wbGVfdGVzdCB3aGVyZQppZD0nMyciIHx8IGJyZWFrOyBk b25lOyBkYXRlCgo= --===============6594302189133236997==--