Mysqli statement execute error : Deadlock found when trying to get lock

Nirjonadda

Well-known member
#1
Toady I get Server Error Logs on my admin CP, Please let me know the fix.

HTML:
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: Unknown Account, Today at 3:10 PM
Stack Trace

#0 /home/nadda/public_html/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /home/nadda/public_html/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /home/nadda/public_html/library/Zend/Db/Adapter/Abstract.php(632): Zend_Db_Adapter_Abstract->query('UPDATE `xf_user...', Array)
#3 /home/nadda/public_html/library/XenForo/Model/Session.php(444): Zend_Db_Adapter_Abstract->update('xf_user', Array, '(user_id = 1323...')
#4 /home/nadda/public_html/library/XenForo/CronEntry/CleanUp.php(32): XenForo_Model_Session->updateUserLastActivityFromSessions()
#5 /home/nadda/public_html/library/XenForo/Model/Cron.php(356): XenForo_CronEntry_CleanUp::runHourlyCleanUp(Array)
#6 /home/nadda/public_html/library/XenForo/Deferred/Cron.php(24): XenForo_Model_Cron->runEntry(Array)
#7 /home/nadda/public_html/library/XenForo/Model/Deferred.php(295): XenForo_Deferred_Cron->execute(Array, Array, 7.9999980926514, '')
#8 /home/nadda/public_html/library/XenForo/Model/Deferred.php(429): XenForo_Model_Deferred->runDeferred(Array, 7.9999980926514, '', false)
#9 /home/nadda/public_html/library/XenForo/Model/Deferred.php(374): XenForo_Model_Deferred->_runInternal(Array, 8, '', false)
#10 /home/nadda/public_html/deferred.php(23): XenForo_Model_Deferred->run(false)
#11 {main}

Request State

array(3) {
  ["url"] => string(39) "https://www.nirmoladda.com/deferred.php"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(4) {
    ["_xfRequestUri"] => string(29) "/admin.php?tools/run-deferred"
    ["_xfNoRedirect"] => string(1) "1"
    ["_xfToken"] => string(8) "********"
    ["_xfResponseType"] => string(4) "json"
  }
}
 

Mike

XenForo developer
Staff member
#2
There isn't really a fix. Deadlocks can happen. If you suddenly got a bunch of them, it may indicate your server had temporary problems (or a massive load spike). Unless they're happening with any regularity, it's best to ignore them.
 
Top