View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004046 | SymmetricDS | Improvement | public | 2019-07-17 14:34 | 2019-08-23 16:46 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.10.0 | ||||
| Target Version | 3.10.4 | Fixed in Version | 3.10.4 | ||
| Summary | 0004046: Potential bottleneck from flushing cache while processing extract requests | ||||
| Description | There 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 | ||||
| Tags | No tags attached. | ||||
| 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 |