View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004798 | SymmetricDS | Bug | public | 2021-01-28 20:57 | 2021-02-25 21:33 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.12.0 | ||||
| Target Version | 3.12.7 | Fixed in Version | 3.12.7 | ||
| Summary | 0004798: No data found while correcting foreign key error for reload batch | ||||
| Description | If 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. | ||||
| Tags | initial/partial load | ||||
|
SymmetricDS: 3.12 ebb58650 2021-01-28 20:58:42 Details Diff |
0004798: No data found while correcting foreign key error for reload batch |
Affected Issues 0004798 |
|
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataService.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataServiceSqlMap.java | Diff File | ||
| 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 |