Page MenuHomePhabricator

Unable to apply 'phabricator:20150503.repositorysymbols.2.php': Unknown column 'r.spacePHID' in 'where clause'
Closed, ResolvedPublic

Description

The upgrade to the latest versions stops when trying to apply the following upgrade script:

phabricator:20150503.repositorysymbols.2.php

It seems similar to T8375 but refers to a different column.

The full error messsage is:

Applying patch 'phabricator:20150503.repositorysymbols.2.php'...
[2015-06-26 18:27:52] EXCEPTION: (AphrontSchemaQueryException) #1054: Unknown column 'r.spacePHID' in 'where clause' at [<phutil>/src/aphront/storage/connection/mysql/AphrontBaseMySQLDatabaseConnection.php:308]
arcanist(head=master, ref.master=29839e8c72c5), phabricator(head=master, ref.master=7c3a7f47cdf6), phutil(head=master, ref.master=ea6830cc8019)
  #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, string, string, string, string, string, string, string, string)
  #4 call_user_func_array(string, array) called at [<phutil>/src/xsprintf/queryfx.php:11]
  #5 queryfx_all(AphrontMySQLiDatabaseConnection, string, string, string, string, string, string, string, string, string, string) called at [<phabricator>/src/infrastructure/query/policy/PhabricatorCursorPagedPolicyAwareQuery.php:99]
  #6 PhabricatorCursorPagedPolicyAwareQuery::loadStandardPageRows(PhabricatorRepository) called at [<phabricator>/src/applications/repository/query/PhabricatorRepositoryQuery.php:159]
  #7 PhabricatorRepositoryQuery::loadPage() called at [<phabricator>/src/infrastructure/query/policy/PhabricatorPolicyAwareQuery.php:227]
  #8 PhabricatorPolicyAwareQuery::execute() called at [<phabricator>/src/infrastructure/query/policy/PhabricatorPolicyAwareQuery.php:167]
  #9 PhabricatorPolicyAwareQuery::executeOne() called at [<phabricator>/resources/sql/autopatches/20150503.repositorysymbols.2.php:15]
  #10 require_once(string) called at [<phabricator>/src/infrastructure/storage/management/PhabricatorStorageManagementAPI.php:226]
  #11 PhabricatorStorageManagementAPI::applyPatchPHP(string) called at [<phabricator>/src/infrastructure/storage/management/PhabricatorStorageManagementAPI.php:191]
  #12 PhabricatorStorageManagementAPI::applyPatch(PhabricatorStoragePatch) called at [<phabricator>/src/infrastructure/storage/management/workflow/PhabricatorStorageManagementUpgradeWorkflow.php:190]
  #13 PhabricatorStorageManagementUpgradeWorkflow::execute(PhutilArgumentParser) called at [<phutil>/src/parser/argument/PhutilArgumentParser.php:406]
  #14 PhutilArgumentParser::parseWorkflowsFull(array) called at [<phutil>/src/parser/argument/PhutilArgumentParser.php:301]
  #15 PhutilArgumentParser::parseWorkflows(array) called at [<phabricator>/scripts/sql/manage_storage.php:176]

Revisions and Commits

Event Timeline

FvD created this task.Jun 27 2015, 12:33 AM
FvD raised the priority of this task from to Needs Triage.
FvD updated the task description. (Show Details)
FvD added a subscriber: FvD.

Thanks for the report. That should fix the issue, let us know if you run into anything else.