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.96) (envelope-from ) id 1vXfzO-001NrL-0O for pgsql-bugs@arkaria.postgresql.org; Mon, 22 Dec 2025 13:30:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vXfzM-00Et3N-2O for pgsql-bugs@arkaria.postgresql.org; Mon, 22 Dec 2025 13:30:17 +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.96) (envelope-from ) id 1vXbi3-00DseU-38 for pgsql-bugs@lists.postgresql.org; Mon, 22 Dec 2025 08:56:08 +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.96) (envelope-from ) id 1vXbi1-0022jC-3B for pgsql-bugs@lists.postgresql.org; Mon, 22 Dec 2025 08:56: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=GoB4bB5nn/zuXzAjHY058uSHNlYyIHW80h+iqUnaOYk=; b=38PhLRz+jsVTmu+mcxSVUqJJR3 1jUYM3P6Q3WcLi+BHWZfUnJ6/felbTaO2a3ycJGqR6Z1JAdcuyd5PdEZXLqU30RAwILRc3tTPgxH1 0GyZ1/O2OX1XDLdoWFgA4N1d+1xCt0WUVYmrTv9Uss1FAoO94ruqyM1WM6SI01uOwEHy5pkYtl22Y edhhbrnwUrEl8IJZFPdUuT6htbZGv1CGkSWQmEuegtsN5CKmtJg35OIsf8nukVLESbKAC2JyJ/ECp A9UASaIntIOfvztqKTpL48kgsUrzPk724woIWQUw2HCfIsxUIUaV8c1FOl9FbdtN1FVxcONiIE5Gq 145GJAHQ==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vXbi1-005iF7-00 for pgsql-bugs@lists.postgresql.org; Mon, 22 Dec 2025 08:56:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vXbhy-00ASbx-27 for pgsql-bugs@lists.postgresql.org; Mon, 22 Dec 2025 08:56:03 +0000 Content-Type: multipart/mixed; boundary="===============5146322831563715985==" MIME-Version: 1.0 Subject: BUG #19360: Bug Report: Logical Replication initial sync fails with "conflict=update_origin_differs" PG12 toPG18 To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: mostafaa.hasanzadeh@gmail.com Reply-To: mostafaa.hasanzadeh@gmail.com, pgsql-bugs@lists.postgresql.org Date: Mon, 22 Dec 2025 08:55:15 +0000 Message-ID: <19360-1952ab7afd799f70@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 --===============5146322831563715985== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxOTM2MApMb2dnZWQgYnk6ICAgICAgICAgIE1vc3RhZmEgSGFzc2FuemFk ZWgKRW1haWwgYWRkcmVzczogICAgICBtb3N0YWZhYS5oYXNhbnphZGVoQGdtYWlsLmNvbQpQb3N0 Z3JlU1FMIHZlcnNpb246IDE4LjEKT3BlcmF0aW5nIHN5c3RlbTogICBVYnVudHUgMjQuMDQKRGVz Y3JpcHRpb246ICAgICAgICAKCkRlc2NyaXB0aW9uOiBJIGFtIGVuY291bnRlcmluZyBhIHBlcnNp c3RlbnQgaXNzdWUgZHVyaW5nIHRoZSBpbml0aWFsCnN5bmNocm9uaXphdGlvbiAoTG9naWNhbCBS ZXBsaWNhdGlvbikgbWlncmF0aW5nIGZyb20gUG9zdGdyZVNRTCAxMiAoU291cmNlKQp0byBQb3N0 Z3JlU1FMIDE4IChUYXJnZXQvRGV2ZWwpLgoKRGVzcGl0ZSBlbnN1cmluZyBhIGNsZWFuIHN0YXRl ICh0cnVuY2F0ZWQgdGFibGVzLCBkaXNhYmxlZCB0cmlnZ2VycywgZHJvcHBlZAppbmRleGVzKSwg dGhlIHJlcGxpY2F0aW9uIGZhaWxzIGltbWVkaWF0ZWx5IGFmdGVyIHRoZSBpbml0aWFsIENPUFkg cGhhc2UKd2hlbiBpdCB0cmllcyB0byBhcHBseSBjb25jdXJyZW50IHVwZGF0ZXMgZnJvbSBXQUwu IFRoZSBlcnJvciBpbmRpY2F0ZXMgYW4Kb3JpZ2luIGNvbmZsaWN0LCBldmVuIHRob3VnaCBvcmln aW4gaXMgc2V0IHRvIG5vbmUuCgpJdCBhcHBlYXJzIHRoYXQgdGhlIHJvd3MgaW5zZXJ0ZWQgZHVy aW5nIHRoZSBpbml0aWFsIENPUFkgcHJvY2VzcyBpbiBQRzE4CmFyZSBub3QgYmVpbmcgdHJlYXRl ZCBjb3JyZWN0bHkgcmVnYXJkaW5nIHRoZWlyIG9yaWdpbiBzdGF0dXMsIGNhdXNpbmcgYQpjb25m bGljdCB3aGVuIHRoZSBBcHBseSBXb3JrZXIgdHJpZXMgdG8gdXBkYXRlIHRoZXNlIHJvd3Mgd2l0 aCBpbmNvbWluZyBXQUwKZW50cmllcy4KCkVudmlyb25tZW50OgoKICAgIFB1Ymxpc2hlcjogUG9z dGdyZVNRTCAxMgoKICAgIFN1YnNjcmliZXI6IFBvc3RncmVTUUwgMTggKERldmVsb3BtZW50L0Jl dGEgdmVyc2lvbikKCiAgICBPUzogTGludXggKEtlcm5lbCA+IDUuMTApCgogICAgU2V0dXA6IEhp Z2gtdm9sdW1lIGRhdGEgbWlncmF0aW9uICh+MTAwR0IgdGFibGVzKQoKU3RlcHMgdG8gUmVwcm9k dWNlOgoKICAgIFB1Ymxpc2hlciAoUEcxMik6IENyZWF0ZSBhIHB1YmxpY2F0aW9uIGZvciB0YWJs ZXMgd2l0aCBtb2RlcmF0ZSB3cml0ZQp0cmFmZmljLgoKICAgIFN1YnNjcmliZXIgKFBHMTgpOgoK ICAgICAgICBESVNBQkxFIFRSSUdHRVIgQUxMIG9uIHRhcmdldCB0YWJsZXMuCgogICAgICAgIFRS VU5DQVRFIHRhcmdldCB0YWJsZXMuCgogICAgICAgIENyZWF0ZSBhIHN1YnNjcmlwdGlvbiB3aXRo OgogICAgICAgIFNRTAoKICAgICAgICBDUkVBVEUgU1VCU0NSSVBUSU9OIHN1Yl9uYW1lCiAgICAg ICAgQ09OTkVDVElPTiAnLi4uJwogICAgICAgIFBVQkxJQ0FUSU9OIHB1Yl9uYW1lCiAgICAgICAg V0lUSCAoY29weV9kYXRhID0gdHJ1ZSwgb3JpZ2luID0gJ25vbmUnLCBiaW5hcnkgPSBmYWxzZSk7 CgogICAgT2JzZXJ2YXRpb246CgogICAgICAgIFRoZSBDT1BZIHBoYXNlIHN0YXJ0cyBhbmQgd3Jp dGVzIGRhdGEgdG8gdGhlIGRpc2suCgogICAgICAgIEFzIHNvb24gYXMgQ09QWSBmaW5pc2hlcyBh bmQgdGhlIHdvcmtlciBzd2l0Y2hlcyB0byBzdHJlYW1pbmcgdG8KY2F0Y2ggdXAsIGl0IGNyYXNo ZXMgd2l0aCB0aGUgZm9sbG93aW5nIGVycm9yLgoKRXJyb3IgTG9nOgoKTE9HOiAgY29uZmxpY3Qg ZGV0ZWN0ZWQgb24gcmVsYXRpb24gInB1YmxpYy5wbGF5ZXIiOgpjb25mbGljdD11cGRhdGVfb3Jp Z2luX2RpZmZlcnMKREVUQUlMOiAgVXBkYXRpbmcgdGhlIHJvdyB0aGF0IHdhcyBtb2RpZmllZCBi eSBhIG5vbi1leGlzdGVudCBvcmlnaW4gaW4KdHJhbnNhY3Rpb24gW1RYSURdIGF0IFtUSU1FU1RB TVBdLgpFeGlzdGluZyBsb2NhbCByb3cgKC4uLik7IHJlbW90ZSByb3cgKC4uLik7IHJlcGxpY2Eg aWRlbnRpdHkgKGlkKT0oLi4uKS4KQ09OVEVYVDogIHByb2Nlc3NpbmcgcmVtb3RlIGRhdGEgZm9y IHJlcGxpY2F0aW9uIG9yaWdpbiAicGdfLi4uIiBkdXJpbmcKbWVzc2FnZSB0eXBlICJVUERBVEUi IC4uLgoKQW5hbHlzaXM6IEkgaGF2ZSB2ZXJpZmllZCB0aGF0OgoKICAgIFRoZXJlIGFyZSBubyBv dGhlciBhY3RpdmUgc3Vic2NyaXB0aW9ucyB3cml0aW5nIHRvIHRoZSB0YXJnZXQgZGF0YWJhc2Uu CgogICAgQWxsIHRyaWdnZXJzIGFuZCBmb3JlaWduIGtleXMgYXJlIGRpc2FibGVkIG9uIHRoZSBz dWJzY3JpYmVyLgoKICAgIFRoZSBpc3N1ZSBwZXJzaXN0cyBldmVuIGFmdGVyIG11bHRpcGxlIGNs ZWFudXBzIChEUk9QIFNVQlNDUklQVElPTiAvClRSVU5DQVRFKS4KClN1c3BlY3RlZCBDYXVzZTog SXQgc2VlbXMgdGhlcmUgaXMgYW4gaW5jb21wYXRpYmlsaXR5IG9yIHJlZ3Jlc3Npb24gaW4KUG9z dGdyZVNRTCAxOCdzIGxvZ2ljYWwgcmVwbGljYXRpb24gaGFuZGxpbmcuIFNwZWNpZmljYWxseSwg dHVwbGVzIGluc2VydGVkCnZpYSB0aGUgaW5pdGlhbCBDT1BZIHByb3RvY29sIChmcm9tIGEgUEcx MiBzb3VyY2UpIG1pZ2h0IGJlIHRhZ2dlZCB3aXRoIGEKbG9jYWwgb3IgbnVsbCBvcmlnaW4gaW4g YSB3YXkgdGhhdCBjb25mbGljdHMgd2l0aCB0aGUgY29uZmxpY3RfcmVzb2x2ZXIgb3IKb3JpZ2lu IGNoZWNraW5nIGxvZ2ljIGluIFBHMTgsIGV2ZW4gd2hlbiBvcmlnaW4gPSAnbm9uZScgaXMgZXhw bGljaXRseQpjb25maWd1cmVkLgoKSSBzdXNwZWN0IHRoZSBDT1BZIHByb2Nlc3MgZG9lcyBub3Qg Y29ycmVjdGx5IHNldCB0aGUgdHVwbGUgb3JpZ2luIHN0YXRlCnRoYXQgdGhlIFdBTCBhcHBseSB3 b3JrZXIgZXhwZWN0cywgbGVhZGluZyBpdCB0byBiZWxpZXZlIHRoZSByb3cgd2FzCm1vZGlmaWVk IGxvY2FsbHkgYnkgYSB0aGlyZCBwYXJ0eS4KCg== --===============5146322831563715985==--