''Deadlock found when trying to get lock'' when save articles Topic is solved

Need help with the Administration of your Joomla! 3.x site? This is the spot for you.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Post Reply
AntoB
Joomla! Fledgling
Joomla! Fledgling
Posts: 4
Joined: Mon Nov 20, 2017 2:18 pm

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

Post by AntoB » Mon Sep 16, 2019 12:44 am

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.

harperlala
Joomla! Guru
Joomla! Guru
Posts: 680
Joined: Mon Aug 24, 2015 5:55 pm

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

Post by harperlala » Mon Sep 16, 2019 2:06 am

- extension manager/ database/ fix button click
- set error_reporting to maximum and see error message

User avatar
leolam
Joomla! Master
Joomla! Master
Posts: 19740
Joined: Mon Aug 29, 2005 10:17 am
Location: Netherlands/ UK/ S'pore/Jakarta/ North America
Contact:

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

Post by leolam » 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)
Joomla's #1 Professional Support Provider:
-> Joomla Professional Support: https://gws-desk.com -
-> Joomla Specialized Hosting Solutions: https://gws-host.com -
-> Joomla Webmaster Services: gws-webmaster.services

AntoB
Joomla! Fledgling
Joomla! Fledgling
Posts: 4
Joined: Mon Nov 20, 2017 2:18 pm

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

Post by AntoB » Mon Oct 14, 2019 7:50 pm

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. :)


Post Reply

Return to “Administration Joomla! 3.x”