View Issue Details

IDProjectCategoryView StatusLast Update
0004314SymmetricDSBugpublic2022-09-12 13:29
Reporterpmarzullo Assigned Tojosh-a-hicks  
Status closedResolutionfixed 
Product Version3.11.0 
Target Version3.11.8Fixed in Version3.11.8 
Summary0004314: JdbcBatchBulk: Make it work for insert conflict resolution to be able to be used on reload channel
DescriptionJdbcBatchBulkDatabaseWriter needs to implement conflict resolution completely, but this issue is for a short term fix to the insert conflict resolution.
Right now, when JdbcBatchBulkDataWriter encounters unique key exception, it falls back to the DefaultDatabaseWriter, which attempts to do an insert.
When the same unique key exception is encountered, the conflict resolution for that (fallback to update) is short circuited by the JdbcBatchBulkDatabaseWriter, and the row is marked as successful, causing the databases to remain out of synch.

Eliminating the short circuit allows the DefaultDatabaseWriter to finish its fallback to update, bringing the databases into synch.
Steps To Reproduce1. Set dataloader type to bulk for a change data capture channel.
2. Insert a record into the target system.
3. Insert a record into the source system with the same primary keys but different values in other columns.

Target will not be updated even though the batch is marked as successful.


related to 0004315 closedjosh-a-hicks JdbcBatchBulk: Make it work for all conflict resolution 
related to 0003762 closedjosh-a-hicks Bulk loader fallback to default loader and fails will mark batch ok on source when it did not load the batch. 


There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.11 352bf49f

2020-03-23 12:31:51


Details Diff
0004314: JdbcBatchBulk: Make it work for insert conflict resolution to
be able to be used on reload channel
Affected Issues
mod - symmetric-client/src/main/java/org/jumpmind/symmetric/io/ Diff File

Issue History

Date Modified Username Field Change
2020-03-13 15:17 pmarzullo New Issue
2020-03-13 15:17 pmarzullo Status new => assigned
2020-03-13 15:17 pmarzullo Assigned To => pmarzullo
2020-03-13 15:17 pmarzullo Tag Attached: bulk
2020-03-16 20:14 admin Target Version 3.11.7 => 3.11.8
2020-03-23 17:00 josh-a-hicks Changeset attached => SymmetricDS 3.11 352bf49f
2020-04-10 19:14 elong Relationship added related to 0004315
2020-04-10 19:15 elong Assigned To pmarzullo => josh-a-hicks
2020-04-10 19:15 elong Status assigned => resolved
2020-04-10 19:15 elong Resolution open => fixed
2020-04-10 19:15 elong Product Version 3.11.6 => 3.11.0
2020-04-10 19:15 elong Fixed in Version => 3.11.8
2020-04-21 19:02 admin Status resolved => closed
2022-09-12 13:29 elong Relationship added related to 0003762