AnsweredAssumed Answered

Socket read timed out

Question asked by rodiaz on Aug 1, 2012
Latest reply on Feb 17, 2014 by jbarrez
Hi,

We're using activiti 5.8 on weblogic and oracle and after deploy processes succesfully we get

31-jul-2012 22:18:34 org.activiti.engine.impl.bpmn.deployer.BpmnDeployer deploy
INFO: Processing resource g101171218758350081338d4e456380002998
31-jul-2012 22:18:34 org.activiti.engine.impl.interceptor.CommandContext close
GRAVE: Error while closing command context
org.apache.ibatis.exceptions.PersistenceException:
### Error updating database.  Cause: java.sql.SQLRecoverableException: Excepci?n de E/S: Socket read timed out
### The error may involve org.activiti.engine.impl.persistence.entity.JobEntity.updateMessage-Inline
### The error occurred while setting parameters
### Cause: java.sql.SQLRecoverableException: Excepci?n de E/S: Socket read timed out
   at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:8)
   at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:120)
   at org.activiti.engine.impl.db.DbSqlSession.flushUpdates(DbSqlSession.java:433)
   at org.activiti.engine.impl.db.DbSqlSession.flush(DbSqlSession.java:348)
   at org.activiti.engine.impl.interceptor.CommandContext.flushSessions(CommandContext.java:147)
   at org.activiti.engine.impl.interceptor.CommandContext.close(CommandContext.java:103)
   at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:49)
   at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33)
   at org.activiti.engine.impl.jobexecutor.JobAcquisitionThread.run(JobAcquisitionThread.java:63)
Caused by: java.sql.SQLRecoverableException: Excepci?n de E/S: Socket read timed out
   at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:101)
   at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
   at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:199)
   at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:263)
   at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:521)
   at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:969)
   at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1223)
   at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3386)
   at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3487)
   at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)
   at weblogic.jdbc.wrapper.PreparedStatement.execute(PreparedStatement.java:98)
   at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:22)
   at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:51)
   at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:29)
   at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:75)
   at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:43)
   at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:118)
   … 7 more
Caused by: oracle.net.ns.NetException: Socket read timed out
   at oracle.net.ns.Packet.receive(Packet.java:331)
   at oracle.net.ns.DataPacket.receive(DataPacket.java:92)
   at oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:174)
   at oracle.net.ns.NetInputStream.read(NetInputStream.java:119)
   at oracle.net.ns.NetInputStream.read(NetInputStream.java:94)
   at oracle.net.ns.NetInputStream.read(NetInputStream.java:79)
   at oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:112)
   at oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:73)
   at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1040)
   at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1016)
   at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:588)
   at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
   at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:953)
   … 18 more
31-jul-2012 22:18:34 org.activiti.engine.impl.cfg.standalone.StandaloneMybatisTransactionContext rollback
INFO: Exception during transaction:
### Error rolling back transaction.  Cause: java.sql.SQLException: Conexi?n cerrada
### Cause: java.sql.SQLException: Conexi?n cerrada
31-jul-2012 22:18:34 org.activiti.engine.impl.interceptor.CommandContext exception
GRAVE: masked exception in command context. for root cause, see below as it will be rethrown later.
org.apache.ibatis.exceptions.PersistenceException:
### Error rolling back transaction.  Cause: java.sql.SQLException: Conexi?n cerrada
### Cause: java.sql.SQLException: Conexi?n cerrada
   at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:8)
   at org.apache.ibatis.session.defaults.DefaultSqlSession.rollback(DefaultSqlSession.java:158)
   at org.apache.ibatis.session.defaults.DefaultSqlSession.rollback(DefaultSqlSession.java:150)
   at org.activiti.engine.impl.db.DbSqlSession.rollback(DbSqlSession.java:458)
   at org.activiti.engine.impl.cfg.standalone.StandaloneMybatisTransactionContext.rollback(StandaloneMybatisTransactionContext.java:91)
   at org.activiti.engine.impl.interceptor.CommandContext.close(CommandContext.java:120)
   at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:49)
   at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33)
   at org.activiti.engine.impl.jobexecutor.JobAcquisitionThread.run(JobAcquisitionThread.java:63)
Caused by: java.sql.SQLException: Conexi?n cerrada

And nothig work. Do you have any idea? is ibatis caching wrong? what can I do?Update to activiti 5.9 or 5.10 can help?

Thanks in advance

Outcomes