topic Re: deadlock with basic multithreaded usertask test in Alfresco Archive

deadlock with basic multithreaded usertask test

jsher — Wed, 19 Dec 2012 10:42:33 GMT

Hi, I hope someone can help with a deadlock I am seeing with a basic multithreaded test which interacts with a usertask.I have a simple process with a single usertask. Attached is maven project if anyone would like to try it out for themselves.I run N threads each of which start a process instance,

Re: deadlock with basic multithreaded usertask test

frederikherema1 — Wed, 19 Dec 2012 15:17:00 GMT

org.h2.jdbc.JdbcSQLException

Don't use H2 when you want to to multi-threaded tests. H2 uses a lot of table-locks when only row-locks are needed. H2 is used because of it's speed in testing, but NEVER as production database. I'm confident that the same test won't block on mysql, postgres or any other DB we support.

Re: deadlock with basic multithreaded usertask test

jsher — Wed, 19 Dec 2012 15:45:17 GMT

Many thanks Frederik. I'll repeat tests with 'real' DB

Re: deadlock with basic multithreaded usertask test

meyerd — Wed, 19 Dec 2012 16:21:06 GMT

In h2, use MVCC=true

Re: deadlock with basic multithreaded usertask test

jsher — Wed, 19 Dec 2012 17:21:06 GMT

Thanks Daniel - that worked very nicely.

Regards
James