topic DB deadlock when running processes concurrently in Alfresco Archive

DB deadlock when running processes concurrently

lichtin — Tue, 11 Oct 2011 08:20:14 GMT

HiFollowing experience when running a few processes in parallel:11.10.2011 10:12:11 org.activiti.engine.impl.interceptor.CommandContext closeSCHWERWIEGEND: Error while closing command contextorg.apache.ibatis.exceptions.PersistenceException: ### Error updating database. Cause: org.h2.jdbc.JdbcSQLEx

Re: DB deadlock when running processes concurrently

frederikherema1 — Tue, 11 Oct 2011 08:44:12 GMT

H2 database uses full-table-locks. Afaik, h2 is not really a production database I recommend using another DB that can handle transactions and locking better…

Re: DB deadlock when running processes concurrently

lichtin — Thu, 13 Oct 2011 08:59:01 GMT

Thanks, with mySQL, for example, this deadlock issue does not appear when running the same tests.

One small thing (excuse my ignorance): How does Activiti create the database/schema?
I can't find a "create schema" anywhere in the code…

Re: DB deadlock when running processes concurrently

rodolfobarbeiro — Thu, 13 Oct 2011 16:51:04 GMT

The SQL scripts are within the folder src/main/resources, in package: org.activiti.db.create. (activiti-engine)

Regards,

Rodolfo Barbeiro

Re: DB deadlock when running processes concurrently

lichtin — Thu, 13 Oct 2011 19:05:40 GMT

Thanks Rodolfo

Yes, the scripts, I'm just looking at them because I want to add support for another DB.
But what I am missing is the place where "create schema" is called.
Or does Activiti assume that all the currently supported DBs have a default schema?