Re: Conflict detection for update_deleted in logical replication

From: Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com>
To: "Zhijie Hou (Fujitsu)" <houzj(dot)fnst(at)fujitsu(dot)com>
Cc: shveta malik <shveta(dot)malik(at)gmail(dot)com>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, Dilip Kumar <dilipbalaut(at)gmail(dot)com>, Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>, "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, vignesh C <vignesh21(at)gmail(dot)com>, Nisha Moond <nisha(dot)moond412(at)gmail(dot)com>
Subject: Re: Conflict detection for update_deleted in logical replication
Date: 2025-08-21 08:55:02
Message-ID: CADzfLwViWQOQSJ9FQVE9j99JN6Ggw5oyLEGTyCE6uFjPhkeZQg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello!

Sorry for being noisy - just want to remind: conflict detection system
(including new updated_deleted) is giving invalid reports because of
the issue related to SnapshotDirty vs btree. So, it is not possible to
rely on that at the moment.

You may check TAP tests here [0] and some explanation here [1] and
here [2]. Set $simulate_race_condition to disable race condition in
tests.

Invalid conflicts so far (valid/detected):
* delete_origin_differs/delete_missing
* update_origin_differs/update_missing
* update_origin_differs/update_deleted

Best regards,
Mikhail.

[0]: https://commitfest.postgresql.org/patch/5151/
[1]: https://www.postgresql.org/message-id/flat/CADzfLwWC49oanFSGPTf%3D6FJoTw-kAnpPZV8nVqAyR5KL68LrHQ%40mail.gmail.com#5f6b3be849f8d95c166decfae541df09
[2]: https://www.postgresql.org/message-id/flat/CADzfLwWuXh8KO%3DOZvB71pZnQ8nH0NYXfuGbFU6FBiVZUbmuFGg%40mail.gmail.com#76f98a9ae3479bbaf5ee9262322d466e

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Shubham Khanna 2025-08-21 09:08:33 Re: Add support for specifying tables in pg_createsubscriber.
Previous Message Hayato Kuroda (Fujitsu) 2025-08-21 08:54:44 doc patch: correct function name for slot synchronization.