{"header":{"message":"Make \"Running builds\" and \"Machine status\" pages faster","description":null,"timestamp":"2016-03-16T14:19:18Z","authors":[{"email":"eelco.dolstra@logicblox.com","name":"Eelco Dolstra"}]},"hash":"O5ZANJMR27RRDAY7EVZLXZRKCKA24TFRBIZYWW7I72KG3DZQSCJAC","authors":[],"deps":{"hashes":[["O5ZANJMR27RRDAY7EVZLXZRKCKA24TFRBIZYWW7I72KG3DZQSCJAC","Make \"Running builds\" and \"Machine status\" pages faster"],["AA",null],["HWKCMAK5MMOKAZG7JJOTWCPB5EL2BABBGNDR22TS2JT3NOIWMIAQC","Remove some redundant SQL queries"],["AXU7D4PDON5DIMTSTNPFEV5XBIEUTWR6XTI3OSK3XFMFAAXREGHAC","Machine status page: Add link to build step"],["IT5AXPY2VAG2ECQN23UROQCTC4AUN7ZMCBVJC3ZK2CT4MSFSKVUAC","Disable channels on binary cached based Hydra instances"],["QAUDQPWGE3S3WOG6GEIT5MFZKLUZDGR4V4DO4F7QHFYRPH6XDGTAC","Add a more concise queue page"],["E46TNJK6LJK5GSNQM63D647NXTAKXZNG6N6O6B3ETOMDKPGCD6KQC","Use faster query to determine number of running builds"],["SMCOU72FKTPFNCDXFJAILVUWFE4DY33CJJE4436H5POKENFFDFFAC","hydra: add some admin for adding/enabling/etc build machines"],["J4R2VCPPXW6QPVIDNXVHFRTDAZAPLAFBBBPIQZLZVPUHFXCO67TAC","Fix showing build steps in the machine status page"],["TPNHTE5VJ36IPKMFENDERDBFBHLYFXOVNDLV2QSC4G5STPPMBLMAC","Remove obsolete Builds columns and provide accurate \"Running builds\""],["6FRLEP4PY7HKDWDD7TWQ7HXILOWRMIKXHJRXXXS65Q5CXMQ5CSMQC","first try for timeline of last 24 hours in hydra"],["V6S6OYIAW3ZCBP6UHUYAZGG4P237WBB6HDG5NQIF3E5YFDTQRA4AC","Formatting tweaks"],["2DHE2ZAKR4AU7OE6E5CYNFWVGQXLHEX5LFKVU43PMBVX3QW6RHFAC","Allow Hydra to run as a private instance by requiring a login."],["FPK5LF53CFUEKFYJ3IYXT4UTVC6IITWJOCFATMC4PLHEUP5SIEAAC","* Put the project-related actions in a separate controller. Put the"],["MOX7XJ2E3XISXA7V7T4W6GEAGECGWBZ4PYSLTYBVVR4VAKOI33CQC","Merge the BuildSchedulingInfo table into the Builds table"],["K42RSSSITOALPCQVUO7YUAFPI5QWKZOI4ITZSZ4DVGK3Y76AXN7QC",""],["HRAFVVOEGQJQS4XQNZSMNYN2SUZGKEGPSJUDZUBMI2IN32WFNQ4QC","make logo configurable via HYDRA_LOGO env var"],["HTL6HIBMRGSX2H2H7KB4MC3H6UQ5C752VC3UHC43SRA7V66PQCRQC","machine-status: Read /etc/nix.machines instead of using the BuildMachines table"],["RFGPN7U7DOFZMPNLJDTS3IXEYSDN57HUDKI5I54NU4LC376JUR2AC","Machine status: Don't show removed machines anymore"],["MGOGOKQPECPTSG66DV7QXJHY3SXUJVHPGRWPCY4JMMNRQSDE564AC","add tracker html code via HYDRA_TRACKER"],["R2PON6R7RJT63XVKGEXAIKB76RHIQL3WCDTZQM5JLKAZ7B5AZAFQC","Allow non-admin users to see the machine status page"],["CQTN62OHT4DY35E2MJEG7GFTVNEE5KRDMV6ASBQLBHN7BUDK7WHAC","Die tabs die"],["36ZTCZ4FDV6ILURQEIGFHCP57ALZH6OWYNN3MBXG2QXZSBULBPMAC","Add basic Persona support"],["EFWN7JBV7YIHNMCA6ZGFRSHZIUQJ2EX57SWYGVT7ZRJCHPIM2R3QC","* Added a status page that shows all the currently executing build steps."],["LZVO64YG43JD7YMZSCTZNOBS5ROZA4FMPKJW2YOMHX2V5PTGBVWQC","Merge in the first bits of the API work"],["J5UVLXOK6EDIL5I7VKWH4V2QDS4DPD7FHRK6XBWSXFRQS4JKXFZQC","* Start of a basic Catalyst web interface."],["LBNVQXUBEZ45SOTGVXK5UEZXIAIZTJLWZNUYFI4JZ6J65N3KPDVQC","* Build the /build stuff in a separate controller."],["CS7T2XFIISZ7TPQ6FFRIDYPR6BDCQHURP4JE4YKLI4OYSNWKZCHAC",""],["AFNDUSGDI2LSRZICZNFXTCFNIVG6IZCKYR7V3KOTHXYUFUU6AYCAC","Set Expires headers for Hydra's binary cache"],["ZWCTAZGLJZQNTYWTC2XQUKMILJF6JGDL5IND6QNYWK4FIGMLRFXAC","added newsitems, added some admin options to clear various caches."]],"deps":["HWKCMAK5MMOKAZG7JJOTWCPB5EL2BABBGNDR22TS2JT3NOIWMIAQC","AXU7D4PDON5DIMTSTNPFEV5XBIEUTWR6XTI3OSK3XFMFAAXREGHAC","IT5AXPY2VAG2ECQN23UROQCTC4AUN7ZMCBVJC3ZK2CT4MSFSKVUAC","QAUDQPWGE3S3WOG6GEIT5MFZKLUZDGR4V4DO4F7QHFYRPH6XDGTAC","E46TNJK6LJK5GSNQM63D647NXTAKXZNG6N6O6B3ETOMDKPGCD6KQC"],"known":["FPK5LF53CFUEKFYJ3IYXT4UTVC6IITWJOCFATMC4PLHEUP5SIEAAC","6FRLEP4PY7HKDWDD7TWQ7HXILOWRMIKXHJRXXXS65Q5CXMQ5CSMQC","EFWN7JBV7YIHNMCA6ZGFRSHZIUQJ2EX57SWYGVT7ZRJCHPIM2R3QC","K42RSSSITOALPCQVUO7YUAFPI5QWKZOI4ITZSZ4DVGK3Y76AXN7QC","SMCOU72FKTPFNCDXFJAILVUWFE4DY33CJJE4436H5POKENFFDFFAC","HRAFVVOEGQJQS4XQNZSMNYN2SUZGKEGPSJUDZUBMI2IN32WFNQ4QC","MGOGOKQPECPTSG66DV7QXJHY3SXUJVHPGRWPCY4JMMNRQSDE564AC","MOX7XJ2E3XISXA7V7T4W6GEAGECGWBZ4PYSLTYBVVR4VAKOI33CQC","CQTN62OHT4DY35E2MJEG7GFTVNEE5KRDMV6ASBQLBHN7BUDK7WHAC","R2PON6R7RJT63XVKGEXAIKB76RHIQL3WCDTZQM5JLKAZ7B5AZAFQC","V6S6OYIAW3ZCBP6UHUYAZGG4P237WBB6HDG5NQIF3E5YFDTQRA4AC","HTL6HIBMRGSX2H2H7KB4MC3H6UQ5C752VC3UHC43SRA7V66PQCRQC","J4R2VCPPXW6QPVIDNXVHFRTDAZAPLAFBBBPIQZLZVPUHFXCO67TAC","RFGPN7U7DOFZMPNLJDTS3IXEYSDN57HUDKI5I54NU4LC376JUR2AC","LZVO64YG43JD7YMZSCTZNOBS5ROZA4FMPKJW2YOMHX2V5PTGBVWQC","36ZTCZ4FDV6ILURQEIGFHCP57ALZH6OWYNN3MBXG2QXZSBULBPMAC","2DHE2ZAKR4AU7OE6E5CYNFWVGQXLHEX5LFKVU43PMBVX3QW6RHFAC","TPNHTE5VJ36IPKMFENDERDBFBHLYFXOVNDLV2QSC4G5STPPMBLMAC"]},"hunks":[{"Replacement":{"inode":{"change":26,"pos":804},"path":"src/lib/Hydra/Controller/Root.pm","line":48,"ins":{"up_context":[{"change":7,"pos":54}],"down_context":[{"change":6,"pos":95}],"flag":"BLOCK","start":0,"end":65,"inode":{"change":26,"pos":804}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":7,"pos":54},"to":{"change":6,"start":0,"end":95},"introduced_by":6}],"inode":{"change":26,"pos":804}},"ins_contents":[{"Add":{"text":" $c->stash->{nrRunningBuilds} = dbh($c)->selectrow_array(","pos":"O5ZANJMR27RRDAY7EVZLXZRKCKA24TFRBIZYWW7I72KG3DZQSCJAC:64"}}],"del_contents":[{"Del":{"text":" $c->stash->{nrRunningBuilds} = $c->model('DB')->schema->storage->dbh->selectrow_array(","pos":"E46TNJK6LJK5GSNQM63D647NXTAKXZNG6N6O6B3ETOMDKPGCD6KQC:94"}}]}},{"Replacement":{"inode":{"change":26,"pos":804},"path":"src/lib/Hydra/Controller/Root.pm","line":108,"ins":{"up_context":[{"change":7,"pos":378}],"down_context":[{"change":5,"pos":220}],"flag":"BLOCK","start":66,"end":121,"inode":{"change":26,"pos":804}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":7,"pos":378},"to":{"change":5,"start":135,"end":220},"introduced_by":5}],"inode":{"change":26,"pos":804}},"ins_contents":[{"Add":{"text":" $c->stash->{queued} = dbh($c)->selectall_arrayref(","pos":"O5ZANJMR27RRDAY7EVZLXZRKCKA24TFRBIZYWW7I72KG3DZQSCJAC:120"}}],"del_contents":[{"Del":{"text":" $c->stash->{queued} = $c->model('DB')->schema->storage->dbh->selectall_arrayref(","pos":"QAUDQPWGE3S3WOG6GEIT5MFZKLUZDGR4V4DO4F7QHFYRPH6XDGTAC:219"}}]}},{"Replacement":{"inode":{"change":26,"pos":804},"path":"src/lib/Hydra/Controller/Root.pm","line":122,"ins":{"up_context":[{"change":7,"pos":1314}],"down_context":[{"change":7,"pos":1369}],"flag":"BLOCK","start":122,"end":162,"inode":{"change":26,"pos":804}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":7,"pos":1314},"to":{"change":7,"start":1314,"end":1369},"introduced_by":7}],"inode":{"change":26,"pos":804}},"ins_contents":[{"Add":{"text":" { \"buildsteps.busy\" => 1 },","pos":"O5ZANJMR27RRDAY7EVZLXZRKCKA24TFRBIZYWW7I72KG3DZQSCJAC:161"}}],"del_contents":[{"Del":{"text":" { finished => 0, \"buildsteps.busy\" => 1 },","pos":"TPNHTE5VJ36IPKMFENDERDBFBHLYFXOVNDLV2QSC4G5STPPMBLMAC:1368"}}]}},{"Replacement":{"inode":{"change":26,"pos":804},"path":"src/lib/Hydra/Controller/Root.pm","line":167,"ins":{"up_context":[{"change":7,"pos":391}],"down_context":[{"change":7,"pos":634}],"flag":"BLOCK","start":163,"end":490,"inode":{"change":26,"pos":804}},"del":{"edges":[{"previous":"","flag":"DELETED","from":{"change":7,"pos":391},"to":{"change":7,"start":416,"end":480},"introduced_by":7},{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":7,"pos":416},"to":{"change":7,"start":416,"end":480},"introduced_by":7},{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":7,"pos":480},"to":{"change":7,"start":1524,"end":1568},"introduced_by":7},{"previous":"","flag":"DELETED","from":{"change":7,"pos":1568},"to":{"change":7,"start":543,"end":634},"introduced_by":7},{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":7,"pos":543},"to":{"change":7,"start":543,"end":634},"introduced_by":7}],"inode":{"change":26,"pos":804}},"ins_contents":[{"Add":{"text":" $c->stash->{steps} = dbh($c)->selectall_arrayref(","pos":"O5ZANJMR27RRDAY7EVZLXZRKCKA24TFRBIZYWW7I72KG3DZQSCJAC:216"}},{"Add":{"text":" \"select build, stepnr, s.system as system, s.drvpath as drvpath, machine, s.starttime as starttime, project, jobset, job \" .","pos":"O5ZANJMR27RRDAY7EVZLXZRKCKA24TFRBIZYWW7I72KG3DZQSCJAC:349"}},{"Add":{"text":" \"from BuildSteps s join Builds b on s.build = b.id \" .","pos":"O5ZANJMR27RRDAY7EVZLXZRKCKA24TFRBIZYWW7I72KG3DZQSCJAC:412"}},{"Add":{"text":" \"where busy = 1 order by machine, stepnr\",","pos":"O5ZANJMR27RRDAY7EVZLXZRKCKA24TFRBIZYWW7I72KG3DZQSCJAC:463"}},{"Add":{"text":" { Slice => {} });","pos":"O5ZANJMR27RRDAY7EVZLXZRKCKA24TFRBIZYWW7I72KG3DZQSCJAC:489"}}],"del_contents":[{"Del":{"text":" $c->stash->{steps} = [ $c->model('DB::BuildSteps')->search(","pos":"R2PON6R7RJT63XVKGEXAIKB76RHIQL3WCDTZQM5JLKAZ7B5AZAFQC:479"}},{"Del":{"text":" { finished => 0, 'me.busy' => 1, },","pos":"TPNHTE5VJ36IPKMFENDERDBFBHLYFXOVNDLV2QSC4G5STPPMBLMAC:1567"}},{"Del":{"text":" { join => [ 'build' ]","pos":"R2PON6R7RJT63XVKGEXAIKB76RHIQL3WCDTZQM5JLKAZ7B5AZAFQC:572"}},{"Del":{"text":" , order_by => [ 'machine', 'stepnr' ]","pos":"R2PON6R7RJT63XVKGEXAIKB76RHIQL3WCDTZQM5JLKAZ7B5AZAFQC:618"}},{"Del":{"text":" } ) ];","pos":"R2PON6R7RJT63XVKGEXAIKB76RHIQL3WCDTZQM5JLKAZ7B5AZAFQC:633"}}]}},{"Edit":{"inode":{"change":27,"pos":3469},"path":"src/lib/Hydra/Helper/CatalystUtils.pm","line":29,"atom":{"NewVertex":{"up_context":[{"change":4,"pos":191}],"down_context":[{"change":28,"pos":180}],"flag":"BLOCK","start":491,"end":499,"inode":{"change":27,"pos":3469}}},"contents":[{"Add":{"text":" dbh","pos":"O5ZANJMR27RRDAY7EVZLXZRKCKA24TFRBIZYWW7I72KG3DZQSCJAC:498"}}]}},{"Edit":{"inode":{"change":27,"pos":3469},"path":"src/lib/Hydra/Helper/CatalystUtils.pm","line":355,"atom":{"NewVertex":{"up_context":[{"change":29,"pos":315}],"down_context":[{"change":27,"pos":3787}],"flag":"BLOCK","start":500,"end":582,"inode":{"change":27,"pos":3469}}},"contents":[{"Add":{"text":"sub dbh {","pos":"O5ZANJMR27RRDAY7EVZLXZRKCKA24TFRBIZYWW7I72KG3DZQSCJAC:509"}},{"Add":{"text":" my ($c) = @_;","pos":"O5ZANJMR27RRDAY7EVZLXZRKCKA24TFRBIZYWW7I72KG3DZQSCJAC:527"}},{"Add":{"text":" return $c->model('DB')->schema->storage->dbh;","pos":"O5ZANJMR27RRDAY7EVZLXZRKCKA24TFRBIZYWW7I72KG3DZQSCJAC:577"}},{"Add":{"text":"}","pos":"O5ZANJMR27RRDAY7EVZLXZRKCKA24TFRBIZYWW7I72KG3DZQSCJAC:579"}},{"Add":{"text":"","pos":"O5ZANJMR27RRDAY7EVZLXZRKCKA24TFRBIZYWW7I72KG3DZQSCJAC:580"}},{"Add":{"text":"","pos":"O5ZANJMR27RRDAY7EVZLXZRKCKA24TFRBIZYWW7I72KG3DZQSCJAC:581"}}]}},{"Replacement":{"inode":{"change":30,"pos":8348},"path":"src/root/machine-status.tt","line":42,"ins":{"up_context":[{"change":7,"pos":852}],"down_context":[{"change":7,"pos":1006}],"flag":"BLOCK","start":583,"end":698,"inode":{"change":30,"pos":8348}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":7,"pos":852},"to":{"change":2,"start":0,"end":86},"introduced_by":2}],"inode":{"change":30,"pos":8348}},"ins_contents":[{"Add":{"text":" [% INCLUDE renderFullJobName project=step.project jobset=step.jobset job=step.job %]","pos":"O5ZANJMR27RRDAY7EVZLXZRKCKA24TFRBIZYWW7I72KG3DZQSCJAC:697"}}],"del_contents":[{"Del":{"text":" [% INCLUDE renderFullJobNameOfBuild build=step.build %]","pos":"HWKCMAK5MMOKAZG7JJOTWCPB5EL2BABBGNDR22TS2JT3NOIWMIAQC:85"}}]}},{"Replacement":{"inode":{"change":30,"pos":8348},"path":"src/root/machine-status.tt","line":44,"ins":{"up_context":[{"change":7,"pos":1054}],"down_context":[{"change":7,"pos":1149}],"flag":"BLOCK","start":699,"end":930,"inode":{"change":30,"pos":8348}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":7,"pos":1054},"to":{"change":7,"start":1054,"end":1149},"introduced_by":7},{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":7,"pos":1149},"to":{"change":3,"start":190,"end":335},"introduced_by":3}],"inode":{"change":30,"pos":8348}},"ins_contents":[{"Add":{"text":" [% step.build %]","pos":"O5ZANJMR27RRDAY7EVZLXZRKCKA24TFRBIZYWW7I72KG3DZQSCJAC:787"}},{"Add":{"text":" [% step.stepnr %]","pos":"O5ZANJMR27RRDAY7EVZLXZRKCKA24TFRBIZYWW7I72KG3DZQSCJAC:929"}}],"del_contents":[{"Del":{"text":" [% step.build.id %]","pos":"V6S6OYIAW3ZCBP6UHUYAZGG4P237WBB6HDG5NQIF3E5YFDTQRA4AC:1148"}},{"Del":{"text":" [% step.stepnr %]","pos":"AXU7D4PDON5DIMTSTNPFEV5XBIEUTWR6XTI3OSK3XFMFAAXREGHAC:334"}}]}}],"owner":"grahamc","repo":"hydra2","token":"PIcVlEjv3YmYBsA2ibgEwuaTraj9HxaZk6sonJZgRT4=","login":null}

…

Dependencies

Change contents

Review