AnsweredAssumed Answered

Frequent Io exception: Connection reset

Question asked by mathewvimal@gmail.com on Aug 9, 2013
Latest reply on Aug 14, 2013 by jbarrez
We are seeing the following exception when activiti runs continuously (for about more than 8 hours). Restart would resolve this issue.
Has anyone seen similar issues? Is there any DB configuration that could resolve this issue?

2013-08-09 10:24:10,196 DEBUG [com.srn.workflow.processinstance.ProcessInstanceManagerImpl] (http-10.71.1.58-8080-2) Starting new worlflow for scrid:1460440 and eventCode:MODIFY_ASSET
2013-08-09 10:24:10,202 ERROR [STDERR] (http-10.71.1.58-8080-2) Aug 9, 2013 10:24:10 AM org.activiti.engine.impl.interceptor.CommandContext close
SEVERE: Error while closing command context
org.apache.ibatis.exceptions.PersistenceException:
### Error querying database.  Cause: java.sql.SQLRecoverableException: Io exception: Connection reset
### The error may involve org.activiti.engine.impl.persistence.entity.ProcessDefinitionEntity.selectLatestProcessDefinitionByKey-Inline
### The error occurred while setting parameters
### Cause: java.sql.SQLRecoverableException: Io exception: Connection reset
        at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:8)
        at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:81)
        at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:73)
        at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:39)
        at org.activiti.engine.impl.db.DbSqlSession.selectOne(DbSqlSession.java:201)
        at org.activiti.engine.impl.persistence.entity.ProcessDefinitionManager.findLatestProcessDefinitionByKey(ProcessDefinitionManager.java:34)
        at org.activiti.engine.impl.persistence.deploy.DeploymentCache.findDeployedLatestProcessDefinitionByKey(DeploymentCache.java:58)
        at org.activiti.engine.impl.cmd.StartProcessInstanceCmd.execute(StartProcessInstanceCmd.java:58)
        at org.activiti.engine.impl.cmd.StartProcessInstanceCmd.execute(StartProcessInstanceCmd.java:31)
        at org.activiti.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:24)
        at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:42)
        at org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:42)
        at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)

Outcomes