grahamc/hydra2 - Change 26PYNDXVE4EBTZ5R3PYSFRPYNV777BM2EBPREGH5DOUHPSBJMTVQC

Remove the errorMsg column from the Builds table

The queue runner no longer uses this field, and it doesn't provide very interesting historical data (mostly SSH failures), but it takes up a lot of space. Also, it contained some bad UTF-8 which was preventing an upgrade to Postgres 9.5, so a good occasion to get rid of it.

Created by Eelco Dolstra on February 12, 2016

26PYNDXVE4EBTZ5R3PYSFRPYNV777BM2EBPREGH5DOUHPSBJMTVQC

Dependencies

In channels

main

Change contents

Deletion in src/lib/Hydra/Schema/Builds.pm at line 171 [5.5202]
B:BD[3.4595] → [4.5786:5841]
```
  is_nullable: 1
=head2 errormsg
  data_type: 'text'
```
Deletion in src/lib/Hydra/Schema/Builds.pm at line 247 [5.5202]
B:BD[4.6339] → [4.6339:6398]
```
  "errormsg",
  { data_type => "text", is_nullable => 1 },
```

Replacement in src/lib/Hydra/Schema/Builds.pm at line 540 [5.5202]

B:BD[6.3378] → [2.1815:1957]

# Created by DBIx::Class::Schema::Loader v0.07043 @ 2015-10-27 13:54:16
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:iN9vwO5i3dURKOTgaPTHxw

[6.3378]

[7.4481]

# Created by DBIx::Class::Schema::Loader v0.07043 @ 2016-02-12 17:20:42
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:/8aVtXu/+o0jmKHnSzwt+g

Deletion in src/root/build.tt at line 283 [5.7350]

B:BD[8.57] → [9.7289:7480]

∅:D[9.7480] → [10.10746:10747]

B:BD[10.10746] → [10.10746:10747]

      [% IF build.errormsg && build.buildstatus != 5 %]
        <h2 id="nix-error">Nix error output</h2>
        <pre class="buildlog">[% HTML.escape(build.errormsg) %]</pre>
      [% END %]

Replacement in src/sql/hydra.sql at line 187 [12.1]
B:BD[11.4805] → [11.4805:4847]
```
    --   3 = other failure (see errorMsg)
```
[11.4805]
[13.3108]
```
    --   3 = other failure
```
Deletion in src/sql/hydra.sql at line 195 [12.1]
∅:D[11.4874] → [6.9983:9984]
B:BD[14.2005] → [6.9983:9984]
∅:D[6.9984] → [14.2005:2071]
B:BD[14.2005] → [14.2005:2071]
```
    errorMsg      text, -- error message in case of a Nix failure
```
File addition: upgrade-44.sql (----------)
[15.3004]
```
alter table Builds drop column errorMsg;
```

Remove the errorMsg column from the Builds table

Dependencies

In channels

Change contents

Deletion in src/lib/Hydra/Schema/Builds.pm at line 171 [5.5202]

Deletion in src/lib/Hydra/Schema/Builds.pm at line 247 [5.5202]

Replacement in src/lib/Hydra/Schema/Builds.pm at line 540 [5.5202]

Deletion in src/root/build.tt at line 283 [5.7350]

Replacement in src/sql/hydra.sql at line 187 [12.1]

Deletion in src/sql/hydra.sql at line 195 [12.1]

File addition: upgrade-44.sql (----------)