View Issue Details

IDProjectCategoryView StatusLast Update
0006981SymmetricDSBugpublic2025-08-07 15:49
Reporterelong Assigned Toelong  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.14.0 
Target Version3.16.5Fixed in Version3.16.5 
Summary0006981: Reload batches from auto resolver get foreign key error
DescriptionWhen 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.
Tagsdata sync

Activities

pbelov

2025-08-07 15:49

manager   ~0003305

Included in the 3.16.5 release

Related Changesets

SymmetricDS: 3.16 df51a9ec

2025-07-14 15:09:27

elong


Committer: GitHub Details Diff
0006981: Reload batches from auto resolver get foreign key error (#318)

* 0006981: Reload batches from auto resolver get foreign key error
Affected Issues
0006981
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataService.java Diff File

Issue History

Date Modified Username Field Change
2025-06-30 19:57 elong New Issue
2025-06-30 19:57 elong Status new => assigned
2025-06-30 19:57 elong Assigned To => elong
2025-06-30 19:57 elong Tag Attached: data sync
2025-07-01 15:16 pbelov Target Version 3.16.4 => 3.16.5
2025-07-07 12:50 elong Status assigned => resolved
2025-07-07 12:50 elong Resolution open => fixed
2025-07-07 12:50 elong Fixed in Version => 3.16.5
2025-07-14 16:00 elong Changeset attached => SymmetricDS 3.16 df51a9ec
2025-08-07 15:49 pbelov Note Added: 0003305
2025-08-07 15:49 pbelov Status resolved => closed