Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rNY7r-00DDWd-6o for pgsql-bugs@arkaria.postgresql.org; Wed, 10 Jan 2024 12:56:07 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rNY7p-003XHY-TL for pgsql-bugs@arkaria.postgresql.org; Wed, 10 Jan 2024 12:56:05 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rNY43-003WPo-I8 for pgsql-bugs@lists.postgresql.org; Wed, 10 Jan 2024 12:52:11 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rNY3y-000phC-UY for pgsql-bugs@lists.postgresql.org; Wed, 10 Jan 2024 12:52: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=TA30TlcdRJ/+6c0s9TaHZ02PnuT5FK4xAnN+3gzJsrM=; b=EROwSGyfvyfoVO/uCwgMLB5bnn bENcA+sOgSxztmvz+XdJpN6g0O5Iy26VApEMfS831fHwyWbQVYh6XNGwWWzbPY845CbAwxnhoJdfo TBdXHmG01+5+5f447VhZp7IpwDYQWtI5C/0iSUVwIvwljpSN+YYpgbkO6XTrySqAQJhGuirg2Fhr7 4yg0sNQ9qJ+8cqHYVWzvNthuwf7KzJ5vX4RUHnX593vX/eqHhgeQJV78KX82ye6b7crTzdUZohE9x fMb6HBvO0Y2QXCQvgkxQuoApOtysexo6a+LOUnwRyCChSmysqYmzi2/qI3X0FTSqBQaL8TmFEIn/n ivljJfEA==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rNY3v-002WUP-CB for pgsql-bugs@lists.postgresql.org; Wed, 10 Jan 2024 12:52:05 +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 1rNY3u-005Bi3-Fa for pgsql-bugs@lists.postgresql.org; Wed, 10 Jan 2024 12:52:02 +0000 Content-Type: multipart/mixed; boundary="===============6350824046473728978==" MIME-Version: 1.0 Subject: BUG #18280: logical decoding build wrong snapshot for subtransactions To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: feichanghong@qq.com Reply-To: feichanghong@qq.com, pgsql-bugs@lists.postgresql.org Date: Wed, 10 Jan 2024 12:51:08 +0000 Message-ID: <18280-4c8060178cb41750@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 --===============6350824046473728978== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODI4MApMb2dnZWQgYnk6ICAgICAgICAgIEZlaSBDaGFuZ2hvbmcKRW1h aWwgYWRkcmVzczogICAgICBmZWljaGFuZ2hvbmdAcXEuY29tClBvc3RncmVTUUwgdmVyc2lvbjog MTUuNQpPcGVyYXRpbmcgc3lzdGVtOiAgIE9wZXJhdGluZyBzeXN0ZW06IGNlbnRvcyA3LEtlcm5l bCB2ZXJzaW9uOiA1LjEwLjEzCkRlc2NyaXB0aW9uOiAgICAgICAgCgpIaSwgYWxsDQpJIGVuY291 bnRlcmVkIGEgcHJvYmxlbSByZWxhdGVkIHRvIGxvZ2ljYWwgZGVjb2RpbmcgaGlzdG9yeSBzbmFw c2hvdC4gVGhlCnNwZWNpZmljIHBoZW5vbWVub24gaXMgIkVSUk9SOiBjb3VsZCBub3QgbWFwIGZp bGVub2RlICJiYXNlLzUvMTYzOTAiIHRvCnJlbGF0aW9uIE9JRCIuDQpUaGUgc3ViLXRyYW5zYWN0 aW9uIHRoYXQgbW9kaWZpZWQgdGhlIGNhdGFsb2cgZW5kcyBlYXJsaWVyIHRoYW4gdGhlCnJlc3Rh cnRfbHNuIG9mIHRoZSBsb2dpY2FsIHJlcGxpY2F0aW9uIHNsb3QsIGJ1dCB0aGUgY29tbWl0IHdh bCByZWNvcmQgb2YKaXRzIHBhcmVudCB0cmFuc2FjdGlvbiBpcyBhZnRlciB0aGUgcmVzdGFydF9s c24uIFRoZSBXQUwgcmVjb3JkIHJlbGF0ZWQgdG8KdGhlIHN1Yi10cmFuc2FjdGlvbiB3aWxsIG5v dCBiZSBkZWNvZGVkIGR1cmluZyBsb2dpY2FsIGRlY29kaW5nLCBzbyBpdCB3aWxsCm5vdCBiZSBt YXJrZWQgYXMgY29udGFpbmluZyBjYXRhbG9nIGNoYW5nZXMuIFRoZSBjYXRhbG9nIGlzIG5vdCBy ZWNvcmRlZCBpbgp0aGUgY29tbWl0dGVkIGxpc3Qgb2YgdGhlIHNuYXBzaG90Lg0KU25hcEJ1aWxk WGlkU2V0Q2F0YWxvZ0NoYW5nZXMgKGludHJvZHVjZWQgaW4gMjcyMjQ4YSkgc2tpcHBpbmcgdGhl IGNoZWNrIGZvcgp0aGUgc3ViLXRyYW5zYWN0aW9ucyB3aGVuIHRoZSBwYXJlbnQgdHJhbnNhY3Rp b24gaGFzIGJlZW4gbWFya2VkIGFzCmNvbnRhaW5pbmcgY2F0YWxvZyBjaGFuZ2VzIHNob3VsZCBi ZSB0aGUgcm9vdCBjYXVzZSBvZiB0aGUgcHJvYmxlbS4NCg0KVGhlIHByb2JsZW0gY2FuIGJlIHJl cHJvZHVjZWQgYnkgZm9sbG93aW5nIHRoZSBmb2xsb3dpbmcgc3RlcHMgKHRvIGF2b2lkIHRoZQpp bXBhY3Qgb2YgYmd3cml0ZXIgd3JpdGluZyBYTE9HX1JVTk5JTkdfWEFDVFMgV0FMIHJlY29yZHMs IEkgaW5jcmVhc2VkIHRoZQp2YWx1ZSBvZiBMT0dfU05BUFNIT1RfSU5URVJWQUxfTVMpOg0Kc2Vz c2lvbiAxOg0KYGBgDQpDUkVBVEUgVEFCTEUgdGJsMSAodmFsMSBpbnRlZ2VyLCB2YWwyIGludGVn ZXIpOw0KQ1JFQVRFIFRBQkxFIHRibDFfcGFydCAodmFsMSBpbnRlZ2VyKSBQQVJUSVRJT04gQlkg UkFOR0UgKHZhbDEpOw0KDQpTRUxFQ1QgJ2luaXQnIEZST00gcGdfY3JlYXRlX2xvZ2ljYWxfcmVw bGljYXRpb25fc2xvdCgnaXNvbGF0aW9uX3Nsb3QnLAondGVzdF9kZWNvZGluZycpOw0KDQpCRUdJ TjsNClNBVkVQT0lOVCBzcDE7DQpDUkVBVEUgVEFCTEUgdGJsMV9wYXJ0X3AxIFBBUlRJVElPTiBP RiB0YmwxX3BhcnQgRk9SIFZBTFVFUyBGUk9NICgwKSBUTwooMTApOw0KUkVMRUFTRSBTQVZFUE9J TlQgc3AxOw0KYGBgDQoNCnNlc3Npb24gMjoNCmBgYA0KQ0hFQ0tQT0lOVDsNCmBgYA0KDQpzZXNz aW9uIDE6DQpgYGANCkNSRUFURSBUQUJMRSB0YmwxX3BhcnRfcDIgUEFSVElUSU9OIE9GIHRibDFf cGFydCBGT1IgVkFMVUVTIEZST00gKDEwKSBUTwooMjApOw0KQ09NTUlUOw0KQkVHSU47DQpUUlVO Q0FURSB0YmwxOw0KYGBgDQoNCnNlc3Npb24gMjoNCmBgYA0KQ0hFQ0tQT0lOVDsNClNFTEVDVCBk YXRhIEZST00gcGdfbG9naWNhbF9zbG90X2dldF9jaGFuZ2VzKCdpc29sYXRpb25fc2xvdCcsIE5V TEwsIE5VTEwsCidza2lwLWVtcHR5LXhhY3RzJywgJzEnLCAnaW5jbHVkZS14aWRzJywgJzAnKTsN CklOU0VSVCBJTlRPIHRibDFfcGFydCBWQUxVRVMgKDEpOw0KU0VMRUNUIGRhdGEgRlJPTSBwZ19s b2dpY2FsX3Nsb3RfZ2V0X2NoYW5nZXMoJ2lzb2xhdGlvbl9zbG90JywgTlVMTCwgTlVMTCwKJ3Nr aXAtZW1wdHkteGFjdHMnLCAnMScsICdpbmNsdWRlLXhpZHMnLCAnMCcpOw0KYGBgDQoNCkkgd2ls bCBwcm92aWRlIGEgcGF0Y2ggdG8gZml4IHRoaXMgcHJvYmxlbSBsYXRlci4KCg== --===============6350824046473728978==--