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 1ooLZf-0000yt-F2 for pgsql-bugs@arkaria.postgresql.org; Fri, 28 Oct 2022 09:22:47 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ooLZe-0001aJ-7w for pgsql-bugs@arkaria.postgresql.org; Fri, 28 Oct 2022 09:22:46 +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 1ooK75-000886-B5 for pgsql-bugs@lists.postgresql.org; Fri, 28 Oct 2022 07:49:11 +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 1ooK70-0002DX-MG for pgsql-bugs@lists.postgresql.org; Fri, 28 Oct 2022 07:49: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=OSfrMwYZt1R+ICHG0TH31aT7ZQJOzPvnMiwdc2joQgs=; b=X2EhCNBk3ij6hMa0KeJ0RHIX2i e40ZxflE/rsL3nDmM6+UcGufbAL82CV4kBpXsqDp41DRJlPsHu1YwE4jG+SrRaLU2li39AknG/cGl 72/Te5G6fun/D0a80O7BfrOJIX03TlEzbPIC9uvWIvhKTIVQj23HC/pOqHeyjJs6VQpFRP0dNOZux qUYEL6rsEUIXrbYRYMTo9l1Bm88vvPLznoB6kWZ91btBZy5kbSA90PUiaRH/IDPA/SAAXCc6PxcoD ZMyxHfD7Kqcpiq0RQ6MJbqPocUkv+78KmSaeM6Layae6Z6kMF/fAceHmzkZCXPjnaNwt1wpOhE4s3 MmmC8aZg==; 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 1ooK6z-0001nF-MT for pgsql-bugs@lists.postgresql.org; Fri, 28 Oct 2022 07:49:06 +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 1ooK6w-0056vc-CA for pgsql-bugs@lists.postgresql.org; Fri, 28 Oct 2022 07:49:03 +0000 Content-Type: multipart/mixed; boundary="===============6485659068074849810==" MIME-Version: 1.0 Subject: BUG #17670: Logical Replication data may be lost on the subscription under certain scenarios To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: xyh@nvn.xyz Reply-To: xyh@nvn.xyz, pgsql-bugs@lists.postgresql.org Date: Fri, 28 Oct 2022 07:48:50 +0000 Message-ID: <17670-8266c823f774a63f@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 --===============6485659068074849810== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzY3MApMb2dnZWQgYnk6ICAgICAgICAgIFl1bmhlIFh1CkVtYWlsIGFk ZHJlc3M6ICAgICAgeHloQG52bi54eXoKUG9zdGdyZVNRTCB2ZXJzaW9uOiAxNC40Ck9wZXJhdGlu ZyBzeXN0ZW06ICAgcmhlbCA3CkRlc2NyaXB0aW9uOiAgICAgICAgCgpMb2dpY2FsIFJlcGxpY2F0 aW9uIGRhdGEgbWF5IGJlIGxvc3Qgb24gdGhlIHN1YnNjcmlwdGlvbiB1bmRlciBjZXJ0YWluCnNj ZW5hcmlvcy4NClRoZSBmb2xsb3dpbmcgaXMgcmV2aWV3IHByb2Nlc3MuDQoNCiogTG9naWNhbCBS ZXBsaWNhdGlvbiBJbmZvcm1hdGlvbg0KdDE9IyBzZWxlY3QgKiBmcm9tIHBnX3B1YmxpY2F0aW9u X3RhYmxlcyA7DQogIHB1Ym5hbWUgICB8IHNjaGVtYW5hbWUgfCAgIHRhYmxlbmFtZSAgICANCi0t LS0tLS0tLS0tLSstLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLQ0KIHB1YjEgICAgICAgfCBw dWJsaWMgICAgIHwgdF90ZXN0MQ0KdDI9IyBzZWxlY3Qgc3JyZWxpZDo6cmVnY2xhc3MsKiBmcm9t IHBnX3N1YnNjcmlwdGlvbl9yZWwgOw0KIHNycmVsaWQgfCBzcnN1YmlkIHwgc3JyZWxpZCB8IHNy c3Vic3RhdGUgfCBzcnN1YmxzbiAgDQotLS0tLS0tLS0rLS0tLS0tLS0tKy0tLS0tLS0tLSstLS0t LS0tLS0tLS0rLS0tLS0tLS0tLS0NCiB0X3Rlc3QxIHwgICA1NzU1MSB8ICAgNDExNzAgfCByICAg ICAgICAgIHwgMC82OTZFNDE4DQp0MT0jIHNlbGVjdCBhcHBsaWNhdGlvbl9uYW1lLHN0YXRlIGZy b20gcGdfc3RhdF9yZXBsaWNhdGlvbiB3aGVyZQphcHBsaWNhdGlvbl9uYW1lPSd0ZXN0Ml9zdWIn Ow0KIGFwcGxpY2F0aW9uX25hbWUgfCAgIHN0YXRlICAgDQotLS0tLS0tLS0tLS0tLS0tLS0rLS0t LS0tLS0tLS0NCiB0ZXN0Ml9zdWIgICAgICAgIHwgc3RyZWFtaW5nDQoNCiogVmVyaWZ5IHRoZSBz dGF0dXMgaXMgbm9ybWFsDQp0MT0jIGluc2VydCBpbnRvIHRfdGVzdDEgdmFsdWVzICgxKTsNCklO U0VSVCAwIDENCnQxPSMgc2VsZWN0ICogZnJvbSB0X3Rlc3QxOw0KIGlkIA0KLS0tLQ0KICAxDQp0 Mj0jIHNlbGVjdCAqIGZyb20gdF90ZXN0MTsNCiBpZCANCi0tLS0NCiAgMQ0KDQoqIFRoZW4gZGVs ZXRlIHRoaXMgdGFibGUgb24gc3Vic2NyaXB0aW9uIDogDQp0Mj0jIGFsdGVyIHRhYmxlIHRfdGVz dDEgcmVuYW1lIFRPIHRfdGVzdDI7DQpBTFRFUiBUQUJMRQ0KDQoqIE5vdyxkbyBETUxzDQp0MT0j IGluc2VydCBpbnRvIHRfdGVzdDEgdmFsdWVzICgyKTsNCklOU0VSVCAwIDENCnQxPSMgZGVsZXRl IGZyb20gdF90ZXN0MSB3aGVyZSBpZD0xOw0KREVMRVRFIDENCnQxPSMgDQoqIFRoZSBsb2cgZ2l2 ZXMgc29tZSBlcnJvcnMNCjIwMjItMTAtMjggMTU6MTQ6MDcuOTE5IENTVCwsLDI2MDAsLDYzNWI4 MTNmLmEyOCwyLCwyMDIyLTEwLTI4IDE1OjE0OjA3CkNTVCw0LzEyLDAsRVJST1IsNTUwMDAsImxv Z2ljYWwgcmVwbGljYXRpb24gdGFyZ2V0IHJlbGF0aW9uCiIicHVibGljLnRfdGVzdDEiIiBkb2Vz IG5vdCBleGlzdCIsLCwsLCwsLCwiIiwibG9naWNhbCByZXBsaWNhdGlvbgp3b3JrZXIiLCwwDQoN CiogT0ssTGV0IG1lIGNyZWF0ZSB0aGlzIHRhYmxlDQp0Mj0jIGNyZWF0ZSB0YWJsZSB0X3Rlc3Qx IChpZCBpbnQgUFJJTUFSWSBLRVkpOw0KQ1JFQVRFIFRBQkxFDQoNCiogQXQgdGhpcyBwb2ludCwg dGhlIGxvZyBpcyBubyBsb25nZXIgc2hvd2luZyBlcnJvcnMuQnV0IHRoZSBpbmNyZW1lbnRhbApk YXRhIGlzIGxvc3QuDQp0Mj0jIHNlbGVjdCAqIGZyb20gdF90ZXN0MTsNCiBpZCANCi0tLS0NCigw IHJvd3MpDQoNCnQxPSMgaW5zZXJ0IGludG8gdF90ZXN0MSB2YWx1ZXMgKDMpOw0KSU5TRVJUIDAg MQ0KdDE9IyBpbnNlcnQgaW50byB0X3Rlc3QxIHZhbHVlcyAoNCk7DQpJTlNFUlQgMCAxDQoNCnQy PSMgc2VsZWN0ICogZnJvbSB0X3Rlc3QxOw0KIGlkIA0KLS0tLQ0KKDAgcm93cykNCnQyPSMgc2Vs ZWN0ICogZnJvbSB0X3Rlc3QyIDsNCiBpZCANCi0tLS0NCiAgMQ0KKDEgcm93KQ0KDQoqIFN0aWxs IG5vIGVycm9yLg0KKiBOb3cgbW9kaWZ5IHRoZSBwcmV2aW91cyB0YWJsZSBiYWNrDQoNCnQyPSMg ZHJvcCB0YWJsZSB0X3Rlc3QxIDsNCkRST1AgVEFCTEUNCnQyPSMgYWx0ZXIgdGFibGUgdF90ZXN0 MiByZW5hbWUgVE8gdF90ZXN0MTsNCkFMVEVSIFRBQkxFDQoNCnQxPSMgaW5zZXJ0IGludG8gdF90 ZXN0MSB2YWx1ZXMgKDUpOw0KSU5TRVJUIDAgMQ0KdDE9IyBzZWxlY3QgKiBmcm9tIHRfdGVzdDE7 DQogaWQgDQotLS0tDQogIDINCiAgMw0KICA0DQogIDUNCig0IHJvd3MpDQoNCnQyPSMgc2VsZWN0 ICogZnJvbSB0X3Rlc3QxOw0KIGlkIA0KLS0tLQ0KICAxDQogIDUNCigyIHJvd3MpDQoNCiogVGhl IG1pZGRsZSBvcGVyYXRpb24tZGVsZXRlIGlkPTEgYW5kIGluc2VydCBpZD0zLDQtaXMgbG9zcy4N CipQbGVhc2UgY29uZmlybSBpZiB0aGlzIGlzIGEgQlVHLg0KDQpUaGFua3MuDQpZdW5oZSBYdQoK --===============6485659068074849810==--