CiviCRM Community Forums (archive)

I have tried upgrading an installation from 4.4.x to 4.5.0 and it consistently hangs after 'Executed: Migrate honoree information to module_data'.  Is the best thing to restore the files to 4.4.x and the database from backup and try again?  Any suggestions on where one might look.  Is it significant that the process has deleted all the database triggers?

Thanks for a quick reply.  The upgrade process appears to hang 'forever', but has occasionally given a database error, which I think is what this log entry refers to:

06 09:29:20  [info] $backTrace = #0 /home/missio95/public_html/livetest/administrator/components/com_civicrm/civicrm/CRM/Core/Error.php(866): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 [internal function](): CRM_Core_Error::exceptionHandler(Object(DB_Error))
#2 /home/missio95/public_html/livetest/administrator/components/com_civicrm/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
#3 /home/missio95/public_html/livetest/administrator/components/com_civicrm/civicrm/packages/DB.php(975): PEAR_Error->PEAR_Error("DB Error: no database selected", -14, 16, (Array:2), "SET NAMES utf8 [nativecode=2006 ** MySQL server has gone away]")
#4 /home/missio95/public_html/livetest/administrator/components/com_civicrm/civicrm/packages/PEAR.php(564): DB_Error->DB_Error(-14, 16, (Array:2), "SET NAMES utf8 [nativecode=2006 ** MySQL server has gone away]")
#5 /home/missio95/public_html/livetest/administrator/components/com_civicrm/civicrm/packages/DB/common.php(1905): PEAR->raiseError(NULL, -14, NULL, NULL, "SET NAMES utf8 [nativecode=2006 ** MySQL server has gone away]", "DB_Error", TRUE)
#6 /home/missio95/public_html/livetest/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php(899): DB_common->raiseError(-14, NULL, NULL, NULL, "2006 ** MySQL server has gone away")
#7 /home/missio95/public_html/livetest/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php(309): DB_mysql->mysqlRaiseError(-14)
#8 /home/missio95/public_html/livetest/administrator/components/com_civicrm/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery("SET NAMES utf8")
#9 /home/missio95/public_html/livetest/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php(2442): DB_common->query("SET NAMES utf8")
#10 /home/missio95/public_html/livetest/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php(1634): DB_DataObject->_query("SET NAMES utf8")
#11 /home/missio95/public_html/livetest/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php(325): DB_DataObject->query("SET NAMES utf8")
#12 /home/missio95/public_html/livetest/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php(366): CRM_Core_DAO->query("SET NAMES utf8")
#13 /home/missio95/public_html/livetest/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php(86): CRM_Core_DAO->initialize()
#14 /home/missio95/public_html/livetest/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php(1106): CRM_Core_DAO->__construct()
#15 /home/missio95/public_html/livetest/administrator/components/com_civicrm/civicrm/CRM/Queue/Queue/Sql.php(221): CRM_Core_DAO::executeQuery("UPDATE civicrm_queue_item SET release_time = NULL WHERE id = %1", (Array:1))
#16 /home/missio95/public_html/livetest/administrator/components/com_civicrm/civicrm/CRM/Queue/Runner.php(249): CRM_Queue_Queue_Sql->releaseItem(Object(CRM_Queue_DAO_QueueItem))
#17 /home/missio95/public_html/livetest/administrator/components/com_civicrm/civicrm/CRM/Queue/Runner.php(203): CRM_Queue_Runner->releaseErrorItem(Object(CRM_Queue_DAO_QueueItem))
#18 /home/missio95/public_html/livetest/administrator/components/com_civicrm/civicrm/CRM/Queue/Page/AJAX.php(48): CRM_Queue_Runner->runNext(TRUE)
#19 /home/missio95/public_html/livetest/administrator/components/com_civicrm/civicrm/CRM/Queue/ErrorPolicy.php(89): CRM_Queue_Page_AJAX::{closure}()
#20 /home/missio95/public_html/livetest/administrator/components/com_civicrm/civicrm/CRM/Queue/Page/AJAX.php(51): CRM_Queue_ErrorPolicy->call(Object(Closure))
#21 [internal function](): CRM_Queue_Page_AJAX::runNext()
#22 /home/missio95/public_html/livetest/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php(296): call_user_func((Array:2))
#23 /home/missio95/public_html/livetest/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php(75): CRM_Core_Invoke::runItem((Array:13))
#24 /home/missio95/public_html/livetest/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:5))
#25 /home/missio95/public_html/livetest/administrator/components/com_civicrm/admin.civicrm.php(116): CRM_Core_Invoke::invoke((Array:5))
#26 /home/missio95/public_html/livetest/administrator/components/com_civicrm/admin.civicrm.php(40): civicrm_invoke()
#27 /home/missio95/public_html/livetest/libraries/joomla/application/component/helper.php(380): require_once("/home/missio95/public_html/livetest/administrator/components/com_civicrm/admi...")
#28 /home/missio95/public_html/livetest/libraries/joomla/application/component/helper.php(348): JComponentHelper::executeComponent("/home/missio95/public_html/livetest/administrator/components/com_civicrm/admi...")
#29 /home/missio95/public_html/livetest/administrator/includes/application.php(153): JComponentHelper::renderComponent("com_civicrm")
#30 /home/missio95/public_html/livetest/administrator/index.php(46): JAdministrator->dispatch()
#31 {main}


