View Issue Details

IDProjectCategoryView StatusLast Update
0004185SymmetricDSBugpublic2019-12-09 17:27
Reporterelong Assigned Toelong  
Status closedResolutionfixed 
Product Version3.11.0 
Target Version3.11.2Fixed in Version3.11.2 
Summary0004185: Incorrect resolver behavior: Failed to find and delete the blocking row
DescriptionIncorrect resolver behavior when two conflicts occur in the same batch and the second conflict is caused by an UPDATE that affects zero rows.

ERROR [client-1] [DefaultDatabaseWriterConflictResolver] [client-1-dataloader-22] Failed to find and delete the blocking row by primary key: DELETE from "DB"."PUBLIC"."MYTEST" where "ID" = ? {2}

For example, a batch that contains an INSERT for a row that already exists, followed by an UPDATE to a row that does not exist. The first conflict gets an exception, but the exception is not cleared from memory. On the second conflict, there is no exception from the database, so it incorrectly uses the first exception to determine its behavior.
Additional InformationEven with the ugly error message in the log, the data does still manage to get synced correctly.
TagsNo tags attached.


related to 0004184 closedelong Incorrect resolver behavior: Failed to find and delete the blocking row 


There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2019-12-05 17:55 elong New Issue
2019-12-05 17:55 elong Status new => assigned
2019-12-05 17:55 elong Assigned To => elong
2019-12-05 17:55 elong Issue generated from: 0004184
2019-12-05 17:55 elong Relationship added related to 0004184
2019-12-05 18:06 elong Status assigned => resolved
2019-12-05 18:06 elong Resolution open => fixed
2019-12-05 18:06 elong Fixed in Version => 3.11.2
2019-12-09 17:27 admin Status resolved => closed