View Issue Details

IDProjectCategoryView StatusLast Update
0004046SymmetricDSImprovementpublic2019-08-23 16:46
Reporterelong Assigned Toelong  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.10.0 
Target Version3.10.4Fixed in Version3.10.4 
Summary0004046: Potential bottleneck from flushing cache while processing extract requests
DescriptionThere may be a possible bottleneck in Data Extractor Service where it processes extract requests in a loop and keeps flushing the trigger cache in Trigger Router Service. Saw the following thread on a slow running system:

java.util.HashMap.hash():362
java.util.HashMap.put():492
org.jumpmind.util.LinkedCaseInsensitiveMap.put():106
org.jumpmind.db.sql.JdbcSqlReadCursor.getMapForRow():153
org.jumpmind.db.sql.JdbcSqlReadCursor.next():135
org.jumpmind.db.sql.AbstractSqlTemplate.query():205
org.jumpmind.db.sql.AbstractSqlTemplate.query():195
org.jumpmind.db.sql.AbstractSqlTemplate.query():185
org.jumpmind.db.sql.AbstractSqlTemplate.query():121
org.jumpmind.symmetric.service.impl.TriggerRouterService.getTriggers():178
org.jumpmind.symmetric.service.impl.TriggerRouterService.getTriggers():174
org.jumpmind.symmetric.service.impl.TriggerRouterService.getTriggerById():788
org.jumpmind.symmetric.service.impl.TriggerRouterService.getTriggerById():776
org.jumpmind.symmetric.service.impl.DataExtractorService.canProcessExtractRequest():1590
org.jumpmind.symmetric.service.impl.DataExtractorService.execute():1618
org.jumpmind.symmetric.service.impl.NodeCommunicationService$1.run():519
java.util.concurrent.ThreadPoolExecutor.runWorker():1145
java.util.concurrent.ThreadPoolExecutor$Worker.run():615
java.lang.Thread.run():745
TagsNo tags attached.

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.10 54745042

2019-07-17 10:36:17

admin

Details Diff
0004046: Potential bottleneck from flushing cache while processing
extract requests
Affected Issues
0004046
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataExtractorService.java Diff File

Issue History

Date Modified Username Field Change
2019-07-17 14:34 elong New Issue
2019-07-17 14:34 elong Status new => assigned
2019-07-17 14:34 elong Assigned To => elong
2019-07-17 14:36 elong Status assigned => resolved
2019-07-17 14:36 elong Resolution open => fixed
2019-07-17 14:36 elong Fixed in Version => 3.10.4
2019-07-17 15:00 admin Changeset attached => SymmetricDS 3.10 54745042
2019-08-23 16:46 admin Status resolved => closed