View Issue Details

IDProjectCategoryView StatusLast Update
0003550SymmetricDSImprovementpublic2018-05-08 16:09
ReporterelongAssigned Toelong 
Prioritynormal 
Status closedResolutionfixed 
Product Version3.9.0 
Target Version3.9.7Fixed in Version3.9.7 
Summary0003550: Timeouts on routing query and purge service
DescriptionThe routing query is susceptible to query timeouts because it runs often (every 10 seconds) against a high contention table (sym_data). The purge query is susceptible to query timeouts because it runs against a high contention table (sym_data), and may be scheduled once a day, so it's failure to run can result in the table growing too large.

If either queries get a timeout, log it as informational and try again. If it fails a second time, then log it as an error.

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.9 569f710d

2018-05-07 12:17:33

admin

Details Diff
0003550: Timeouts on routing query and purge service
0003550
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/route/DataGapRouteReader.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/PurgeService.java Diff File

SymmetricDS: 3.9 8afd6c3d

2018-05-07 14:04:19

admin

Details Diff
0003550: Timeouts on routing query and purge service
0003550
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/route/DataGapRouteReader.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/PurgeService.java Diff File

Issue History

Date Modified Username Field Change
2018-05-07 11:26 elong New Issue
2018-05-07 11:26 elong Status new => assigned
2018-05-07 11:26 elong Assigned To => elong
2018-05-07 12:17 elong Status assigned => resolved
2018-05-07 12:17 elong Resolution open => fixed
2018-05-07 12:17 elong Fixed in Version => 3.9.7
2018-05-07 13:00 admin Changeset attached => SymmetricDS 3.9 569f710d
2018-05-07 15:00 admin Changeset attached => SymmetricDS 3.9 8afd6c3d
2018-05-08 16:09 mmichalek Status resolved => closed