topic Transaction Isolation Level and MySQL in Alfresco Archive

Transaction Isolation Level and MySQL

arandall — Wed, 19 Mar 2014 07:23:37 GMT

I have been having trouble with the following code;@Overridepublic void notify(DelegateExecution execution) throws Exception { String parentOrderID = (String) execution.getVariable("parentOrderId"); ProcessInstance instance = runtimeService.createProcessInstanceQuery() .processInstanceB

Re: Transaction Isolation Level and MySQL

arandall — Wed, 19 Mar 2014 23:27:43 GMT

Since changing the transaction isolation in MYSQL to READ COMMITTED I have been unable to hit this issue.

https://dev.mysql.com/doc/refman/5.0/en/set-transaction.html#isolevel_read-committed

<code>
[mysqld]
transaction-isolation = READ-COMMITTED
</code>

Reading details about Oracle and Postgres they use read committed by default suggesting that this setting should also be used for MySQL and be added to the Acticiti user guide.

Can someone confirm the isolation that should be used for Activiti?

Thanks.

Re: Transaction Isolation Level and MySQL

jbarrez — Mon, 24 Mar 2014 12:41:14 GMT

We do assume READ_COMMITTED, yes.

However, I always assumed that Repeatable read would work also, as it is more restrictive …