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

XF 1.2 Deadlock ?

Discussion in 'Troubleshooting and Problems' started by Adam Howard, Sep 22, 2013.

  1. Adam Howard

    Adam Howard Well-Known Member

    Error Info
    PHP:
    Zend_Db_Statement_Mysqli_ExceptionMysqli statement execute error Deadlock found when trying to get lock; try restarting transaction library/Zend/Db/Statement/Mysqli.php:214
    Generated By
    Unknown AccountYesterday at 7:30 AM
    Stack Trace
    PHP:
    #0 /home/www/public_html/forums/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
    #1 /home/www/public_html/forums/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
    #2 /home/www/public_html/forums/library/XenForo/Model/Deferred.php(103): Zend_Db_Adapter_Abstract->query('????INSERT INTO...', Array)
    #3 /home/www/public_html/forums/library/XenForo/Application.php(1288): XenForo_Model_Deferred->defer('Cron', Array, 'cron', false, 1379763050)
    #4 /home/www/public_html/forums/library/XenForo/Model/Cron.php(397): XenForo_Application::defer('Cron', Array, 'cron', false, 1379763050)
    #5 /home/www/public_html/forums/library/XenForo/Deferred/Cron.php(31): XenForo_Model_Cron->updateMinimumNextRunTime()
    #6 /home/www/public_html/forums/library/XenForo/Model/Deferred.php(198): XenForo_Deferred_Cron->execute(Array, Array, 9.99999785423, '')
    #7 /home/www/public_html/forums/library/XenForo/Model/Deferred.php(321): XenForo_Model_Deferred->runDeferred(Array, 9.99999785423, '', false)
    #8 /home/www/public_html/forums/library/XenForo/Model/Deferred.php(274): XenForo_Model_Deferred->_runInternal(Array, NULL, '', false)
    #9 /home/www/public_html/forums/deferred.php(18): XenForo_Model_Deferred->run(false)
    #10 {main}
    Request State
    PHP:
    array(3) {
      [
    "url"] => string(52"http://www.sociallyuncensored.eu/forums/deferred.php"
      
    ["_GET"] => array(0) {
      }
      [
    "_POST"] => array(4) {
        [
    "_xfRequestUri"] => string(45"/forums/threads/random-thoughts.13964/page-92"
        
    ["_xfNoRedirect"] => string(1"1"
        
    ["_xfToken"] => string(8"********"
        
    ["_xfResponseType"] => string(4"json"
      
    }
    }

    So I wasn't doing anything to the site at the time of this (wasn't even home). And this is the 1st time I've ever seen this error .... so ..... Thoughts?
     
    Last edited: Sep 22, 2013
  2. Digital Doctor

    Digital Doctor Well-Known Member

    Adam Howard likes this.
  3. Jeremy

    Jeremy XenForo Moderator Staff Member

  4. Digital Doctor

    Digital Doctor Well-Known Member


     
    Adam Howard likes this.
  5. Adam Howard

    Adam Howard Well-Known Member

  6. Jeremy

    Jeremy XenForo Moderator Staff Member

    Deadlocks are a condition of the mySQL server itself and can happen with any transaction. As Mike has been quoted saying, its extremely hard to prevent or programmatically work around. If its only happened once, I would suggest forgetting about it. If it happens more often, then it becomes a problem to worry about.
     
    Adam Howard likes this.
  7. Adam Howard

    Adam Howard Well-Known Member

    So assume this happens more often.... It maybe a server side issue?
     
  8. Jeremy

    Jeremy XenForo Moderator Staff Member

    Yes:
     
    Adam Howard likes this.
  9. CyclingTribe

    CyclingTribe Well-Known Member

    The only time I've ever seen this is after upgrading CycleChat to XF 1.2.1 - it happened the once and I've never seen it since. :)
     
    Adam Howard likes this.

Share This Page