{"action":"created","issue":{"url":"https://api.github.com/repos/brettwooldridge/HikariCP/issues/764","repository_url":"https://api.github.com/repos/brettwooldridge/HikariCP","labels_url":"https://api.github.com/repos/brettwooldridge/HikariCP/issues/764/labels{/name}","comments_url":"https://api.github.com/repos/brettwooldridge/HikariCP/issues/764/comments","events_url":"https://api.github.com/repos/brettwooldridge/HikariCP/issues/764/events","html_url":"https://github.com/brettwooldridge/HikariCP/issues/764","id":190004027,"number":764,"title":"In HikariCP jobs get failed due to stale threads","user":{"login":"Sunshine-23","id":23521045,"avatar_url":"https://avatars.githubusercontent.com/u/23521045?v=3","gravatar_id":"","url":"https://api.github.com/users/Sunshine-23","html_url":"https://github.com/Sunshine-23","followers_url":"https://api.github.com/users/Sunshine-23/followers","following_url":"https://api.github.com/users/Sunshine-23/following{/other_user}","gists_url":"https://api.github.com/users/Sunshine-23/gists{/gist_id}","starred_url":"https://api.github.com/users/Sunshine-23/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Sunshine-23/subscriptions","organizations_url":"https://api.github.com/users/Sunshine-23/orgs","repos_url":"https://api.github.com/users/Sunshine-23/repos","events_url":"https://api.github.com/users/Sunshine-23/events{/privacy}","received_events_url":"https://api.github.com/users/Sunshine-23/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2016-11-17T10:25:00Z","updated_at":"2016-11-17T14:14:01Z","closed_at":null,"body":"Hi,\r\nI have recently switched my project to HikariCP. When I run multiple jobs paralelly on the server, random jobs gets failed with below error. I tried to change the HikariCP configurations by changing idleTimeout to 2 mins to remove the stale threads but it didn't helped me. \r\n\r\njava.lang.IllegalStateException: Cannot cancel cache update - current state (1) is not UPDATE_IN_PROGRESS\r\n\tat com.opensymphony.oscache.base.EntryUpdateState.cancelUpdate(EntryUpdateState.java:91) ~[oscache-2.3.jar:2.3]\r\n\tat com.opensymphony.oscache.base.Cache.cancelUpdate(Cache.java:386) ~[oscache-2.3.jar:2.3]\r\n\tat com.opensymphony.oscache.general.GeneralCacheAdministrator.cancelUpdate(GeneralCacheAdministrator.java:184) ~[oscache-2.3.jar:2.3]\r\n\tat com.tcs.bfsarch.caching.OSCacheManagerImpl.getCacheObject(OSCacheManagerImpl.java:227) ~[core.jar:?]\r\n\tat com.tcs.bfsarch.caching.AbstractCacheManager.getCacheObject(AbstractCacheManager.java:118) ~[core.jar:?]\r\n\tat com.tcs.bfsarch.springbatch.utils.SpringBatchServiceInfoManager.getServiceInfo(SpringBatchServiceInfoManager.java:155) ~[springbatch.jar:?]\r\n\tat com.tcs.bfsarch.springbatch.writers.WriterAdapter.setWorkFlowData(WriterAdapter.java:772) [springbatch.jar:?]\r\n\tat com.tcs.bfsarch.springbatch.writers.WriterAdapter.initWorkFlow(WriterAdapter.java:749) [springbatch.jar:?]\r\n\tat com.tcs.bfsarch.springbatch.writers.WriterAdapter.initialize(WriterAdapter.java:670) [springbatch.jar:?]\r\n\tat com.tcs.bfsarch.springbatch.writers.WriterAdapter$2.doInTransactionWithoutResult(WriterAdapter.java:355) [springbatch.jar:?]\r\n\tat org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:34) [spring-tx-4.0.2.RELEASE.jar:4.0.2.RELEASE]\r\n\tat org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:133) [spring-tx-4.0.2.RELEASE.jar:4.0.2.RELEASE]\r\n\tat com.tcs.bfsarch.springbatch.writers.WriterAdapter.beforeStep(WriterAdapter.java:346) [springbatch.jar:?]\r\n\tat org.springframework.batch.core.listener.CompositeStepExecutionListener.beforeStep(CompositeStepExecutionListener.java:77) [spring-batch-core-2.2.5.RELEASE.jar:?]\r\n\tat org.springframework.batch.core.step.AbstractStep.execute(AbstractStep.java:191) [spring-batch-core-2.2.5.RELEASE.jar:?]\r\n\tat org.springframework.batch.core.job.SimpleStepHandler.handleStep(SimpleStepHandler.java:137) [spring-batch-core-2.2.5.RELEASE.jar:?]\r\n\tat org.springframework.batch.core.job.flow.JobFlowExecutor.executeStep(JobFlowExecutor.java:64) [spring-batch-core-2.2.5.RELEASE.jar:?]\r\n\tat org.springframework.batch.core.job.flow.support.state.StepState.handle(StepState.java:60) [spring-batch-core-2.2.5.RELEASE.jar:?]\r\n\tat org.springframework.batch.core.job.flow.support.SimpleFlow.resume(SimpleFlow.java:152) [spring-batch-core-2.2.5.RELEASE.jar:?]\r\n\tat org.springframework.batch.core.job.flow.support.SimpleFlow.start(SimpleFlow.java:131) [spring-batch-core-2.2.5.RELEASE.jar:?]\r\n\tat org.springframework.batch.core.job.flow.support.state.SplitState$1.call(SplitState.java:93) [spring-batch-core-2.2.5.RELEASE.jar:?]\r\n\tat org.springframework.batch.core.job.flow.support.state.SplitState$1.call(SplitState.java:90) [spring-batch-core-2.2.5.RELEASE.jar:?]\r\n\tat java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:1.8.0_91]\r\n\tat java.lang.Thread.run(Thread.java:745) [?:1.8.0_91]\r\n\r\nIn logger HikariCP configuration is set as below \r\n\r\n2016-11-17|12:02:11,404|INFO |main|com.zaxxer.hikari.pool.PoolBase:469||SchedulerDataSourceConnectionPool - Driver does not support get/set network timeout for connections. (oracle.jdbc.driver.T4CConnection.getNetworkTimeout()I)|\r\n2016-11-17|12:02:11,608|WARN |main|com.zaxxer.hikari.HikariConfig:804||SchedulerDataSourceConnectionPool - idleTimeout is close to or more than maxLifetime, disabling it.|\r\n2016-11-17|12:02:11,609|DEBUG|main|com.zaxxer.hikari.HikariConfig:841||SchedulerDataSourceConnectionPool - configuration:|\r\n2016-11-17|12:02:11,612|DEBUG|main|com.zaxxer.hikari.HikariConfig:857||allowPoolSuspension.............false|\r\n2016-11-17|12:02:11,613|DEBUG|main|com.zaxxer.hikari.HikariConfig:857||autoCommit......................true|\r\n2016-11-17|12:02:11,613|DEBUG|main|com.zaxxer.hikari.HikariConfig:857||catalog.........................null|\r\n2016-11-17|12:02:11,613|DEBUG|main|com.zaxxer.hikari.HikariConfig:857||connectionInitSql...............null|\r\n2016-11-17|12:02:11,614|DEBUG|main|com.zaxxer.hikari.HikariConfig:857||connectionTestQuery.............\"SELECT 1 FROM DUAL\"|\r\n2016-11-17|12:02:11,614|DEBUG|main|com.zaxxer.hikari.HikariConfig:857||connectionTimeout...............30000|\r\n2016-11-17|12:02:11,614|DEBUG|main|com.zaxxer.hikari.HikariConfig:857||dataSource......................null|\r\n2016-11-17|12:02:11,614|DEBUG|main|com.zaxxer.hikari.HikariConfig:857||dataSourceClassName.............\"oracle.jdbc.pool.OracleDataSource\"|\r\n2016-11-17|12:02:11,615|DEBUG|main|com.zaxxer.hikari.HikariConfig:857||dataSourceJNDI..................null|\r\n2016-11-17|12:02:11,616|DEBUG|main|com.zaxxer.hikari.HikariConfig:857||dataSourceProperties............{user=tcsdev, maxStatements=200, url=jdbc:oracle:thin:@10.33.131.34:1522:bancsdev, password=<masked>, implicitCachingEnabled=true}|\r\n2016-11-17|12:02:11,616|DEBUG|main|com.zaxxer.hikari.HikariConfig:857||driverClassName.................null|\r\n2016-11-17|12:02:11,616|DEBUG|main|com.zaxxer.hikari.HikariConfig:857||healthCheckProperties...........{}|\r\n2016-11-17|12:02:11,617|DEBUG|main|com.zaxxer.hikari.HikariConfig:857||healthCheckRegistry.............null|\r\n2016-11-17|12:02:11,617|DEBUG|main|com.zaxxer.hikari.HikariConfig:857||idleTimeout.....................0|\r\n2016-11-17|12:02:11,617|DEBUG|main|com.zaxxer.hikari.HikariConfig:857||initializationFailFast..........true|\r\n2016-11-17|12:02:11,617|DEBUG|main|com.zaxxer.hikari.HikariConfig:857||isolateInternalQueries..........false|\r\n2016-11-17|12:02:11,618|DEBUG|main|com.zaxxer.hikari.HikariConfig:857||jdbc4ConnectionTest.............false|\r\n2016-11-17|12:02:11,618|DEBUG|main|com.zaxxer.hikari.HikariConfig:857||jdbcUrl.........................null|\r\n2016-11-17|12:02:11,618|DEBUG|main|com.zaxxer.hikari.HikariConfig:857||leakDetectionThreshold..........0|\r\n2016-11-17|12:02:11,618|DEBUG|main|com.zaxxer.hikari.HikariConfig:857||maxLifetime.....................600000|\r\n2016-11-17|12:02:11,619|DEBUG|main|com.zaxxer.hikari.HikariConfig:857||maximumPoolSize.................18|\r\n2016-11-17|12:02:11,619|DEBUG|main|com.zaxxer.hikari.HikariConfig:857||metricRegistry..................null|\r\n2016-11-17|12:02:11,619|DEBUG|main|com.zaxxer.hikari.HikariConfig:857||metricsTrackerFactory...........null|\r\n2016-11-17|12:02:11,619|DEBUG|main|com.zaxxer.hikari.HikariConfig:857||minimumIdle.....................18|\r\n2016-11-17|12:02:11,619|DEBUG|main|com.zaxxer.hikari.HikariConfig:857||password........................<masked>|\r\n2016-11-17|12:02:11,620|DEBUG|main|com.zaxxer.hikari.HikariConfig:857||poolName........................\"SchedulerDataSourceConnectionPool\"|\r\n2016-11-17|12:02:11,620|DEBUG|main|com.zaxxer.hikari.HikariConfig:857||readOnly........................false|\r\n2016-11-17|12:02:11,620|DEBUG|main|com.zaxxer.hikari.HikariConfig:857||registerMbeans..................false|\r\n2016-11-17|12:02:11,620|DEBUG|main|com.zaxxer.hikari.HikariConfig:857||scheduledExecutorService........null|\r\n2016-11-17|12:02:11,621|DEBUG|main|com.zaxxer.hikari.HikariConfig:857||threadFactory...................null|\r\n2016-11-17|12:02:11,621|DEBUG|main|com.zaxxer.hikari.HikariConfig:857||transactionIsolation............null|\r\n2016-11-17|12:02:11,621|DEBUG|main|com.zaxxer.hikari.HikariConfig:857||username........................null|\r\n2016-11-17|12:02:11,621|DEBUG|main|com.zaxxer.hikari.HikariConfig:857||validationTimeout...............5000|\r\n2016-11-17|12:02:11,622|INFO |main|com.zaxxer.hikari.HikariDataSource:70||SchedulerDataSourceConnectionPool - Started.|\r\n2016-11-17|12:02:11,651|WARN |main|com.zaxxer.hikari.HikariConfig:804||SchedulerDataSourceConnectionPool - idleTimeout is close to or more than maxLifetime, disabling it.|\r\n2016-11-17|12:02:11,652|DEBUG|main|com.zaxxer.hikari.HikariConfig:841||SchedulerDataSourceConnectionPool - configuration:|\r\n2016-11-17|12:02:11,654|DEBUG|main|com.zaxxer.hikari.HikariConfig:857||allowPoolSuspension.............false|\r\n2016-11-17|12:02:11,659|DEBUG|main|com.zaxxer.hikari.HikariConfig:857||autoCommit......................true|\r\n2016-11-17|12:02:11,660|DEBUG|main|com.zaxxer.hikari.HikariConfig:857||catalog.........................null|\r\n2016-11-17|12:02:11,660|DEBUG|main|com.zaxxer.hikari.HikariConfig:857||connectionInitSql...............null|\r\n2016-11-17|12:02:11,660|DEBUG|main|com.zaxxer.hikari.HikariConfig:857||connectionTestQuery.............\"SELECT 1 FROM DUAL\"|\r\n2016-11-17|12:02:11,661|DEBUG|main|com.zaxxer.hikari.HikariConfig:857||connectionTimeout...............30000|\r\n2016-11-17|12:02:11,661|DEBUG|main|com.zaxxer.hikari.HikariConfig:857||dataSource......................null|\r\n2016-11-17|12:02:11,661|DEBUG|main|com.zaxxer.hikari.HikariConfig:857||dataSourceClassName.............\"oracle.jdbc.pool.OracleDataSource\"|\r\n2016-11-17|12:02:11,661|DEBUG|main|com.zaxxer.hikari.HikariConfig:857||dataSourceJNDI..................null|\r\n2016-11-17|12:02:11,672|DEBUG|main|com.zaxxer.hikari.HikariConfig:857||dataSourceProperties............{user=tcsdev, maxStatements=200, url=jdbc:oracle:thin:@10.33.131.34:1522:bancsdev, password=<masked>, implicitCachingEnabled=true}|\r\n2016-11-17|12:02:11,674|DEBUG|main|com.zaxxer.hikari.HikariConfig:857||driverClassName.................null|\r\n2016-11-17|12:02:11,674|DEBUG|main|com.zaxxer.hikari.HikariConfig:857||healthCheckProperties...........{}|\r\n2016-11-17|12:02:11,674|DEBUG|main|com.zaxxer.hikari.HikariConfig:857||healthCheckRegistry.............null|\r\n2016-11-17|12:02:11,674|DEBUG|main|com.zaxxer.hikari.HikariConfig:857||idleTimeout.....................0|\r\n2016-11-17|12:02:11,675|DEBUG|main|com.zaxxer.hikari.HikariConfig:857||initializationFailFast..........true|\r\n2016-11-17|12:02:11,675|DEBUG|main|com.zaxxer.hikari.HikariConfig:857||isolateInternalQueries..........false|\r\n2016-11-17|12:02:11,675|DEBUG|main|com.zaxxer.hikari.HikariConfig:857||jdbc4ConnectionTest.............false|\r\n2016-11-17|12:02:11,675|DEBUG|main|com.zaxxer.hikari.HikariConfig:857||jdbcUrl.........................null|\r\n2016-11-17|12:02:11,676|DEBUG|main|com.zaxxer.hikari.HikariConfig:857||leakDetectionThreshold..........0|\r\n2016-11-17|12:02:11,676|DEBUG|main|com.zaxxer.hikari.HikariConfig:857||maxLifetime.....................600000|\r\n2016-11-17|12:02:11,676|DEBUG|main|com.zaxxer.hikari.HikariConfig:857||maximumPoolSize.................18|\r\n2016-11-17|12:02:11,676|DEBUG|main|com.zaxxer.hikari.HikariConfig:857||metricRegistry..................null|\r\n2016-11-17|12:02:11,677|DEBUG|main|com.zaxxer.hikari.HikariConfig:857||metricsTrackerFactory...........null|\r\n2016-11-17|12:02:11,677|DEBUG|main|com.zaxxer.hikari.HikariConfig:857||minimumIdle.....................18|\r\n2016-11-17|12:02:11,677|DEBUG|main|com.zaxxer.hikari.HikariConfig:857||password........................<masked>|\r\n2016-11-17|12:02:11,677|DEBUG|main|com.zaxxer.hikari.HikariConfig:857||poolName........................\"SchedulerDataSourceConnectionPool\"|\r\n2016-11-17|12:02:11,677|DEBUG|main|com.zaxxer.hikari.HikariConfig:857||readOnly........................false|\r\n2016-11-17|12:02:11,678|DEBUG|main|com.zaxxer.hikari.HikariConfig:857||registerMbeans..................false|\r\n2016-11-17|12:02:11,678|DEBUG|main|com.zaxxer.hikari.HikariConfig:857||scheduledExecutorService........null|\r\n2016-11-17|12:02:11,678|DEBUG|main|com.zaxxer.hikari.HikariConfig:857||threadFactory...................null|\r\n2016-11-17|12:02:11,678|DEBUG|main|com.zaxxer.hikari.HikariConfig:857||transactionIsolation............null|\r\n2016-11-17|12:02:11,679|DEBUG|main|com.zaxxer.hikari.HikariConfig:857||username........................null|\r\n2016-11-17|12:02:11,679|DEBUG|main|com.zaxxer.hikari.HikariConfig:857||validationTimeout...............5000|\r\n2016-11-17|12:02:11,680|INFO |main|com.zaxxer.hikari.HikariDataSource:70||SchedulerDataSourceConnectionPool - Started.|\r\n2016-11-17|12:02:11,791|DEBUG|SchedulerDataSourceConnectionPool housekeeper|com.zaxxer.hikari.pool.HikariPool:378||SchedulerDataSourceConnectionPool - Pool stats (total=0, active=0, idle=0, waiting=0)|\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/brettwooldridge/HikariCP/issues/comments/261256527","html_url":"https://github.com/brettwooldridge/HikariCP/issues/764#issuecomment-261256527","issue_url":"https://api.github.com/repos/brettwooldridge/HikariCP/issues/764","id":261256527,"user":{"login":"billoneil","id":5205330,"avatar_url":"https://avatars.githubusercontent.com/u/5205330?v=3","gravatar_id":"","url":"https://api.github.com/users/billoneil","html_url":"https://github.com/billoneil","followers_url":"https://api.github.com/users/billoneil/followers","following_url":"https://api.github.com/users/billoneil/following{/other_user}","gists_url":"https://api.github.com/users/billoneil/gists{/gist_id}","starred_url":"https://api.github.com/users/billoneil/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/billoneil/subscriptions","organizations_url":"https://api.github.com/users/billoneil/orgs","repos_url":"https://api.github.com/users/billoneil/repos","events_url":"https://api.github.com/users/billoneil/events{/privacy}","received_events_url":"https://api.github.com/users/billoneil/received_events","type":"User","site_admin":false},"created_at":"2016-11-17T14:14:01Z","updated_at":"2016-11-17T14:14:01Z","body":"Why do you think there are stale threads? I don't even see hikaricp in the stack trace. It also looks like you have configured two pools is that intended?"}}
{"actor":{"display_login":"billoneil"}}