1. 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

Discussion in 'Troubleshooting and Problems' started by Divvens, Oct 26, 2013.

  1. Divvens

    Divvens Well-Known Member

    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>
    </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"
    }
    }
     
  2. Jeremy

    Jeremy XenForo Moderator Staff Member

    Divvens likes this.
  3. Divvens

    Divvens Well-Known Member

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

Share This Page