View Issue Details

IDProjectCategoryView StatusLast Update
0004088SymmetricDSBugpublic2019-09-13 15:00
ReporterelongAssigned Toelong 
Prioritynormal 
Status resolvedResolutionfixed 
Product Version3.10.0 
Target Version3.10.5Fixed in Version3.10.5 
Summary0004088: Failed to delete blocking row
DescriptionThe data loader has auto resolution logic to remove a blocking row that can fail for a couple reasons.

1) It fails to delete a blocking row when one of the column values are NULL in the unique constraint.

Failed to find and delete the blocking row by unique constraint: DELETE from testfallback where ID = ? and NAME = ? {1,null}

2) It fails to delete a blocking row when an extra primary key column is sent from the source that doesn't exist on the target. This can cause misleading logging, where it uses the wrong column value and possibly a conversion error.
TagsNo tags attached.

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.10 e1d08151

2019-09-13 14:01:40

admin

Details Diff
0004088: Failed to delete blocking row
0004088
mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/writer/DefaultDatabaseWriterConflictResolver.java Diff File

Issue History

Date Modified Username Field Change
2019-09-13 14:00 elong New Issue
2019-09-13 14:00 elong Status new => assigned
2019-09-13 14:00 elong Assigned To => elong
2019-09-13 14:02 elong Status assigned => resolved
2019-09-13 14:02 elong Resolution open => fixed
2019-09-13 14:02 elong Fixed in Version => 3.10.5
2019-09-13 15:00 admin Changeset attached => SymmetricDS 3.10 e1d08151