Page MenuHomePhabricator
Paste P1923

backtrace from ./bin/repository with big commit
ActivePublic

Authored by clemvangelis on Jan 13 2016, 9:03 AM.
./bin/repository reparse rRTEMSa4661ab1866e --message --trace
>>> [2] <connect> phabricator_repository
<<< [2] <connect> 1,711 us
>>> [3] <query> SELECT `r`.* FROM `repository` r WHERE ((r.callsign IN ('RTEMS'))) ORDER BY `r`.`id` DESC
<<< [3] <query> 602 us
>>> [4] <query> SELECT `commit`.* FROM `repository_commit` commit WHERE (((commit.repositoryID = 64
AND commit.commitIdentifier LIKE 'a4661ab1866e%'))) ORDER BY `commit`.`id` DESC
<<< [4] <query> 754 us
>>> [5] <query> SELECT `r`.* FROM `repository` r WHERE (r.id IN (64)) ORDER BY `r`.`id` DESC
<<< [5] <query> 472 us
>>> [6] <query> SELECT `commit`.* FROM `repository_commit` commit WHERE (commit.id IN (58644)) ORDER BY `commit`.`id` DESC
<<< [6] <query> 464 us
>>> [7] <query> SELECT `r`.* FROM `repository` r WHERE (r.id IN (64)) ORDER BY `r`.`id` DESC
<<< [7] <query> 498 us
>>> [8] <conduit> diffusion.querycommits()
>>> [9] <query> SELECT `commit`.* FROM `repository_commit` commit WHERE (commit.phid IN ('PHID-CMIT-gho5xuio5pbmcrjwxbts')) ORDER BY `commit`.`id` DESC LIMIT 101
<<< [9] <query> 675 us
>>> [10] <query> SELECT `r`.* FROM `repository` r WHERE (r.id IN (64)) ORDER BY `r`.`id` DESC
<<< [10] <query> 552 us
>>> [11] <query> SELECT * FROM `repository_commitdata` WHERE commitID in (58644)
<<< [11] <query> 521 us
>>> [12] <exec> $ git log -n 1 --encoding='UTF-8' --format='%e%x00%cn%x00%ce%x00%an%x00%ae%x00%T%x00%s%n%n%b' 'a4661ab1866e3e09fcb8f96d62445ca733d19215' --
<<< [12] <exec> 8,727 us
<<< [8] <conduit> 20,614 us
>>> [13] <query> SELECT * FROM `repository_commitdata` WHERE commitID = 58644
<<< [13] <query> 514 us
>>> [14] <connect> phabricator_user
<<< [14] <connect> 850 us
>>> [15] <query> SELECT * FROM `user` WHERE userName = 'joel <joel>'
<<< [15] <query> 519 us
>>> [16] <query> SELECT * FROM `user_email` WHERE address = 'joel <joel>'
<<< [16] <query> 442 us
>>> [17] <query> SELECT * FROM `user` WHERE realName = 'joel <joel>'
<<< [17] <query> 545 us
>>> [18] <query> SELECT * FROM `user_email` WHERE address = 'joel'
<<< [18] <query> 381 us
>>> [19] <query> SELECT * FROM `user` WHERE userName = 'joel'
<<< [19] <query> 401 us
>>> [20] <query> SELECT * FROM `user` WHERE realName = 'joel'
<<< [20] <query> 428 us
>>> [21] <event> diffusion.lookupUser <listeners = 1>
<<< [21] <event> 171 us
>>> [22] <query> SELECT * FROM `user` WHERE userName = 'joel <joel>'
<<< [22] <query> 381 us
>>> [23] <query> SELECT * FROM `user_email` WHERE address = 'joel <joel>'
<<< [23] <query> 310 us
>>> [24] <query> SELECT * FROM `user` WHERE realName = 'joel <joel>'
<<< [24] <query> 418 us
>>> [25] <query> SELECT * FROM `user_email` WHERE address = 'joel'
<<< [25] <query> 303 us
>>> [26] <query> SELECT * FROM `user` WHERE userName = 'joel'
<<< [26] <query> 344 us
>>> [27] <query> SELECT * FROM `user` WHERE realName = 'joel'
<<< [27] <query> 417 us
>>> [28] <event> diffusion.lookupUser <listeners = 1>
<<< [28] <event> 136 us
>>> [29] <conduit> differential.parsecommitmessage()
>>> [30] <connect> phabricator_auth
<<< [30] <connect> 643 us
>>> [31] <query> SELECT * FROM `auth_providerconfig` ORDER BY `id` DESC
<<< [31] <query> 457 us
<<< [29] <conduit> 21,874 us
>>> [32] <connect> phabricator_differential
<<< [32] <connect> 653 us
>>> [33] <query> (SELECT `r`.* FROM `differential_revision` r JOIN `differential_revisionhash` hash_rel ON hash_rel.revisionID = r.id WHERE (((hash_rel.type = 'gtcm' AND hash_rel.hash = 'a4661ab1866e3e09fcb8f96d62445ca733d19215') OR (hash_rel.type = 'gttr' AND hash_rel.hash = 'ff15615251bf017fe89e06f1d5ceaf095078697f'))) ORDER BY `r`.`dateModified` DESC, `r`.`id` DESC )
<<< [33] <query> 1,405 us
>>> [34] <connect> phabricator_repository
<<< [34] <connect> 602 us
>>> [35] <query> UPDATE `repository_commit` SET `repositoryID` = '64', `phid` = 'PHID-CMIT-gho5xuio5pbmcrjwxbts', `commitIdentifier` = 'a4661ab1866e3e09fcb8f96d62445ca733d19215', `epoch` = '929122769', `mailKey` = 'zjk3zfu6kut4shth3wlc', `authorPHID` = NULL, `auditStatus` = '0', `summary` = 'Regenerated.', `id` = '58644' WHERE `id` = '58644'
<<< [35] <query> 15,882 us
>>> [36] <query> UPDATE `repository_commitdata` SET `commitID` = '58644', `authorName` = 'joel <joel>', `commitMessage` = 'Regenerated.\n\n\n', `commitDetails` = '{\"authorName\":\"joel\",\"authorEmail\":\"joel\",\"authorPHID\":null,\"committer\":\"joel <joel>\",\"committerName\":\"joel\",\"committerEmail\":\"joel\",\"committerPHID\":null,\"differential.revisionID\":null,\"autocloseReason\":\"auto\\/importing\"}', `id` = '75706' WHERE `id` = '75706'
<<< [36] <query> 7,508 us
>>> [37] <query> UPDATE `repository_commit` SET importStatus = (importStatus | 1) WHERE id = 58644
<<< [37] <query> 389 us
[phab@phabricator phabricator]$ ./bin/repository reparse rRTEMS8f0455f4b4db7a5512112ddecc96cc2dc139721f --message --trace
>>> [2] <connect> phabricator_repository
<<< [2] <connect> 1,712 us
>>> [3] <query> SELECT `r`.* FROM `repository` r WHERE ((r.callsign IN ('RTEMS'))) ORDER BY `r`.`id` DESC
<<< [3] <query> 547 us
>>> [4] <query> SELECT `commit`.* FROM `repository_commit` commit WHERE (((commit.repositoryID = 64
AND commit.commitIdentifier = '8f0455f4b4db7a5512112ddecc96cc2dc139721f'))) ORDER BY `commit`.`id` DESC
<<< [4] <query> 594 us
>>> [5] <query> SELECT `r`.* FROM `repository` r WHERE (r.id IN (64)) ORDER BY `r`.`id` DESC
<<< [5] <query> 568 us
>>> [6] <query> SELECT `commit`.* FROM `repository_commit` commit WHERE (commit.id IN (58645)) ORDER BY `commit`.`id` DESC
<<< [6] <query> 499 us
>>> [7] <query> SELECT `r`.* FROM `repository` r WHERE (r.id IN (64)) ORDER BY `r`.`id` DESC
<<< [7] <query> 570 us
>>> [8] <conduit> diffusion.querycommits()
>>> [9] <query> SELECT `commit`.* FROM `repository_commit` commit WHERE (commit.phid IN ('PHID-CMIT-wix6h7r6t42ymy2z3537')) ORDER BY `commit`.`id` DESC LIMIT 101
<<< [9] <query> 669 us
>>> [10] <query> SELECT `r`.* FROM `repository` r WHERE (r.id IN (64)) ORDER BY `r`.`id` DESC
<<< [10] <query> 577 us
>>> [11] <query> SELECT * FROM `repository_commitdata` WHERE commitID in (58645)
<<< [11] <query> 519 us
>>> [12] <exec> $ git log -n 1 --encoding='UTF-8' --format='%e%x00%cn%x00%ce%x00%an%x00%ae%x00%T%x00%s%n%n%b' '8f0455f4b4db7a5512112ddecc96cc2dc139721f' --
<<< [12] <exec> 9,091 us
<<< [8] <conduit> 21,306 us
>>> [13] <query> SELECT * FROM `repository_commitdata` WHERE commitID = 58645
<<< [13] <query> 519 us
>>> [14] <connect> phabricator_user
<<< [14] <connect> 862 us
>>> [15] <query> SELECT * FROM `user` WHERE userName = 'joel <joel>'
<<< [15] <query> 549 us
>>> [16] <query> SELECT * FROM `user_email` WHERE address = 'joel <joel>'
<<< [16] <query> 452 us
>>> [17] <query> SELECT * FROM `user` WHERE realName = 'joel <joel>'
<<< [17] <query> 560 us
>>> [18] <query> SELECT * FROM `user_email` WHERE address = 'joel'
<<< [18] <query> 444 us
>>> [19] <query> SELECT * FROM `user` WHERE userName = 'joel'
<<< [19] <query> 464 us
>>> [20] <query> SELECT * FROM `user` WHERE realName = 'joel'
<<< [20] <query> 486 us
>>> [21] <event> diffusion.lookupUser <listeners = 1>
<<< [21] <event> 169 us
>>> [22] <query> SELECT * FROM `user` WHERE userName = 'joel <joel>'
<<< [22] <query> 439 us
>>> [23] <query> SELECT * FROM `user_email` WHERE address = 'joel <joel>'
<<< [23] <query> 370 us
>>> [24] <query> SELECT * FROM `user` WHERE realName = 'joel <joel>'
<<< [24] <query> 476 us
>>> [25] <query> SELECT * FROM `user_email` WHERE address = 'joel'
<<< [25] <query> 378 us
>>> [26] <query> SELECT * FROM `user` WHERE userName = 'joel'
<<< [26] <query> 409 us
>>> [27] <query> SELECT * FROM `user` WHERE realName = 'joel'
<<< [27] <query> 454 us
>>> [28] <event> diffusion.lookupUser <listeners = 1>
<<< [28] <event> 134 us
>>> [29] <conduit> differential.parsecommitmessage()
>>> [30] <connect> phabricator_auth
<<< [30] <connect> 649 us
>>> [31] <query> SELECT * FROM `auth_providerconfig` ORDER BY `id` DESC
<<< [31] <query> 456 us
>>> [32] <connect> phabricator_project
<<< [32] <connect> 820 us
>>> [33] <query> SELECT `p`.* FROM `project` p JOIN `project_slug` slug on slug.projectPHID = p.phid WHERE (slug.slug IN ('if', 'else', 'endif')) ORDER BY `p`.`name` ASC
<<< [33] <query> 931 us
<<< [29] <conduit> 163,491 us
[2016-01-13 10:01:00] EXCEPTION: (AphrontParameterQueryException) Expected a numeric scalar or null for %Ld conversion. Query: r.id IN (%Ld) at [<phutil>/src/xsprintf/qsprintf.php:294]
arcanist(head=master, ref.master=aeb374b33348), phabricator(head=cleger/master, ref.master=d7e6dfc154b1, ref.cleger/master=f4d47d93fd8a), phutil(head=master, ref.master=0fa7efbf09d7)
#0 qsprintf_check_scalar_type(string, string, string) called at [<phutil>/src/xsprintf/qsprintf.php:267]
#1 qsprintf_check_type(array, string, string) called at [<phutil>/src/xsprintf/qsprintf.php:134]
#2 xsprintf_query(AphrontMySQLiDatabaseConnection, string, integer, array, integer) called at [<phutil>/src/xsprintf/xsprintf.php:70]
#3 xsprintf(string, AphrontMySQLiDatabaseConnection, array) called at [<phutil>/src/xsprintf/qsprintf.php:64]
#4 qsprintf(AphrontMySQLiDatabaseConnection, string, array) called at [<phabricator>/src/applications/repository/query/PhabricatorRepositoryQuery.php:523]
#5 PhabricatorRepositoryQuery::buildWhereClauseParts(AphrontMySQLiDatabaseConnection) called at [<phabricator>/src/infrastructure/query/policy/PhabricatorCursorPagedPolicyAwareQuery.php:266]
#6 PhabricatorCursorPagedPolicyAwareQuery::buildWhereClause(AphrontMySQLiDatabaseConnection) called at [<phabricator>/src/infrastructure/query/policy/PhabricatorCursorPagedPolicyAwareQuery.php:96]
#7 PhabricatorCursorPagedPolicyAwareQuery::loadStandardPageRows(PhabricatorRepository) called at [<phabricator>/src/applications/repository/query/PhabricatorRepositoryQuery.php:176]
#8 PhabricatorPolicyAwareQuery::execute() called at [<phabricator>/src/applications/repository/phid/PhabricatorRepositoryRepositoryPHIDType.php:70]
#9 PhabricatorRepositoryRepositoryPHIDType::loadNamedObjects(PhabricatorObjectQuery, array) called at [<phabricator>/src/applications/phid/query/PhabricatorObjectQuery.php:100]
#10 PhabricatorObjectQuery::loadObjectsByName(array, array) called at [<phabricator>/src/applications/phid/query/PhabricatorObjectQuery.php:57]
#11 PhabricatorObjectQuery::loadPage() called at [<phabricator>/src/infrastructure/query/policy/PhabricatorPolicyAwareQuery.php:227]
#12 PhabricatorPolicyAwareQuery::execute() called at [<phabricator>/src/applications/phid/query/PhabricatorObjectListQuery.php:113]
#13 PhabricatorObjectListQuery::loadObjects(array) called at [<phabricator>/src/applications/phid/query/PhabricatorObjectListQuery.php:50]
#14 PhabricatorObjectListQuery::execute() called at [<phabricator>/src/applications/differential/customfield/DifferentialCustomField.php:44]
#15 DifferentialCustomField::parseObjectList(string, array) called at [<phabricator>/src/applications/differential/customfield/DifferentialSubscribersField.php:81]
#16 DifferentialSubscribersField::parseValueFromCommitMessage(string) called at [<phabricator>/src/applications/differential/conduit/DifferentialParseCommitMessageConduitAPIMethod.php:58]
#17 DifferentialParseCommitMessageConduitAPIMethod::execute(ConduitAPIRequest) called at [<phabricator>/src/applications/conduit/method/ConduitAPIMethod.php:118]
#18 ConduitAPIMethod::executeMethod(ConduitAPIRequest) called at [<phabricator>/src/applications/conduit/call/ConduitCall.php:135]
#19 ConduitCall::executeMethod() called at [<phabricator>/src/applications/conduit/call/ConduitCall.php:85]
#20 ConduitCall::execute() called at [<phabricator>/src/applications/diffusion/query/lowlevel/DiffusionLowLevelCommitFieldsQuery.php:41]
#21 DiffusionLowLevelCommitFieldsQuery::executeQuery() called at [<phabricator>/src/applications/diffusion/query/lowlevel/DiffusionLowLevelQuery.php:23]
#22 DiffusionLowLevelQuery::execute() called at [<phabricator>/src/applications/repository/worker/commitmessageparser/PhabricatorRepositoryCommitMessageParserWorker.php:100]
#23 PhabricatorRepositoryCommitMessageParserWorker::updateCommitData(DiffusionCommitRef) called at [<phabricator>/src/applications/repository/worker/commitmessageparser/PhabricatorRepositoryGitCommitMessageParserWorker.php:11]
#24 PhabricatorRepositoryGitCommitMessageParserWorker::parseCommitWithRef(PhabricatorRepository, PhabricatorRepositoryCommit, DiffusionCommitRef) called at [<phabricator>/src/applications/repository/worker/commitmessageparser/PhabricatorRepositoryCommitMessageParserWorker.php:40]
#25 PhabricatorRepositoryCommitMessageParserWorker::parseCommit(PhabricatorRepository, PhabricatorRepositoryCommit) called at [<phabricator>/src/applications/repository/worker/PhabricatorRepositoryCommitParserWorker.php:39]
#26 PhabricatorRepositoryCommitParserWorker::doWork() called at [<phabricator>/src/infrastructure/daemon/workers/PhabricatorWorker.php:122]
#27 PhabricatorWorker::executeTask() called at [<phabricator>/src/applications/repository/management/PhabricatorRepositoryManagementReparseWorkflow.php:325]
#28 PhabricatorRepositoryManagementReparseWorkflow::execute(PhutilArgumentParser) called at [<phutil>/src/parser/argument/PhutilArgumentParser.php:408]
#29 PhutilArgumentParser::parseWorkflowsFull(array) called at [<phutil>/src/parser/argument/PhutilArgumentParser.php:301]
#30 PhutilArgumentParser::parseWorkflows(array) called at [<phabricator>/scripts/repository/manage_repositories.php:22]
[phab@phabricator phabricator]$