Oct 06 09:29:20  [info] $CRM_Queue_ErrorPolicy_reportException = PEAR_Exception: "DB Error: no database selected"
 * ERROR TYPE: DB_Error
 * ERROR CODE: -14
 * ERROR MESSAGE: DB Error: no database selected
 * ERROR MODE: 16
 * ERROR USERINFO: SET NAMES utf8 [nativecode=2006 ** MySQL server has gone away]
 * ERROR DEBUGINFO: SET NAMES utf8 [nativecode=2006 ** MySQL server has gone away]
#0 [internal function](): CRM_Core_Error::exceptionHandler(Object(DB_Error))
#1 /home/missio95/public_html/livetest/administrator/components/com_civicrm/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
#2 /home/missio95/public_html/livetest/administrator/components/com_civicrm/civicrm/packages/DB.php(975): PEAR_Error->PEAR_Error("DB Error: no database selected", -14, 16, (Array:2), "SET NAMES utf8 [nativecode=2006 ** MySQL server has gone away]")
#3 /home/missio95/public_html/livetest/administrator/components/com_civicrm/civicrm/packages/PEAR.php(564): DB_Error->DB_Error(-14, 16, (Array:2), "SET NAMES utf8 [nativecode=2006 ** MySQL server has gone away]")
#4 /home/missio95/public_html/livetest/administrator/components/com_civicrm/civicrm/packages/DB/common.php(1905): PEAR->raiseError(NULL, -14, NULL, NULL, "SET NAMES utf8 [nativecode=2006 ** MySQL server has gone away]", "DB_Error", TRUE)
#5 /home/missio95/public_html/livetest/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php(899): DB_common->raiseError(-14, NULL, NULL, NULL, "2006 ** MySQL server has gone away")
#6 /home/missio95/public_html/livetest/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php(309): DB_mysql->mysqlRaiseError(-14)
#7 /home/missio95/public_html/livetest/administrator/components/com_civicrm/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery("SET NAMES utf8")
#8 /home/missio95/public_html/livetest/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php(2442): DB_common->query("SET NAMES utf8")
#9 /home/missio95/public_html/livetest/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php(1634): DB_DataObject->_query("SET NAMES utf8")
#10 /home/missio95/public_html/livetest/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php(325): DB_DataObject->query("SET NAMES utf8")
#11 /home/missio95/public_html/livetest/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php(366): CRM_Core_DAO->query("SET NAMES utf8")
#12 /home/missio95/public_html/livetest/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php(86): CRM_Core_DAO->initialize()
#13 /home/missio95/public_html/livetest/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php(1106): CRM_Core_DAO->__construct()
#14 /home/missio95/public_html/livetest/administrator/components/com_civicrm/civicrm/CRM/Queue/Queue/Sql.php(221): CRM_Core_DAO::executeQuery("UPDATE civicrm_queue_item SET release_time = NULL WHERE id = %1", (Array:1))
#15 /home/missio95/public_html/livetest/administrator/components/com_civicrm/civicrm/CRM/Queue/Runner.php(249): CRM_Queue_Queue_Sql->releaseItem(Object(CRM_Queue_DAO_QueueItem))
#16 /home/missio95/public_html/livetest/administrator/components/com_civicrm/civicrm/CRM/Queue/Runner.php(203): CRM_Queue_Runner->releaseErrorItem(Object(CRM_Queue_DAO_QueueItem))
#17 /home/missio95/public_html/livetest/administrator/components/com_civicrm/civicrm/CRM/Queue/Page/AJAX.php(48): CRM_Queue_Runner->runNext(TRUE)
#18 /home/missio95/public_html/livetest/administrator/components/com_civicrm/civicrm/CRM/Queue/ErrorPolicy.php(89): CRM_Queue_Page_AJAX::{closure}()
#19 /home/missio95/public_html/livetest/administrator/components/com_civicrm/civicrm/CRM/Queue/Page/AJAX.php(51): CRM_Queue_ErrorPolicy->call(Object(Closure))
#20 [internal function](): CRM_Queue_Page_AJAX::runNext()
#21 /home/missio95/public_html/livetest/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php(296): call_user_func((Array:2))
#22 /home/missio95/public_html/livetest/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php(75): CRM_Core_Invoke::runItem((Array:13))
#23 /home/missio95/public_html/livetest/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:5))
#24 /home/missio95/public_html/livetest/administrator/components/com_civicrm/admin.civicrm.php(116): CRM_Core_Invoke::invoke((Array:5))
#25 /home/missio95/public_html/livetest/administrator/components/com_civicrm/admin.civicrm.php(40): civicrm_invoke()
#26 /home/missio95/public_html/livetest/libraries/joomla/application/component/helper.php(380): require_once("/home/missio95/public_html/livetest/administrator/components/com_civicrm/admi...")
#27 /home/missio95/public_html/livetest/libraries/joomla/application/component/helper.php(348): JComponentHelper::executeComponent("/home/missio95/public_html/livetest/administrator/components/com_civicrm/admi...")
#28 /home/missio95/public_html/livetest/administrator/includes/application.php(153): JComponentHelper::renderComponent("com_civicrm")
#29 /home/missio95/public_html/livetest/administrator/index.php(46): JAdministrator->dispatch()
#30 {main}

I ended up porting the environment to a local machine where I could after some fiddling around get the update to run and then importing the database back to its original location.  It is a pity the update process can't be set to log what it is doing so one can tell exactly where it fails, if it does fail.