topic Re: Exception (Timeout trying to lock table ACT_RU_EXECUTION) in Alfresco Archive

Exception (Timeout trying to lock table ACT_RU_EXECUTION)

lojian — Thu, 20 Jan 2011 08:22:34 GMT

I am signal two process instance in 2 threads. But got following exceptions, any idea?### The error may involve org.activiti.persistence.selectExecutionById-Inline### The error occurred while setting parameters### Cause: org.h2.jdbc.JdbcSQLException: Timeout trying to lock table "ACT_RU_EXECUTION" [

Re: Exception (Timeout trying to lock table ACT_RU_EXECUTION)

jbarrez — Thu, 20 Jan 2011 09:42:01 GMT

I assume you are using H2, since it used by default table locking.

You could try to add MVCC=true to your url of H2.

Re: Exception (Timeout trying to lock table ACT_RU_EXECUTION)

lojian — Thu, 20 Jan 2011 12:20:27 GMT

Thanks….And yes, H2 is used…

After appended MVCC=true, the exception changes to:

[INFO] Exception in thread "taskExecutor-3" org.activiti.engine.ActivitiException: execution 29 doesn't exist
[INFO] at org.activiti.engine.impl.cmd.SignalCmd.execute(SignalCmd.java:47)
[INFO] at org.activiti.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:22)
[INFO] at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:37)
[INFO] at org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:42)
[INFO] at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)
[INFO] at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:40)
[INFO] at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33)
[INFO] at org.activiti.engine.impl.RuntimeServiceImpl.signal(RuntimeServiceImpl.java:131)

Any idea?

I am using Activiti 5.1

Re: Exception (Timeout trying to lock table ACT_RU_EXECUTION)

jbarrez — Thu, 20 Jan 2011 12:31:57 GMT

Do you get this exception on both machines?$

It looks like one thread is faster and signals the process for continuation.
The second thread can't signal it anymore, hence the exception, which is completely to be expected in the multi-threaded environment you have.

Re: Exception (Timeout trying to lock table ACT_RU_EXECUTION)

lojian — Thu, 20 Jan 2011 13:46:15 GMT

Do you mean I am signal 2 "identical" process instance?
:?:

Re: Exception (Timeout trying to lock table ACT_RU_EXECUTION)

jbarrez — Fri, 21 Jan 2011 08:30:10 GMT

Yes, looking at your exception it looks like you are signalling the same execution id.

Re: Exception (Timeout trying to lock table ACT_RU_EXECUTION)

lojian — Sat, 22 Jan 2011 14:46:59 GMT

Thank you for finding this for me 🙂

I see. There was a bug in my prototype program.