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
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 |