View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004661 | SymmetricDS | Improvement | public | 2020-11-24 21:56 | 2021-01-11 13:47 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.12.0 | ||||
| Target Version | 3.12.6 | Fixed in Version | 3.12.6 | ||
| Summary | 0004661: Initial load foreign key error auto resolve when foreign key missing at source | ||||
| Description | When running the initial load on a busy system, it is possible to get a missing foreign key error because each table extraction happens at different time under different transactions. If the system is very busy, it is possible for the parent row to be deleted on the source database before the auto resolution logic has a chance to send the missing parent row to the target. In this case, the row in the batch should be ignored, since there are changes in the capture log that will bring that row into consistency when replication catches up. | ||||
| Tags | initial/partial load | ||||
|
SymmetricDS: 3.12 9dc830bb 2020-11-24 21:57:36 Details Diff |
0004661: Initial load foreign key error auto resolve when foreign key missing at source |
Affected Issues 0004661 |
|
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/IDataService.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataLoaderService.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataService.java | Diff File | ||
|
SymmetricDS: 3.12 58ba7870 2020-12-09 19:54:49 Details Diff |
0004661: Initial load foreign key error auto resolve when foreign key missing at source |
Affected Issues 0004661 |
|
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/IDataService.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/AcknowledgeService.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataLoaderService.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataService.java | Diff File | ||
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/AbstractJdbcDdlReader.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2020-11-24 21:56 | elong | New Issue | |
| 2020-11-24 21:56 | elong | Status | new => assigned |
| 2020-11-24 21:56 | elong | Assigned To | => elong |
| 2020-11-24 21:56 | elong | Tag Attached: initial/partial load | |
| 2020-11-24 21:57 | elong | Status | assigned => resolved |
| 2020-11-24 21:57 | elong | Resolution | open => fixed |
| 2020-11-24 21:57 | elong | Fixed in Version | => 3.12.6 |
| 2020-11-24 21:58 | elong | Relationship added | related to 0003886 |
| 2020-11-24 22:00 | admin | Changeset attached | => SymmetricDS 3.12 9dc830bb |
| 2020-12-09 20:00 | admin | Changeset attached | => SymmetricDS 3.12 58ba7870 |
| 2021-01-11 13:47 | admin | Status | resolved => closed |