[Vtigercrm-developers] Deadlock found when trying to get lock

[lajeesh k]

Hi Alan,

The possible reason for this issue is In some places of vtiger it
uses $this->db and in some some place $adb in the same transaction. This
can cause lock
Also If any transaction didn't completed successfully , I can cause lock
for the other coming transactions
you can refer this doc to find out the process causing lock and kill that
process

use these queries

show full processlist;

SHOW ENGINE INNODB STATUS;






Regards,
Lajeesh
Freelance developer / entrepreneur



On Mon, Jul 15, 2019 at 8:29 PM nilay khatri <nilay.spartan at gmail.com>
wrote:

> We faced a similar issue, but no solution till now.
>
> Customer moved to MariaDB and surprisingly it did not repeat.
>
> On Mon, Jul 15, 2019 at 7:31 PM Alan Lord <alanslists at gmail.com> wrote:
>
>> I have a customer with a very large vtiger system (> 500 users, millions
>> of rows) and occasionally, after adding some debug code to try and find
>> what the problem was, I managed to get the above error message after an
>> INSERT operation from the PearDatabase object.
>>
>> The MySQL docs recommend coding for this by retrying the operation if a
>> deadlock happens. I can probably do this but was wondering if anyone
>> else has seen this before and if so how did they deal with it?
>>
>> Cheers
>>
>> Al
>> _______________________________________________
>> http://www.vtiger.com/
>
> _______________________________________________
> http://www.vtiger.com/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20190715/2c093ba7/attachment.html>