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

[Ronald L.]

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

#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

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?

 

[Ronald L.]

Nvm fixed this by restarting nfs (nfs got caught up due to not having enough bandwidth available)