AnsweredAssumed Answered

Error accessing PooledConnection. Connection is invalid.

Question asked by mpradny on Nov 28, 2012
Latest reply on Nov 28, 2012 by ronald.van.kuijk
We were running Activiti quite fine for several months. We are running 5.10 connected to Oracle. Last Thrusday we got first error Error accessing PooledConnection. Connection is invalid. Activiti seems to keep running, but after some time server stopped responding.

We cheked db, even migrated from Oracle 9 to 11 (which was planned anyway). But today we got this error again.

Does anyone have an idea what can cause this? This time I have Oracle debug turned on, but it will take me some time to get those logs since they have 6GB.

—————-


28.11.2012 12:16:42   HTTP JVM: Caused by:
28.11.2012 12:16:42   HTTP JVM: org.apache.ibatis.exceptions.PersistenceException:
28.11.2012 12:16:42   HTTP JVM: ### Error querying database.  Cause: java.sql.SQLException: Error accessing PooledConnection. Connection is invalid.
28.11.2012 12:16:42   HTTP JVM: ### The error may exist in org/activiti/db/mapping/entity/VariableInstance.xml
28.11.2012 12:16:42   HTTP JVM: ### The error may involve org.activiti.engine.impl.persistence.entity.VariableInstanceEntity.selectVariablesByTaskId
28.11.2012 12:16:42   HTTP JVM: ### The error occurred while executing a query
28.11.2012 12:16:42   HTTP JVM: ### SQL: select * from ACT_RU_VARIABLE where     TASK_ID_ = ?
28.11.2012 12:16:42   HTTP JVM: ### Cause: java.sql.SQLException: Error accessing PooledConnection. Connection is invalid.
28.11.2012 12:16:42   HTTP JVM:    at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23)
28.11.2012 12:16:42   HTTP JVM:    at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:104)
28.11.2012 12:16:42   HTTP JVM:    at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:95)
28.11.2012 12:16:42   HTTP JVM:    at org.activiti.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:216)
28.11.2012 12:16:42   HTTP JVM:    at org.activiti.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:200)
28.11.2012 12:16:42   HTTP JVM:    at org.activiti.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:181)
28.11.2012 12:16:42   HTTP JVM:    at org.activiti.engine.impl.persistence.entity.VariableInstanceManager.findVariableInstancesByTaskId(VariableInstanceManager.java:42)
28.11.2012 12:16:42   HTTP JVM:    at org.activiti.engine.impl.persistence.entity.TaskEntity.loadVariableInstances(TaskEntity.java:223)
28.11.2012 12:16:42   HTTP JVM:    at org.activiti.engine.impl.persistence.entity.VariableScopeImpl.ensureVariableInstancesInitialized(VariableScopeImpl.java:57)
28.11.2012 12:16:42   HTTP JVM:    at org.activiti.engine.impl.persistence.entity.VariableScopeImpl.getVariableLocal(VariableScopeImpl.java:103)
28.11.2012 12:16:42   HTTP JVM:    at cz.actis.activiti.history.UserTaskCreateHandlerLN.notify(UserTaskCreateHandlerLN.java:56)
28.11.2012 12:16:42   HTTP JVM:    at org.activiti.engine.impl.delegate.TaskListenerInvocation.invoke(TaskListenerInvocation.java:34)
28.11.2012 12:16:42   HTTP JVM:    at org.activiti.engine.impl.delegate.DelegateInvocation.proceed(DelegateInvocation.java:37)
28.11.2012 12:16:42   HTTP JVM:    at org.activiti.engine.impl.delegate.DefaultDelegateInterceptor.handleInvocation(DefaultDelegateInterceptor.java:25)
28.11.2012 12:16:42   HTTP JVM:    at org.activiti.engine.impl.persistence.entity.TaskEntity.fireEvent(TaskEntity.java:515)
28.11.2012 12:16:42   HTTP JVM:    … 217 more
28.11.2012 12:16:42   HTTP JVM: Caused by:
28.11.2012 12:16:42   HTTP JVM: java.sql.SQLException: Error accessing PooledConnection. Connection is invalid.

Outcomes