XF 1.2 Deadlock ?

Adam Howard

Well-known member
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
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
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?
 

CTXMedia

Formerly CyclingTribe
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. :)
 
Top