Re: Logical replication from 11.x to 12.x and "unique key violations"

From: Thomas Kellerer <shammat(at)gmx(dot)net>
To:
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Logical replication from 11.x to 12.x and "unique key violations"
Date: 2020-07-21 05:46:53
Message-ID: 6f6b1a8b-1e2c-e971-1b1f-d7320e81f0a5@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tom Lane schrieb am 20.07.2020 um 20:04:
> Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> writes:
>> I'm probably missing something, but would that not result in a 'key not
>> found' type of error. The OP is seeing "duplicate key value violates
>> unique constraint xxx_pkey". To me that indicates a doubling up of at
>> least some of the data replication.
>
> [ squint... ] Sorry, I completely misread the error condition.
>
> Yeah, duplicate keys does seem odd here. Can you provide a self
> contained example?

I'll try, but this is a production system.
Extracting the necessary anonymous data will be tricky.

Is there any chance the version difference might cause this?
And a slightly outdated 11.x at that?

Thomas

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Kellerer 2020-07-21 05:48:03 Re: Logical replication from 11.x to 12.x and "unique key violations"
Previous Message Thomas Kellerer 2020-07-21 05:42:41 Re: Logical replication from 11.x to 12.x and "unique key violations"