After update we found that creating tasks is not possible anymore. Only error we see:
Unhandled Exception ("AphrontSchemaQueryException")
#1054: Unknown column 'projectPHIDs' in 'field list'NOTE: This usually indicates that the MySQL schema has not been properly upgraded. Run 'bin/storage upgrade' to ensure your schema is up to date.
Database schema was not changed by hand, we already use bin/storage upgrade
How to reproduce (I don't sure you will be succeeded):
- use phabricator about 2 month without updates
- update it via update_phabricator.sh
From logs:
2016/02/26 15:12:02 [error] 13134#0: *4312 FastCGI sent in stderr: "PHP message: PHP Fatal error: Uncaught exception 'Exception' with message 'Process exited with an open transaction! The transaction will be implicitly rolled back. Calls to openTransaction() must always be paired with a call to saveTransaction() or killTransaction().' in /home/ylphil/sites/phabricator/libphutil/src/aphront/storage/connection/AphrontDatabase" while reading upstream, client: 32.130.91.221, server: phabricator.orbilet.ru, request: "POST /maniphest/task/edit/form/default/ HTTP/1.1", upstream: "fastcgi://unix:/var/run/php5-fpm.sock:", host: "phabricator.orbilet.ru"
2016/02/26 15:12:02 [error] 13134#0: *4312 FastCGI sent in stderr: "TransactionState.php:78
Stack trace:
#0 [internal function]: AphrontDatabaseTransactionState->__destruct()
#1 {main}
thrown in /home/ylphil/sites/phabricator/libphutil/src/aphront/storage/connection/AphrontDatabaseTransactionState.php on line 78" while reading upstream, client: 32.130.91.221, server: phabricator.orbilet.ru, request: "POST /maniphest/task/edit/form/default/ HTTP/1.1", upstream: "fastcgi://unix:/var/run/php5-fpm.sock:", host: "phabricator.orbilet.ru"
2016/02/26 15:12:41 [error] 13134#0: *4333 FastCGI sent in stderr: "PHP message: [2016-02-26 15:12:41] EXCEPTION: (AphrontSchemaQueryException) #1054: Unknown column 'projectPHIDs' in 'field list' at [<phutil>/src/aphront/storage/connection/mysql/AphrontBaseMySQLDatabaseConnection.php:310]
PHP message: arcanist(head=stable, ref.master=57f6fb59d739, ref.stable=ed476cf8489c), phabricator(head=stable, ref.master=b5518d4bfb0d, ref.stable=ad53db0979de), phutil(head=stable, ref.master=f43291e99d36, ref.stable=9c472e7c9b64)
PHP message: #0 <#2> AphrontBaseMySQLDatabaseConnection::throwCommonException(integer, string) called at [<phutil>/src/aphront/storage/connection/mysql/AphrontBaseMySQLDatabaseConnection.php:333]
PHP message: #1 <#2> AphrontBaseMySQLDatabaseConnection::throwQueryCodeException(integer, string) called at [<phutil>/src/aphront/storage/connection/mysql/AphrontBaseMySQLDatabaseConnection.php:275]
PHP message: #2 <#2> AphrontBaseMySQLDatabaseConnection::throwQueryException(mysqli) called at [<phutil>/src/aphront/storage/connection/mysql/AphrontBaseMySQLDatabaseConnection.php:181]
PHP message: #3 <#2> AphrontBaseMySQLDatabaseConnection::executeRawQuery(string) called at [<phutil>/src/xsprintf/queryfx.php:6]
PHP message: #4 <#2> queryfx(AphrontMySQLiDatabaseConnection, string, string, string, array, string)
PHP message: #5 <#2> call_user_func_array(string, array) called at [<phutil>/src/aphront/storage/connection/AphrontDatabaseConnection.php:28]
PHP message: #6 <#2> AphrontDatabaseConnection::query(string, string, string, array, string) called at [<phabricator>/src/infrastructure/storage/lisk/LiskDAO.php:1261]
PHP message: #7 <#2> LiskDAO::insertRecordIntoDatabase(string) c" while reading response header from upstream, client: 32.130.91.221, server: phabricator.orbilet.ru, request: "POST /maniphest/task/edit/form/default/ HTTP/1.1", upstream: "fastcgi://unix:/var/run/php5-fpm.sock:", host: "phabricator.orbilet.ru"
2016/02/26 15:12:41 [error] 13134#0: *4333 FastCGI sent in stderr: "alled at [<phabricator>/src/infrastructure/storage/lisk/LiskDAO.php:1106]
PHP message: #8 <#2> LiskDAO::insert() called at [<phabricator>/src/infrastructure/storage/lisk/LiskDAO.php:1075]
PHP message: #9 <#2> LiskDAO::save() called at [<phabricator>/src/applications/maniphest/storage/ManiphestTask.php:201]
PHP message: #10 <#2> ManiphestTask::save() called at [<phabricator>/src/applications/transactions/editor/PhabricatorApplicationTransactionEditor.php:897]
PHP message: #11 <#2> PhabricatorApplicationTransactionEditor::applyTransactions(ManiphestTask, array) called at [<phabricator>/src/applications/transactions/editengine/PhabricatorEditEngine.php:896]
PHP message: #12 <#2> PhabricatorEditEngine::buildEditResponse(ManiphestTask) called at [<phabricator>/src/applications/transactions/editengine/PhabricatorEditEngine.php:792]
PHP message: #13 <#2> PhabricatorEditEngine::buildResponse() called at [<phabricator>/src/applications/maniphest/controller/ManiphestTaskEditController.php:12]
PHP message: #14 <#2> ManiphestTaskEditController::handleRequest(AphrontRequest) called at [<phabricator>/src/aphront/configuration/AphrontApplicationConfiguration.php:237]
PHP message: #15 phlog(AphrontSchemaQueryException) called at [<phabricator>/src/aphront/handler/PhabricatorDefaultRequestExceptionHandler.php:32]
PHP message: #16 PhabricatorDefaultRequestExceptionHandler::handleRequestException(AphrontRequest, AphrontSchemaQueryException) called at [<phabricator>/src/aphront/configuration/AphrontApplicationConfiguration.php:632]
PHP message: #17 AphrontApplicationConfiguration::handleException(AphrontSchemaQueryException) called at [<phabricator>/src/aphront/configuration/AphrontApplicationConfiguration.php:242]
PHP message: #18 AphrontApplicationConfiguration::processRequest(AphrontRequest, PhutilDeferredLog, AphrontPHPHTTPSink, MultimeterControl) called at [<phabricator>/src/aphront/configuration/AphrontApplicationConfiguration.php:149]How to return phabricator back to normal life?