root@iridium:~# /srv/phab/phabricator/bin/repository importing OPUP --simplerOPUP782413587eb5a246e67d426d7c8b2e2927ce1f18
rOPUP4cbebb710ebbb84ea608ae78a4b77f08e2d31780
rOPUP5c103fe23689bea836f6697d8f30856b743feb33
rOPUPfd5273a5fdbf6766b386a90a983fe4b7ab44b9e0
rOPUP4d105737116a927344ccd501d34d903060668f96
rOPUP6e4fac5909ff17217da6513a62f2de411aa090c8
rOPUP68e354d659035736bb3dd91324f751d5cdfa9270
rOPUPf1d22656f098d617344027f557168eb5aaf90d3c
root@iridium:~# /srv/phab/phabricator/scripts/repository/reparse.php rOPUPf1d22656f098d617344027f557168eb5aaf90d3c --message --change --trace
>>> [2] <connect> phabricator_repository
<<< [2] <connect> 2,773 us
>>> [3] <query> SELECT * FROM `repository` WHERE callsign = 'OPUP'
<<< [3] <query> 615 us
>>> [4] <query> SELECT * FROM `repository_commit` WHERE repositoryID = 751 AND commitIdentifier = 'f1d22656f098d617344027f557168eb5aaf90d3c'
<<< [4] <query> 604 us
>>> [5] <query> SELECT * FROM `repository_commit` WHERE `id` = 487175
<<< [5] <query> 587 us
>>> [6] <query> SELECT * FROM `repository` r WHERE (r.id IN (751)) ORDER BY r.id DESC
<<< [6] <query> 622 us
>>> [7] <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' 'f1d22656f098d617344027f557168eb5aaf90d3c' --
<<< [7] <exec> 8,264 us
>>> [8] <query> SELECT * FROM `repository_commitdata` WHERE commitID = 487175
<<< [8] <query> 866 us
>>> [9] <connect> phabricator_user
<<< [9] <connect> 1,670 us
>>> [10] <query> SELECT * FROM `user` WHERE userName = 'Alexandros Kosiaris <akosiaris@wikimedia.org>'
<<< [10] <query> 769 us
>>> [11] <query> SELECT * FROM `user_email` WHERE address = 'Alexandros Kosiaris <akosiaris@wikimedia.org>'
<<< [11] <query> 685 us
>>> [12] <query> SELECT * FROM `user` WHERE realName = 'Alexandros Kosiaris <akosiaris@wikimedia.org>'
<<< [12] <query> 828 us
>>> [13] <query> SELECT * FROM `user_email` WHERE address = 'akosiaris@wikimedia.org'
<<< [13] <query> 560 us
>>> [14] <query> SELECT * FROM `user` WHERE phid = 'PHID-USER-xwxce3kpvsv54t735g7q'
<<< [14] <query> 638 us
>>> [15] <event> diffusion.lookupUser <listeners = 1>
<<< [15] <event> 128 us
>>> [16] <query> SELECT * FROM `user` WHERE userName = 'Alexandros Kosiaris <akosiaris@wikimedia.org>'
<<< [16] <query> 591 us
>>> [17] <query> SELECT * FROM `user_email` WHERE address = 'Alexandros Kosiaris <akosiaris@wikimedia.org>'
<<< [17] <query> 501 us
>>> [18] <query> SELECT * FROM `user` WHERE realName = 'Alexandros Kosiaris <akosiaris@wikimedia.org>'
<<< [18] <query> 605 us
>>> [19] <query> SELECT * FROM `user_email` WHERE address = 'akosiaris@wikimedia.org'
<<< [19] <query> 499 us
>>> [20] <query> SELECT * FROM `user` WHERE phid = 'PHID-USER-xwxce3kpvsv54t735g7q'
<<< [20] <query> 555 us
>>> [21] <event> diffusion.lookupUser <listeners = 1>
<<< [21] <event> 108 us
>>> [22] <query> SELECT * FROM `user` WHERE phid = 'PHID-USER-xwxce3kpvsv54t735g7q'
<<< [22] <query> 588 us
>>> [23] <connect> phabricator_repository
<<< [23] <connect> 1,127 us
>>> [24] <query> UPDATE `repository_commit` SET `repositoryID` = '751', `phid` = 'PHID-CMIT-matli4csujxgsyk333g6', `commitIdentifier` = 'f1d22656f098d617344027f557168eb5aaf90d3c', `epoch` = '1400243836', `mailKey` = 'ritwkvpvtkheasi3s7mb', `authorPHID` = 'PHID-USER-xwxce3kpvsv54t735g7q', `auditStatus` = '0', `summary` = 'Revert \"Introduce role::mariadb::backup\"', `importStatus` = '7', `id` = '487175' WHERE `id` = '487175'
<<< [24] <query> 1,314 us
>>> [25] <query> UPDATE `repository_commitdata` SET `commitID` = '487175', `authorName` = 'Alexandros Kosiaris <akosiaris@wikimedia.org>', `commitMessage` = 'Revert \"Introduce role::mariadb::backup\"\n\nReverting because needed class passwords::mysql::dump has not yet been\nadded in the private repo.\n\nThis reverts commit 0cdadcd1535862a909ba14e48e7b45716e0b5365.\n\nChange-Id: Ib1ad7b103cde05d7770576ff26b6841b77639173\n\n', `commitDetails` = '{\"authorName\":\"Alexandros Kosiaris\",\"authorEmail\":\"akosiaris@wikimedia.or
<<< [25] <query> 1,277 us
>>> [26] <query> UPDATE `repository_commit` SET importStatus = (importStatus | 1) WHERE id = 487175
<<< [26] <query> 848 us
>>> [27] <query> SELECT * FROM `repository_commit` WHERE `id` = 487175
<<< [27] <query> 512 us
>>> [28] <query> SELECT * FROM `repository` r WHERE (r.id IN (751)) ORDER BY r.id DESC
<<< [28] <query> 484 us
Parsing rOPUPf1d22656f098d617344027f557168eb5aaf90d3c...
>>> [29] <query> SELECT * FROM `repository_badcommit` WHERE fullCommitName = 'rOPUPf1d22656f098d617344027f557168eb5aaf90d3c'
<<< [29] <query> 453 us
>>> [30] <exec> $ git log -n1 --format='%P' 'f1d22656f098d617344027f557168eb5aaf90d3c'
<<< [30] <exec> 6,844 us
>>> [31] <exec> $ git diff -n1 -M -C -B --find-copies-harder --raw -t --abbrev=40 'f1d22656f098d617344027f557168eb5aaf90d3c'^1 'f1d22656f098d617344027f557168eb5aaf90d3c'
<<< [31] <exec> 25,444 us
>>> [32] <query> SELECT path, id FROM `repository_path` WHERE pathHash IN ('65f0e4f7f4dd586c20a2fbafeef8a98c', '7bcad250c54610d8b4aa63faa5565e8c', 'be7d52e0360e0855cf4760f90e0bfcb0', 'dc1e4e27b1741c51cf09e8f93d91b624', '6666cd76f96956469e7be39d750cc7d9')
<<< [32] <query> 800 us
>>> [33] <query> DELETE FROM `repository_pathchange` WHERE commitID = 487175
<<< [33] <query> 1,376 us
>>> [34] <query> INSERT INTO `repository_pathchange`
(repositoryID, pathID, commitID, targetPathID, targetCommitID,
changeType, fileType, isDirect, commitSequence)
VALUES (751, 32411, 487175, null, null, 10, 4, 0, 1400243836), (751, 32963, 487175, null, null, 10, 4, 0, 1400243836), (751, 37800, 487175, null, null, 2, 7, 1, 1400243836), (751, 32448, 487175, null, null, 2, 7, 1, 1400243836), (751, 3, 487175, null, null, 10, 4, 0, 1400243836)
<<< [34] <query> 1,333 us
>>> [35] <query> UPDATE `repository_commit` SET importStatus = (importStatus | 2) WHERE id = 487175
<<< [35] <query> 971 us
>>> [36] <connect> phabricator_worker
<<< [36] <connect> 1,564 us
>>> [37] <query> INSERT INTO `worker_taskdata` (`data`) VALUES ('{\"documentPHID\":\"PHID-CMIT-matli4csujxgsyk333g6\"}')
<<< [37] <query> 1,704 us
>>> [38] <query> INSERT INTO `lisk_counter` (counterName, counterValue) VALUES
('worker_activetask', LAST_INSERT_ID(1))
ON DUPLICATE KEY UPDATE
counterValue = LAST_INSERT_ID(counterValue + 1)
<<< [38] <query> 1,606 us
>>> [39] <query> INSERT INTO `worker_activetask` (`failureTime`, `taskClass`, `leaseOwner`, `leaseExpires`, `failureCount`, `dataID`, `priority`, `id`) VALUES (NULL, 'PhabricatorSearchWorker', NULL, NULL, '0', '5560483', '4000', '5560477')
<<< [39] <query> 1,578 us
>>> [40] <query> SELECT * FROM `repository` WHERE `id` = 751
<<< [40] <query> 782 us
>>> [41] <query> SELECT * FROM `repository_commit` WHERE repositoryID = 751 AND commitIdentifier = 'f1d22656f098d617344027f557168eb5aaf90d3c'
<<< [41] <query> 622 us
>>> [42] <query> SELECT c.*, p.path pathName, t.path targetPathName,
i.commitIdentifier targetCommitIdentifier
FROM `repository_pathchange` c
LEFT JOIN `repository_path` p ON c.pathID = p.id
LEFT JOIN `repository_path` t ON c.targetPathID = t.id
LEFT JOIN `repository_commit` i ON c.targetCommitID = i.id
WHERE c.commitID = 487175 AND isDirect = 1
<<< [42] <query> 854 us
>>> [43] <query> SELECT * FROM `repository` WHERE `id` = 751
<<< [43] <query> 698 us
root@iridium:~# /srv/phab/phabricator/bin/repository importing OPUP --simplerOPUP782413587eb5a246e67d426d7c8b2e2927ce1f18
rOPUP4cbebb710ebbb84ea608ae78a4b77f08e2d31780
rOPUP5c103fe23689bea836f6697d8f30856b743feb33
rOPUPfd5273a5fdbf6766b386a90a983fe4b7ab44b9e0
rOPUP4d105737116a927344ccd501d34d903060668f96
rOPUP6e4fac5909ff17217da6513a62f2de411aa090c8
rOPUP68e354d659035736bb3dd91324f751d5cdfa9270
rOPUPf1d22656f098d617344027f557168eb5aaf90d3c
root@iridium:~#