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

[Alan Lord]

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.

Al


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.