Drop the errorMsg column in the Jobs table

Dependencies

• [2] YU6CND7C Remove support for views
• [3] WQXF2T3D hydra-evaluator: Don't require $HYDRA_CONFIG
• [4] PHNLYPKB Call buildFinished when a cached build is added
• [5] Y6AHH4TH Remove the logfile and logSize columns from the database
• [6] JM3DPYOM generated schema with new dbix class schema loader, grrrrrr
• [7] 2YXO5ZGQ Hydra/28: Rename "scheduler" to "evaluator"
• [8] S5PV6IIM * Represent jobs explicitly in the DB.
• [9] NI5BVF2V * In job inputs of type "build", allow the project and jobset names of
• [10] AHTEIK7G * Added a maintainers field to the Builds table.
• [11] SB2V735V Keep track of the database schema version
• [12] E7M2WP7A Remove unused Jobs columns
• [13] YI3BZG5N Cleanup Jobset serialization
• [14] TIOBBINA * Some renaming.
• [15] FTPCV25M Store aggregate members in the database
• [16] RFE6T5LG * Store jobset evaluations in the database explicitly. This includes
• [17] LZO3C2KI * Hack around those SQLite timeouts: just retry the transaction.
• [18] KN3VYE5P * Cleaned up the foreign key constraints.
• [19] S6OISBQ3 * Mark the "current" builds in a jobset, i.e. those corresponding to
• [20] IXCUNELF * Don't bother with the Jobs.active column anymore.
• [21] RXVJFQ5A Evaluator cleanups
• [22] X27GNHDV * Basic job info in the database.
• [23] DDMYFZ5X Fix the jobset unchanged check
• [24] BXHG3HYL When renaming a jobset, add a redirect from the old name
• [25] 7ECJWNVX Cleanup Project model
• [26] KSBB33RE Add a dashboard
• [27] JOYONH2K Prevent multiple builds with the same (job, outPath) tuple from being added
• [28] LZVO64YG Merge in the first bits of the API work
• [*] 5SHCWE7X * Prevent repeated evaluation of a jobset with the same inputs. This
• [*] N22GPKYT * Put info about logs / build products in the DB.
• [*] C3AG65SW Add one-shot jobsets
• [*] D5QIOJGP * Move everything up one directory.

Change contents

• edit in src/lib/Hydra/Schema/Jobs.pm at line 54
  [3.13952]→[3.13952:13953](∅→∅),[3.14025]→[3.14025:14042](∅→∅),[3.14042]→[3.15284:15304](∅→∅),[3.15352]→[3.14278:14295](∅→∅),[3.14278]→[3.14278:14295](∅→∅)
  −

  − =head2 errormsg

  −

  − data_type: 'text'

  − is_nullable: 1
• edit in src/lib/Hydra/Schema/Jobs.pm at line 64
  [3.10954]→[3.1919:1933](∅→∅),[3.15625]→[3.1919:1933](∅→∅),[3.1919]→[3.1919:1933](∅→∅),[3.1933]→[3.15626:15671](∅→∅)
  − "errormsg",

  − { data_type => "text", is_nullable => 1 },
• replacement in src/lib/Hydra/Schema/Jobs.pm at line 153
  [3.1556]→[3.1556:1698](∅→∅)
  − # Created by DBIx::Class::Schema::Loader v0.07033 @ 2013-10-14 15:46:29

  − # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:uYKWjewvKBEAuK53u7vKuw
  [3.1556]

  [3.2756]
  + # Created by DBIx::Class::Schema::Loader v0.07033 @ 2014-09-29 19:41:42

  + # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:lnZSd0gDXgLk8WQeAFqByA
• edit in src/lib/Hydra/Schema/Jobsets.pm at line 321
  [3.1961]

  [3.22627]
  +

  + =head2 projects
• edit in src/lib/Hydra/Schema/Jobsets.pm at line 324
  [3.22628]

  [3.1962]
  + Type: many_to_many
