View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0005133 | SymmetricDS | Bug | public | 2021-11-24 18:15 | 2021-12-11 17:11 |
| Reporter | elong | Assigned To | josh-a-hicks | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.11.0 | ||||
| Target Version | 3.12.13 | Fixed in Version | 3.12.13 | ||
| Summary | 0005133: During a full load do not ok existing batches for the same load id. | ||||
| Description | If 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. | ||||
| Tags | No tags attached. | ||||
| related to | 0005118 | closed | josh-a-hicks | During a full load do not ok existing batches for the same load id. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2021-11-24 18:15 | elong | New Issue | |
| 2021-11-24 18:15 | elong | Status | new => assigned |
| 2021-11-24 18:15 | elong | Assigned To | => josh-a-hicks |
| 2021-11-24 18:15 | elong | Issue generated from: 0005118 | |
| 2021-11-24 18:15 | elong | Relationship added | related to 0005118 |
| 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.12.13 |
| 2021-11-24 18:16 | elong | Target Version | => 3.12.13 |
| 2021-12-11 17:11 | admin | Status | resolved => closed |