View Issue Details

IDProjectCategoryView StatusLast Update
0004798SymmetricDSBugpublic2021-02-25 21:33
Reporterelong Assigned Toelong  
Status closedResolutionfixed 
Product Version3.12.0 
Target Version3.12.7Fixed in Version3.12.7 
Summary0004798: No data found while correcting foreign key error for reload batch
DescriptionIf a reload batch in the initial load gets a foreign key error, the client will request the missing foreign key rows:

INFO [client-4] [DataService] [qtp1377301456-20] Requesting missing foreign key rows for batch server-1-378 row 542 for table child_table

If there are multiple batches associated with the same table (initial load extract is enabled), then server can't look up the sym_data row that it needs for the table name and trigger_hist:

WARN [server-1] [DataService] [server-1-dataloader-4] Unable to correct missing foreign key error in batch client-4-378 row 542 because no data found

Which leaves the batch stuck with a foreign key error. There was an optimization made where only the first batch in the series has the sym_data row populated, so it needs to use the sym_extract_request table to find that batch.
Tagsinitial/partial load


There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.12 ebb58650

2021-01-28 20:58:42


Details Diff
0004798: No data found while correcting foreign key error for reload
Affected Issues
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/ Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/ Diff File

Issue History

Date Modified Username Field Change
2021-01-28 20:57 elong New Issue
2021-01-28 20:57 elong Status new => assigned
2021-01-28 20:57 elong Assigned To => elong
2021-01-28 20:57 elong Tag Attached: initial/partial load
2021-01-28 20:59 elong Status assigned => resolved
2021-01-28 20:59 elong Resolution open => fixed
2021-01-28 20:59 elong Fixed in Version => 3.12.7
2021-01-28 21:00 admin Changeset attached => SymmetricDS 3.12 ebb58650
2021-02-25 21:33 admin Status resolved => closed