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

XF 1.2 Deadlock ?

Adam Howard

Well-known member
#1
Error Info
PHP:
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: Unknown Account, Yesterday 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:

Jeremy

Well-known member
#6
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

Well-known member
#7
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.
So assume this happens more often.... It maybe a server side issue?