View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0003723 | SymmetricDS | Improvement | public | 2018-09-13 20:12 | 2018-09-13 22:00 |
| Reporter | elong | Assigned To | elong | ||
| Priority | urgent | ||||
| Status | resolved | Resolution | fixed | ||
| Product Version | 3.9.0 | ||||
| Target Version | 3.9.14 | Fixed in Version | 3.9.14 | ||
| Summary | 0003723: Purge stranded batches can get deadlock or timeout when outgoing_batches is large | ||||
| Description | When sym_outgoing_batch table grows too large, the purge job gets either a deadlock or timeout when trying to update batches to OK that are associated with old channels and old nodes. The error is possible even when the update will get 0 rows affected. Make the SQL more efficient by getting a list of channels (or nodes) with abandoned batches, then deleting by channel (or node). | ||||
| Tags | No tags attached. | ||||
|
SymmetricDS: 3.9 2926a7df 2018-09-13 17:44:35 Details Diff |
0003723: Purge stranded batches can get deadlock or timeout when outgoing_batches is large |
Affected Issues 0003723 |
|
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/PurgeService.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/PurgeServiceSqlMap.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2018-09-13 20:12 | elong | New Issue | |
| 2018-09-13 20:12 | elong | Status | new => assigned |
| 2018-09-13 20:12 | elong | Assigned To | => elong |
| 2018-09-13 20:31 | elong | Status | assigned => resolved |
| 2018-09-13 20:31 | elong | Resolution | open => fixed |
| 2018-09-13 20:31 | elong | Fixed in Version | => 3.9.14 |
| 2018-09-13 22:00 | admin | Changeset attached | => SymmetricDS 3.9 2926a7df |