topic Re: Got lots of Deadlock exception in Alfresco Forum

Got lots of Deadlock exception

dean — Wed, 30 Aug 2017 15:16:49 GMT

I used Quartz to start timing task, e.g. At 9:00 AM start 1000 instance, bpmn just like this StartEvent-> ServiceTask -> EndTask, very simple.<?xml version="1.0" encoding="UTF-8"?><definitions xmlns="http://www.omg.org/spec/BPMN/20100524/MODEL" xmlns:xsi="http://www.w3.org/2001/XMLSch

Re: Got lots of Deadlock exception

cjose — Fri, 01 Sep 2017 15:41:07 GMT

That's a huge number of deadlocks! Which version of MySQL & Activiti are you using?

Also, can you try disabling bulk inserts and see if that makes a difference?

Cheers,

Ciju

Re: Got lots of Deadlock exception

dean — Sat, 02 Sep 2017 10:37:28 GMT

Hi Joseph,

Thanks for your reply.

Activiti: 5.22.0

MySQL: 5.7.15

I will try to disable the bulk inserts but I don' think it should have problems with MySQL DB.

Dean