• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

XF 1.2 Server Error - Deadlock found when trying to get lock; try restarting transaction

Divvens

Well-known member
#1
This error popped up on the ACP when I checked it some minutes back, first time coming across such an error!

Error Info
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
Generated By: Riven, 51 minutes ago

Stack Trace
#0 /home/xxxxxx/public_html/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /home/xxxxxx/public_html/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /home/xxxxxx/public_html/library/Zend/Db/Adapter/Abstract.php(632): Zend_Db_Adapter_Abstract->query('UPDATE `xf_foru...', Array)
#3 /home/xxxxxx/public_html/library/XenForo/DataWriter.php(1628): Zend_Db_Adapter_Abstract->update('xf_forum', Array, 'node_id = 160')
#4 /home/xxxxxx/public_html/library/XenForo/DataWriter.php(1597): XenForo_DataWriter->_update()
#5 /home/xxxxxx/public_html/library/XenForo/DataWriter.php(1393): XenForo_DataWriter->_save()
#6 /home/xxxxxx/public_html/library/XenForo/DataWriter/Discussion.php(542): XenForo_DataWriter->save()
#7 /home/xxxxxx/public_html/library/XenForo/DataWriter/Discussion.php(431): XenForo_DataWriter_Discussion->_updateContainerPostSave()
#8 /home/xxxxxx/public_html/library/XenForo/DataWriter.php(1397): XenForo_DataWriter_Discussion->_postSave()
#9 /home/xxxxxx/public_html/library/XenForo/DataWriter/DiscussionMessage.php(1126): XenForo_DataWriter->save()
#10 /home/xxxxxx/public_html/library/XenForo/DataWriter/DiscussionMessage.php(589): XenForo_DataWriter_DiscussionMessage->_saveDiscussionDataWriter()
#11 /home/xxxxxx/public_html/library/XenForo/DataWriter.php(1397): XenForo_DataWriter_DiscussionMessage->_postSave()
#12 /home/xxxxxx/public_html/library/XenForo/ControllerPublic/Thread.php(548): XenForo_DataWriter->save()
#13 /home/xxxxxx/public_html/library/DoublePost/ControllerPublic/Thread.php(40): XenForo_ControllerPublic_Thread->actionAddReply()
#14 /home/xxxxxx/public_html/library/XenForo/FrontController.php(337): DoublePost_ControllerPublic_Thread->actionAddReply()
#15 /home/xxxxxxs/public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#16 /home/xxxxxx/public_html/index.php(13): XenForo_FrontController->run()
#17 {main}

Request State
array(3) {
["url"] => string(82) "http://orojackson.com/threads/island-3-insanity-daily-random-events.2143/add-reply"
["_GET"] => array(0) {
}
["_POST"] => array(8) {
["message_html"] => string(396) "<p>
<img src="http://orojackson.com/styles/default/xenforo/smilies/sneaky.png" class="mceSmilie" alt="&gt;:)" unselectable="on"> Hmm I see you Join the Revos at least you didn't join the Marines scum
</p><p><br></p><p>You could say that Revolutionaries are merely Pirates that fight to free on land instead of running away to be free at sea. ;D</p>"
["_xfRelativeResolver"] => string(79) "http://orojackson.com/threads/island-3-insanity-daily-random-events.2143/page-2"
["last_date"] => string(10) "1382758638"
["last_known_date"] => string(10) "1382758638"
["_xfToken"] => string(8) "********"
["_xfRequestUri"] => string(58) "/threads/island-3-insanity-daily-random-events.2143/page-2"
["_xfNoRedirect"] => string(1) "1"
["_xfResponseType"] => string(4) "json"
}
}
 

Divvens

Well-known member
#3
Deadlocks are an internal server problem and not easily programmatically involved. This post of mine has a few links, but restarting your mySQL server should clear the dead lock for the time being:
http://xenforo.com/community/threads/deadlock.60097/#post-639413
It's happened only once, if I see it pop-up in the server error log again I'll inform my host, this can be a one off issue since its the first time such an error has occurred and it's only once. Thanks for the link, I'm ignoring it now since it's just once as you suggested on the other thread :)