• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

XF 1.4 Rebuilding templates for 2+ hours still not complete...

XxUnkn0wnxX

Active member
#1
i was in a rush to turn of all my add ones and i ran into a few dead locks

from there i started to rebuild templates from where it left off and its been going at it got 2+ hours which is a lot longer then it suppose to.. usually it takes about 8-15 min Max..

and now it like on a never ending loop. is there a way to find out if its in a loop or stuck somewhere?

and any ideas on fixing this?
 

Brogan

XenForo moderator
Staff member
#2
Try loading the install path manually - either in the same browser or a new one.
From there you may be able to commence a manual rebuild of the templates.
 

XxUnkn0wnxX

Active member
#4
and i been using several browsers.. i cleaned caches swapping non stop.. restarted apache and repaired mysql DB nothing worked...
 

XxUnkn0wnxX

Active member
#5
i had 9-10 errors of these b4 i started the rebuilding process:

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: XxUnkn0wnxX, Today at 9:35 PM
Stack Trace
#0 /home/admin/public_html/forums/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /home/admin/public_html/forums/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /home/admin/public_html/forums/library/Zend/Db/Adapter/Abstract.php(661): Zend_Db_Adapter_Abstract->query('DELETE FROM `xf...')
#3 /home/admin/public_html/forums/library/XenForo/Model/Template.php(1634): Zend_Db_Adapter_Abstract->delete('xf_template_inc...', 'source_map_id =...')
#4 /home/admin/public_html/forums/library/XenForo/Deferred/TemplatePartialCompile.php(55): XenForo_Model_Template->compileAndInsertParsedTemplate(15779, Array, 'PAGE_CONTAINER', 66)
#5 /home/admin/public_html/forums/library/XenForo/Model/Deferred.php(256): XenForo_Deferred_TemplatePartialCompile->execute(Array, Array, 7.9999961853, 'Rebuilding... T...')
#6 /home/admin/public_html/forums/library/XenForo/Model/Deferred.php(390): XenForo_Model_Deferred->runDeferred(Array, 7.9999961853, 'Rebuilding... T...', false)
#7 /home/admin/public_html/forums/library/XenForo/Model/Deferred.php(335): XenForo_Model_Deferred->_runInternal(Array, NULL, 'Rebuilding... T...', false)
#8 /home/admin/public_html/forums/library/XenForo/ControllerAdmin/Tools.php(159): XenForo_Model_Deferred->run(true, NULL, 'Rebuilding... T...', false)
#9 /home/admin/public_html/forums/library/XenForo/FrontController.php(347): XenForo_ControllerAdmin_Tools->actionRunDeferred()
#10 /home/admin/public_html/forums/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#11 /home/admin/public_html/forums/admin.php(13): XenForo_FrontController->run()
#12 {main}
Request State
array(3) {
  ["url"] => string(60) "http://portalcentric.net/forums/admin.php?tools/run-deferred"
  ["_GET"] => array(1) {
    ["tools/run-deferred"] => string(0) ""
  }
  ["_POST"] => array(5) {
    ["execute"] => string(1) "1"
    ["_xfRequestUri"] => string(26) "/forums/admin.php?add-ons/"
    ["_xfNoRedirect"] => string(1) "1"
    ["_xfToken"] => string(8) "********"
    ["_xfResponseType"] => string(4) "json"
  }
}
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: XxUnkn0wnxX, Today at 9:34 PM
Stack Trace
#0 /home/admin/public_html/forums/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /home/admin/public_html/forums/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /home/admin/public_html/forums/library/XenForo/Model/DataRegistry.php(164): Zend_Db_Adapter_Abstract->query('\r\n\t\t\tINSERT INT...', Array)
#3 /home/admin/public_html/forums/library/XenForo/Model/CodeEvent.php(421): XenForo_Model_DataRegistry->set('codeEventListen...', Array)
#4 /home/admin/public_html/forums/library/XenForo/Model/AddOn.php(513): XenForo_Model_CodeEvent->rebuildEventListenerCache()
#5 /home/admin/public_html/forums/library/XenForo/DataWriter/AddOn.php(164): XenForo_Model_AddOn->rebuildAddOnCachesAfterActiveSwitch(Array)
#6 /home/admin/public_html/forums/library/Waindigo/InstallUpgrade/Extend/XenForo/DataWriter/AddOn.php(93): XenForo_DataWriter_AddOn->_postSave()
#7 /home/admin/public_html/forums/library/XenForo/DataWriter.php(1409): Waindigo_InstallUpgrade_Extend_XenForo_DataWriter_AddOn->_postSave()
#8 /home/admin/public_html/forums/library/XenForo/ControllerAdmin/Abstract.php(134): XenForo_DataWriter->save()
#9 /home/admin/public_html/forums/library/XenForo/ControllerAdmin/AddOn.php(319): XenForo_ControllerAdmin_Abstract->_getToggleResponse(Array, 'XenForo_DataWri...', 'add-ons')
#10 /home/admin/public_html/forums/library/XenForo/FrontController.php(347): XenForo_ControllerAdmin_AddOn->actionToggle()
#11 /home/admin/public_html/forums/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#12 /home/admin/public_html/forums/admin.php(13): XenForo_FrontController->run()
#13 {main}
Request State
array(3) {
  ["url"] => string(56) "http://portalcentric.net/forums/admin.php?add-ons/toggle"
  ["_GET"] => array(1) {
    ["add-ons/toggle"] => string(0) ""
  }
  ["_POST"] => array(7) {
    ["filter"] => string(0) ""
    ["exists"] => array(111) {
      ["mercAds"] => string(1) "1"
      ["AddOnInstaller"] => string(1) "1"
      ["adminCPLoginEnhanced"] => string(1) "1"
      ["Waindigo_AdminImages"] => string(1) "1"
      ["Waindigo_AdminStyles"] => string(1) "1"
      ["liam_cpfirewall"] => string(1) "1"
      ["ragtekTeamIgnore"] => string(1) "1"
      ["Waindigo_Avatar"] => string(1) "1"
      ["BBM"] => string(1) "1"
      ["Sedo_AdvBBcodeBar"] => string(1) "1"
      ["media_sites_package"] => string(1) "1"
      ["BRCLU_ConversationUpdate"] => string(1) "1"
      ["*******_MetadataEssential"] => string(1) "1"
      ["*******_Pokes"] => string(1) "1"
      ["BRSCIA_SpamCleanerInAdmin"] => string(1) "1"
      ["*******_ThreadLiveUpdate"] => string(1) "1"
      ["*******_ProfileCover"] => string(1) "1"
      ["BR_UpgradeExpiredReminder"] => string(1) "1"
      ["SedoDetectBrowser"] => string(1) "1"
      ["clear_shoutbox"] => string(1) "1"
      ["click_trophy_points"] => string(1) "1"
      ["Waindigo_ContactUs"] => string(1) "1"
      ["Waindigo_ConvSearch"] => string(1) "1"
      ["Waindigo_ConvAccess"] => string(1) "1"
      ["dpAdPositioning"] => string(1) "1"
      ["mercDonationManager"] => string(1) "1"
      ["robboDonationSidebar"] => string(1) "1"
      ["DoublePost"] => string(1) "1"
      ["DragDropNodes"] => string(1) "1"
      ["cz_easyban"] => string(1) "1"
      ["Waindigo_EditUserJoinDate"] => string(1) "1"
      ["Waindigo_EmailAlerts"] => string(1) "1"
      ["EnableDebugFromAdminHome"] => string(1) "1"
      ["Waindigo_ExtraNodeInfo"] => string(1) "1"
      ["FollowersCount"] => string(1) "1"
      ["Waindigo_FontAweAcp"] => string(1) "1"
      ["Waindigo_Friends"] => string(1) "1"
      ["Waindigo_Genesis"] => string(1) "1"
      ["ragtekGCT"] => string(1) "1"
      ["Sedo_GoToTop"] => string(1) "1"
      ["Waindigo_InstallUpgrade"] => string(1) "1"
      ["InteractiveSnow"] => string(1) "1"
      ["LiveUpdate"] => string(1) "1"
      ["Waindigo_LoginAsUser"] => string(1) "1"
      ["LoginUserLocks"] => string(1) "1"
      ["MassAlert"] => string(1) "1"
      ["message_banned_shoutbox"] => string(1) "1"
      ["MobileReadTempBanGroup"] => string(1) "1"
      ["BorboleWelcome"] => string(1) "1"
      ["Waindigo_NodeNumbers"] => string(1) "1"
      ["NodesAsTabs"] => string(1) "1"
      ["moderatorbardropdown"] => string(1) "1"
      ["Waindigo_PrivacyGroups"] => string(1) "1"
      ["QMIAL"] => string(1) "1"
      ["BorboleRecentPosts"] => string(1) "1"
      ["ReputationSystem"] => string(1) "1"
      ["ResetPasswordFromACP"] => string(1) "1"
      ["cy_respollo"] => string(1) "1"
      ["DroidHost_ShowHooksName"] => string(1) "1"
      ["SmileyManager"] => string(1) "1"
      ["BannedAvatar"] => string(1) "1"
      ["StatsBar"] => string(1) "1"
      ["CustomImgCaptcha"] => string(1) "1"
      ["dedos"] => string(1) "1"
      ["StopCountrySpam"] => string(1) "1"
      ["stopHumanSpam"] => string(1) "1"
      ["tag_shoutbox"] => string(1) "1"
      ["TaigaChat"] => string(1) "1"
      ["TMS"] => string(1) "1"
      ["sedo_tinymce_quattro"] => string(1) "1"
      ["toggle_menu"] => string(1) "1"
      ["TPUFindDeletedPosts"] => string(1) "1"
      ["Waindigo_Trophies"] => string(1) "1"
      ["Waindigo_TrophyProgress"] => string(1) "1"
      ["twitterBbcode"] => string(1) "1"
      ["Waindigo_UndeleteUsers"] => string(1) "1"
      ["Waindigo_UserUpgrades"] => string(1) "1"
      ["cz_changeusername"] => string(1) "1"
      ["vfcoders_hide_hack"] => string(1) "1"
      ["Waindigo_Warnings"] => string(1) "1"
      ["WhoHasVisited"] => string(1) "1"
      ["XenResource"] => string(1) "1"
      ["XenLoginSecurity"] => string(1) "1"
      ["xenmoods"] => string(1) "1"
      ["xfa_bbcode_tabs"] => string(1) "1"
      ["xfa_bump_thread"] => string(1) "1"
      ["xfa_dice"] => string(1) "1"
      ["XxUnkn0wnxX"] => string(1) "1"
      ["EWRutiles_staff"] => string(1) "1"
      ["sedo_html5media"] => string(1) "1"
      ["bdMails"] => string(1) "1"
      ["bdPaygateBitpay"] => string(1) "1"
      ["bdPaygate"] => string(1) "1"
      ["bdTagMe"] => string(1) "1"
      ["widget_framework"] => string(1) "1"
      ["CrazYimProfileLinks"] => string(1) "1"
      ["administrateForum"] => string(1) "1"
      ["FHLogger"] => string(1) "1"
      ["FHTwoFactor"] => string(1) "1"
      ["FakeOnlineUser"] => string(1) "1"
      ["Banlist"] => string(1) "1"
      ["UsergroupWidget"] => string(1) "1"
      ["AccountDetection"] => string(1) "1"
      ["PromoteAndDemote"] => string(1) "1"
      ["rellect_adblock_detector"] => string(1) "1"
      ["rellect_favicon_for_links"] => string(1) "1"
      ["rellect_organize_tms"] => string(1) "1"
      ["OnlineStatusRibbon"] => string(1) "1"
      ["RTSpoiler"] => string(1) "1"
      ["StyleChooserVisitorPanel"] => string(1) "1"
      ["WGBB_Notes"] => string(1) "1"
    }
    ["id"] => array(64) {
      ["MassAlert"] => string(1) "1"
      ["message_banned_shoutbox"] => string(1) "1"
      ["MobileReadTempBanGroup"] => string(1) "1"
      ["BorboleWelcome"] => string(1) "1"
      ["Waindigo_NodeNumbers"] => string(1) "1"
      ["NodesAsTabs"] => string(1) "1"
      ["moderatorbardropdown"] => string(1) "1"
      ["Waindigo_PrivacyGroups"] => string(1) "1"
      ["QMIAL"] => string(1) "1"
      ["BorboleRecentPosts"] => string(1) "1"
      ["ReputationSystem"] => string(1) "1"
      ["ResetPasswordFromACP"] => string(1) "1"
      ["cy_respollo"] => string(1) "1"
      ["DroidHost_ShowHooksName"] => string(1) "1"
      ["SmileyManager"] => string(1) "1"
      ["BannedAvatar"] => string(1) "1"
      ["StatsBar"] => string(1) "1"
      ["dedos"] => string(1) "1"
      ["StopCountrySpam"] => string(1) "1"
      ["stopHumanSpam"] => string(1) "1"
      ["tag_shoutbox"] => string(1) "1"
      ["TaigaChat"] => string(1) "1"
      ["TMS"] => string(1) "1"
      ["sedo_tinymce_quattro"] => string(1) "1"
      ["toggle_menu"] => string(1) "1"
      ["TPUFindDeletedPosts"] => string(1) "1"
      ["Waindigo_Trophies"] => string(1) "1"
      ["Waindigo_TrophyProgress"] => string(1) "1"
      ["twitterBbcode"] => string(1) "1"
      ["Waindigo_UndeleteUsers"] => string(1) "1"
      ["cz_changeusername"] => string(1) "1"
      ["vfcoders_hide_hack"] => string(1) "1"
      ["Waindigo_Warnings"] => string(1) "1"
      ["WhoHasVisited"] => string(1) "1"
      ["XenResource"] => string(1) "1"
      ["XenLoginSecurity"] => string(1) "1"
      ["xenmoods"] => string(1) "1"
      ["xfa_bbcode_tabs"] => string(1) "1"
      ["xfa_bump_thread"] => string(1) "1"
      ["xfa_dice"] => string(1) "1"
      ["XxUnkn0wnxX"] => string(1) "1"
      ["EWRutiles_staff"] => string(1) "1"
      ["sedo_html5media"] => string(1) "1"
      ["bdMails"] => string(1) "1"
      ["bdPaygateBitpay"] => string(1) "1"
      ["bdPaygate"] => string(1) "1"
      ["bdTagMe"] => string(1) "1"
      ["widget_framework"] => string(1) "1"
      ["CrazYimProfileLinks"] => string(1) "1"
      ["administrateForum"] => string(1) "1"
      ["FHLogger"] => string(1) "1"
      ["FHTwoFactor"] => string(1) "1"
      ["FakeOnlineUser"] => string(1) "1"
      ["Banlist"] => string(1) "1"
      ["UsergroupWidget"] => string(1) "1"
      ["AccountDetection"] => string(1) "1"
      ["PromoteAndDemote"] => string(1) "1"
      ["rellect_adblock_detector"] => string(1) "1"
      ["rellect_favicon_for_links"] => string(1) "1"
      ["rellect_organize_tms"] => string(1) "1"
      ["OnlineStatusRibbon"] => string(1) "1"
      ["RTSpoiler"] => string(1) "1"
      ["StyleChooserVisitorPanel"] => string(1) "1"
      ["WGBB_Notes"] => string(1) "1"
    }
    ["_xfToken"] => string(8) "********"
    ["_xfRequestUri"] => string(26) "/forums/admin.php?add-ons/"
    ["_xfNoRedirect"] => string(1) "1"
    ["_xfResponseType"] => string(4) "json"
  }
}
 

HWS

Well-known member
#9
using Percona Server on a Cpanel Server
Deadlocks happen very often if a Percona or MariaDB cluster is used for MySQL. Since you use just a single MySQL server this is not applicable to you.

However it still looks like a database problem to me.