XF 1.5 Deadlock found when trying to get lock

Nirjonadda

Well-known member
How to fixing Deadlock found when trying to get lock?

Code:
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, 32 minutes ago
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/XenForo/Model/ImageProxy.php(791): Zend_Db_Adapter_Abstract->query('\n\t\t\tINSERT INTO...', Array)
#3 /home/nadda/public_html/library/XenForo/ProxyOutput.php(269): XenForo_Model_ImageProxy->logImageReferrer(275887, 'https://www.nir...')
#4 /home/nadda/public_html/library/XenForo/ProxyOutput.php(193): XenForo_ProxyOutput->_outputImage(false)
#5 /home/nadda/public_html/library/XenForo/ProxyOutput.php(426): XenForo_ProxyOutput->output()
#6 /home/nadda/public_html/proxy.php(12): XenForo_ProxyOutput::run()
#7 {main}

Request State

array(3) {
  ["url"] => string(146) "/proxy.php?image=http%3A%2F%2Fimg66.imagetwist.com%2Fth%2F15051%2Fht4r9lriyxqf.jpg&hash=ede395acf85b4cd0ffc8ffc443b69455"
  ["_GET"] => array(2) {
    ["image"] => string(53) "http://img66.imagetwist.com/th/15051/12.jpg"
    ["hash"] => string(32) "ede395acf85b4cd0ffc8ffc443b69455"
  }
  ["_POST"] => array(0) {
  }
}
 
If it's infrequent, it can be disregarded.

But its happen lot of time with /proxy.php, When happen Mysqli statement execute error : Deadlock found when trying to get lock then page loading take lot of time. why the deadlock error came up, I’m afraid it happens within internal functions of xF script?
 
Back
Top Bottom