Logical replication conflict after using pg_createsubscriber under heavy load

Title

CI (CFBot)

Needs rebase! Needs rebase since 2 days. Failing since 2 days.
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-06-23 08:42:59 (1 month ago)

Latest email

2025-07-24 10:49:02 (yesterday)

Status

PG19-1 (2025-07-01 - 2025-07-31): Needs review

Target version

Authors

Shlok Kyal (shlokkyal)

Reviewers

Become reviewer

Committer

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-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