MySQL query error: Deadlock found when trying to get lock in UPDATE xf_user

Affected version
2.3.4
I've seen a few similar posts, not sure how related this is with them though.
And FWIW, I never saw this error in the last decade running XenForo, but now got it once a day after finally upgrading from v2.2 to v2.3.4.

Code:
                    UPDATE xf_user
                    SET message_count = GREATEST(0, CAST(message_count AS SIGNED) - ?)
                    WHERE user_id = ?
               
------------

#0 src/XF/Db/Mysqli/Statement.php(207): XF\Db\AbstractStatement->getException('MySQL query err...', 1213, '40001')
#1 src/XF/Db/Mysqli/Statement.php(83): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1213, '40001')
#2 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Entity/Thread.php(1254): XF\Db\AbstractAdapter->query('
                    UPDATE xf...', Array)
#4 src/XF/Entity/Thread.php(1167): XF\Entity\Thread->adjustUserMessageCountIfNeeded(-1)
#5 src/XF/Entity/Thread.php(1086): XF\Entity\Thread->threadHidden()
#6 src/XF/Mvc/Entity/Entity.php(1324): XF\Entity\Thread->_postSave()
#7 src/XF/Entity/Post.php(612): XF\Mvc\Entity\Entity->save()
#8 src/XF/Mvc/Entity/Entity.php(1324): XF\Entity\Post->_postSave()
#9 src/XF/Service/Post/EditorService.php(201): XF\Mvc\Entity\Entity->save(true, false)
#10 src/XF/Service/ValidateAndSavableTrait.php(42): XF\Service\Post\EditorService->_save()
#11 src/XF/Pub/Controller/PostController.php(175): XF\Service\Post\EditorService->save()
#12 src/XF/Mvc/Dispatcher.php(362): XF\Pub\Controller\PostController->actionEdit(Object(XF\Mvc\ParameterBag))
#13 src/XF/Mvc/Dispatcher.php(264): XF\Mvc\Dispatcher->dispatchClass('XF:Post', 'Edit', Object(XF\Mvc\RouteMatch), Object(XF\Pub\Controller\PostController), NULL)
#14 src/XF/Mvc/Dispatcher.php(121): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(XF\Pub\Controller\PostController), NULL)
#15 src/XF/Mvc/Dispatcher.php(63): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#16 src/XF/App.php(2826): XF\Mvc\Dispatcher->run()
#17 src/XF.php(806): XF\App->run()
#18 index.php(23): XF::runApp('XF\\Pub\\App')
#19 {main}
 
Back
Top Bottom