|
|
source.png (5,697 bytes) target.png (5,452 bytes) |
|
|
If the source node of the changed row was updated more recently than the local row, then the source row will win the conflict. This is working as designed. |
|
|
Yes, that's the point, but in my case, the target node win the conflict ! When the incoming row is received on the target node, a "useless" update seems to be executed on the target table (you can see the state of the sym_data table on target.png). This update is obviously more recent than the source row and distorts the timestamp comparison. |
|
|
Maybe I misundestood something. To be more precise, the table base.agent is initially in the following state on each node : -------------------------- Source codeAgent : 01641 nomAgent : ETA -------------------------- Target codeAgent : 01641 nomAgent : ETO I execute the following query on the source node : Update base.agent set nomAgent = ‘ETU’ where codeAgent = ‘01641’ ; A conflict is detected on the target node and the change is not applied. |
|
|
Here are the exact steps that I executed to show that the conflict resolution is correct. Set up synchronization using H2 databases for both source and target. If you use a different database, see how to disable data capture for your specific database: https://support.jumpmind.com/kb/article/23-Disabling-Sync-Triggers-for-Session 1. Source node: insert into agent (codeAgent, nomAgent) values('01641', 'ETA'); 2. Allow the record to synch to the target 3. Target node:s select * from agent; -- Make sure ETA is set as the nomAgent 4. Target node: set auto commit to false 5. Disable capturing data changes on the target node Target node: set @sync_prevented=1; 5. Update agent table record to ETO Target node: update agent set nomAgent='ETO' where codeAgent='01641'; 6. Start capturing data changes on the target node Target node: set @sync_prevented=null; 7. Commit changes on target node Target node: commit; 8.Update agent on source node update agent set nomAgent='ETU' where codeAgent='01641'; 9. Wait for synchronization to target node Target node: select * from agent where nodeAgent='01641'; Target node will have nomAgent='ETU' for codeAgent='01641' |
- Anonymous