Page MenuHomePhabricator
Paste P1045

(An Untitled Masterwork)
ActivePublic
Actions

Authored by hach-que on Jan 11 2014, 1:30 AM.
Tags
None
Referenced Files
F100756: file
Jan 11 2014, 1:30 AM
Subscribers
None
>>> [2] <connect> phabricator_repository
<<< [2] <connect> 1,934 us
>>> [3] <query> SELECT * FROM `repository_commit` WHERE (((commitIdentifier LIKE 'b5f2dddf3a915418a5389914b2354b1d246dff08%' AND LENGTH(commitIdentifier) = 40))) ORDER BY id DESC
<<< [3] <query> 740 us
>>> [4] <query> SELECT * FROM `repository` r WHERE (r.id IN (1)) ORDER BY r.id DESC
<<< [4] <query> 390 us
>>> [5] <connect> phabricator_harbormaster
<<< [5] <connect> 657 us
>>> [6] <query> SELECT * FROM `harbormaster_buildplan` WHERE (id IN (1)) ORDER BY id DESC
<<< [6] <query> 473 us
>>> [7] <connect> phabricator_harbormaster
<<< [7] <connect> 688 us
>>> [8] <query> INSERT INTO `harbormaster_buildable` (`buildablePHID`, `containerPHID`, `buildStatus`, `buildableStatus`, `isManualBuildable`, `phid`, `dateCreated`, `dateModified`) VALUES ('PHID-CMIT-66r74fans6yxi6jfgvjf', 'PHID-REPO-s4arod4v7pow4s2jiobz', 'whatever', 'whatever', '1', 'PHID-HMBB-o5kat6tqhzh2bnxdq3yy', '1389403776', '1389403776')
<<< [8] <query> 907 us
Applying plan 1 to new buildable B207...
https://code.redpointsoftware.com.au/B207
>>> [9] <query> INSERT INTO `harbormaster_build` (`buildablePHID`, `buildPlanPHID`, `buildStatus`, `phid`, `dateCreated`, `dateModified`) VALUES ('PHID-HMBB-o5kat6tqhzh2bnxdq3yy', 'PHID-HMCP-fneqkdhmi2qktqcb2e3n', 'pending', 'PHID-HMBD-2kp3u7uhqicqtdrtxxxq', '1389403776', '1389403776')
<<< [9] <query> 1,328 us
>>> [10] <query> SELECT * FROM `harbormaster_build` WHERE (id IN (409)) ORDER BY id DESC
<<< [10] <query> 495 us
>>> [11] <query> SELECT * FROM `harbormaster_buildable` WHERE (phid IN ('PHID-HMBB-o5kat6tqhzh2bnxdq3yy')) ORDER BY id DESC
<<< [11] <query> 362 us
>>> [12] <query> SELECT * FROM `repository_commit` WHERE (phid IN ('PHID-CMIT-66r74fans6yxi6jfgvjf')) ORDER BY id DESC
<<< [12] <query> 396 us
>>> [13] <query> SELECT * FROM `repository` r WHERE (r.id IN (1)) ORDER BY r.id DESC
<<< [13] <query> 333 us
>>> [14] <query> SELECT * FROM `repository_commit` WHERE (phid IN ('PHID-CMIT-66r74fans6yxi6jfgvjf')) ORDER BY id DESC
<<< [14] <query> 390 us
>>> [15] <query> SELECT * FROM `repository` r WHERE (r.id IN (1)) ORDER BY r.id DESC
<<< [15] <query> 332 us
>>> [16] <query> SELECT * FROM `harbormaster_buildplan` WHERE (phid IN ('PHID-HMCP-fneqkdhmi2qktqcb2e3n')) ORDER BY id DESC
<<< [16] <query> 351 us
>>> [17] <query> SELECT * FROM `harbormaster_buildcommand` WHERE targetPHID IN ('PHID-HMBD-2kp3u7uhqicqtdrtxxxq') ORDER BY id ASC
<<< [17] <query> 384 us
>>> [18] <lock> global:phabricator:harbormaster.build:409
>>> [19] <connect> phabricator_repository
<<< [19] <connect> 586 us
>>> [20] <query> SET wait_timeout = 2147483
<<< [20] <query> 242 us
>>> [21] <query> SELECT GET_LOCK('phabricator:harbormaster.build:409', 15)
<<< [21] <query> 248 us
>>> [22] <query> SELECT * FROM `harbormaster_build` WHERE `id` = 409
<<< [22] <query> 412 us
>>> [23] <query> SELECT * FROM `harbormaster_buildtarget` WHERE (buildPHID in ('PHID-HMBD-2kp3u7uhqicqtdrtxxxq')) ORDER BY id DESC
<<< [23] <query> 512 us
>>> [24] <query> UPDATE `harbormaster_build` SET `buildablePHID` = 'PHID-HMBB-o5kat6tqhzh2bnxdq3yy', `buildPlanPHID` = 'PHID-HMCP-fneqkdhmi2qktqcb2e3n', `buildStatus` = 'building', `id` = '409', `phid` = 'PHID-HMBD-2kp3u7uhqicqtdrtxxxq', `dateCreated` = '1389403776', `dateModified` = '1389403776' WHERE `id` = '409'
<<< [24] <query> 3,721 us
>>> [25] <query> SELECT * FROM `harbormaster_buildtarget` WHERE (buildPHID in ('PHID-HMBD-2kp3u7uhqicqtdrtxxxq')) ORDER BY id DESC
<<< [25] <query> 479 us
>>> [26] <query> SELECT * FROM `harbormaster_buildstep` WHERE (buildPlanPHID in ('PHID-HMCP-fneqkdhmi2qktqcb2e3n')) ORDER BY sequence ASC
<<< [26] <query> 519 us
>>> [27] <query> SELECT * FROM `harbormaster_buildplan` WHERE (phid IN ('PHID-HMCP-fneqkdhmi2qktqcb2e3n')) ORDER BY id DESC
<<< [27] <query> 385 us
>>> [28] <query> INSERT INTO `harbormaster_buildtarget` (`buildPHID`, `buildStepPHID`, `className`, `details`, `variables`, `targetStatus`, `phid`, `dateCreated`, `dateModified`) VALUES ('PHID-HMBD-2kp3u7uhqicqtdrtxxxq', 'PHID-HMCS-5eqyvoax3obexbskqki7', 'LeaseHostBuildStepImplementation', '{\"name\":\"Linux Build Machine\",\"platform\":\"linux\"}', '{\"buildable.diff\":null,\"buildable.revision\":null,\"buildable.commit\":\"b5f2dddf3a915418a5389914b2354b1d246dff08\",\"repository.callsign\":\"T\",\"repository.vcs\":\"git\",
<<< [28] <query> 735 us
>>> [29] <query> SELECT RELEASE_LOCK('phabricator:harbormaster.build:409')
<<< [29] <query> 316 us
<<< [18] <lock> 18,064 us
>>> [30] <query> SELECT * FROM `harbormaster_buildtarget` WHERE (id IN (1028)) ORDER BY id DESC
<<< [30] <query> 406 us
>>> [31] <query> SELECT * FROM `harbormaster_build` WHERE (phid in ('PHID-HMBD-2kp3u7uhqicqtdrtxxxq')) ORDER BY id DESC
<<< [31] <query> 341 us
>>> [32] <query> SELECT * FROM `harbormaster_buildable` WHERE (phid IN ('PHID-HMBB-o5kat6tqhzh2bnxdq3yy')) ORDER BY id DESC
<<< [32] <query> 415 us
>>> [33] <query> SELECT * FROM `repository_commit` WHERE (phid IN ('PHID-CMIT-66r74fans6yxi6jfgvjf')) ORDER BY id DESC
<<< [33] <query> 402 us
>>> [34] <query> SELECT * FROM `repository` r WHERE (r.id IN (1)) ORDER BY r.id DESC
<<< [34] <query> 372 us
>>> [35] <query> SELECT * FROM `repository_commit` WHERE (phid IN ('PHID-CMIT-66r74fans6yxi6jfgvjf')) ORDER BY id DESC
<<< [35] <query> 481 us
>>> [36] <query> SELECT * FROM `repository` r WHERE (r.id IN (1)) ORDER BY r.id DESC
<<< [36] <query> 377 us
>>> [37] <query> SELECT * FROM `harbormaster_buildplan` WHERE (phid IN ('PHID-HMCP-fneqkdhmi2qktqcb2e3n')) ORDER BY id DESC
<<< [37] <query> 448 us
>>> [38] <query> SELECT * FROM `harbormaster_buildcommand` WHERE targetPHID IN ('PHID-HMBD-2kp3u7uhqicqtdrtxxxq') ORDER BY id ASC
<<< [38] <query> 473 us
>>> [39] <connect> phabricator_drydock
<<< [39] <connect> 681 us
>>> [40] <query> INSERT INTO `drydock_lease` (`resourceID`, `resourceType`, `until`, `ownerPHID`, `attributes`, `status`, `taskID`, `phid`, `dateCreated`, `dateModified`) VALUES (NULL, 'host', NULL, NULL, '{\"platform\":\"linux\"}', '0', NULL, 'PHID-DRYL-egk2rsjfcr5z4erc6con', '1389403776', '1389403776')
<<< [40] <query> 738 us
>>> [41] <query> SELECT lease.* FROM `drydock_lease` lease WHERE (id IN (355)) ORDER BY id DESC
<<< [41] <query> 411 us
>>> [42] <query> INSERT INTO `drydock_log` (`resourceID`, `leaseID`, `epoch`, `message`) VALUES (NULL, '355', '1389403776', 'Allocating Lease')
<<< [42] <query> 708 us
>>> [43] <query> SELECT blueprint.* FROM `drydock_blueprint` blueprint ORDER BY id DESC
<<< [43] <query> 365 us
>>> [44] <query> SELECT * FROM `drydock_resource` WHERE type = 'host' AND status = '1'
<<< [44] <query> 528 us
>>> [45] <query> INSERT INTO `drydock_log` (`resourceID`, `leaseID`, `epoch`, `message`) VALUES (NULL, '355', '1389403776', 'Found 2 Open Resource(s)')
<<< [45] <query> 673 us
>>> [46] <query> INSERT INTO `drydock_log` (`resourceID`, `leaseID`, `epoch`, `message`) VALUES (NULL, '355', '1389403776', '1 Open Resource(s) Remain')
<<< [46] <query> 614 us
>>> [47] <query> INSERT INTO `drydock_log` (`resourceID`, `leaseID`, `epoch`, `message`) VALUES ('1', '355', '1389403776', 'Trying to Allocate Lease')
<<< [47] <query> 715 us
>>> [48] <query> START TRANSACTION
<<< [48] <query> 222 us
>>> [49] <query> SELECT * FROM `drydock_resource` WHERE `id` = 1 FOR UPDATE
<<< [49] <query> 481 us
>>> [50] <query> SELECT * FROM `drydock_lease` WHERE status IN (5, 1) AND resourceID = 1 FOR UPDATE
<<< [50] <query> 1,367 us
>>> [51] <query> UPDATE `drydock_lease` SET `resourceID` = '1', `resourceType` = 'host', `until` = NULL, `ownerPHID` = NULL, `attributes` = '{\"platform\":\"linux\"}', `status` = '5', `taskID` = NULL, `id` = '355', `phid` = 'PHID-DRYL-egk2rsjfcr5z4erc6con', `dateCreated` = '1389403776', `dateModified` = '1389403776' WHERE `id` = '355'
<<< [51] <query> 511 us
>>> [52] <query> COMMIT
<<< [52] <query> 621 us
>>> [53] <query> INSERT INTO `drydock_log` (`resourceID`, `leaseID`, `epoch`, `message`) VALUES ('1', '355', '1389403776', 'Allocated Lease')
<<< [53] <query> 771 us
>>> [54] <query> SELECT * FROM `drydock_blueprint` WHERE phid = 'PHID-DRYB-jghxqz6oxlfhl5krz36s'
<<< [54] <query> 370 us
>>> [55] <query> INSERT INTO `drydock_log` (`resourceID`, `leaseID`, `epoch`, `message`) VALUES ('1', '355', '1389403776', 'Acquiring Lease')
<<< [55] <query> 495 us
>>> [56] <connect> phabricator_passphrase
<<< [56] <connect> 872 us
>>> [57] <query> SELECT * FROM `passphrase_credential` WHERE (id IN (2)) ORDER BY id DESC
<<< [57] <query> 548 us
>>> [58] <query> SELECT * FROM `passphrase_secret` WHERE id IN (2)
<<< [58] <query> 371 us
>>> [59] <query> SELECT * FROM `passphrase_credential` WHERE (phid IN ('PHID-CDTL-mtvbilgfm2v5xeuyidmq')) ORDER BY id DESC
<<< [59] <query> 402 us
>>> [60] <query> SELECT * FROM `passphrase_secret` WHERE id IN (2)
<<< [60] <query> 334 us
>>> [61] <exec> $ ssh -o StrictHostKeyChecking=no -p '26' -i 'xxxxx' 'xxxxx'@'omv.elexisvenator.net' -- 'mkdir '\''/srv/build/leases/355'\'''
<<< [61] <exec> 2,360,257 us
>>> [62] <query> UPDATE `drydock_lease` SET `resourceID` = '1', `resourceType` = 'host', `until` = NULL, `ownerPHID` = NULL, `attributes` = '{\"platform\":\"linux\",\"path\":\"\\/srv\\/build\\/leases\\/355\"}', `status` = '1', `taskID` = NULL, `id` = '355', `phid` = 'PHID-DRYL-egk2rsjfcr5z4erc6con', `dateCreated` = '1389403776', `dateModified` = '1389403779' WHERE `id` = '355'
<<< [62] <query> 1,029 us
>>> [63] <query> INSERT INTO `drydock_log` (`resourceID`, `leaseID`, `epoch`, `message`) VALUES ('1', '355', '1389403779', 'Acquired Lease')
<<< [63] <query> 637 us
>>> [64] <connect> phabricator_worker
<<< [64] <connect> 747 us
>>> [65] <query> START TRANSACTION
<<< [65] <query> 308 us
>>> [66] <query> INSERT INTO `worker_taskdata` (`data`) VALUES ('355')
<<< [66] <query> 311 us
>>> [67] <query> INSERT INTO `lisk_counter` (counterName, counterValue) VALUES
('worker_activetask', LAST_INSERT_ID(1))
ON DUPLICATE KEY UPDATE
counterValue = LAST_INSERT_ID(counterValue + 1)
<<< [67] <query> 300 us
>>> [68] <query> INSERT INTO `worker_activetask` (`failureTime`, `taskClass`, `leaseOwner`, `leaseExpires`, `failureCount`, `dataID`, `id`) VALUES (NULL, 'DrydockAllocatorWorker', NULL, NULL, '0', '137851', '137852')
<<< [68] <query> 283 us
>>> [69] <query> SAVEPOINT Aphront_Savepoint_1
<<< [69] <query> 194 us
>>> [70] <query> DELETE FROM `worker_activetask` WHERE id = 137852
<<< [70] <query> 329 us
>>> [71] <query> INSERT INTO `worker_archivetask` (`duration`, `result`, `taskClass`, `leaseOwner`, `leaseExpires`, `failureCount`, `dataID`, `id`, `dateCreated`, `dateModified`) VALUES ('0', '0', 'DrydockAllocatorWorker', NULL, NULL, '0', '137851', '137852', '1389403779', '1389403779')
<<< [71] <query> 359 us
>>> [72] <query> COMMIT
<<< [72] <query> 594 us
>>> [73] <query> SELECT * FROM `drydock_lease` WHERE `id` = 355
<<< [73] <query> 642 us
>>> [74] <query> UPDATE `drydock_lease` SET `resourceID` = '1', `resourceType` = 'host', `until` = NULL, `ownerPHID` = NULL, `attributes` = '{\"platform\":\"linux\",\"path\":\"\\/srv\\/build\\/leases\\/355\"}', `status` = '1', `taskID` = '0', `id` = '355', `phid` = 'PHID-DRYL-egk2rsjfcr5z4erc6con', `dateCreated` = '1389403776', `dateModified` = '1389403779' WHERE `id` = '355'
<<< [74] <query> 1,430 us
>>> [75] <query> SELECT * FROM `drydock_lease` WHERE `id` = 355
<<< [75] <query> 497 us
>>> [76] <query> SELECT * FROM `drydock_resource` WHERE id = 1
<<< [76] <query> 372 us
>>> [77] <query> INSERT INTO `harbormaster_buildartifact` (`buildTargetPHID`, `artifactType`, `artifactIndex`, `artifactKey`, `artifactData`, `dateCreated`, `dateModified`) VALUES ('PHID-HMBT-pvg3ru7xv2u2dswua5gx', 'host', '4VSVUZ4N36KY', 'Linux Build Machine', '[]', '1389403779', '1389403779')
<<< [77] <query> 789 us
>>> [78] <query> UPDATE `harbormaster_buildartifact` SET `buildTargetPHID` = 'PHID-HMBT-pvg3ru7xv2u2dswua5gx', `artifactType` = 'host', `artifactIndex` = '4VSVUZ4N36KY', `artifactKey` = 'Linux Build Machine', `artifactData` = '{\"drydock-lease\":\"355\"}', `id` = '512', `dateCreated` = '1389403779', `dateModified` = '1389403779' WHERE `id` = 512
<<< [78] <query> 924 us
>>> [79] <query> UPDATE `harbormaster_buildtarget` SET `buildPHID` = 'PHID-HMBD-2kp3u7uhqicqtdrtxxxq', `buildStepPHID` = 'PHID-HMCS-5eqyvoax3obexbskqki7', `className` = 'LeaseHostBuildStepImplementation', `details` = '{\"name\":\"Linux Build Machine\",\"platform\":\"linux\"}', `variables` = '{\"buildable.diff\":null,\"buildable.revision\":null,\"buildable.commit\":\"b5f2dddf3a915418a5389914b2354b1d246dff08\",\"repository.callsign\":\"T\",\"repository.vcs\":\"git\",\"repository.uri\":\"git:\\/\\/github.com\\/hach-que\\/Tycha
<<< [79] <query> 838 us
>>> [80] <lock> global:phabricator:harbormaster.build:409
>>> [81] <connect> phabricator_repository
<<< [81] <connect> 847 us
>>> [82] <query> SELECT GET_LOCK('phabricator:harbormaster.build:409', 15)
<<< [82] <query> 276 us
>>> [83] <query> SELECT * FROM `harbormaster_build` WHERE `id` = 409
<<< [83] <query> 437 us
>>> [84] <query> SELECT * FROM `harbormaster_buildtarget` WHERE (buildPHID in ('PHID-HMBD-2kp3u7uhqicqtdrtxxxq')) ORDER BY id DESC
<<< [84] <query> 607 us
>>> [85] <query> SELECT * FROM `harbormaster_build` WHERE (phid in ('PHID-HMBD-2kp3u7uhqicqtdrtxxxq')) ORDER BY id DESC
<<< [85] <query> 468 us
>>> [86] <query> SELECT * FROM `harbormaster_buildable` WHERE (phid IN ('PHID-HMBB-o5kat6tqhzh2bnxdq3yy')) ORDER BY id DESC
<<< [86] <query> 385 us
>>> [87] <query> SELECT * FROM `repository_commit` WHERE (phid IN ('PHID-CMIT-66r74fans6yxi6jfgvjf')) ORDER BY id DESC
<<< [87] <query> 386 us
>>> [88] <query> SELECT * FROM `repository` r WHERE (r.id IN (1)) ORDER BY r.id DESC
<<< [88] <query> 493 us
>>> [89] <query> SELECT * FROM `repository_commit` WHERE (phid IN ('PHID-CMIT-66r74fans6yxi6jfgvjf')) ORDER BY id DESC
<<< [89] <query> 442 us
>>> [90] <query> SELECT * FROM `repository` r WHERE (r.id IN (1)) ORDER BY r.id DESC
<<< [90] <query> 412 us
>>> [91] <query> SELECT * FROM `harbormaster_buildplan` WHERE (phid IN ('PHID-HMCP-fneqkdhmi2qktqcb2e3n')) ORDER BY id DESC
<<< [91] <query> 348 us
>>> [92] <query> SELECT * FROM `harbormaster_buildcommand` WHERE targetPHID IN ('PHID-HMBD-2kp3u7uhqicqtdrtxxxq') ORDER BY id ASC
<<< [92] <query> 452 us
>>> [93] <query> SELECT * FROM `harbormaster_buildstep` WHERE (buildPlanPHID in ('PHID-HMCP-fneqkdhmi2qktqcb2e3n')) ORDER BY sequence ASC
<<< [93] <query> 374 us
>>> [94] <query> SELECT * FROM `harbormaster_buildplan` WHERE (phid IN ('PHID-HMCP-fneqkdhmi2qktqcb2e3n')) ORDER BY id DESC
<<< [94] <query> 424 us
>>> [95] <query> INSERT INTO `harbormaster_buildtarget` (`buildPHID`, `buildStepPHID`, `className`, `details`, `variables`, `targetStatus`, `phid`, `dateCreated`, `dateModified`) VALUES ('PHID-HMBD-2kp3u7uhqicqtdrtxxxq', 'PHID-HMCS-xupstgaxcz3yq6n4lupm', 'CommandBuildStepImplementation', '{\"command\":\"\\/srv\\/build\\/run_linux ${build.id} ${buildable.commit} ${buildable.diff}\",\"hostartifact\":\"Linux Build Machine\"}', '{\"buildable.diff\":null,\"buildable.revision\":null,\"buildable.commit\":\"b5f2dddf3a915418a5389914
<<< [95] <query> 1,120 us
>>> [96] <query> SELECT RELEASE_LOCK('phabricator:harbormaster.build:409')
<<< [96] <query> 308 us
<<< [80] <lock> 26,618 us
>>> [97] <query> SELECT * FROM `harbormaster_buildtarget` WHERE (id IN (1029)) ORDER BY id DESC
<<< [97] <query> 380 us
>>> [98] <query> SELECT * FROM `harbormaster_build` WHERE (phid in ('PHID-HMBD-2kp3u7uhqicqtdrtxxxq')) ORDER BY id DESC
<<< [98] <query> 385 us
>>> [99] <query> SELECT * FROM `harbormaster_buildable` WHERE (phid IN ('PHID-HMBB-o5kat6tqhzh2bnxdq3yy')) ORDER BY id DESC
<<< [99] <query> 483 us
>>> [100] <query> SELECT * FROM `repository_commit` WHERE (phid IN ('PHID-CMIT-66r74fans6yxi6jfgvjf')) ORDER BY id DESC
<<< [100] <query> 499 us
>>> [101] <query> SELECT * FROM `repository` r WHERE (r.id IN (1)) ORDER BY r.id DESC
<<< [101] <query> 370 us
>>> [102] <query> SELECT * FROM `repository_commit` WHERE (phid IN ('PHID-CMIT-66r74fans6yxi6jfgvjf')) ORDER BY id DESC
<<< [102] <query> 459 us
>>> [103] <query> SELECT * FROM `repository` r WHERE (r.id IN (1)) ORDER BY r.id DESC
<<< [103] <query> 490 us
>>> [104] <query> SELECT * FROM `harbormaster_buildplan` WHERE (phid IN ('PHID-HMCP-fneqkdhmi2qktqcb2e3n')) ORDER BY id DESC
<<< [104] <query> 379 us
>>> [105] <query> SELECT * FROM `harbormaster_buildcommand` WHERE targetPHID IN ('PHID-HMBD-2kp3u7uhqicqtdrtxxxq') ORDER BY id ASC
<<< [105] <query> 435 us
>>> [106] <query> SELECT * FROM `harbormaster_buildartifact` WHERE (artifactIndex IN ('4VSVUZ4N36KY')) ORDER BY id DESC
<<< [106] <query> 1,421 us
>>> [107] <query> SELECT * FROM `harbormaster_buildtarget` WHERE (phid in ('PHID-HMBT-pvg3ru7xv2u2dswua5gx')) ORDER BY id DESC
<<< [107] <query> 527 us
>>> [108] <query> SELECT * FROM `harbormaster_build` WHERE (phid in ('PHID-HMBD-2kp3u7uhqicqtdrtxxxq')) ORDER BY id DESC
<<< [108] <query> 501 us
>>> [109] <query> SELECT * FROM `harbormaster_buildable` WHERE (phid IN ('PHID-HMBB-o5kat6tqhzh2bnxdq3yy')) ORDER BY id DESC
<<< [109] <query> 452 us
>>> [110] <query> SELECT * FROM `repository_commit` WHERE (phid IN ('PHID-CMIT-66r74fans6yxi6jfgvjf')) ORDER BY id DESC
<<< [110] <query> 413 us
>>> [111] <query> SELECT * FROM `repository` r WHERE (r.id IN (1)) ORDER BY r.id DESC
<<< [111] <query> 494 us
>>> [112] <query> SELECT * FROM `repository_commit` WHERE (phid IN ('PHID-CMIT-66r74fans6yxi6jfgvjf')) ORDER BY id DESC
<<< [112] <query> 442 us
>>> [113] <query> SELECT * FROM `repository` r WHERE (r.id IN (1)) ORDER BY r.id DESC
<<< [113] <query> 489 us
>>> [114] <query> SELECT * FROM `harbormaster_buildplan` WHERE (phid IN ('PHID-HMCP-fneqkdhmi2qktqcb2e3n')) ORDER BY id DESC
<<< [114] <query> 499 us
>>> [115] <query> SELECT * FROM `harbormaster_buildcommand` WHERE targetPHID IN ('PHID-HMBD-2kp3u7uhqicqtdrtxxxq') ORDER BY id ASC
<<< [115] <query> 447 us
>>> [116] <query> SELECT * FROM `drydock_lease` WHERE `id` = 355
<<< [116] <query> 411 us
>>> [117] <query> SELECT * FROM `drydock_resource` WHERE `id` = 1
<<< [117] <query> 356 us
>>> [118] <query> SELECT * FROM `drydock_blueprint` WHERE phid = 'PHID-DRYB-jghxqz6oxlfhl5krz36s'
<<< [118] <query> 380 us
>>> [119] <query> SELECT * FROM `passphrase_credential` WHERE (id IN (2)) ORDER BY id DESC
<<< [119] <query> 458 us
>>> [120] <query> SELECT * FROM `passphrase_secret` WHERE id IN (2)
<<< [120] <query> 437 us
>>> [121] <query> SELECT * FROM `passphrase_credential` WHERE (phid IN ('PHID-CDTL-mtvbilgfm2v5xeuyidmq')) ORDER BY id DESC
<<< [121] <query> 447 us
>>> [122] <query> SELECT * FROM `passphrase_secret` WHERE id IN (2)
<<< [122] <query> 316 us
>>> [123] <query> INSERT INTO `harbormaster_buildlog` (`buildTargetPHID`, `logSource`, `logType`, `duration`, `live`, `phid`, `dateCreated`, `dateModified`) VALUES ('PHID-HMBT-ewsgkg6y5bhyhnhutcgi', 'remote', 'stdout', NULL, '0', 'PHID-HMCL-2ppjif2zst5s762rtday', '1389403779', '1389403779')
<<< [123] <query> 836 us
>>> [124] <query> INSERT INTO `harbormaster_buildlog` (`buildTargetPHID`, `logSource`, `logType`, `duration`, `live`, `phid`, `dateCreated`, `dateModified`) VALUES ('PHID-HMBT-ewsgkg6y5bhyhnhutcgi', 'remote', 'stderr', NULL, '0', 'PHID-HMCL-gjh5yiv5v2xmtj2tuj24', '1389403779', '1389403779')
<<< [124] <query> 545 us
>>> [125] <query> UPDATE `harbormaster_buildlog` SET `buildTargetPHID` = 'PHID-HMBT-ewsgkg6y5bhyhnhutcgi', `logSource` = 'remote', `logType` = 'stdout', `duration` = NULL, `live` = '1', `id` = '705', `phid` = 'PHID-HMCL-2ppjif2zst5s762rtday', `dateCreated` = '1389403779', `dateModified` = '1389403779' WHERE `id` = 705
<<< [125] <query> 659 us
>>> [126] <query> UPDATE `harbormaster_buildlog` SET `buildTargetPHID` = 'PHID-HMBT-ewsgkg6y5bhyhnhutcgi', `logSource` = 'remote', `logType` = 'stderr', `duration` = NULL, `live` = '1', `id` = '706', `phid` = 'PHID-HMCL-gjh5yiv5v2xmtj2tuj24', `dateCreated` = '1389403779', `dateModified` = '1389403779' WHERE `id` = 706
<<< [126] <query> 694 us
>>> [127] <exec> $ ssh -o StrictHostKeyChecking=no -p '26' -i 'xxxxx' 'xxxxx'@'omv.elexisvenator.net' -- '/srv/build/run_linux '\''409'\'' '\''b5f2dddf3a915418a5389914b2354b1d246dff08'\'' '\'''\'''
<<< [127] <exec> 7,987 us
>>> [128] <query> UPDATE `harbormaster_buildtarget` SET `buildPHID` = 'PHID-HMBD-2kp3u7uhqicqtdrtxxxq', `buildStepPHID` = 'PHID-HMCS-xupstgaxcz3yq6n4lupm', `className` = 'CommandBuildStepImplementation', `details` = '{\"command\":\"\\/srv\\/build\\/run_linux ${build.id} ${buildable.commit} ${buildable.diff}\",\"hostartifact\":\"Linux Build Machine\"}', `variables` = '{\"buildable.diff\":null,\"buildable.revision\":null,\"buildable.commit\":\"b5f2dddf3a915418a5389914b2354b1d246dff08\",\"repository.callsign\":\"T\",\"repositor
<<< [128] <query> 1,192 us
>>> [129] <lock> global:phabricator:harbormaster.build:409
>>> [130] <connect> phabricator_repository
<<< [130] <connect> 869 us
>>> [131] <query> SELECT GET_LOCK('phabricator:harbormaster.build:409', 15)
<<< [131] <query> 315 us
>>> [132] <query> SELECT * FROM `harbormaster_build` WHERE `id` = 409
<<< [132] <query> 422 us
>>> [133] <query> SELECT * FROM `harbormaster_buildtarget` WHERE (buildPHID in ('PHID-HMBD-2kp3u7uhqicqtdrtxxxq')) ORDER BY id DESC
<<< [133] <query> 537 us
>>> [134] <query> SELECT * FROM `harbormaster_build` WHERE (phid in ('PHID-HMBD-2kp3u7uhqicqtdrtxxxq')) ORDER BY id DESC
<<< [134] <query> 340 us
>>> [135] <query> SELECT * FROM `harbormaster_buildable` WHERE (phid IN ('PHID-HMBB-o5kat6tqhzh2bnxdq3yy')) ORDER BY id DESC
<<< [135] <query> 359 us
>>> [136] <query> SELECT * FROM `repository_commit` WHERE (phid IN ('PHID-CMIT-66r74fans6yxi6jfgvjf')) ORDER BY id DESC
<<< [136] <query> 439 us
>>> [137] <query> SELECT * FROM `repository` r WHERE (r.id IN (1)) ORDER BY r.id DESC
<<< [137] <query> 344 us
>>> [138] <query> SELECT * FROM `repository_commit` WHERE (phid IN ('PHID-CMIT-66r74fans6yxi6jfgvjf')) ORDER BY id DESC
<<< [138] <query> 415 us
>>> [139] <query> SELECT * FROM `repository` r WHERE (r.id IN (1)) ORDER BY r.id DESC
<<< [139] <query> 365 us
>>> [140] <query> SELECT * FROM `harbormaster_buildplan` WHERE (phid IN ('PHID-HMCP-fneqkdhmi2qktqcb2e3n')) ORDER BY id DESC
<<< [140] <query> 341 us
>>> [141] <query> SELECT * FROM `harbormaster_buildcommand` WHERE targetPHID IN ('PHID-HMBD-2kp3u7uhqicqtdrtxxxq') ORDER BY id ASC
<<< [141] <query> 344 us
>>> [142] <query> SELECT * FROM `harbormaster_buildstep` WHERE (buildPlanPHID in ('PHID-HMCP-fneqkdhmi2qktqcb2e3n')) ORDER BY sequence ASC
<<< [142] <query> 376 us
>>> [143] <query> SELECT * FROM `harbormaster_buildplan` WHERE (phid IN ('PHID-HMCP-fneqkdhmi2qktqcb2e3n')) ORDER BY id DESC
<<< [143] <query> 365 us
>>> [144] <query> UPDATE `harbormaster_build` SET `buildablePHID` = 'PHID-HMBB-o5kat6tqhzh2bnxdq3yy', `buildPlanPHID` = 'PHID-HMCP-fneqkdhmi2qktqcb2e3n', `buildStatus` = 'failed', `id` = '409', `phid` = 'PHID-HMBD-2kp3u7uhqicqtdrtxxxq', `dateCreated` = '1389403776', `dateModified` = '1389403779' WHERE `id` = '409'
<<< [144] <query> 769 us
>>> [145] <query> SELECT RELEASE_LOCK('phabricator:harbormaster.build:409')
<<< [145] <query> 296 us
<<< [129] <lock> 23,025 us
>>> [146] <query> START TRANSACTION
<<< [146] <query> 366 us
>>> [147] <query> INSERT INTO `worker_taskdata` (`data`) VALUES ('{\"targetID\":1029}')
<<< [147] <query> 435 us
>>> [148] <query> INSERT INTO `lisk_counter` (counterName, counterValue) VALUES
('worker_activetask', LAST_INSERT_ID(1))
ON DUPLICATE KEY UPDATE
counterValue = LAST_INSERT_ID(counterValue + 1)
<<< [148] <query> 364 us
>>> [149] <query> INSERT INTO `worker_activetask` (`failureTime`, `taskClass`, `leaseOwner`, `leaseExpires`, `failureCount`, `dataID`, `id`) VALUES (NULL, 'HarbormasterTargetWorker', NULL, NULL, '0', '137852', '137853')
<<< [149] <query> 329 us
>>> [150] <query> SAVEPOINT Aphront_Savepoint_1
<<< [150] <query> 275 us
>>> [151] <query> DELETE FROM `worker_activetask` WHERE id = 137853
<<< [151] <query> 368 us
>>> [152] <query> INSERT INTO `worker_archivetask` (`duration`, `result`, `taskClass`, `leaseOwner`, `leaseExpires`, `failureCount`, `dataID`, `id`, `dateCreated`, `dateModified`) VALUES ('0', '0', 'HarbormasterTargetWorker', NULL, NULL, '0', '137852', '137853', '1389403779', '1389403779')
<<< [152] <query> 341 us
>>> [153] <query> COMMIT
<<< [153] <query> 657 us
>>> [154] <query> START TRANSACTION
<<< [154] <query> 267 us
>>> [155] <query> INSERT INTO `worker_taskdata` (`data`) VALUES ('{\"targetID\":1028}')
<<< [155] <query> 304 us
>>> [156] <query> INSERT INTO `lisk_counter` (counterName, counterValue) VALUES
('worker_activetask', LAST_INSERT_ID(1))
ON DUPLICATE KEY UPDATE
counterValue = LAST_INSERT_ID(counterValue + 1)
<<< [156] <query> 336 us
>>> [157] <query> INSERT INTO `worker_activetask` (`failureTime`, `taskClass`, `leaseOwner`, `leaseExpires`, `failureCount`, `dataID`, `id`) VALUES (NULL, 'HarbormasterTargetWorker', NULL, NULL, '0', '137853', '137854')
<<< [157] <query> 383 us
>>> [158] <query> SAVEPOINT Aphront_Savepoint_1
<<< [158] <query> 209 us
>>> [159] <query> DELETE FROM `worker_activetask` WHERE id = 137854
<<< [159] <query> 288 us
>>> [160] <query> INSERT INTO `worker_archivetask` (`duration`, `result`, `taskClass`, `leaseOwner`, `leaseExpires`, `failureCount`, `dataID`, `id`, `dateCreated`, `dateModified`) VALUES ('0', '0', 'HarbormasterTargetWorker', NULL, NULL, '0', '137853', '137854', '1389403779', '1389403779')
<<< [160] <query> 303 us
>>> [161] <query> COMMIT
<<< [161] <query> 746 us
>>> [162] <query> START TRANSACTION
<<< [162] <query> 234 us
>>> [163] <query> INSERT INTO `worker_taskdata` (`data`) VALUES ('{\"buildID\":409}')
<<< [163] <query> 357 us
>>> [164] <query> INSERT INTO `lisk_counter` (counterName, counterValue) VALUES
('worker_activetask', LAST_INSERT_ID(1))
ON DUPLICATE KEY UPDATE
counterValue = LAST_INSERT_ID(counterValue + 1)
<<< [164] <query> 385 us
>>> [165] <query> INSERT INTO `worker_activetask` (`failureTime`, `taskClass`, `leaseOwner`, `leaseExpires`, `failureCount`, `dataID`, `id`) VALUES (NULL, 'HarbormasterBuildWorker', NULL, NULL, '0', '137854', '137855')
<<< [165] <query> 385 us
>>> [166] <query> SAVEPOINT Aphront_Savepoint_1
<<< [166] <query> 290 us
>>> [167] <query> DELETE FROM `worker_activetask` WHERE id = 137855
<<< [167] <query> 470 us
>>> [168] <query> INSERT INTO `worker_archivetask` (`duration`, `result`, `taskClass`, `leaseOwner`, `leaseExpires`, `failureCount`, `dataID`, `id`, `dateCreated`, `dateModified`) VALUES ('0', '0', 'HarbormasterBuildWorker', NULL, NULL, '0', '137854', '137855', '1389403779', '1389403779')
<<< [168] <query> 473 us
>>> [169] <query> COMMIT
<<< [169] <query> 576 us
Done.

Event Timeline

hach-que edited the content of this paste. (Show Details)Jan 11 2014, 1:30 AM
hach-que updated the paste's language from autodetect to autodetect.
Phabricator · Built by Phacility