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

XF 1.1 Mysqli statement execute error : Deadlock found when trying to get lock; try restarting transaction

Discussion in 'Troubleshooting and Problems' started by RoldanLT, Apr 3, 2013.

  1. RoldanLT

    RoldanLT Well-Known Member

    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: bkdrebz, 4 minutes ago

    Stack Trace
    #0 /home/phcorner/public_html/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
    #1 /home/phcorner/public_html/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
    #2 /home/phcorner/public_html/library/Zend/Db/Adapter/Abstract.php(632): Zend_Db_Adapter_Abstract->query('UPDATE `xf_foru...', Array)
    #3 /home/phcorner/public_html/library/XenForo/DataWriter.php(1607): Zend_Db_Adapter_Abstract->update('xf_forum', Array, 'node_id = 168')
    #4 /home/phcorner/public_html/library/XenForo/DataWriter.php(1576): XenForo_DataWriter->_update()
    #5 /home/phcorner/public_html/library/XenForo/DataWriter.php(1381): XenForo_DataWriter->_save()
    #6 /home/phcorner/public_html/library/XenForo/DataWriter/Discussion.php(480): XenForo_DataWriter->save()
    #7 /home/phcorner/public_html/library/XenForo/DataWriter/Discussion.php(368): XenForo_DataWriter_Discussion->_updateContainerPostSave()
    #8 /home/phcorner/public_html/library/XenForo/DataWriter.php(1385): XenForo_DataWriter_Discussion->_postSave()
    #9 /home/phcorner/public_html/library/XenForo/DataWriter/DiscussionMessage.php(1047): XenForo_DataWriter->save()
    #10 /home/phcorner/public_html/library/XenForo/DataWriter/DiscussionMessage.php(530): XenForo_DataWriter_DiscussionMessage->_saveDiscussionDataWriter()
    #11 /home/phcorner/public_html/library/XenForo/DataWriter.php(1385): XenForo_DataWriter_DiscussionMessage->_postSave()
    #13 /home/phcorner/public_html/library/XenForo/ControllerPublic/Thread.php(504): Dark_TaigaChat_DataWriter_DiscussionMessage_Post->save()
    #14 /home/phcorner/public_html/library/XenForo/FrontController.php(310): XenForo_ControllerPublic_Thread->actionAddReply()
    #15 /home/phcorner/public_html/library/XenForo/FrontController.php(132): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
    #16 /home/phcorner/public_html/index.php(13): XenForo_FrontController->run()
    #17 {main}

    Request State
    array(3) {
    ["url"] => string(109) "http://www.phcorner.net/threads/hot...-9-100-working-pc-application.47769/add-reply"
    ["_GET"] => array(0) {
    }
    ["_POST"] => array(8) {
    ["message_html"] => string(53) "<p>wow.. sige try ako.. galing nto</p>
    <p>&nbsp;</p>"
    ["_xfRelativeResolver"] => string(100) "http://www.phcorner.net/threads/hottest-oneshot-bugging-tools-v2-9-100-working-pc-application.47769/"
    ["attachment_hash"] => string(32) "3e119dcfea0e20b3223b4209f1016cc1"
    ["last_date"] => string(10) "1361644943"
    ["_xfToken"] => string(8) "********"
    ["_xfRequestUri"] => string(77) "/threads/hottest-oneshot-bugging-tools-v2-9-100-working-pc-application.47769/"
    ["_xfNoRedirect"] => string(1) "1"
    ["_xfResponseType"] => string(4) "json"
    }
    }
     
  2. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    I have seen this error reported before. I believe the answer is to just refresh the page. Deadlocks happen.
     
  3. RoldanLT

    RoldanLT Well-Known Member

    What was causing this to happen?
     
  4. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    RoldanLT likes this.
  5. RoldanLT

    RoldanLT Well-Known Member

    So, possible.
    Certain addons is causing this?
     
  6. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Not directly. It's an internal condition of the MySQL server, not an error with an addon.
     
    RoldanLT likes this.
  7. RoldanLT

    RoldanLT Well-Known Member

    Ok, so server problems.
     
  8. RoldanLT

    RoldanLT Well-Known Member

    I always encounter this when performing "Spam Cleaner" on members having 200+ post
     

Share This Page