cancel
Showing results for 
Search instead for 
Did you mean: 

Socket read timed out

rodiaz
Champ in-the-making
Champ in-the-making
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
6 REPLIES 6

frederikherema1
Star Contributor
Star Contributor
Looks like a problem with your SQL/JDBC connection, it times out when activiti tries to flush/commit it's data…

aeross
Champ in-the-making
Champ in-the-making
Hi rodiaz and frederik, can you tell me more about the problem, it arrived for me on Jboss AS7, with oracle DB.

I don't understand and i don't know what to look for?

Thanks in advance.

jbarrez
Star Contributor
Star Contributor
Well, the error typically means no good connection can be made to the database. So first thing is to check the jdbc settings and see if the instance is reachable from the machine you're running activiti on.

aeross
Champ in-the-making
Champ in-the-making
Thanks for your response Joram.
I will test my database connection and see if anything happening.

aeross
Champ in-the-making
Champ in-the-making
I come back to news, for the moment the problem will not reappear. So i think it's a lost connection database that cause the problem.

Thanks.

jbarrez
Star Contributor
Star Contributor
Ok, thanks for the update!