Re: Dupe Key Violations in Logical Replication with PKs in Place

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: Don Seiler <don(at)seiler(dot)us>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Dupe Key Violations in Logical Replication with PKs in Place
Date: 2023-11-14 18:02:47
Message-ID: DBF3465E-49A1-4F72-8795-3B98229EE04D@elevated-dev.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> On Nov 14, 2023, at 10:54 AM, Don Seiler <don(at)seiler(dot)us> wrote:
>
> Well this looks to be human error/cause after all. I made the mistake of announcing the upcoming migration and one eager developer connected to the new/subscription DB and ran some inserts (also running them on the old/publication DB). The inserts were all in one transaction, and look to be responsible for all 3 of duplicate key incidents.

So this would be about the 2 billionth or so episode in the DBA series titled "shit happens" ;-) Glad you figured it out.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Don Seiler 2023-11-14 18:19:54 Re: Dupe Key Violations in Logical Replication with PKs in Place
Previous Message Don Seiler 2023-11-14 17:54:58 Re: Dupe Key Violations in Logical Replication with PKs in Place