none
Peer-Peer Replication RRS feed

  • Question

  • Hi Team,

    Getting below issue on Publisher in SQL 2016 Peer-Peer replication. But Subscriber is working fine:

    Cannot insert duplicate key row in object 'dbo.MSpeer_lsns' with unique index 'uci_MSpeer_lsns'. The duplicate key value is (Serverdev01, rcs, 1, 1373081981, 0x000000bd00000ef1008f).

    Message: The procedure sys.sp_MSupdatepeerlsn failed to UPDATE the resource MSpeer_lsns.. Server error = 2601.


    • Edited by VijayKSQL Thursday, December 12, 2019 10:27 PM add
    Thursday, December 12, 2019 10:26 PM

All replies

  • Hi VijayKSQL,

    Ensure you have set following two properties to TRUE in Subscription Options tab(You can found this tab in Publication Properties) :
    1. Allow peer-to-peer conflict detection
    2. Continue replication after conflict detection

    Or maybe you have mistakenly tried to insert the same row on both servers. i.e. you have inserted the row on node A & it has been replicated to node B. Now, when you will you try to insert the same row on B, you will get this error as this is already there.

    Also please refer to this blog.

    Best regards,

    Cris


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Friday, December 13, 2019 9:45 AM
  • Hi,

    These are already set to TRUE:

    1. Allow peer-to-peer conflict detection
    2. Continue replication after conflict detection

    Saturday, December 14, 2019 8:59 PM