View Issue Details

IDProjectCategoryView StatusLast Update
0005439SymmetricDSBugpublic2022-10-04 15:15
Reporterjvanmeter Assigned Tojvanmeter  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.14.0 
Target Version3.14.2Fixed in Version3.14.2 
Summary0005439: Conflict resolver fails if there are no primary keys on the target and it is set to not use primary keys from source
DescriptionIf the dataloader.use.primary.keys.from.source is set to false, and the target has no primary keys, the Conflict Resolution fails. This happens because when it gets into the Conflict Resolver, it attempts to create a where clause using the target table primary keys, however in this case there are none, resulting in an empty where clause that throws a sql error.
Steps To ReproduceSetup Two nodes, Source and a Load-Only Target
Source table with no primary keys
Target table with no primary keys
Set dataloader.use.primary.keys.from.source to false
Create a conflict. Can achieve this by stopping the pull job on the target, update a row on the target and then updating the same row with different data on the source and then starting the pull job on the target again.
Tagsconflict manager

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.14 e9a4283c

2022-09-06 17:59:31

jakobvanmeter

Details Diff
0005439: Conflict resolver fails if there are no primary keys on the
target and it is set to not use primary keys from source
Affected Issues
0005439
mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/writer/DefaultDatabaseWriter.java Diff File

Issue History

Date Modified Username Field Change
2022-09-06 17:58 jvanmeter New Issue
2022-09-06 17:58 jvanmeter Status new => assigned
2022-09-06 17:58 jvanmeter Assigned To => jvanmeter
2022-09-06 17:58 jvanmeter Tag Attached: conflict manager
2022-09-06 17:59 jvanmeter Status assigned => resolved
2022-09-06 17:59 jvanmeter Resolution open => fixed
2022-09-06 17:59 jvanmeter Fixed in Version => 3.14.2
2022-09-06 18:00 Changeset attached => SymmetricDS 3.14 e9a4283c
2022-10-04 15:15 admin Status resolved => closed