Mysqli statement execute error

[Caric]

Has been getting this on Xenforo 1.4.4

It does not happen often but this event happen when one of the moderator was performing the routline of deleting threads.

If you need more information, I will be more than happy to provide.

#0 /home/user/www/forum/library/XenForo/DataWriter/DiscussionMessage.php(354): XenForo_DataWriter_DiscussionMessage->_setPosition()
#1 /home/user/www/forum/library/XenForo/DataWriter.php(1446): XenForo_DataWriter_DiscussionMessage->_preSave()
#2 /home/user/www/forum/library/XenForo/ControllerPublic/Thread.php(550): XenForo_DataWriter->preSave()
#3 /home/user/www/forum/library/XenForo/FrontController.php(347): XenForo_ControllerPublic_Thread->actionAddReply()
#4 /home/user/www/forum/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#5 /home/user/www/forum/index.php(13): XenForo_FrontController->run()
#6 {main}​

 

[Paul B]

Can you paste the first line of the error message?

 

[Caric]

Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Deadlock found when trying to get lock; try restarting transaction - library/Zend/Db/Statement/Mysqli.php:214

Here you go

 

[Caric]

Sorry, any updates on this issue? Not sure whether it is related to my duplicated post issue too

 

[Paul B]

It's something which can happen occasionally.

This thread has some discussion on it, along with several links: https://xenforo.com/community/threa...to-get-lock-try-restarting-transaction.62915/