1. 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...

Discussion in 'Troubleshooting and Problems' started by XxUnkn0wnxX, Jan 7, 2015.

  1. XxUnkn0wnxX

    XxUnkn0wnxX Active Member

    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?
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

    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.
     
  3. XxUnkn0wnxX

    XxUnkn0wnxX Active Member

  4. XxUnkn0wnxX

    XxUnkn0wnxX Active Member

    and i been using several browsers.. i cleaned caches swapping non stop.. restarted apache and repaired mysql DB nothing worked...
     
  5. XxUnkn0wnxX

    XxUnkn0wnxX Active Member

    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"
      }
    }
     
  6. XxUnkn0wnxX

    XxUnkn0wnxX Active Member

    ok it finally completed after 4+ hours this isn't normal...
     
  7. HWS

    HWS Well-Known Member

    Are you using a MySQL Galera multi master setup?
     
  8. XxUnkn0wnxX

    XxUnkn0wnxX Active Member

    using Percona Server on a Cpanel Server
     
  9. HWS

    HWS Well-Known Member

    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.
     

Share This Page