Logical replication conflict after using pg_createsubscriber under heavy load

Edit
ID 5837
Title Logical replication conflict after using pg_createsubscriber under heavy load
CI (CFBot) Needs rebase! Needs rebase since 3 months. Failing since 3 months.
Additional links previous successfully applied patch (outdated):
Summary
Stats (from CFBot) Unknown
Topic Replication & Recovery
Tags Bugfix Logical Replication
Created 2025-06-23 05:47:58
Last modified 2025-07-28 02:57:51 (3 months ago)
Latest email 2025-07-24 10:49:02 (3 months ago)
Status
PG19-1 (2025-07-01 – 2025-07-31): Committed
Target version 18
Authors Shlok Kyal (shlokkyal)
Reviewers Become reviewer
Committer Amit Kapila (amitkapila)
Links
Emails
BUG #18897: Logical replication conflict after using pg_createsubscriber under heavy load
First at 2025-04-16 23:14:19 by PG Bug reporting form <noreply at postgresql.org>
Latest at 2025-07-24 10:49:02 by Amit Kapila <amit.kapila16 at gmail.com>
Latest attachment (v6_HEAD-0001-Fix-duplicate-insert-during-pg_createsubscri.patch) at 2025-07-23 13:25:49 from Shlok Kyal <shlok.kyal.oss at gmail.com>
    Attachment (v6_HEAD-0001-Fix-duplicate-insert-during-pg_createsubscri.patch) at 2025-07-23 13:25:49 from Shlok Kyal <shlok.kyal.oss at gmail.com> (Patch: Yes)
    Attachment (v5_REL_18-0001-Fix-duplicate-insert-during-pg_createsubsc.txt) at 2025-07-22 11:24:29 from Shlok Kyal <shlok.kyal.oss at gmail.com> (Patch: Yes)
    Attachment (v4_REL_17-0001-Fix-duplicate-insert-during-pg_createsubscriber.txt) at 2025-07-01 19:41:32 from Shlok Kyal <shlok.kyal.oss at gmail.com> (Patch: Yes)
    Attachment (test.log) at 2025-05-10 19:19:38 from Shlok Kyal <shlok.kyal.oss at gmail.com> (Patch: No)
    Attachment (log_consistent_lsn_type.patch) at 2025-05-05 14:47:33 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Fix-duplicate-insert-during-pg_createsubscriber.patch) at 2025-04-29 07:47:30 from Shlok Kyal <shlok.kyal.oss at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Fix-duplicate-insert-during-pg_createsubscriber.patch) at 2025-04-25 08:44:23 from Shlok Kyal <shlok.kyal.oss at gmail.com> (Patch: Yes)
    Attachment (logical_stress_test.sh) at 2025-04-16 23:54:23 from Zane Duffield <duffieldzane at gmail.com> (Patch: No)
History
When Who What
2025-07-28 02:57:51 vigneshwaran C (vignesh.postgres) Closed in commitfest PG19-1 with status: Committed
2025-07-28 02:57:51 vigneshwaran C (vignesh.postgres) Changed committer to amitkapila
2025-07-23 14:58:21 CFbot Patch needs rebase
2025-07-01 20:05:25 CFbot Patch does not need rebase anymore
2025-06-26 09:09:28 CFbot Patch needs rebase
2025-06-23 08:42:59 Jelte Fennema-Nio (jeltef) Changed tags to Bugfix, Logical Replication
2025-06-23 05:47:58 Shlok Kyal (shlokkyal) Attached mail thread 18897-d3db67535860dddb@postgresql.org
2025-06-23 05:47:58 Shlok Kyal (shlokkyal) Created patch record
Edit