On these things:
- Queries
- All Stories
- Search
- Advanced Search
- Transactions
- Transaction Logs
Advanced Search
Aug 6 2015
@chad, do you have any particular objections to disabling all mail (other than welcome / password reset mail, which we obviously need to send) by default-default after we give administrators tools to selectively adjust the defaults in T5791 / T4103? It feels a little extreme to me, but I think we're going to be dealing with this forever if we don't do it.
Put another way, the one case of this which I've conclusively pinned on a root cause was "user is wildly sensitive about email and also would rather complain about it over and over again than spend much less energy fixing the problem", and the fix was "look up volume statistics, roll eyes out of sockets".
Product reasons normally, although technical reasons if metamta.one-mail-per-recipient is enabled (we can't batch mail which must be delivered to multiple distinct recipients).
For example, suppose A is on B, which is on master.
As a reviewer, I expect the code that lands to be the code from the revision web page
Yeah, that's exactly what I'm imagining (I mean, maybe not exactly that command, but that workflow). Then I can sign your packages as Phacility and users can see that they're trusting your claim about the package, but that Phacility also supports your claims about who you are and your claims about the package.
Thing seem quiet now.
I think we could pick any available UTF8 locale here safely, as they should only differ in collation rules (I think?) and I don't think we ever rely on VCS commands to sort text. I'd also favor a setup warning if only a small number of user are affected and it's easy to install/generate locales, though.
How do you detect that a locale is missing? Parse locale -a?
The broad issue with making this process have fewer side effects is that it potentially makes it much harder for less experienced users to understand what's happening and what state they're in. My experience at Facebook was that a majority of engineers learned as little about Git as they could in order to do their jobs, and I would not have expected many of them to understand concepts like a "detached HEAD". I'd guess less than 20% knew about or were comfortable with git reflog.
I think we can just take the tree hash (git show -s --format=%T) and sign that [1].
See also T6502. Our handling of permissions here has changed a couple of times and this should never be greyed out, I think.
OK. I figured out the issue. Steps to reproduce are roughly as follows:
./bin/worker execute --trace --id 18829015>>> [2] <connect> phabricator_worker
<<< [2] <connect> 4,734 us
>>> [3] <query> SELECT * FROM `worker_activetask` WHERE id IN ('18829015')
<<< [3] <query> 1,038 us
>>> [4] <query> SELECT * FROM `worker_archivetask` WHERE (id in (18829015)) ORDER BY id DESC
<<< [4] <query> 1,051 us
>>> [5] <connect> phabricator_worker
<<< [5] <connect> 4,057 us
>>> [6] <query> UPDATE `worker_activetask` SET `failureTime` = '1438841678', `taskClass` = 'PhabricatorApplicationTransactionPublishWorker', `leaseOwner` = NULL, `leaseExpires` = '1438841719', `failureCount` = '1744', `dataID` = '18858361', `priority` = '1000', `objectPHID` = 'PHID-DREV-4mhbuxmiuwzo37rixqlg', `id` = '18829015' WHERE `id` = '18829015'
<<< [6] <query> 15,661 us
>>> [7] <query> SELECT * FROM `worker_taskdata` WHERE id = 18858361
<<< [7] <query> 1,097 us
Executing task 18829015 (PhabricatorApplicationTransactionPublishWorker)...>>> [8] <connect> phabricator_differential
<<< [8] <connect> 4,149 us
>>> [9] <query> (SELECT `r`.* FROM `differential_revision` r WHERE (r.phid IN ('PHID-DREV-4mhbuxmiuwzo37rixqlg')) ORDER BY `r`.`dateModified` DESC, `r`.`id` DESC )
<<< [9] <query> 1,096 us
>>> [10] <connect> phabricator_repository
<<< [10] <connect> 4,121 us
>>> [11] <query> SELECT `r`.* FROM `repository` r WHERE (r.phid IN ('PHID-REPO-rgnn364lembo2emt5622')) ORDER BY `r`.`id` DESC
<<< [11] <query> 1,149 us
>>> [12] <query> SELECT * FROM `differential_transaction` x WHERE (phid IN ('PHID-XACT-DREV-p5gcdmcnkw5wbkf', 'PHID-XACT-DREV-sxxh7nigyrhy7fh', 'PHID-XACT-DREV-gdelyb3soycjphm', 'PHID-XACT-DREV-3chlxztlhpwmnry', 'PHID-XACT-DREV-aewd7vbxwkvsfjx', 'PHID-XACT-DREV-xrhkvvzmlai4qhw', 'PHID-XACT-DREV-pxrls5jrsppn4qr')) ORDER BY `id` DESC
<<< [12] <query> 1,271 us
>>> [13] <query> (SELECT `r`.* FROM `differential_revision` r WHERE (r.phid IN ('PHID-DREV-4mhbuxmiuwzo37rixqlg')) ORDER BY `r`.`dateModified` DESC, `r`.`id` DESC )
<<< [13] <query> 1,080 us
>>> [14] <query> SELECT `r`.* FROM `repository` r WHERE (r.phid IN ('PHID-REPO-rgnn364lembo2emt5622')) ORDER BY `r`.`id` DESC
<<< [14] <query> 1,074 us
>>> [15] <connect> phabricator_auth
<<< [15] <connect> 4,305 us
>>> [16] <query> SELECT * FROM `auth_providerconfig` ORDER BY `id` DESC
<<< [16] <query> 1,151 us
>>> [17] <connect> phabricator_project
<<< [17] <connect> 4,077 us
>>> [18] <query> SELECT `p`.*, vm.dst viewerIsMember FROM `project` p LEFT JOIN `edge` vm ON vm.src = p.phid AND vm.type = 13 AND vm.dst = '' WHERE (phid IN ('PHID-PROJ-z4lum22ekior7wxtn7ub', 'PHID-PROJ-fpucoegg437ttgxyfciu')) ORDER BY `p`.`name` ASC
<<< [18] <query> 1,244 us
>>> [19] <connect> phabricator_file
<<< [19] <connect> 4,019 us
>>> [20] <query> SELECT `f`.* FROM `file` f WHERE (f.phid IN ('PHID-FILE-fbyv3ulhxu3erfudpdzg')) ORDER BY `f`.`id` DESC
<<< [20] <query> 1,137 us
>>> [21] <query> SELECT edge.* FROM `edge` edge WHERE (edge.src IN ('PHID-FILE-fbyv3ulhxu3erfudpdzg')) AND (edge.type IN ('26')) ORDER BY edge.dateCreated DESC, edge.seq DESC
<<< [21] <query> 1,091 us
>>> [22] <query> SELECT * FROM `file_transformedfile` WHERE transformedPHID IN ('PHID-FILE-fbyv3ulhxu3erfudpdzg')
<<< [22] <query> 1,033 us
>>> [23] <query> SELECT `f`.* FROM `file` f JOIN `file_transformedfile` t ON t.transformedPHID = f.phid WHERE (((t.originalPHID = 'PHID-VOID-00000000000000000000' AND t.transform = 'builtin:project.png'))) ORDER BY `f`.`id` DESC
<<< [23] <query> 1,102 us
>>> [24] <query> SELECT edge.* FROM `edge` edge WHERE (edge.src IN ('PHID-FILE-mpgyi55wthmxjdg4vewp')) AND (edge.type IN ('26')) ORDER BY edge.dateCreated DESC, edge.seq DESC
<<< [24] <query> 1,044 us
>>> [25] <query> SELECT * FROM `file_transformedfile` WHERE transformedPHID IN ('PHID-FILE-mpgyi55wthmxjdg4vewp')
<<< [25] <query> 1,024 us
>>> [26] <connect> phabricator_user
<<< [26] <connect> 4,075 us
>>> [27] <query> SELECT `user`.* FROM `user` user WHERE (user.phid IN ('PHID-USER-l4hrts2frjnyghof5fgm')) ORDER BY `user`.`id` DESC
<<< [27] <query> 1,188 us
>>> [28] <connect> phabricator_maniphest
<<< [28] <connect> 4,014 us
>>> [29] <query> SELECT `task`.* FROM `maniphest_task` task WHERE (task.phid in ('PHID-TASK-xlaezfav3hqyzgbie2li')) ORDER BY `task`.`id` DESC
<<< [29] <query> 1,096 us
>>> [30] <query> SELECT * FROM `differential_diff` WHERE (phid IN ('PHID-DIFF-qr2rcjd2lparj2atn2m6')) ORDER BY `id` DESC
<<< [30] <query> 1,064 us
>>> [31] <query> (SELECT `r`.* FROM `differential_revision` r WHERE (r.id IN (23146)) ORDER BY `r`.`dateModified` DESC, `r`.`id` DESC )
<<< [31] <query> 1,055 us
>>> [32] <query> SELECT `r`.* FROM `repository` r WHERE (r.phid IN ('PHID-REPO-rgnn364lembo2emt5622')) ORDER BY `r`.`id` DESC
<<< [32] <query> 1,081 us
>>> [33] <query> (SELECT `r`.* FROM `differential_revision` r WHERE (r.id IN (23146)) ORDER BY `r`.`dateModified` DESC, `r`.`id` DESC )
<<< [33] <query> 1,106 us
>>> [34] <query> SELECT `r`.* FROM `repository` r WHERE (r.phid IN ('PHID-REPO-rgnn364lembo2emt5622')) ORDER BY `r`.`id` DESC
<<< [34] <query> 1,075 us
>>> [35] <query> SELECT revisionID, id FROM `differential_diff` WHERE revisionID IN (23146)
ORDER BY id DESC
<<< [35] <query> 1,024 us
>>> [36] <query> SELECT * FROM `differential_diff` WHERE id IN (566473)
<<< [36] <query> 1,044 us
>>> [37] <query> SELECT edge.* FROM `edge` edge WHERE (edge.src IN ('PHID-DREV-4mhbuxmiuwzo37rixqlg')) AND (edge.type IN ('35')) ORDER BY edge.dateCreated ASC, edge.seq ASC
<<< [37] <query> 1,118 us
>>> [38] <query> SELECT edgedata.* FROM `edgedata` edgedata WHERE id IN (85773, 85774, 85775, 85776)
<<< [38] <query> 1,038 us
>>> [39] <query> SELECT `p`.*, vm.dst viewerIsMember FROM `project` p LEFT JOIN `edge` vm ON vm.src = p.phid AND vm.type = 13 AND vm.dst = '' WHERE (phid IN ('PHID-PROJ-z4lum22ekior7wxtn7ub', 'PHID-PROJ-fpucoegg437ttgxyfciu')) ORDER BY `p`.`name` ASC
<<< [39] <query> 1,209 us
>>> [40] <query> SELECT edge.* FROM `edge` edge WHERE (edge.src IN ('PHID-PROJ-z4lum22ekior7wxtn7ub', 'PHID-PROJ-fpucoegg437ttgxyfciu')) AND (edge.type IN ('21')) ORDER BY edge.dateCreated DESC, edge.seq DESC
<<< [40] <query> 1,214 us
>>> [41] <query> SELECT `user`.* FROM `user` user WHERE (user.phid IN ('PHID-USER-l4hrts2frjnyghof5fgm', 'PHID-USER-mw6ockgrrgytq3d3yywa', 'PHID-USER-peuiavsm52zpxge5kiok', 'PHID-USER-hzs5buz4sbj5lcbwx4vu', 'PHID-USER-comtfhp2czgmyrs3cm7m', 'PHID-USER-inwz7rtaiuxgmjduhmmq', 'PHID-USER-hfenohlvucsbthy2su73', 'PHID-USER-abzwhc667osh5mwd4gk7', 'PHID-USER-yl3qonlcgmrtn3tdxppz', 'PHID-USER-3u5vybbidp7ael5ebh6z', 'PHID-USER-cfqyrlmwwho74uzi4cbl', 'PHID-USER-bqflamirb2342abaeqf5', 'PHID-USER-q2zc6dtm6uvbjqsxzut6', 'PHID-USER-raqt
<<< [41] <query> 2,285 us
>>> [42] <connect> phabricator_spaces
<<< [42] <connect> 4,078 us
>>> [43] <query> SELECT * FROM `spaces_namespace` ORDER BY `id` DESC
<<< [43] <query> 1,029 us
>>> [44] <query> SELECT `user`.* FROM `user` user WHERE (user.phid IN ('PHID-USER-l4hrts2frjnyghof5fgm')) ORDER BY `user`.`id` DESC
<<< [44] <query> 1,107 us
>>> [45] <connect> phabricator_policy
<<< [45] <connect> 4,195 us
>>> [46] <query> SELECT * FROM `policy` WHERE phid IN ('PHID-PLCY-mz7dj6am3bq4yx477tgg')
<<< [46] <query> 1,077 us
>>> [47] <query> SELECT `p`.*, vm.dst viewerIsMember FROM `project` p LEFT JOIN `edge` vm ON vm.src = p.phid AND vm.type = 13 AND vm.dst = '' JOIN `edge` e ON e.src = p.phid AND e.type = 13 WHERE (phid IN ('PHID-PROJ-5fgvj2vy6q3bzdcyrdsx')) AND (e.dst IN ('PHID-USER-l4hrts2frjnyghof5fgm')) GROUP BY p.phid ORDER BY `p`.`name` ASC
<<< [47] <query> 1,127 us
>>> [48] <query> SELECT * FROM `differential_diff` WHERE (phid IN ('PHID-DIFF-qr2rcjd2lparj2atn2m6')) ORDER BY `id` DESC
<<< [48] <query> 1,108 us
>>> [49] <query> (SELECT `r`.* FROM `differential_revision` r WHERE (r.id IN (23146)) ORDER BY `r`.`dateModified` DESC, `r`.`id` DESC )
<<< [49] <query> 1,131 us
>>> [50] <query> SELECT * FROM `policy` WHERE phid IN ('PHID-PLCY-uwziuxgtcivsiknlo73u')
<<< [50] <query> 1,127 us
>>> [51] <query> SELECT `p`.*, vm.dst viewerIsMember FROM `project` p LEFT JOIN `edge` vm ON vm.src = p.phid AND vm.type = 13 AND vm.dst = '' JOIN `edge` e ON e.src = p.phid AND e.type = 13 WHERE (phid IN ('PHID-PROJ-5fgvj2vy6q3bzdcyrdsx')) AND (e.dst IN ('PHID-USER-l4hrts2frjnyghof5fgm')) GROUP BY p.phid ORDER BY `p`.`name` ASC
<<< [51] <query> 1,186 us
>>> [52] <query> SELECT `r`.* FROM `repository` r WHERE (`r`.spacePHID IS NULL) AND (r.phid IN ('PHID-REPO-rgnn364lembo2emt5622')) ORDER BY `r`.`id` DESC
<<< [52] <query> 1,186 us
>>> [53] <query> SELECT `p`.*, vm.dst viewerIsMember FROM `project` p LEFT JOIN `edge` vm ON vm.src = p.phid AND vm.type = 13 AND vm.dst = 'PHID-USER-l4hrts2frjnyghof5fgm' WHERE (phid IN ('PHID-PROJ-z4lum22ekior7wxtn7ub', 'PHID-PROJ-fpucoegg437ttgxyfciu')) ORDER BY `p`.`name` ASC
<<< [53] <query> 1,189 us
>>> [54] <query> SELECT `f`.* FROM `file` f WHERE (f.phid IN ('PHID-FILE-fbyv3ulhxu3erfudpdzg')) ORDER BY `f`.`id` DESC
<<< [54] <query> 1,093 us
>>> [55] <query> SELECT edge.* FROM `edge` edge WHERE (edge.src IN ('PHID-FILE-fbyv3ulhxu3erfudpdzg')) AND (edge.type IN ('26')) ORDER BY edge.dateCreated DESC, edge.seq DESC
<<< [55] <query> 1,065 us
>>> [56] <query> SELECT * FROM `file_transformedfile` WHERE transformedPHID IN ('PHID-FILE-fbyv3ulhxu3erfudpdzg')
<<< [56] <query> 1,034 us
>>> [57] <query> SELECT `f`.* FROM `file` f JOIN `file_transformedfile` t ON t.transformedPHID = f.phid WHERE (((t.originalPHID = 'PHID-VOID-00000000000000000000' AND t.transform = 'builtin:project.png'))) ORDER BY `f`.`id` DESC
<<< [57] <query> 1,157 us
>>> [58] <query> SELECT edge.* FROM `edge` edge WHERE (edge.src IN ('PHID-FILE-mpgyi55wthmxjdg4vewp')) AND (edge.type IN ('26')) ORDER BY edge.dateCreated DESC, edge.seq DESC
<<< [58] <query> 1,067 us
>>> [59] <query> SELECT * FROM `file_transformedfile` WHERE transformedPHID IN ('PHID-FILE-mpgyi55wthmxjdg4vewp')
<<< [59] <query> 1,008 us
>>> [60] <query> SELECT `task`.* FROM `maniphest_task` task WHERE (`task`.spacePHID IS NULL) AND (task.phid in ('PHID-TASK-xlaezfav3hqyzgbie2li')) ORDER BY `task`.`id` DESC
<<< [60] <query> 1,076 us
>>> [61] <query> SELECT * FROM `differential_diff` WHERE (phid IN ('PHID-DIFF-qr2rcjd2lparj2atn2m6')) ORDER BY `id` DESC
<<< [61] <query> 1,071 us
>>> [62] <query> (SELECT `r`.* FROM `differential_revision` r WHERE (r.id IN (23146)) ORDER BY `r`.`dateModified` DESC, `r`.`id` DESC )
<<< [62] <query> 1,053 us
>>> [63] <query> SELECT `r`.* FROM `repository` r WHERE (`r`.spacePHID IS NULL) AND (r.phid IN ('PHID-REPO-rgnn364lembo2emt5622')) ORDER BY `r`.`id` DESC
<<< [63] <query> 1,076 us
>>> [64] <query> SELECT * FROM `differential_changeset` WHERE (diffID IN (565918)) ORDER BY `id` DESC
<<< [64] <query> 1,121 us
>>> [65] <query> SELECT * FROM `differential_hunk_modern` WHERE (changesetID IN (7748366, 7748365)) ORDER BY `id` ASC
<<< [65] <query> 1,137 us
>>> [66] <query> SELECT * FROM `differential_hunk` WHERE (changesetID IN (7748366, 7748365)) ORDER BY `id` ASC
<<< [66] <query> 1,071 us
>>> [67] <query> SELECT edge.* FROM `edge` edge WHERE (edge.src IN ('PHID-DREV-4mhbuxmiuwzo37rixqlg')) AND (edge.type IN ('41')) ORDER BY edge.dateCreated DESC, edge.seq DESC
<<< [67] <query> 1,075 us
>>> [68] <query> SELECT `user`.* FROM `user` user WHERE (user.phid IN ('PHID-USER-l4hrts2frjnyghof5fgm')) ORDER BY `user`.`id` DESC
<<< [68] <query> 1,165 us
>>> [69] <query> SELECT `p`.*, vm.dst viewerIsMember FROM `project` p LEFT JOIN `edge` vm ON vm.src = p.phid AND vm.type = 13 AND vm.dst = 'PHID-USER-l4hrts2frjnyghof5fgm' WHERE (phid IN ('PHID-PROJ-z4lum22ekior7wxtn7ub', 'PHID-PROJ-fpucoegg437ttgxyfciu')) ORDER BY `p`.`name` ASC
<<< [69] <query> 1,198 us
>>> [70] <query> SELECT `f`.* FROM `file` f WHERE (f.phid IN ('PHID-FILE-fbyv3ulhxu3erfudpdzg')) ORDER BY `f`.`id` DESC
<<< [70] <query> 1,080 us
>>> [71] <query> SELECT edge.* FROM `edge` edge WHERE (edge.src IN ('PHID-FILE-fbyv3ulhxu3erfudpdzg')) AND (edge.type IN ('26')) ORDER BY edge.dateCreated DESC, edge.seq DESC
<<< [71] <query> 1,133 us
>>> [72] <query> SELECT * FROM `file_transformedfile` WHERE transformedPHID IN ('PHID-FILE-fbyv3ulhxu3erfudpdzg')
<<< [72] <query> 1,029 us
>>> [73] <query> SELECT `f`.* FROM `file` f JOIN `file_transformedfile` t ON t.transformedPHID = f.phid WHERE (((t.originalPHID = 'PHID-VOID-00000000000000000000' AND t.transform = 'builtin:project.png'))) ORDER BY `f`.`id` DESC
<<< [73] <query> 1,090 us
>>> [74] <query> SELECT edge.* FROM `edge` edge WHERE (edge.src IN ('PHID-FILE-mpgyi55wthmxjdg4vewp')) AND (edge.type IN ('26')) ORDER BY edge.dateCreated DESC, edge.seq DESC
<<< [74] <query> 1,036 us
>>> [75] <query> SELECT * FROM `file_transformedfile` WHERE transformedPHID IN ('PHID-FILE-mpgyi55wthmxjdg4vewp')
<<< [75] <query> 1,041 us
>>> [76] <query> SELECT `user`.* FROM `user` user WHERE (user.phid IN ('PHID-USER-l4hrts2frjnyghof5fgm')) ORDER BY `user`.`id` DESC
<<< [76] <query> 1,101 us
>>> [77] <query> SELECT * FROM `policy` WHERE phid IN ('PHID-PLCY-mz7dj6am3bq4yx477tgg')
<<< [77] <query> 1,055 us
>>> [78] <query> SELECT `p`.*, vm.dst viewerIsMember FROM `project` p LEFT JOIN `edge` vm ON vm.src = p.phid AND vm.type = 13 AND vm.dst = '' JOIN `edge` e ON e.src = p.phid AND e.type = 13 WHERE (phid IN ('PHID-PROJ-5fgvj2vy6q3bzdcyrdsx')) AND (e.dst IN ('PHID-USER-mw6ockgrrgytq3d3yywa')) GROUP BY p.phid ORDER BY `p`.`name` ASC
<<< [78] <query> 1,147 us
>>> [79] <query> SELECT * FROM `differential_diff` WHERE (phid IN ('PHID-DIFF-qr2rcjd2lparj2atn2m6')) ORDER BY `id` DESC
<<< [79] <query> 1,092 us
>>> [80] <query> (SELECT `r`.* FROM `differential_revision` r WHERE (r.id IN (23146)) ORDER BY `r`.`dateModified` DESC, `r`.`id` DESC )
<<< [80] <query> 1,067 us
>>> [81] <query> SELECT * FROM `policy` WHERE phid IN ('PHID-PLCY-uwziuxgtcivsiknlo73u')
<<< [81] <query> 1,007 us
>>> [82] <query> SELECT `p`.*, vm.dst viewerIsMember FROM `project` p LEFT JOIN `edge` vm ON vm.src = p.phid AND vm.type = 13 AND vm.dst = '' JOIN `edge` e ON e.src = p.phid AND e.type = 13 WHERE (phid IN ('PHID-PROJ-5fgvj2vy6q3bzdcyrdsx')) AND (e.dst IN ('PHID-USER-mw6ockgrrgytq3d3yywa')) GROUP BY p.phid ORDER BY `p`.`name` ASC
<<< [82] <query> 1,076 us
>>> [83] <query> SELECT `r`.* FROM `repository` r WHERE (`r`.spacePHID IS NULL) AND (r.phid IN ('PHID-REPO-rgnn364lembo2emt5622')) ORDER BY `r`.`id` DESC
<<< [83] <query> 1,091 us
>>> [84] <query> SELECT `p`.*, vm.dst viewerIsMember FROM `project` p LEFT JOIN `edge` vm ON vm.src = p.phid AND vm.type = 13 AND vm.dst = 'PHID-USER-mw6ockgrrgytq3d3yywa' WHERE (phid IN ('PHID-PROJ-z4lum22ekior7wxtn7ub', 'PHID-PROJ-fpucoegg437ttgxyfciu')) ORDER BY `p`.`name` ASC
<<< [84] <query> 1,177 us
>>> [85] <query> SELECT `f`.* FROM `file` f WHERE (f.phid IN ('PHID-FILE-fbyv3ulhxu3erfudpdzg')) ORDER BY `f`.`id` DESC
<<< [85] <query> 1,092 us
>>> [86] <query> SELECT edge.* FROM `edge` edge WHERE (edge.src IN ('PHID-FILE-fbyv3ulhxu3erfudpdzg')) AND (edge.type IN ('26')) ORDER BY edge.dateCreated DESC, edge.seq DESC
<<< [86] <query> 1,050 us
>>> [87] <query> SELECT * FROM `file_transformedfile` WHERE transformedPHID IN ('PHID-FILE-fbyv3ulhxu3erfudpdzg')
<<< [87] <query> 1,024 us
>>> [88] <query> SELECT `f`.* FROM `file` f JOIN `file_transformedfile` t ON t.transformedPHID = f.phid WHERE (((t.originalPHID = 'PHID-VOID-00000000000000000000' AND t.transform = 'builtin:project.png'))) ORDER BY `f`.`id` DESC
<<< [88] <query> 1,127 us
>>> [89] <query> SELECT edge.* FROM `edge` edge WHERE (edge.src IN ('PHID-FILE-mpgyi55wthmxjdg4vewp')) AND (edge.type IN ('26')) ORDER BY edge.dateCreated DESC, edge.seq DESC
<<< [89] <query> 1,081 us
>>> [90] <query> SELECT * FROM `file_transformedfile` WHERE transformedPHID IN ('PHID-FILE-mpgyi55wthmxjdg4vewp')
<<< [90] <query> 1,111 us
>>> [91] <query> SELECT `task`.* FROM `maniphest_task` task WHERE (`task`.spacePHID IS NULL) AND (task.phid in ('PHID-TASK-xlaezfav3hqyzgbie2li')) ORDER BY `task`.`id` DESC
<<< [91] <query> 1,105 us
>>> [92] <query> SELECT * FROM `differential_diff` WHERE (phid IN ('PHID-DIFF-qr2rcjd2lparj2atn2m6')) ORDER BY `id` DESC
<<< [92] <query> 1,070 us
>>> [93] <query> (SELECT `r`.* FROM `differential_revision` r WHERE (r.id IN (23146)) ORDER BY `r`.`dateModified` DESC, `r`.`id` DESC )
<<< [93] <query> 1,168 us
>>> [94] <query> SELECT `r`.* FROM `repository` r WHERE (`r`.spacePHID IS NULL) AND (r.phid IN ('PHID-REPO-rgnn364lembo2emt5622')) ORDER BY `r`.`id` DESC
<<< [94] <query> 1,073 us
>>> [95] <query> SELECT * FROM `differential_changeset` WHERE (diffID IN (565918)) ORDER BY `id` DESC
<<< [95] <query> 1,127 us
>>> [96] <query> SELECT * FROM `differential_hunk_modern` WHERE (changesetID IN (7748366, 7748365)) ORDER BY `id` ASC
<<< [96] <query> 1,126 us
>>> [97] <query> SELECT * FROM `differential_hunk` WHERE (changesetID IN (7748366, 7748365)) ORDER BY `id` ASC
<<< [97] <query> 1,059 us
>>> [98] <query> SELECT edge.* FROM `edge` edge WHERE (edge.src IN ('PHID-DREV-4mhbuxmiuwzo37rixqlg')) AND (edge.type IN ('41')) ORDER BY edge.dateCreated DESC, edge.seq DESC
<<< [98] <query> 1,059 us
>>> [99] <query> SELECT `user`.* FROM `user` user WHERE (user.phid IN ('PHID-USER-l4hrts2frjnyghof5fgm')) ORDER BY `user`.`id` DESC
<<< [99] <query> 1,173 us
>>> [100] <query> SELECT `p`.*, vm.dst viewerIsMember FROM `project` p LEFT JOIN `edge` vm ON vm.src = p.phid AND vm.type = 13 AND vm.dst = 'PHID-USER-mw6ockgrrgytq3d3yywa' WHERE (phid IN ('PHID-PROJ-z4lum22ekior7wxtn7ub', 'PHID-PROJ-fpucoegg437ttgxyfciu')) ORDER BY `p`.`name` ASC
<<< [100] <query> 1,222 us
>>> [101] <query> SELECT `f`.* FROM `file` f WHERE (f.phid IN ('PHID-FILE-fbyv3ulhxu3erfudpdzg')) ORDER BY `f`.`id` DESC
<<< [101] <query> 1,056 us
>>> [102] <query> SELECT edge.* FROM `edge` edge WHERE (edge.src IN ('PHID-FILE-fbyv3ulhxu3erfudpdzg')) AND (edge.type IN ('26')) ORDER BY edge.dateCreated DESC, edge.seq DESC
<<< [102] <query> 1,157 us
>>> [103] <query> SELECT * FROM `file_transformedfile` WHERE transformedPHID IN ('PHID-FILE-fbyv3ulhxu3erfudpdzg')
<<< [103] <query> 1,034 us
>>> [104] <query> SELECT `f`.* FROM `file` f JOIN `file_transformedfile` t ON t.transformedPHID = f.phid WHERE (((t.originalPHID = 'PHID-VOID-00000000000000000000' AND t.transform = 'builtin:project.png'))) ORDER BY `f`.`id` DESC
<<< [104] <query> 1,107 us
>>> [105] <query> SELECT edge.* FROM `edge` edge WHERE (edge.src IN ('PHID-FILE-mpgyi55wthmxjdg4vewp')) AND (edge.type IN ('26')) ORDER BY edge.dateCreated DESC, edge.seq DESC
<<< [105] <query> 1,055 us
>>> [106] <query> SELECT * FROM `file_transformedfile` WHERE transformedPHID IN ('PHID-FILE-mpgyi55wthmxjdg4vewp')
<<< [106] <query> 1,164 us
>>> [107] <query> SELECT `user`.* FROM `user` user WHERE (user.phid IN ('PHID-USER-l4hrts2frjnyghof5fgm')) ORDER BY `user`.`id` DESC
<<< [107] <query> 1,117 us
>>> [108] <query> SELECT * FROM `policy` WHERE phid IN ('PHID-PLCY-mz7dj6am3bq4yx477tgg')
<<< [108] <query> 1,070 us
>>> [109] <query> SELECT `p`.*, vm.dst viewerIsMember FROM `project` p LEFT JOIN `edge` vm ON vm.src = p.phid AND vm.type = 13 AND vm.dst = '' JOIN `edge` e ON e.src = p.phid AND e.type = 13 WHERE (phid IN ('PHID-PROJ-5fgvj2vy6q3bzdcyrdsx')) AND (e.dst IN ('PHID-USER-peuiavsm52zpxge5kiok')) GROUP BY p.phid ORDER BY `p`.`name` ASC
<<< [109] <query> 1,126 us
>>> [110] <query> SELECT * FROM `differential_diff` WHERE (phid IN ('PHID-DIFF-qr2rcjd2lparj2atn2m6')) ORDER BY `id` DESC
<<< [110] <query> 1,106 us
>>> [111] <query> (SELECT `r`.* FROM `differential_revision` r WHERE (r.id IN (23146)) ORDER BY `r`.`dateModified` DESC, `r`.`id` DESC )
<<< [111] <query> 1,132 us
>>> [112] <query> SELECT * FROM `policy` WHERE phid IN ('PHID-PLCY-uwziuxgtcivsiknlo73u')
<<< [112] <query> 1,098 us
>>> [113] <query> SELECT `p`.*, vm.dst viewerIsMember FROM `project` p LEFT JOIN `edge` vm ON vm.src = p.phid AND vm.type = 13 AND vm.dst = '' JOIN `edge` e ON e.src = p.phid AND e.type = 13 WHERE (phid IN ('PHID-PROJ-5fgvj2vy6q3bzdcyrdsx')) AND (e.dst IN ('PHID-USER-peuiavsm52zpxge5kiok')) GROUP BY p.phid ORDER BY `p`.`name` ASC
<<< [113] <query> 1,122 us
>>> [114] <query> SELECT `r`.* FROM `repository` r WHERE (`r`.spacePHID IS NULL) AND (r.phid IN ('PHID-REPO-rgnn364lembo2emt5622')) ORDER BY `r`.`id` DESC
<<< [114] <query> 1,063 us
>>> [115] <query> SELECT `p`.*, vm.dst viewerIsMember FROM `project` p LEFT JOIN `edge` vm ON vm.src = p.phid AND vm.type = 13 AND vm.dst = 'PHID-USER-peuiavsm52zpxge5kiok' WHERE (phid IN ('PHID-PROJ-z4lum22ekior7wxtn7ub', 'PHID-PROJ-fpucoegg437ttgxyfciu')) ORDER BY `p`.`name` ASC
<<< [115] <query> 1,185 us
>>> [116] <query> SELECT `f`.* FROM `file` f WHERE (f.phid IN ('PHID-FILE-fbyv3ulhxu3erfudpdzg')) ORDER BY `f`.`id` DESC
<<< [116] <query> 1,102 us
>>> [117] <query> SELECT edge.* FROM `edge` edge WHERE (edge.src IN ('PHID-FILE-fbyv3ulhxu3erfudpdzg')) AND (edge.type IN ('26')) ORDER BY edge.dateCreated DESC, edge.seq DESC
<<< [117] <query> 1,079 us
>>> [118] <query> SELECT * FROM `file_transformedfile` WHERE transformedPHID IN ('PHID-FILE-fbyv3ulhxu3erfudpdzg')
<<< [118] <query> 1,071 us
>>> [119] <query> SELECT `f`.* FROM `file` f JOIN `file_transformedfile` t ON t.transformedPHID = f.phid WHERE (((t.originalPHID = 'PHID-VOID-00000000000000000000' AND t.transform = 'builtin:project.png'))) ORDER BY `f`.`id` DESC
<<< [119] <query> 1,133 us
>>> [120] <query> SELECT edge.* FROM `edge` edge WHERE (edge.src IN ('PHID-FILE-mpgyi55wthmxjdg4vewp')) AND (edge.type IN ('26')) ORDER BY edge.dateCreated DESC, edge.seq DESC
<<< [120] <query> 1,109 us
>>> [121] <query> SELECT * FROM `file_transformedfile` WHERE transformedPHID IN ('PHID-FILE-mpgyi55wthmxjdg4vewp')
<<< [121] <query> 1,040 us
>>> [122] <query> SELECT `task`.* FROM `maniphest_task` task WHERE (`task`.spacePHID IS NULL) AND (task.phid in ('PHID-TASK-xlaezfav3hqyzgbie2li')) ORDER BY `task`.`id` DESC
<<< [122] <query> 1,108 us
>>> [123] <query> SELECT * FROM `differential_diff` WHERE (phid IN ('PHID-DIFF-qr2rcjd2lparj2atn2m6')) ORDER BY `id` DESC
<<< [123] <query> 1,287 us
>>> [124] <query> (SELECT `r`.* FROM `differential_revision` r WHERE (r.id IN (23146)) ORDER BY `r`.`dateModified` DESC, `r`.`id` DESC )
<<< [124] <query> 1,065 us
>>> [125] <query> SELECT `r`.* FROM `repository` r WHERE (`r`.spacePHID IS NULL) AND (r.phid IN ('PHID-REPO-rgnn364lembo2emt5622')) ORDER BY `r`.`id` DESC
<<< [125] <query> 1,141 us
>>> [126] <query> SELECT * FROM `differential_changeset` WHERE (diffID IN (565918)) ORDER BY `id` DESC
<<< [126] <query> 1,157 us
>>> [127] <query> SELECT * FROM `differential_hunk_modern` WHERE (changesetID IN (7748366, 7748365)) ORDER BY `id` ASC
<<< [127] <query> 1,236 us
>>> [128] <query> SELECT * FROM `differential_hunk` WHERE (changesetID IN (7748366, 7748365)) ORDER BY `id` ASC
<<< [128] <query> 1,005 us
>>> [129] <query> SELECT edge.* FROM `edge` edge WHERE (edge.src IN ('PHID-DREV-4mhbuxmiuwzo37rixqlg')) AND (edge.type IN ('41')) ORDER BY edge.dateCreated DESC, edge.seq DESC
<<< [129] <query> 1,072 us
>>> [130] <query> SELECT `user`.* FROM `user` user WHERE (user.phid IN ('PHID-USER-l4hrts2frjnyghof5fgm')) ORDER BY `user`.`id` DESC
<<< [130] <query> 1,127 us
>>> [131] <query> SELECT `p`.*, vm.dst viewerIsMember FROM `project` p LEFT JOIN `edge` vm ON vm.src = p.phid AND vm.type = 13 AND vm.dst = 'PHID-USER-peuiavsm52zpxge5kiok' WHERE (phid IN ('PHID-PROJ-z4lum22ekior7wxtn7ub', 'PHID-PROJ-fpucoegg437ttgxyfciu')) ORDER BY `p`.`name` ASC
<<< [131] <query> 1,267 us
>>> [132] <query> SELECT `f`.* FROM `file` f WHERE (f.phid IN ('PHID-FILE-fbyv3ulhxu3erfudpdzg')) ORDER BY `f`.`id` DESC
<<< [132] <query> 1,084 us
>>> [133] <query> SELECT edge.* FROM `edge` edge WHERE (edge.src IN ('PHID-FILE-fbyv3ulhxu3erfudpdzg')) AND (edge.type IN ('26')) ORDER BY edge.dateCreated DESC, edge.seq DESC
<<< [133] <query> 1,061 us
>>> [134] <query> SELECT * FROM `file_transformedfile` WHERE transformedPHID IN ('PHID-FILE-fbyv3ulhxu3erfudpdzg')
<<< [134] <query> 1,036 us
>>> [135] <query> SELECT `f`.* FROM `file` f JOIN `file_transformedfile` t ON t.transformedPHID = f.phid WHERE (((t.originalPHID = 'PHID-VOID-00000000000000000000' AND t.transform = 'builtin:project.png'))) ORDER BY `f`.`id` DESC
<<< [135] <query> 1,168 us
>>> [136] <query> SELECT edge.* FROM `edge` edge WHERE (edge.src IN ('PHID-FILE-mpgyi55wthmxjdg4vewp')) AND (edge.type IN ('26')) ORDER BY edge.dateCreated DESC, edge.seq DESC
<<< [136] <query> 1,050 us
>>> [137] <query> SELECT * FROM `file_transformedfile` WHERE transformedPHID IN ('PHID-FILE-mpgyi55wthmxjdg4vewp')
<<< [137] <query> 1,127 us
>>> [138] <query> SELECT `user`.* FROM `user` user WHERE (user.phid IN ('PHID-USER-l4hrts2frjnyghof5fgm')) ORDER BY `user`.`id` DESC
<<< [138] <query> 1,140 us
>>> [139] <query> SELECT * FROM `policy` WHERE phid IN ('PHID-PLCY-mz7dj6am3bq4yx477tgg')
<<< [139] <query> 1,049 us
>>> [140] <query> SELECT `p`.*, vm.dst viewerIsMember FROM `project` p LEFT JOIN `edge` vm ON vm.src = p.phid AND vm.type = 13 AND vm.dst = '' JOIN `edge` e ON e.src = p.phid AND e.type = 13 WHERE (phid IN ('PHID-PROJ-5fgvj2vy6q3bzdcyrdsx')) AND (e.dst IN ('PHID-USER-hzs5buz4sbj5lcbwx4vu')) GROUP BY p.phid ORDER BY `p`.`name` ASC
<<< [140] <query> 1,248 us
>>> [141] <query> SELECT * FROM `differential_diff` WHERE (phid IN ('PHID-DIFF-qr2rcjd2lparj2atn2m6')) ORDER BY `id` DESC
<<< [141] <query> 1,143 us
>>> [142] <query> (SELECT `r`.* FROM `differential_revision` r WHERE (r.id IN (23146)) ORDER BY `r`.`dateModified` DESC, `r`.`id` DESC )
<<< [142] <query> 1,080 us
>>> [143] <query> SELECT * FROM `policy` WHERE phid IN ('PHID-PLCY-uwziuxgtcivsiknlo73u')
<<< [143] <query> 1,055 us
>>> [144] <query> SELECT `p`.*, vm.dst viewerIsMember FROM `project` p LEFT JOIN `edge` vm ON vm.src = p.phid AND vm.type = 13 AND vm.dst = '' JOIN `edge` e ON e.src = p.phid AND e.type = 13 WHERE (phid IN ('PHID-PROJ-5fgvj2vy6q3bzdcyrdsx')) AND (e.dst IN ('PHID-USER-hzs5buz4sbj5lcbwx4vu')) GROUP BY p.phid ORDER BY `p`.`name` ASC
<<< [144] <query> 1,117 us
>>> [145] <query> SELECT `r`.* FROM `repository` r WHERE (`r`.spacePHID IS NULL) AND (r.phid IN ('PHID-REPO-rgnn364lembo2emt5622')) ORDER BY `r`.`id` DESC
<<< [145] <query> 1,115 us
>>> [146] <query> SELECT `p`.*, vm.dst viewerIsMember FROM `project` p LEFT JOIN `edge` vm ON vm.src = p.phid AND vm.type = 13 AND vm.dst = 'PHID-USER-hzs5buz4sbj5lcbwx4vu' WHERE (phid IN ('PHID-PROJ-z4lum22ekior7wxtn7ub', 'PHID-PROJ-fpucoegg437ttgxyfciu')) ORDER BY `p`.`name` ASC
<<< [146] <query> 1,227 us
>>> [147] <query> SELECT `f`.* FROM `file` f WHERE (f.phid IN ('PHID-FILE-fbyv3ulhxu3erfudpdzg')) ORDER BY `f`.`id` DESC
<<< [147] <query> 1,126 us
>>> [148] <query> SELECT edge.* FROM `edge` edge WHERE (edge.src IN ('PHID-FILE-fbyv3ulhxu3erfudpdzg')) AND (edge.type IN ('26')) ORDER BY edge.dateCreated DESC, edge.seq DESC
<<< [148] <query> 1,100 us
>>> [149] <query> SELECT * FROM `file_transformedfile` WHERE transformedPHID IN ('PHID-FILE-fbyv3ulhxu3erfudpdzg')
<<< [149] <query> 1,075 us
>>> [150] <query> SELECT `f`.* FROM `file` f JOIN `file_transformedfile` t ON t.transformedPHID = f.phid WHERE (((t.originalPHID = 'PHID-VOID-00000000000000000000' AND t.transform = 'builtin:project.png'))) ORDER BY `f`.`id` DESC
<<< [150] <query> 1,148 us
>>> [151] <query> SELECT edge.* FROM `edge` edge WHERE (edge.src IN ('PHID-FILE-mpgyi55wthmxjdg4vewp')) AND (edge.type IN ('26')) ORDER BY edge.dateCreated DESC, edge.seq DESC
<<< [151] <query> 1,224 us
>>> [152] <query> SELECT * FROM `file_transformedfile` WHERE transformedPHID IN ('PHID-FILE-mpgyi55wthmxjdg4vewp')
<<< [152] <query> 1,061 us
>>> [153] <query> SELECT `task`.* FROM `maniphest_task` task WHERE (`task`.spacePHID IS NULL) AND (task.phid in ('PHID-TASK-xlaezfav3hqyzgbie2li')) ORDER BY `task`.`id` DESC
<<< [153] <query> 1,147 us
>>> [154] <query> SELECT * FROM `differential_diff` WHERE (phid IN ('PHID-DIFF-qr2rcjd2lparj2atn2m6')) ORDER BY `id` DESC
<<< [154] <query> 1,089 us
>>> [155] <query> (SELECT `r`.* FROM `differential_revision` r WHERE (r.id IN (23146)) ORDER BY `r`.`dateModified` DESC, `r`.`id` DESC )
<<< [155] <query> 1,092 us
>>> [156] <query> SELECT `r`.* FROM `repository` r WHERE (`r`.spacePHID IS NULL) AND (r.phid IN ('PHID-REPO-rgnn364lembo2emt5622')) ORDER BY `r`.`id` DESC
<<< [156] <query> 1,240 us
>>> [157] <query> SELECT * FROM `differential_changeset` WHERE (diffID IN (565918)) ORDER BY `id` DESC
<<< [157] <query> 1,157 us
>>> [158] <query> SELECT * FROM `differential_hunk_modern` WHERE (changesetID IN (7748366, 7748365)) ORDER BY `id` ASC
<<< [158] <query> 1,168 us
>>> [159] <query> SELECT * FROM `differential_hunk` WHERE (changesetID IN (7748366, 7748365)) ORDER BY `id` ASC
<<< [159] <query> 1,052 us
>>> [160] <query> SELECT edge.* FROM `edge` edge WHERE (edge.src IN ('PHID-DREV-4mhbuxmiuwzo37rixqlg')) AND (edge.type IN ('41')) ORDER BY edge.dateCreated DESC, edge.seq DESC
<<< [160] <query> 1,132 us
>>> [161] <query> SELECT `user`.* FROM `user` user WHERE (user.phid IN ('PHID-USER-l4hrts2frjnyghof5fgm')) ORDER BY `user`.`id` DESC
<<< [161] <query> 1,228 us
>>> [162] <query> SELECT `p`.*, vm.dst viewerIsMember FROM `project` p LEFT JOIN `edge` vm ON vm.src = p.phid AND vm.type = 13 AND vm.dst = 'PHID-USER-hzs5buz4sbj5lcbwx4vu' WHERE (phid IN ('PHID-PROJ-z4lum22ekior7wxtn7ub', 'PHID-PROJ-fpucoegg437ttgxyfciu')) ORDER BY `p`.`name` ASC
<<< [162] <query> 1,482 us
>>> [163] <query> SELECT `f`.* FROM `file` f WHERE (f.phid IN ('PHID-FILE-fbyv3ulhxu3erfudpdzg')) ORDER BY `f`.`id` DESC
<<< [163] <query> 1,241 us
>>> [164] <query> SELECT edge.* FROM `edge` edge WHERE (edge.src IN ('PHID-FILE-fbyv3ulhxu3erfudpdzg')) AND (edge.type IN ('26')) ORDER BY edge.dateCreated DESC, edge.seq DESC
<<< [164] <query> 1,129 us
>>> [165] <query> SELECT * FROM `file_transformedfile` WHERE transformedPHID IN ('PHID-FILE-fbyv3ulhxu3erfudpdzg')
<<< [165] <query> 1,044 us
>>> [166] <query> SELECT `f`.* FROM `file` f JOIN `file_transformedfile` t ON t.transformedPHID = f.phid WHERE (((t.originalPHID = 'PHID-VOID-00000000000000000000' AND t.transform = 'builtin:project.png'))) ORDER BY `f`.`id` DESC
<<< [166] <query> 1,202 us
>>> [167] <query> SELECT edge.* FROM `edge` edge WHERE (edge.src IN ('PHID-FILE-mpgyi55wthmxjdg4vewp')) AND (edge.type IN ('26')) ORDER BY edge.dateCreated DESC, edge.seq DESC
<<< [167] <query> 1,096 us
>>> [168] <query> SELECT * FROM `file_transformedfile` WHERE transformedPHID IN ('PHID-FILE-mpgyi55wthmxjdg4vewp')
<<< [168] <query> 1,101 us
>>> [169] <query> SELECT `user`.* FROM `user` user WHERE (user.phid IN ('PHID-USER-l4hrts2frjnyghof5fgm')) ORDER BY `user`.`id` DESC
<<< [169] <query> 1,410 us
>>> [170] <query> SELECT * FROM `policy` WHERE phid IN ('PHID-PLCY-mz7dj6am3bq4yx477tgg')
<<< [170] <query> 1,110 us
>>> [171] <query> SELECT `p`.*, vm.dst viewerIsMember FROM `project` p LEFT JOIN `edge` vm ON vm.src = p.phid AND vm.type = 13 AND vm.dst = '' JOIN `edge` e ON e.src = p.phid AND e.type = 13 WHERE (phid IN ('PHID-PROJ-5fgvj2vy6q3bzdcyrdsx')) AND (e.dst IN ('PHID-USER-comtfhp2czgmyrs3cm7m')) GROUP BY p.phid ORDER BY `p`.`name` ASC
<<< [171] <query> 1,152 us
>>> [172] <query> SELECT `p`.*, vm.dst viewerIsMember FROM `project` p LEFT JOIN `edge` vm ON vm.src = p.phid AND vm.type = 13 AND vm.dst = 'PHID-USER-comtfhp2czgmyrs3cm7m' WHERE (phid IN ('PHID-PROJ-z4lum22ekior7wxtn7ub', 'PHID-PROJ-fpucoegg437ttgxyfciu')) ORDER BY `p`.`name` ASC
<<< [172] <query> 1,298 us
>>> [173] <query> SELECT `f`.* FROM `file` f WHERE (f.phid IN ('PHID-FILE-fbyv3ulhxu3erfudpdzg')) ORDER BY `f`.`id` DESC
<<< [173] <query> 1,065 us
>>> [174] <query> SELECT edge.* FROM `edge` edge WHERE (edge.src IN ('PHID-FILE-fbyv3ulhxu3erfudpdzg')) AND (edge.type IN ('26')) ORDER BY edge.dateCreated DESC, edge.seq DESC
<<< [174] <query> 1,056 us
>>> [175] <query> SELECT * FROM `file_transformedfile` WHERE transformedPHID IN ('PHID-FILE-fbyv3ulhxu3erfudpdzg')
<<< [175] <query> 1,091 us
>>> [176] <query> SELECT `f`.* FROM `file` f JOIN `file_transformedfile` t ON t.transformedPHID = f.phid WHERE (((t.originalPHID = 'PHID-VOID-00000000000000000000' AND t.transform = 'builtin:project.png'))) ORDER BY `f`.`id` DESC
<<< [176] <query> 1,086 us
>>> [177] <query> SELECT edge.* FROM `edge` edge WHERE (edge.src IN ('PHID-FILE-mpgyi55wthmxjdg4vewp')) AND (edge.type IN ('26')) ORDER BY edge.dateCreated DESC, edge.seq DESC
<<< [177] <query> 1,108 us
>>> [178] <query> SELECT * FROM `file_transformedfile` WHERE transformedPHID IN ('PHID-FILE-mpgyi55wthmxjdg4vewp')
<<< [178] <query> 1,053 us
>>> [179] <query> SELECT `task`.* FROM `maniphest_task` task WHERE (`task`.spacePHID IS NULL) AND (task.phid in ('PHID-TASK-xlaezfav3hqyzgbie2li')) ORDER BY `task`.`id` DESC
<<< [179] <query> 1,196 us
>>> [180] <query> UPDATE `worker_activetask` SET `failureTime` = '1438841719', `taskClass` = 'PhabricatorApplicationTransactionPublishWorker', `leaseOwner` = NULL, `leaseExpires` = '300', `failureCount` = '1745', `dataID` = '18858361', `priority` = '1000', `objectPHID` = 'PHID-DREV-4mhbuxmiuwzo37rixqlg', `id` = '18829015' WHERE `id` = '18829015'
<<< [180] <query> 11,445 us
[2015-08-06 16:15:19] EXCEPTION: (Exception) Diff "PHID-DIFF-qr2rcjd2lparj2atn2m6" does not exist! at [<phabricator>/src/applications/differential/editor/DifferentialTransactionEditor.php:1535]
arcanist(head=master, ref.master=0d6f3328a08f), phabricator(head=master, ref.master=4139305f73f0, custom=1), phlab(head=master, ref.master=c090c8485be5), phutil(head=master, ref.master=aa6cd8f7e5e5)
#0 DifferentialTransactionEditor::requireDiff(string, boolean) called at [<phabricator>/src/applications/differential/editor/DifferentialTransactionEditor.php:1243]
#1 DifferentialTransactionEditor::buildMailBody(DifferentialRevision, array) called at [<phabricator>/src/applications/transactions/editor/PhabricatorApplicationTransactionEditor.php:2326]
#2 PhabricatorApplicationTransactionEditor::buildMailForTarget(DifferentialRevision, array, PhabricatorMailTarget) called at [<phabricator>/src/applications/transactions/editor/PhabricatorApplicationTransactionEditor.php:2285]
#3 PhabricatorApplicationTransactionEditor::buildMail(DifferentialRevision, array) called at [<phabricator>/src/applications/transactions/editor/PhabricatorApplicationTransactionEditor.php:1046]
#4 PhabricatorApplicationTransactionEditor::publishTransactions(DifferentialRevision, array) called at [<phabricator>/src/applications/transactions/worker/PhabricatorApplicationTransactionPublishWorker.php:21]
#5 PhabricatorApplicationTransactionPublishWorker::doWork() called at [<phabricator>/src/infrastructure/daemon/workers/PhabricatorWorker.php:91]
#6 PhabricatorWorker::executeTask() called at [<phabricator>/src/infrastructure/daemon/workers/storage/PhabricatorWorkerActiveTask.php:162]
#7 PhabricatorWorkerActiveTask::executeTask() called at [<phabricator>/src/infrastructure/daemon/workers/management/PhabricatorWorkerManagementExecuteWorkflow.php:51]
#8 PhabricatorWorkerManagementExecuteWorkflow::execute(PhutilArgumentParser) called at [<phutil>/src/parser/argument/PhutilArgumentParser.php:406]
#9 PhutilArgumentParser::parseWorkflowsFull(array) called at [<phutil>/src/parser/argument/PhutilArgumentParser.php:301]
#10 PhutilArgumentParser::parseWorkflows(array) called at [<phabricator>/scripts/setup/manage_worker.php:21]It looks like at some stage, this code is being executed:
Running this code works fine as well:
To clarify, the PHID does exist (I checked by querying the database directly)
Modernizing -- the timeline needs setQuoteTargetID() and setQuoteRef() to activate "Quote". This should be more automatic than it is, but the comment boxes are custom per app right now. If you want to go manually add the calls now that'll work, or we can wait until this gets a general modernization pass and should pick it up for free.
Some SearchEngines don't provide any fields.
Would this solve your problem?
Aug 5 2015
Yeah, I generally agree with that direction. I'm not really even sure if we need anything, or could maybe get away with a binary thing (like "good", which makes the answer gold and promotes it to the top of the page) since a lot of the "such wow" stuff can probably be covered with tokens.
Particularly, I would expect the total cost of ignoring master to be that git branch has one extra line. At least for me, git branch is useless as a routine command anyway:
I'd like to see reports from at least a few other users before pursuing this. I believe this workflow is highly unorthodox, and accommodating it would require special casing almost every step of arc land, make the workflow more complex for everyone else, and replace some errors with potentially confusing behaviors under normal use.
Awesome! I'll keep this around as context for getting the root issue fixed. Thanks for the report, and let us know if you run into anything else.
Another possible workaround would be to go find the credential in Passphrase and just update that, assuming the rest of the configuration is correct.
Er, sorry, had the wrong URL in the previous comment. Should be correct now, I think.
If you manually go to /diffusion/COLP/edit/ does that work?
We should improve the error handling behavior here. Because this is a clustered repository, we're failing more abruptly than we would with a non-service repository, but we should make the behavior more similar.
I am not asking for "support" per se, so I am not sure the referenced link is applicable for this task.
Why do you have a memory limit configured on the CLI? Do you legitimately want scripts to exit after consuming 128MB of RAM, or is this just a default you haven't changed?
Type Depends on D123. in your summary. See T5132.
Yeah, basically strncmp has worst-case runtime O(length(needle)) while strpos has worst-case runtime O(length(haystack) * length(needle)).
Interesting... okay, thanks for clarifying.
Try with a 10MB haystack.
