Page MenuHomePhabricator

Phabricator upgrade error
Closed, DuplicatePublic

Description

Environment: RedHat Linux (RHEL) 6.5
DB: MySql 5.1.71
Web Server: Apache httpd

Issue:
History: I have run this script many times, even last week and everything was working perfectly. But when I ran the script on Oct 3rd Friday, I could not get Phabrictor up and had to skip all the steps in the script and go directly to Apache httpd.
Script: http://www.phabricator.com/rsrc/install/update_phabricator.sh

+ ROOT=/app
+ cd /app/libphutil
+ git pull
Already up-to-date.
+ cd /app/arcanist
+ git pull
Already up-to-date.
+ cd /app/phabricator
+ git pull
Already up-to-date.
+ /app/phabricator/bin/phd stop
There are no running Phabricator daemons.
+ sudo /etc/init.d/httpd stop
Stopping httpd: [FAILED]
+ /app/phabricator/bin/storage upgrade
Before running storage upgrades, you should take down the Phabricator webinterface and stop any running Phabricator daemons (you can disable this warning with --force).

Are you ready to continue? [y/N] :y

Applying patch 'phabricator:db.almanac'...
[2014-10-06 10:31:33] EXCEPTION: (AphrontQueryException) #1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL
server version for the right syntax to use near 'binary' at line 1 at [<phutil>/src/aphront/storage/connection/mysql/AphrontBaseMySQLDatabaseConnection.php:308]

#0 AphrontBaseMySQLDatabaseConnection::throwQueryCodeException(integer, string) called at <phutil>/src/aphront/storage/connection/mysql/AphrontBase

MySQLDatabaseConnection.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) called at <phabricator>/src/infrastructure/storage/management/PhabricatorStorageManagementAPI.php:119]
#4 PhabricatorStorageManagementAPI::createDatabase(string) called at <phabricator>/src/infrastructure/storage/management/PhabricatorStorageManageme

ntAPI.php:169]

#5 PhabricatorStorageManagementAPI::applyPatch(PhabricatorStoragePatch) called at <phabricator>/src/infrastructure/storage/management/workflow/PhabricatorStorageManagementUpgradeWorkflow.php:168]
#6 PhabricatorStorageManagementUpgradeWorkflow::execute(PhutilArgumentParser) called at <phutil>/src/parser/argument/PhutilArgumentParser.php:394]
#7 PhutilArgumentParser::parseWorkflowsFull(array) called at [<phutil>/src/parser/argument/PhutilArgumentParser.php:290]
#8 PhutilArgumentParser::parseWorkflows(array) called at [<phabricator>/scripts/sql/manage_storage.php:163]

My first thought was the database connection, but I can rule that out, as I am able to bring up Phabricator an .

We have been using Phabricator for over 6 months now, and we LOVE it....

Event Timeline

r8j3 assigned this task to epriestley.
r8j3 raised the priority of this task from to High.
r8j3 updated the task description. (Show Details)
r8j3 added a project: Phabricator.
r8j3 added a subscriber: r8j3.
r8j3 updated the task description. (Show Details)