View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0006987 | SymmetricDS | Bug | public | 2025-07-07 13:10 | 2025-08-07 15:49 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.16.0 | ||||
| Target Version | 3.16.5 | Fixed in Version | 3.16.5 | ||
| Summary | 0006987: Suppress first error when auto-resolving lines in batch (foreign key or deadlock), escalate on second error for the same line | ||||
| Description | Currently, when the user sees a batch with the Foreign Key error (or a deadlock error), they think they need to intervene. The SymmetricDS (versions 3.14 and higher) already has logic to auto-resolve such data problems. For foreign key errors it requests missing "parent" row data from the source node and recovers from most such errors automatically. Some batches have multiple foreign key errors (not all on the same row), which can take some time to auto-resolve, but does not require intervention. Change: Suppress the first occurrence of a batch foreign key error so the auto resolver has a chance to recover from the error. Log the line number of the batch with the error, so it is easy to see the batch is advancing (in the logs). The batch tables should show a status of LD and an error flag of 0. The process info should also be OK without a batch number to prevent the web console screens from displaying an indication of an error - until error is sustained (unsolvable). | ||||
| Tags | data sync | ||||
|
SymmetricDS: 3.16 c894fa8f 2025-07-14 16:22:58 Committer: GitHub Details Diff |
0006987: Suppress first foreign key error when auto resolving (#319) |
Affected Issues 0006987 |
|
| 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/ManageIncomingBatchListener.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/transport/AbstractTransportManager.java | Diff File | ||
| mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/writer/DefaultDatabaseWriter.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2025-07-07 13:10 | elong | New Issue | |
| 2025-07-07 13:10 | elong | Status | new => assigned |
| 2025-07-07 13:10 | elong | Assigned To | => elong |
| 2025-07-07 13:10 | elong | Tag Attached: data sync | |
| 2025-07-07 13:11 | elong | Relationship added | related to 0004538 |
| 2025-07-07 13:15 | elong | Status | assigned => resolved |
| 2025-07-07 13:15 | elong | Resolution | open => fixed |
| 2025-07-07 13:15 | elong | Fixed in Version | => 3.16.5 |
| 2025-07-07 16:32 | elong | Project | SymmetricDS Pro => SymmetricDS |
| 2025-07-11 19:52 | pbelov | Summary | Suppress first foreign key error when auto resolving => Suppress first foreign key error when auto resolving lines in batch |
| 2025-07-11 19:52 | pbelov | Description Updated | View Revisions |
| 2025-07-14 16:26 | pbelov | Summary | Suppress first foreign key error when auto resolving lines in batch => Suppress first error when auto-resolving lines in batch (foreign key or deadlock), escalate on second error for the same line |
| 2025-07-14 16:26 | pbelov | Description Updated | View Revisions |
| 2025-07-14 17:00 | elong | Changeset attached | => SymmetricDS 3.16 c894fa8f |
| 2025-08-07 15:49 | pbelov | Note Added: 0003304 | |
| 2025-08-07 15:49 | pbelov | Status | resolved => closed |