View Issue Details

IDProjectCategoryView StatusLast Update
0003723SymmetricDSImprovementpublic2018-09-13 18:00
ReporterelongAssigned Toelong 
Priorityurgent 
Status resolvedResolutionfixed 
Product Version3.9.0 
Target Version3.9.14Fixed in Version3.9.14 
Summary0003723: Purge stranded batches can get deadlock or timeout when outgoing_batches is large
DescriptionWhen 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).

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.9 2926a7df

2018-09-13 17:44:35

admin

Details Diff
0003723: Purge stranded batches can get deadlock or timeout when
outgoing_batches is large

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

Issue History

Date Modified Username Field Change
2018-09-13 16:12 elong New Issue
2018-09-13 16:12 elong Status new => assigned
2018-09-13 16:12 elong Assigned To => elong
2018-09-13 16:31 elong Status assigned => resolved
2018-09-13 16:31 elong Resolution open => fixed
2018-09-13 16:31 elong Fixed in Version => 3.9.14
2018-09-13 18:00 admin Changeset attached => SymmetricDS 3.9 2926a7df