Dealing with bdr update/update conflicts

From: Giles Westwood <giles(dot)westwood(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Dealing with bdr update/update conflicts
Date: 2015-07-08 16:10:51
Message-ID: CANYaG+0FUyYPKYOuyUqfMjm=iZ1ivSTie4Vq8TiQUsXrMk3Mbw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

I've been testing bdr over the last few days and trying to simulate
conflicts.

For an update/update conflict I powered down node a and updated on node b.
Then powered down node b and updated node a and powered node b back on.

The situation I'm left in is that replication happens one way and it's
possible for me to get each record to be identical but whenever I try and
update in the other direction it doesn't replicate and I get this entry in
the conflict history log.

conflict_id | 860
local_node_sysid | 6166345561721046825
local_conflict_xid | 4990
local_conflict_lsn | 0/CA06DD98
local_conflict_time | 2015-07-08 16:30:29.276713+00
object_schema | public
object_name | table
remote_node_sysid | 6166334043667378995
remote_txid | 3114
remote_commit_time | 2015-07-08 15:45:44.999168+00
remote_commit_lsn | 1/4104FF98
conflict_type | update_update
conflict_resolution | last_update_wins_keep_local
local_tuple |
{"table_id":1452776,"last_update_id":"xxx","password":"obs","username":"final7","acc_id":1,"last_update_time":"2015-07-08T16:16:34.854137+00:00","make_public":false}
remote_tuple |
{"table_id":1452776,"last_update_id":"xxx","password":"obs","username":"final8","acc_id":1,"last_update_time":"2015-07-08T15:45:44.994954+00:00","make_public":false}
local_tuple_xmin | 4988

--
Giles Westwood

Browse pgsql-general by date

  From Date Subject
Next Message Daniel Verite 2015-07-08 16:48:06 Re: PG 9.4.4 issue on French Windows 32 bits
Previous Message Adrian Klaver 2015-07-08 16:06:33 Re: PG 9.4.4 issue on French Windows 32 bits