• replacement in src/lib/Hydra/Schema/Jobsets.pm at line 326
  [3.1963]→[3.2852:2994](∅→∅)
  − # Created by DBIx::Class::Schema::Loader v0.07033 @ 2014-04-23 23:13:51

  − # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:CO0aE+jrjB+UrwGRzWZLlw
  [3.1963]

  [3.0]
  + Composing rels: L</jobs> -> project

  +

  + =cut

  +

  + __PACKAGE__->many_to_many("projects", "jobs", "project");
• edit in src/lib/Hydra/Schema/Jobsets.pm at line 332
  [3.1]

  [3.1]
  +

  + # Created by DBIx::Class::Schema::Loader v0.07033 @ 2014-09-29 19:41:42

  + # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ln8UftPqK+aHCCrGkVxeyA

  +
• replacement in src/lib/Hydra/Schema/Projects.pm at line 169
  [3.3218]→[3.24803:24818](∅→∅),[3.20801]→[3.24803:24818](∅→∅)
  − =head2 jobsets
  [3.3218]

  [3.20815]
  + =head2 jobsets_2s
• replacement in src/lib/Hydra/Schema/Projects.pm at line 178
  [3.2234]→[3.24862:24875](∅→∅)
  − "jobsets",
  [3.2234]

  [3.24875]
  + "jobsets_2s",
• edit in src/lib/Hydra/Schema/Projects.pm at line 258
  [30.1866]

  [3.3683]
  +

  + =head2 jobsets

  +

  + Type: many_to_many

  +

  + Composing rels: L</jobs> -> jobset
• edit in src/lib/Hydra/Schema/Projects.pm at line 265
  [3.3684]

  [3.7144]
  + =cut

  +

  + __PACKAGE__->many_to_many("jobsets", "jobs", "jobset");

  +
• replacement in src/lib/Hydra/Schema/Projects.pm at line 280
  [3.7308]→[2.0:142](∅→∅)
  − # Created by DBIx::Class::Schema::Loader v0.07033 @ 2014-04-23 23:13:08

  − # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:fkd9ruEoVSBGIktmAj4u4g
  [3.7308]

  [3.171]
  + # Created by DBIx::Class::Schema::Loader v0.07033 @ 2014-09-29 19:41:42

  + # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:fTCp0shW7pisnCztza68xA
• edit in src/script/hydra-evaluator at line 168
  [3.5921]→[3.5921:5922](∅→∅),[3.5922]→[3.136:219](∅→∅),[3.5278]→[3.136:219](∅→∅),[3.219]→[3.5432:5547](∅→∅),[3.5432]→[3.5432:5547](∅→∅),[3.1623]→[3.1981:2033](∅→∅),[3.5547]→[3.1981:2033](∅→∅),[3.6163]→[3.1981:2033](∅→∅),[3.2033]→[3.1441:1442](∅→∅),[3.1442]→[3.2516:2668](∅→∅),[3.2042]→[3.2516:2668](∅→∅)
  −

  − # Update the last checked times and error messages for each

  − # job.

  − my %failedJobNames;

  − push @{$failedJobNames{$_->{location}}}, $_->{msg} foreach @{$jobs->{error}};

  −

  − $jobset->update({lastcheckedtime => time});

  −

  − $_->update({ errormsg => $failedJobNames{$_->name} ? join '\n', @{$failedJobNames{$_->name}} : undef })

  − foreach $jobset->jobs->all;
• edit in src/script/hydra-evaluator at line 242
  [32.1608]

  [3.5850]
  +

  + $jobset->update({ lastcheckedtime => time });
• edit in src/sql/hydra.sql at line 116
  [3.7006]→[3.7006:7063](∅→∅)
  −

  − errorMsg text, -- evalution error for this job
• file addition: upgrade-28.sql (----------)
  [33.3004]
  + alter table Jobs drop column errorMsg;