(node1のデータベースログ)
bdr (6371561413984311673,2,42879,):receive LOG: starting logical decoding for slot
"bdr_42892_6371561413984311673_2_42879__"
bdr (6371561413984311673,2,42879,):receive DETAIL: streaming transactions committing
after 1/15D41640, reading WAL from 1/15D413B0
bdr (6371561413984311673,2,42879,):receive LOG: logical decoding found consistent point
at 1/15D413B0
bdr (6371561413984311673,2,42879,):receive DETAIL: There are no running transactions.
bdr (6371561413984311673,2,42879,):receive LOG: unexpected EOF on standby connection
LOG: starting background worker process "bdr (6371553825031594764,1,42892,)->bdr
(6371561413984311673,2,"
ERROR: conflicting key value violates exclusion constraint "sample_price_range_excl"
DETAIL: Key (price, range)=(10000, [2012-04-18,2012-04-24)) conflicts with existing key
(price, range)=(10000, [2012-04-16,2012-04-21)).
CONTEXT: apply INSERT from remote relation public.sample in commit 1/194FBC20, xid
3940666 commited at 2017-01-06 16:12:28.275376+09 (action #2) from node
(6371561413984311673,2,42879)
LOG: worker process: bdr (6371553825031594764,1,42892,)->bdr (6371561413984311673,2,
(PID 27843) exited with exit code 1
(node2のデータベースログ)
LOG: starting background worker process "bdr (6371561413984311673,2,42879,)->bdr
(6371553825031594764,1,"
ERROR: conflicting key value violates exclusion constraint "sample_price_range_excl"
DETAIL: Key (price, range)=(10000, [2012-04-16,2012-04-21)) conflicts with existing key
(price, range)=(10000, [2012-04-18,2012-04-24)).
CONTEXT: apply INSERT from remote relation public.sample in commit 1/15D41640, xid
3957701 commited at 2017-01-06 16:09:10.299493+09 (action #2) from node
(6371553825031594764,1,42892)
LOG: worker process: bdr (6371561413984311673,2,42879,)->bdr (6371553825031594764,1,
(PID 29311) exited with exit code 1
bdr (6371553825031594764,1,42892,):receive LOG: starting logical decoding for slot
"bdr_42879_6371553825031594764_1_42892__"
bdr (6371553825031594764,1,42892,):receive DETAIL: streaming transactions committing
after 1/194FB9D0, reading WAL from 1/194FB700
bdr (6371553825031594764,1,42892,):receive LOG: logical decoding found consistent point
at 1/194FB700
bdr (6371553825031594764,1,42892,):receive DETAIL: There are no running transactions.
bdr (6371553825031594764,1,42892,):receive LOG: unexpected EOF on standby connection
※ 各ノードで制約違反が発生し、BDRによる接続が切断されてしまう。解消のためリモートタプルが競合するローカルタプルを削除または変更する
制約違反の状態を解消するために、両側のデータをUPDATEします。
(node1のデータベースにSQLを投入)
=# UPDATE sample SET range = '[2012-04-11,2012-04-16]' WHERE aid = 1;
(node2のデータベースにSQLを投入)
=# UPDATE sample SET range = '[2012-04-23,2012-04-29]' WHERE aid = 2;