View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0006981 | SymmetricDS | Bug | public | 2025-06-30 19:57 | 2025-06-30 19:57 |
Reporter | elong | Assigned To | elong | ||
Priority | normal | ||||
Status | assigned | Resolution | open | ||
Product Version | 3.14.0 | ||||
Target Version | 3.16.4 | ||||
Summary | 0006981: Reload batches from auto resolver get foreign key error | ||||
Description | When a data batch gets a missing parent foreign key error, the auto resolver runs on the source to create reload batches with the missing data. If the rows in the reload batches have foreign key dependencies with each other, the rows must load in the correct error, otherwise a foreign key error is encountered. Sort the auto resolve data by the foreign key dependencies. Example: A depends on B and C B depends on C Data batch with A tries to load and gets FK error. The source creates a reload batch with the needed rows from B and C in that order. The batch for B will fail because the row for C is missing and not yet loaded. | ||||
Tags | data sync | ||||