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

[lajeesh k]

Also refere to this doc

Regards,
Lajeesh
Freelance developer / entrepreneur



On Mon, Jul 15, 2019 at 9:10 PM lajeesh k <lajeeshk at gmail.com> wrote:

> 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/fd9d1081/attachment.html>