topic Mybatis hangs on deploy or execution in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/mybatis-hangs-on-deploy-or-execution/m-p/196779#M149909 <HTML><HEAD></HEAD><BODY><SPAN>Hello,</SPAN><BR /><SPAN>I've been facing some DB problems lately. I'm using Spring configured ProcessEngine. The version is 5.16 and version of Spring dependencies' is 4.0.6.RELEASE. I'm using c3p0 as a connection pool.</SPAN><BR /><SPAN>When I tried to deploy my processes, thread hangs and as I configured c3p0 to warn me I get 'connection closed' exception.</SPAN><BR /><BR /><SPAN>Thread dump as it hangs like that:</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />"http-bio-8080-exec-9@15803" daemon prio=5 tid=0x4b nid=NA runnable<BR />&nbsp; java.lang.Thread.State: RUNNABLE<BR />&nbsp;&nbsp;&nbsp;&nbsp; at java.net.SocketOutputStream.socketWrite0(SocketOutputStream.java:-1)<BR />&nbsp;&nbsp;&nbsp;&nbsp; at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)<BR />&nbsp;&nbsp;&nbsp;&nbsp; at java.net.SocketOutputStream.write(SocketOutputStream.java:136)<BR />&nbsp;&nbsp;&nbsp;&nbsp; at oracle.net.ns.DataPacket.send(DataPacket.java:210)<BR />&nbsp;&nbsp;&nbsp;&nbsp; - locked &lt;0x495f&gt; (a java.net.SocketOutputStream)<BR />&nbsp;&nbsp;&nbsp;&nbsp; at oracle.net.ns.NetOutputStream.write(NetOutputStream.java:195)<BR />&nbsp;&nbsp;&nbsp;&nbsp; at oracle.jdbc.driver.T4CSocketOutputStreamWrapper.flush(T4CSocketOutputStreamWrapper.java:99)<BR />&nbsp;&nbsp;&nbsp;&nbsp; at oracle.jdbc.driver.T4CSocketOutputStreamWrapper.flush(T4CSocketOutputStreamWrapper.java:92)<BR />&nbsp;&nbsp;&nbsp;&nbsp; at oracle.jdbc.driver.T4CSocketOutputStreamWrapper.write(T4CSocketOutputStreamWrapper.java:84)<BR />&nbsp;&nbsp;&nbsp;&nbsp; at oracle.jdbc.driver.T4CMAREngine.marshalB1Array(T4CMAREngine.java:556)<BR />&nbsp;&nbsp;&nbsp;&nbsp; at oracle.jdbc.driver.T4CTTIrxd.marshal(T4CTTIrxd.java:810)<BR />&nbsp;&nbsp;&nbsp;&nbsp; at oracle.jdbc.driver.T4C8Oall.marshalBinds(T4C8Oall.java:1678)<BR />&nbsp;&nbsp;&nbsp;&nbsp; at oracle.jdbc.driver.T4C8Oall.marshal(T4C8Oall.java:1041)<BR />&nbsp;&nbsp;&nbsp;&nbsp; at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:190)<BR />&nbsp;&nbsp;&nbsp;&nbsp; at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)<BR />&nbsp;&nbsp;&nbsp;&nbsp; at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)<BR />&nbsp;&nbsp;&nbsp;&nbsp; at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1044)<BR />&nbsp;&nbsp;&nbsp;&nbsp; at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)<BR />&nbsp;&nbsp;&nbsp;&nbsp; at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584)<BR />&nbsp;&nbsp;&nbsp;&nbsp; at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3685)<BR />&nbsp;&nbsp;&nbsp;&nbsp; - locked &lt;0x4960&gt; (a oracle.jdbc.driver.T4CConnection)<BR />&nbsp;&nbsp;&nbsp;&nbsp; at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1376)<BR />&nbsp;&nbsp;&nbsp;&nbsp; at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:823)<BR />&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:41)<BR />&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:66)<BR />&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:45)<BR />&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:100)<BR />&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:75)<BR />&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:148)<BR />&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:137)<BR />&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.engine.impl.db.DbSqlSession.flushInserts(DbSqlSession.java:751)<BR />&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.engine.impl.db.DbSqlSession.flush(DbSqlSession.java:586)<BR />&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.engine.impl.interceptor.CommandContext.flushSessions(CommandContext.java:211)<BR />&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.engine.impl.interceptor.CommandContext.close(CommandContext.java:137)<BR />&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:66)<BR />&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:47)<BR />&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:133)<BR />&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:45)<BR />&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:31)<BR />&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:40)<BR />&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:35)<BR />&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.engine.impl.RepositoryServiceImpl.deploy(RepositoryServiceImpl.java:78)<BR />&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.engine.impl.repository.DeploymentBuilderImpl.deploy(DeploymentBuilderImpl.java:156)<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><SPAN>What can be the reason for this behaviour?</SPAN></BODY></HTML> Sun, 17 Aug 2014 20:28:54 GMT gokceng1 2014-08-17T20:28:54Z Mybatis hangs on deploy or execution https://connect.hyland.com/t5/alfresco-archive/mybatis-hangs-on-deploy-or-execution/m-p/196779#M149909 Hello,I've been facing some DB problems lately. I'm using Spring configured ProcessEngine. The version is 5.16 and version of Spring dependencies' is 4.0.6.RELEASE. I'm using c3p0 as a connection pool.When I tried to deploy my processes, thread hangs and as I configured c3p0 to warn me I get 'connec Sun, 17 Aug 2014 20:28:54 GMT https://connect.hyland.com/t5/alfresco-archive/mybatis-hangs-on-deploy-or-execution/m-p/196779#M149909 gokceng1 2014-08-17T20:28:54Z Re: Mybatis hangs on deploy or execution https://connect.hyland.com/t5/alfresco-archive/mybatis-hangs-on-deploy-or-execution/m-p/196780#M149910 <HTML><HEAD></HEAD><BODY><SPAN>Afaik, c3p0 needs ping queries (or keepalive - dunno the name anymore) for some database. otherwise the connection might go stale. Did you configure those properties correctly?</SPAN></BODY></HTML> Tue, 19 Aug 2014 10:59:10 GMT https://connect.hyland.com/t5/alfresco-archive/mybatis-hangs-on-deploy-or-execution/m-p/196780#M149910 jbarrez 2014-08-19T10:59:10Z