Change Details

We're having a situation on our Phabricator instance where Diffusion is doing weird stuff with repositories that we have imported from Github. See, e.g.,: https://phab.met.no/rNCLOADf91b56d499749e5bec65ca41c70572242816ebaf I noticed this because our feed on the homepage is getting spammed by these commit messages every five minutes or so. What do we do to fix this (other than take affected the repositories down)? Haven't touched the installation yet, in case I destroy some information that would be useful for debugging, but can't let this continue for much longer. This is happening with at least two of our repositories. Interestingly, the two people whose commits this appears to be happening with are both former employees, so not users registered in Phabricator.

We're having a situation on our Phabricator instance where Diffusion is doing weird stuff with repositories that we have imported from Github. See, e.g.,: https://phab.met.no/rNCLOADf91b56d499749e5bec65ca41c70572242816ebaf I noticed this because our feed on the homepage is getting spammed by these commit messages every five minutes or so. What do we do to fix this (other than take affected the repositories down)? Haven't touched the installation yet, in case I destroy some information that would be useful for debugging, but can't let this continue for much longer. This is happening with at least two of our repositories. Interestingly, the two people whose commits this appears to be happening with are both former employees, so not users registered in Phabricator. ------------------ Problems remaining: See T1191 typical trace: Daemon 304 STDE [Mon, 20 Oct 2014 17:10:48 -0700] [2014-10-20 17:10:48] EXCEPTION: (PhutilProxyException) Error while executing task ID 9711 from queue. {>} (AphrontCharacterSetQueryException) Attempting to construct a query containing characters outside of the Unicode Basic Multilingual Plane. MySQL will silently truncate this data if it is inserted into a `utf8` column. Use the `%B` conversion to escape binary strings data. at [<phutil>/src/aphront/storage/connection/mysql/AphrontBaseMySQLDatabaseConnection.php:346] Daemon 304 STDE [Mon, 20 Oct 2014 17:10:48 -0700] #0 AphrontBaseMySQLDatabaseConnection::validateUTF8String(string) called at [<phutil>/src/aphront/storage/connection/mysql/AphrontMySQLiDatabaseConnection.php:10] Daemon 304 STDE [Mon, 20 Oct 2014 17:10:48 -0700] #1 AphrontMySQLiDatabaseConnection::escapeUTF8String(string) called at [<phutil>/src/xsprintf/qsprintf.php:170] Daemon 304 STDE [Mon, 20 Oct 2014 17:10:48 -0700] #2 xsprintf_query(AphrontMySQLiDatabaseConnection, string, integer, string, integer) called at [<phutil>/src/xsprintf/xsprintf.php:63] Daemon 304 STDE [Mon, 20 Oct 2014 17:10:48 -0700] #3 xsprintf(string, AphrontMySQLiDatabaseConnection, array) called at [<phutil>/src/xsprintf/qsprintf.php:64] Daemon 304 STDE [Mon, 20 Oct 2014 17:10:48 -0700] #4 qsprintf(AphrontMySQLiDatabaseConnection, string, string, string) called at [<phabricator>/src/infrastructure/storage/lisk/LiskDAO.php:1101] Daemon 304 STDE [Mon, 20 Oct 2014 17:10:48 -0700] #5 LiskDAO::update() called at [<phabricator>/src/infrastructure/storage/lisk/LiskDAO.php:1041] Daemon 304 STDE [Mon, 20 Oct 2014 17:10:48 -0700] #6 LiskDAO::save() called at [<phabricator>/src/applications/repository/storage/PhabricatorRepositoryCommit.php:165] Daemon 304 STDE [Mon, 20 Oct 2014 17:10:48 -0700] #7 PhabricatorRepositoryCommit::save() called at [<phabricator>/src/applications/repository/worker/commitmessageparser/PhabricatorRepositoryCommitMessageParserWorker.php:78] Daemon 304 STDE [Mon, 20 Oct 2014 17:10:48 -0700] #8 PhabricatorRepositoryCommitMessageParserWorker::updateCommitData(DiffusionCommitRef) called at [<phabricator>/src/applications/repository/worker/commitmessageparser/PhabricatorRepositoryGitCommitMessageParserWorker.php:15] Daemon 304 STDE [Mon, 20 Oct 2014 17:10:48 -0700] #9 PhabricatorRepositoryGitCommitMessageParserWorker::parseCommit(PhabricatorRepository, PhabricatorRepositoryCommit) called at [<phabricator>/src/applications/repository/worker/PhabricatorRepositoryCommitParserWorker.php:44] Daemon 304 STDE [Mon, 20 Oct 2014 17:10:48 -0700] #10 PhabricatorRepositoryCommitParserWorker::doWork() called at [<phabricator>/src/infrastructure/daemon/workers/PhabricatorWorker.php:87] Daemon 304 STDE [Mon, 20 Oct 2014 17:10:48 -0700] #11 PhabricatorWorker::executeTask() called at [<phabricator>/src/infrastructure/daemon/workers/storage/PhabricatorWorkerActiveTask.php:156] Daemon 304 STDE [Mon, 20 Oct 2014 17:10:48 -0700] #12 PhabricatorWorkerActiveTask::executeTask() called at [<phabricator>/src/infrastructure/daemon/workers/PhabricatorTaskmasterDaemon.php:19] Daemon 304 STDE [Mon, 20 Oct 2014 17:10:48 -0700] #13 PhabricatorTaskmasterDaemon::run() called at [<phutil>/src/daemon/PhutilDaemon.php:91] Daemon 304 STDE [Mon, 20 Oct 2014 17:10:48 -0700] #14 PhutilDaemon::execute() called at [<phutil>/scripts/daemon/exec/exec_daemon.php:111]

