pglogical 2.3.2 on 9.4 --> 12.3 CONFLICT: remote DELETE (tuple not found). Resolution: skip. - Mailing list pgsql-general

From milist ujang
Subject pglogical 2.3.2 on 9.4 --> 12.3 CONFLICT: remote DELETE (tuple not found). Resolution: skip.
Date
Msg-id CACG9ogxKd9f97YiTrdtcxKRS=gnNTeAU281TX9ky3qYtbDZFyA@mail.gmail.com
Whole thread Raw
Responses Re: pglogical 2.3.2 on 9.4 --> 12.3 CONFLICT: remote DELETE (tuple not found). Resolution: skip.
List pgsql-general
Configured pglogical source is 9.4 target is 12.3

a table has PK from multiple column (varchar(50),char(2),char(1)).

initial syncronization is OK, but when at source there is delete , but got error at target...

LOG:  CONFLICT: remote DELETE on relation public.a_XXXX replica identity index a_XXX_pk (tuple not found). Resolution: skip.

replica identity was set to default for the table so yes there is old image on those 3 columns:

but why delete was error at target?
collation exactly same on all GUC.

any direction to print debug verbosity on why delete on target didnt find row and skipped?



--

pgsql-general by date:

Previous
From: raf
Date:
Subject: Re: Implement a new data type
Next
From: Amul Sul
Date:
Subject: Re: Sizing PostgreSQL VM server sizing