[Bucardo-general] How to ignore 'duplicate key value violates unique constraint' exceptions

[Michelle Sullivan]

Sijo Pappachan wrote:
> Hi, 
>
> I have a 3 node master-master setup with conflict strategy as
> bucardo_latest. 
> All has been well, but the sync aborts on unique constraint violation
> on few tables.
>
> The error looks something like this :
>
>     Sync "dpixACsync" public."MediaObject" Reason: DBD::Pg::db
>     pg_putcopyend failed: ERROR:  duplicate key value violates unique
>     constraint "mo_uniq_path_index"
>
>

The obvious question would be, 'why?' if you have these violations then
your table is most obviously out of sync.

Regards,

Michelle

-- 
Michelle Sullivan
http://www.mhix.org/