Revert "Apply IndexBuildsOnJobFinishedId to unfinished builds only"

[?]

Mar 16, 2016, 4:04 PM

APURLT2Q3OKS6VF4HUWI3MGENXAKSSUDXI7CQOEGCRTYJRGUNT6QC

Dependencies

[2] K2WAI5SO Apply IndexBuildsOnJobFinishedId to unfinished builds only
[3] PHJF4FUT Add missing files
[4] JD7AWXQG Remove now-unused SystemTypes table
[5] URHBNFTI Add forgotten file
[6] 4S5JF5JP Use latest DBIx::Class::Schema::Loader
[7] PLOZBRTR Add command ‘hydra-queue-runner --status’ to show current status
[8] 2JGYLIEC Speed up the listing of jobset evals by caching some info in the DB
[9] YU6CND7C Remove support for views
[10] YF3HTIPF Use partial indexes
[11] KSBB33RE Add a dashboard
[12] E7FID72S Remove the BuildMachines and BuildMachinesSystemTypes tables
[13] 4HPT4SDD Revert "Remove now-unused SystemTypes table"
[14] FITVNQ2S Keep track of the time we spend copying to/from build machines
[15] QLOLZHRX Allow a per-jobset check interval
[16] SS4TZXNU Distinguish between permanent evaluation errors and transient input errors
[17] W5OAZWPD Drop the errorMsg column in the Jobs table
[18] LTQMSMYO Get rid of some obsolete indexes
[19] KGGQD6CO Fix the Darcs schema upgrade
[20] RVHBV3B3 Notify the queue runner when a build is deleted
[21] CHJANKMM IndexJobsetEvalsOnJobsetId: Only index jobsets with new builds
[22] UNVMKJV5 Unify build and step status codes
[23] P57OYJ4P Index builds on stop time
[24] KDBWLKRP Index BuildSteps on propagatedFrom
[25] WE5Q2NVI Allow build to be bumped to the front of the queue via the web interface
[26] RXVJFQ5A Evaluator cleanups
[27] G2T4WAHI Store the inputs of each evaluation in the database
[28] TX7Q4RAS Add page showing latest build steps
[29] Q5HZWFCY Add support for darcs repositories.
[30] ACBS7C6Q hydra-queue-runner: Detect changes to the scheduling shares
[31] FANTYCR7 Materialize the number of finished builds
[32] FTPCV25M Store aggregate members in the database
[33] 6QRHXIM3 * Speed up the jobset index page. Especially the query to get the
[34] C5W3WZ3Y * Index the Builds table on drvPath to prevent a full table scan
[35] 4CELXP7P Remove the longDescription field
[36] KN3VYE5P * Cleaned up the foreign key constraints.
[37] EJ7C77C3 Allow searching for store and drv paths. Only does a complete match to reduce load on database.
[38] YTIDBFGU Drop unused "disabled" columns
[39] UJOSXBZI Record which build a failed build step was propagated from
[40] FV2M6MOT hydra: use autoconf/-make
[41] 2NGV7NYN Drop unused "tag" column
[42] DH3KNBAV Merge remote-tracking branch 'upstream/who-broke-builds' into upstream-master
[43] T5BIOVJE Add support for tracking custom metrics
[44] H7HGWODE * Remove an empty file.
[45] BXHG3HYL When renaming a jobset, add a redirect from the old name
[46] MOX7XJ2E Merge the BuildSchedulingInfo table into the Builds table
[47] PCKLFRT5 Support push notification of repository changes
[48] TM6C352U Ensure that stoptime and starttime are set for finished builds
[49] E7M2WP7A Remove unused Jobs columns
[50] GEADFVZ5 hydra-queue-runner: Improved scheduling
[51] RJNMYHJF Add missing file
[52] D5QIOJGP * Move everything up one directory.
[53] 26PYNDXV Remove the errorMsg column from the Builds table
[54] 53IMJNBB Add isChannel column and meta attribute.
[55] KJQWSRCC Speed up hydra-update-gc-roots
[56] D44B24QC Store the account type ("hydra" or "persona") explicitly in the database
[57] TPNHTE5V Remove obsolete Builds columns and provide accurate "Running builds"
[58] IWXLV4OB Add DB columns for when to notify responsible committers and which inputs should be checked
[*] N22GPKYT * Put info about logs / build products in the DB.

Change contents

file deletion: upgrade-47.sql (----------)

[3.3004]→[2.281:319](∅→∅),[2.319]→[2.121:121](∅→∅)

drop index IndexBuildsOnJobFinishedId;
create index IndexBuildsOnJobFinishedId on builds(project, jobset, job, system, finished, id DESC) where finished = 0;
replacement in src/sql/hydra.sql at line 640

[3.79]→[2.0:119](∅→∅)

create index IndexBuildsOnJobFinishedId on builds(project, jobset, job, system, finished, id DESC) where finished = 0;

[3.79]

[3.0]

create index IndexBuildsOnJobFinishedId on builds(project, jobset, job, system, finished, id DESC);