Page MenuHomePhabricator

Unable to Migrate Herald conditions which use mailing lists.. fails (Table 'phabricator_herald.herald_actionrecord' doesn't exist)
Closed, ResolvedPublic

Description

When trying to upgrade from an older installation of Phabricator, I run into the following issue:

Applying patch 'phabricator:20150606.mlist.1.php'...
Migrating Herald conditions which use mailing lists..
[2015-07-25 14:44:46] EXCEPTION: (AphrontSchemaQueryException) #1146: Table 'phabricator_herald.herald_actionrecord' doesn't exist at [<phutil>/src/aphront/storage/connection/mysql/AphrontBaseMySQLDatabaseConnection.php:308]
arcanist(head=master, ref.master=5fcf7b5a3b9e), phabricator(head=master, ref.master=36fc6a622c35), phutil(head=master, ref.master=aa6cd8f7e5e5)
  #0 AphrontBaseMySQLDatabaseConnection::throwQueryCodeException(integer, string) called at [<phutil>/src/aphront/storage/connection/mysql/AphrontBaseMySQLDatabaseConnection.php:275]
  #1 AphrontBaseMySQLDatabaseConnection::throwQueryException(mysqli) called at [<phutil>/src/aphront/storage/connection/mysql/AphrontBaseMySQLDatabaseConnection.php:181]
  #2 AphrontBaseMySQLDatabaseConnection::executeRawQuery(string) called at [<phutil>/src/xsprintf/queryfx.php:6]
  #3 queryfx(AphrontMySQLiDatabaseConnection, string, string, integer, integer, string)
  #4 call_user_func_array(string, array) called at [<phutil>/src/xsprintf/queryfx.php:11]
  #5 queryfx_all(AphrontMySQLiDatabaseConnection, string, string, integer, integer, string)
  #6 call_user_func_array(string, array) called at [<phutil>/src/aphront/storage/connection/AphrontDatabaseConnection.php:22]
  #7 AphrontDatabaseConnection::queryData(string, string, integer, integer, string)
  #8 call_user_func_array(array, array) called at [<phabricator>/src/infrastructure/storage/lisk/LiskDAO.php:535]
  #9 LiskDAO::loadRawDataWhere(string, integer, integer)
  #10 call_user_func_array(array, array) called at [<phabricator>/src/infrastructure/storage/lisk/LiskDAO.php:476]
  #11 LiskDAO::loadAllWhere(string, integer, integer) called at [<phabricator>/src/infrastructure/storage/lisk/LiskMigrationIterator.php:41]
  #12 LiskMigrationIterator::loadPage() called at [<phutil>/src/utils/PhutilBufferedIterator.php:129]
  #13 PhutilBufferedIterator::next() called at [<phutil>/src/utils/PhutilBufferedIterator.php:84]
  #14 PhutilBufferedIterator::rewind() called at [<phabricator>/resources/sql/autopatches/20150606.mlist.1.php:104]
  #15 require_once(string) called at [<phabricator>/src/infrastructure/storage/management/PhabricatorStorageManagementAPI.php:226]
  #16 PhabricatorStorageManagementAPI::applyPatchPHP(string) called at [<phabricator>/src/infrastructure/storage/management/PhabricatorStorageManagementAPI.php:191]
  #17 PhabricatorStorageManagementAPI::applyPatch(PhabricatorStoragePatch) called at [<phabricator>/src/infrastructure/storage/management/workflow/PhabricatorStorageManagementUpgradeWorkflow.php:190]
  #18 PhabricatorStorageManagementUpgradeWorkflow::execute(PhutilArgumentParser) called at [<phutil>/src/parser/argument/PhutilArgumentParser.php:406]
  #19 PhutilArgumentParser::parseWorkflowsFull(array) called at [<phutil>/src/parser/argument/PhutilArgumentParser.php:301]
  #20 PhutilArgumentParser::parseWorkflows(array) called at [<phabricator>/scripts/sql/manage_storage.php:176]

Event Timeline

rene raised the priority of this task from to Needs Triage.
rene updated the task description. (Show Details)
rene added a subscriber: rene.

FYI

I worked around the update issue by using

git fetch
git reset --hard 6be53bd9160807fb7c829b72b23025d233f7072c

(as suggested on the IRC)

I had a test instance running from ~1 week ago where this was the last commit, and updating to this point from an old install of phabricator worked without issues.

Next step was to update further with git pulll and this progressed without any issues.

epriestley triaged this task as Normal priority.