Logical replication conflict after using pg_createsubscriber under heavy load

Title

CI (CFBot)

Summary

Stats (from CFBot)

Patch count: 1, First patch: +1−1, All patches: +1−1

Topic

Replication & Recovery

Tags

Bugfix Logical Replication

Created

2025-06-23 05:47:58

Last modified

2025-06-23 08:42:59 (2 weeks ago)

Latest email

2025-07-10 07:03:37 (yesterday)

Status

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

Target version

Authors

Shlok Kyal (shlokkyal)

Reviewers

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-10 07:03:37 by Amit Kapila <amit.kapila16 at gmail.com>
Latest 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>
    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-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