View Issue Details

IDProjectCategoryView StatusLast Update
0004110SymmetricDSImprovementpublic2019-11-01 08:44
ReporterelongAssigned Toelong 
Prioritynormal 
Status closedResolutionfixed 
Product Version3.10.1 
Target Version3.10.5Fixed in Version3.10.5 
Summary0004110: Improve performance of purge stranded data
DescriptionThe stranded data purge routine can get a query timeout on large databases. (When a sym_data_event does not have a corresponding batch_id in sym_outgoing_batch, or when a sym_data does not have a corresponding data_id in sym_data_event.) Optimize the queries and delete statements used.
TagsNo tags attached.

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.10 bdcd5149

2019-10-11 10:35:42

admin

Details Diff
0004110: Improve performance of purge stranded data
0004110
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
2019-10-11 10:35 elong New Issue
2019-10-11 10:35 elong Status new => assigned
2019-10-11 10:35 elong Assigned To => elong
2019-10-11 10:37 elong Status assigned => resolved
2019-10-11 10:37 elong Resolution open => fixed
2019-10-11 10:37 elong Fixed in Version => 3.10.5
2019-10-11 11:00 admin Changeset attached => SymmetricDS 3.10 bdcd5149
2019-11-01 08:44 admin Status resolved => closed