clear-queue-non-current: Work around PostgreSQL query optimizer stupidity
[?]
Jan 14, 2014, 5:14 PM
KEBKLMYZTP2Z5YLG5VKAX7URF72EJQNWN6JPCSCV2AZXBCCBKRTACDependencies
- [2]
UOINKJ2JAdd an action to cancel all builds in a jobset eval - [3]
R6B5CAFFLet Builds.timestamp refer to the time the build was added - [4]
DETQRBBRclear_queue_non_current: Don't use isCurrent - [5]
67NFGL7Dadd links in admin page to clear queue (all non-running builds, and all non-running old (non-current) builds) - [*]
ZWCTAZGLadded newsitems, added some admin options to clear various caches.
Change contents
- replacement in src/lib/Hydra/Controller/Admin.pm at line 38
{ finished => 0, busy => 0, id => { -not_in => \ "select build from JobsetEvalMembers where eval in (select max(id) from JobsetEvals where hasNewBuilds = 1 group by project, jobset)" }{ id => { -in => \ "select id from Builds where id in ((select id from Builds where finished = 0 and busy = 0) except (select build from JobsetEvalMembers where eval in (select max(id) from JobsetEvals where hasNewBuilds = 1 group by project, jobset)))" }