View Issue Details

IDProjectCategoryView StatusLast Update
0005118SymmetricDSBugpublic2021-12-11 17:10
Reporterjosh-a-hicks Assigned Tojosh-a-hicks  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.11.0 
Target Version3.13.1Fixed in Version3.13.1 
Summary0005118: During a full load do not ok existing batches for the same load id.
DescriptionIf a full reload is sent to the target and there is a socket time out while sending batches, the initial batches could be in a state where they were already loading into sym_incoming_batch table. Then when the load tries again it will send a sql event (as it does for all full loads) to mark any pending batches to OK before running the load.

The issue occurs because this will now ok batches in sym incoming batch for the load that is running but experienced the timeout prior to loading. Then when the batches arrive it will detect they are in sym incoming batch already and marked OK status and will skip them causing these batches to never run.

This fix is to adjust the sql that runs prior to a full load to update the status of only those batches that are not part of the same load id and not ok.
TagsNo tags attached.

Relationships

related to 0005133 closedjosh-a-hicks During a full load do not ok existing batches for the same load id. 

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.12 8dc3880d

2021-11-17 19:49:31

joshahicks

Details Diff
0005118: During a full load do not ok existing batches for the same load
id.
Affected Issues
0005118
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataService.java Diff File

SymmetricDS: 3.13 008fdb4d

2021-11-17 19:52:04

joshahicks

Details Diff
0005118: During a full load do not ok existing batches for the same load
id.
Affected Issues
0005118
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataService.java Diff File

Issue History

Date Modified Username Field Change
2021-11-10 20:58 josh-a-hicks New Issue
2021-11-10 20:58 josh-a-hicks Status new => assigned
2021-11-10 20:58 josh-a-hicks Assigned To => josh-a-hicks
2021-11-17 20:00 Changeset attached => SymmetricDS 3.12 8dc3880d
2021-11-17 20:00 Changeset attached => SymmetricDS 3.13 008fdb4d
2021-11-24 18:15 elong Issue cloned: 0005133
2021-11-24 18:15 elong Relationship added related to 0005133
2021-11-24 18:16 elong Status assigned => resolved
2021-11-24 18:16 elong Resolution open => fixed
2021-11-24 18:16 elong Fixed in Version => 3.13.1
2021-11-24 18:16 elong Target Version 3.12.13 => 3.13.1
2021-12-11 17:10 admin Status resolved => closed