View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004314 | SymmetricDS | Bug | public | 2020-03-13 15:17 | 2022-09-12 13:29 |
| Reporter | pmarzullo | Assigned To | josh-a-hicks | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.11.0 | ||||
| Target Version | 3.11.8 | Fixed in Version | 3.11.8 | ||
| Summary | 0004314: JdbcBatchBulk: Make it work for insert conflict resolution to be able to be used on reload channel | ||||
| Description | JdbcBatchBulkDatabaseWriter 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 Reproduce | 1. 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. | ||||
| Tags | bulk | ||||
| related to | 0004315 | closed | josh-a-hicks | JdbcBatchBulk: Make it work for all conflict resolution |
| related to | 0003762 | closed | josh-a-hicks | Bulk loader fallback to default loader and fails will mark batch ok on source when it did not load the batch. |
| 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 |