topic Lock Wait timeout Exception with MYSQL and MariaDB in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/lock-wait-timeout-exception-with-mysql-and-mariadb/m-p/231667#M184797 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>I am facing the below issue&nbsp; quite a lot specifically on MYSQL and MariaDB. After such an error is seen, the jobs remain stuck and do not process any further.</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />### Error updating database.&nbsp; Cause: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction<BR />### The error may involve org.activiti.engine.impl.persistence.entity.HistoricActivityInstanceEntity.insertHistoricActivityInstance-Inline<BR />### The error occurred while setting parameters<BR />### SQL: insert into ACT_HI_ACTINST (&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ID_,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PROC_DEF_ID_,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PROC_INST_ID_,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; EXECUTION_ID_,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ACT_ID_,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TASK_ID_,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CALL_PROC_INST_ID_,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ACT_NAME_,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ACT_TYPE_,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ASSIGNEE_,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; START_TIME_,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; END_TIME_,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DURATION_,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TENANT_ID_&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ) values (&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )<BR />### Cause: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction<BR />org.apache.ibatis.exceptions.PersistenceException: <BR />### Error updating database.&nbsp; Cause: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction<BR />### The error may involve org.activiti.engine.impl.persistence.entity.HistoricActivityInstanceEntity.insertHistoricActivityInstance-Inline<BR />### The error occurred while setting parameters<BR />### SQL: insert into ACT_HI_ACTINST (&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ID_,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PROC_DEF_ID_,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PROC_INST_ID_,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; EXECUTION_ID_,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ACT_ID_,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TASK_ID_,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CALL_PROC_INST_ID_,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ACT_NAME_,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ACT_TYPE_,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ASSIGNEE_,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; START_TIME_,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; END_TIME_,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DURATION_,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TENANT_ID_&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ) values (&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )<BR />### Cause: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction<BR />&nbsp;&nbsp;&nbsp;at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23)<BR />&nbsp;&nbsp;&nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:150)<BR />&nbsp;&nbsp;&nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:137)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.db.DbSqlSession.flushInserts(DbSqlSession.java:755)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.db.DbSqlSession.flush(DbSqlSession.java:587)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.interceptor.CommandContext.flushSessions(CommandContext.java:211)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.interceptor.CommandContext.close(CommandContext.java:137)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:66)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:47)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:45)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:31)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:40)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:35)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.jobexecutor.ExecuteJobsRunnable.run(ExecuteJobsRunnable.java:48)<BR />&nbsp;&nbsp;&nbsp;at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)<BR />&nbsp;&nbsp;&nbsp;at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)<BR />&nbsp;&nbsp;&nbsp;at java.lang.Thread.run(Thread.java:745)<BR />Caused by: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction<BR />&nbsp;&nbsp;&nbsp;at org.mariadb.jdbc.internal.SQLExceptionMapper.get(SQLExceptionMapper.java:149)<BR />&nbsp;&nbsp;&nbsp;at org.mariadb.jdbc.internal.SQLExceptionMapper.throwException(SQLExceptionMapper.java:106)<BR />&nbsp;&nbsp;&nbsp;at org.mariadb.jdbc.MySQLStatement.executeQueryEpilog(MySQLStatement.java:264)<BR />&nbsp;&nbsp;&nbsp;at org.mariadb.jdbc.MySQLStatement.execute(MySQLStatement.java:288)<BR />&nbsp;&nbsp;&nbsp;at org.mariadb.jdbc.MySQLPreparedStatement.execute(MySQLPreparedStatement.java:141)<BR />&nbsp;&nbsp;&nbsp;at com.zaxxer.hikari.proxy.PreparedStatementProxy.execute(PreparedStatementProxy.java:44)<BR />&nbsp;&nbsp;&nbsp;at com.zaxxer.hikari.proxy.PreparedStatementJavassistProxy.execute(PreparedStatementJavassistProxy.java)<BR />&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:41)<BR />&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:66)<BR />&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:45)<BR />&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:100)<BR />&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:75)<BR />&nbsp;&nbsp;&nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:148)<BR />&nbsp;&nbsp;&nbsp;… 16 more<BR />Caused by: org.mariadb.jdbc.internal.common.QueryException: Lock wait timeout exceeded; try restarting transaction<BR />&nbsp;&nbsp;&nbsp;at org.mariadb.jdbc.internal.mysql.MySQLProtocol.getResult(MySQLProtocol.java:942)<BR />&nbsp;&nbsp;&nbsp;at org.mariadb.jdbc.internal.mysql.MySQLProtocol.executeQuery(MySQLProtocol.java:991)<BR />&nbsp;&nbsp;&nbsp;at org.mariadb.jdbc.MySQLStatement.execute(MySQLStatement.java:281)<BR />&nbsp;&nbsp;&nbsp;… 25 more<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>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /></BODY></HTML> Fri, 18 Mar 2016 08:13:44 GMT sushantmahajan 2016-03-18T08:13:44Z Lock Wait timeout Exception with MYSQL and MariaDB https://connect.hyland.com/t5/alfresco-archive/lock-wait-timeout-exception-with-mysql-and-mariadb/m-p/231667#M184797 Hi,I am facing the below issue&nbsp; quite a lot specifically on MYSQL and MariaDB. After such an error is seen, the jobs remain stuck and do not process any further.### Error updating database.&nbsp; Cause: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction### The error may involve Fri, 18 Mar 2016 08:13:44 GMT https://connect.hyland.com/t5/alfresco-archive/lock-wait-timeout-exception-with-mysql-and-mariadb/m-p/231667#M184797 sushantmahajan 2016-03-18T08:13:44Z Re: Lock Wait timeout Exception with MYSQL and MariaDB https://connect.hyland.com/t5/alfresco-archive/lock-wait-timeout-exception-with-mysql-and-mariadb/m-p/231668#M184798 <HTML><HEAD></HEAD><BODY><SPAN>Hi, </SPAN><BR /><SPAN>could you provide some more details?</SPAN><BR /><SPAN>Activiti version, database version, and other configurations.</SPAN><BR /><BR /><SPAN>Would be great if you could provide a jUnit which shows this, because will be much easier to reproduce and fix the issue.</SPAN><BR /><SPAN>Thanks.</SPAN></BODY></HTML> Tue, 22 Mar 2016 08:16:35 GMT https://connect.hyland.com/t5/alfresco-archive/lock-wait-timeout-exception-with-mysql-and-mariadb/m-p/231668#M184798 vasile_dirla 2016-03-22T08:16:35Z Re: Lock Wait timeout Exception with MYSQL and MariaDB https://connect.hyland.com/t5/alfresco-archive/lock-wait-timeout-exception-with-mysql-and-mariadb/m-p/231669#M184799 <HTML><HEAD></HEAD><BODY><SPAN>Hi Vasile,</SPAN><BR /><SPAN>Below is the information you are seeking-</SPAN><BR /><BR /><SPAN>Activiti version-5.16.1</SPAN><BR /><SPAN>Database-MYSQL 5.1.73</SPAN><BR /><SPAN>Core pool Size-5</SPAN><BR /><SPAN>Max pool size -5</SPAN><BR /><SPAN>History&nbsp; level-Audit(Default)</SPAN><BR /><BR /><SPAN>The issue is randomly seen in the application logs. There is no specific case to reproduce the issue.</SPAN></BODY></HTML> Tue, 22 Mar 2016 10:23:49 GMT https://connect.hyland.com/t5/alfresco-archive/lock-wait-timeout-exception-with-mysql-and-mariadb/m-p/231669#M184799 sushantmahajan 2016-03-22T10:23:49Z Re: Lock Wait timeout Exception with MYSQL and MariaDB https://connect.hyland.com/t5/alfresco-archive/lock-wait-timeout-exception-with-mysql-and-mariadb/m-p/231670#M184800 <HTML><HEAD></HEAD><BODY><SPAN>a lock timeout on an insert is very odd …. can you try using a connection pool (c3p0, bonecp, etc) instead of the default Mybatis connection pooling?</SPAN></BODY></HTML> Fri, 25 Mar 2016 12:50:50 GMT https://connect.hyland.com/t5/alfresco-archive/lock-wait-timeout-exception-with-mysql-and-mariadb/m-p/231670#M184800 jbarrez 2016-03-25T12:50:50Z