Page 1 of 1

''Deadlock found when trying to get lock'' when save articles

Posted: Mon Sep 16, 2019 12:44 am
by AntoB
Hi,

Since the update of joomla 3.9.11 I got some bug. One of them, it happen for exemple one article on 60 this error appear :
''Save failed with the following error: Deadlock found when trying to get lock; try restarting transaction''
Just to it ''Save'' again and it work. But it's the first time in 10 years that I saw this message. What's causing this?

The second one, is that for no reason (samething, happen like one time on 60), me or my moderators are switch on a normal account member. We click on a page and magic we become anoter user. We have acces to his profil and etc. Any information on this?

Thanks in advance.

Re: ''Deadlock found when trying to get lock'' when save articles

Posted: Mon Sep 16, 2019 2:06 am
by harperlala
- extension manager/ database/ fix button click
- set error_reporting to maximum and see error message

Re: ''Deadlock found when trying to get lock'' when save articles

Posted: Thu Sep 19, 2019 5:57 pm
by leolam
No that does not help. It is a known mysql-error and it happens randomly. As mentioned in the MySQL docs it is expected behaviour sp leave it and it will go away by itself. Alternatively connect with your host. It is not a Joomla issue

Leo 8)

Re: ''Deadlock found when trying to get lock'' when save articles

Posted: Mon Oct 14, 2019 7:50 pm
by AntoB
leolam wrote:
Thu Sep 19, 2019 5:57 pm
No that does not help. It is a known mysql-error and it happens randomly. As mentioned in the MySQL docs it is expected behaviour sp leave it and it will go away by itself. Alternatively connect with your host. It is not a Joomla issue

Leo 8)
Yes thank you. So my host did a restart of litespeed + mysql and now everything work fines. :)