topic Re: Lock Wait timeout Exception with MYSQL and MariaDB in Alfresco Archive

Lock Wait timeout Exception with MYSQL and MariaDB

sushantmahajan — Fri, 18 Mar 2016 08:13:44 GMT

Hi,I am facing the below issue 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. Cause: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction### The error may involve

Re: Lock Wait timeout Exception with MYSQL and MariaDB

vasile_dirla — Tue, 22 Mar 2016 08:16:35 GMT

Hi,
could you provide some more details?
Activiti version, database version, and other configurations.

Would be great if you could provide a jUnit which shows this, because will be much easier to reproduce and fix the issue.
Thanks.

Re: Lock Wait timeout Exception with MYSQL and MariaDB

sushantmahajan — Tue, 22 Mar 2016 10:23:49 GMT

Hi Vasile,
Below is the information you are seeking-

Activiti version-5.16.1
Database-MYSQL 5.1.73
Core pool Size-5
Max pool size -5
History level-Audit(Default)

The issue is randomly seen in the application logs. There is no specific case to reproduce the issue.

Re: Lock Wait timeout Exception with MYSQL and MariaDB

jbarrez — Fri, 25 Mar 2016 12:50:50 GMT

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?