[Vtigercrm-developers] I was seeing this quite often: [1205]Lock wait timeout exceeded

Alan Lord alanslists at gmail.com
Thu Jun 18 13:02:26 GMT 2020

That's interesting...,

I have some pretty large customers: > 500 users, tens of millions of 
rows of data, loads of workflows and event handlers and have never seen 
this happen before on their systems - but they only have InnoDB tables.


On 18/06/2020 13:55, nilay khatri wrote:
> Hi Alan,
> this happens for us with InnoDB as well. The reason for this is actually 
> the locks which are acquired on crmentity table. And when workflows or 
> event handlers are triggered and if you have many update or create 
> operations, you will face this issue. We are working on fixing the 
> issue, to make the locks on database tables work properly. One of the 
> other reasons in our case is that we have many installations on the same 
> DB server and so it is quite busy, which amplifies the occurrence of 
> this. As of now we have limited the no. of triggers, workflows and 
> modified certain aspects of transactions.

More information about the vtigercrm-developers mailing list