XF 1.5 Mysqli statement execute error : Lock wait timeout exceeded; try restarting transaction - library/Zend/Db/Statemen

Ronald L.

Member
Hello,

Yesterday i deleted some add-ons and tried to remove some languages from my forum but and after ~60 sec i got Server Error Too many connections
Tried to uninstall it again by clicking on "There are manual rebuild processes that have been stopped before completion. Click here to complete them." But still the same and won't let me uninstall/install anything...

Error Info
Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Lock wait timeout exceeded; try restarting transaction - library/Zend/Db/Statement/Mysqli.php:214
Code:
#0 /share/www/forum/public_html/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /share/www/forum/public_html/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /share/www/forum/public_html/library/XenForo/Model/Template.php(1692): Zend_Db_Adapter_Abstract->query('\r\n\t\t\tINSERT INT...', Array)
#3 /share/www/forum/public_html/library/XenForo/Model/Template.php(1617): XenForo_Model_Template->_insertCompiledTemplateRecord(23, 2, 'ad_thread_view_...', '$__output = '';...')
#4 /share/www/forum/public_html/library/XenForo/Deferred/TemplatePartialCompile.php(54): XenForo_Model_Template->compileAndInsertParsedTemplate(1658, Array, 'ad_thread_view_...', 23)
#5 /share/www/forum/public_html/library/XenForo/Model/Deferred.php(295): XenForo_Deferred_TemplatePartialCompile->execute(Array, Array, 8, 'Rebuilding... T...')
#6 /share/www/forum/public_html/library/XenForo/Model/Deferred.php(429): XenForo_Model_Deferred->runDeferred(Array, 8, 'Rebuilding... T...', false)
#7 /share/www/forum/public_html/library/XenForo/Model/Deferred.php(374): XenForo_Model_Deferred->_runInternal(Array, 8, 'Rebuilding... T...', false)
#8 /share/www/forum/public_html/library/XenForo/ControllerAdmin/Tools.php(159): XenForo_Model_Deferred->run(true, NULL, 'Rebuilding... T...', false)
#9 /share/www/forum/public_html/library/XenForo/FrontController.php(369): XenForo_ControllerAdmin_Tools->actionRunDeferred()
#10 /share/www/forum/public_html/library/XenForo/FrontController.php(152): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#11 /share/www/forum/public_html/admin.php(13): XenForo_FrontController->run()
#12 {main}

Request State
Code:
array(3) {
  ["url"] => string(48) "https://forum.com/admin.php?tools/run-deferred"
  ["_GET"] => array(1) {
    ["tools/run-deferred"] => string(0) ""
  }
  ["_POST"] => array(5) {
    ["execute"] => string(1) "1"
    ["_xfRequestUri"] => string(24) "/admin.php?tools/rebuild"
    ["_xfNoRedirect"] => string(1) "1"
    ["_xfToken"] => string(8) "********"
    ["_xfResponseType"] => string(4) "json"
  }
}

Anyone know what's wrong... >_<
Is safe to delete them from `xf_deferred' table and try again?

Capture.PNG
 
Top