Logical replication conflict after using pg_createsubscriber under heavy load

Title

CI (CFBot)

Needs rebase! Needs rebase since 4 days. Failing since 4 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 week ago)

Latest email

2025-05-14 05:30:39 (1 month ago)

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-05-14 05:30:39 by vignesh C <vignesh21 at gmail.com>
Latest attachment (test.log) at 2025-05-10 19:19:38 from Shlok Kyal <shlok.kyal.oss at gmail.com>
    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-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