XF 1.2 Deadlock ?

[Adam Howard]

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, Yesterday at 7:30 AM

Stack Trace

#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

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?

 

[Digital Doctor]

Similar [here]

 

[Jeremy]

http://stackoverflow.com/questions/...ck-found-when-trying-to-get-lock-try-restarti
http://dev.mysql.com/doc/refman/5.0/en/innodb-deadlocks.html

Does it keep happening or has it gone away?

 

[Digital Doctor]

Not directly. It's an internal condition of the MySQL server, not an error with an addon.

Deadlocks can happen though they should be very rare. In general they're not easy to completely prevent though and they're hard to handle programmatically. A refresh/retry of the action is usually sufficient.

 

[Adam Howard]

http://stackoverflow.com/questions/...ck-found-when-trying-to-get-lock-try-restarti
http://dev.mysql.com/doc/refman/5.0/en/innodb-deadlocks.html

Does it keep happening or has it gone away?

It has only happen once yesterday at 7:30 AM.

Don't know the cause and thus neither the solution

 

[Jeremy]

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]

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?

 

[Jeremy]

Yes:

Deadlocks are a condition of the mySQL server itself

 

[CTXMedia]

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.