We're having a situation on our Phabricator instance where Diffusion is doing weird stuff with repositories that we have imported from Github. See, e.g.,: https://phab.met.no/rNCLOADf91b56d499749e5bec65ca41c70572242816ebaf I noticed this because our feed on the homepage is getting spammed by these commit messages every five minutes or so. What do we do to fix this (other than take affected the repositories down)? Haven't touched the installation yet, in case I destroy some information that would be useful for debugging, but can't let this continue for much longer. This is happening with at least two of our repositories. Interestingly, the two people whose commits this appears to be happening with are both former employees, so not users registered in Phabricator. ------------------ Problems remaining: See T1191 typical trace: Daemon 304 STDE [Mon, 20 Oct 2014 17:10:48 -0700] [2014-10-20 17:10:48] EXCEPTION: (PhutilProxyException) Error while executing task ID 9711 from queue. {>} (AphrontCharacterSetQueryException) Attempting to construct a query containing characters outside of the Unicode Basic Multilingual Plane. MySQL will silently truncate this data if it is inserted into a `utf8` column. Use the `%B` conversion to escape binary strings data. at [<phutil>/src/aphront/storage/connection/mysql/AphrontBaseMySQLDatabaseConnection.php:346] Daemon 304 STDE [Mon, 20 Oct 2014 17:10:48 -0700] #0 AphrontBaseMySQLDatabaseConnection::validateUTF8String(string) called at [<phutil>/src/aphront/storage/connection/mysql/AphrontMySQLiDatabaseConnection.php:10] Daemon 304 STDE [Mon, 20 Oct 2014 17:10:48 -0700] #1 AphrontMySQLiDatabaseConnection::escapeUTF8String(string) called at [<phutil>/src/xsprintf/qsprintf.php:170] Daemon 304 STDE [Mon, 20 Oct 2014 17:10:48 -0700] #2 xsprintf_query(AphrontMySQLiDatabaseConnection, string, integer, string, integer) called at [<phutil>/src/xsprintf/xsprintf.php:63] Daemon 304 STDE [Mon, 20 Oct 2014 17:10:48 -0700] #3 xsprintf(string, AphrontMySQLiDatabaseConnection, array) called at [<phutil>/src/xsprintf/qsprintf.php:64] Daemon 304 STDE [Mon, 20 Oct 2014 17:10:48 -0700] #4 qsprintf(AphrontMySQLiDatabaseConnection, string, string, string) called at [<phabricator>/src/infrastructure/storage/lisk/LiskDAO.php:1101] Daemon 304 STDE [Mon, 20 Oct 2014 17:10:48 -0700] #5 LiskDAO::update() called at [<phabricator>/src/infrastructure/storage/lisk/LiskDAO.php:1041] Daemon 304 STDE [Mon, 20 Oct 2014 17:10:48 -0700] #6 LiskDAO::save() called at [<phabricator>/src/applications/repository/storage/PhabricatorRepositoryCommit.php:165] Daemon 304 STDE [Mon, 20 Oct 2014 17:10:48 -0700] #7 PhabricatorRepositoryCommit::save() called at [<phabricator>/src/applications/repository/worker/commitmessageparser/PhabricatorRepositoryCommitMessageParserWorker.php:78] Daemon 304 STDE [Mon, 20 Oct 2014 17:10:48 -0700] #8 PhabricatorRepositoryCommitMessageParserWorker::updateCommitData(DiffusionCommitRef) called at [<phabricator>/src/applications/repository/worker/commitmessageparser/PhabricatorRepositoryGitCommitMessageParserWorker.php:15] Daemon 304 STDE [Mon, 20 Oct 2014 17:10:48 -0700] #9 PhabricatorRepositoryGitCommitMessageParserWorker::parseCommit(PhabricatorRepository, PhabricatorRepositoryCommit) called at [<phabricator>/src/applications/repository/worker/PhabricatorRepositoryCommitParserWorker.php:44] Daemon 304 STDE [Mon, 20 Oct 2014 17:10:48 -0700] #10 PhabricatorRepositoryCommitParserWorker::doWork() called at [<phabricator>/src/infrastructure/daemon/workers/PhabricatorWorker.php:87] Daemon 304 STDE [Mon, 20 Oct 2014 17:10:48 -0700] #11 PhabricatorWorker::executeTask() called at [<phabricator>/src/infrastructure/daemon/workers/storage/PhabricatorWorkerActiveTask.php:156] Daemon 304 STDE [Mon, 20 Oct 2014 17:10:48 -0700] #12 PhabricatorWorkerActiveTask::executeTask() called at [<phabricator>/src/infrastructure/daemon/workers/PhabricatorTaskmasterDaemon.php:19] Daemon 304 STDE [Mon, 20 Oct 2014 17:10:48 -0700] #13 PhabricatorTaskmasterDaemon::run() called at [<phutil>/src/daemon/PhutilDaemon.php:91] Daemon 304 STDE [Mon, 20 Oct 2014 17:10:48 -0700] #14 PhutilDaemon::execute() called at [<phutil>/scripts/daemon/exec/exec_daemon.php:111]