grahamc/hydra2 - Change S6OISBQ3HPFHAAQ5ENG7N3MNGOPNEJPIFKSSA5N4G6KJQTQBSSLQC

* Mark the "current" builds in a jobset, i.e. those corresponding to

the derivations that the jobset currently contains. This is necessary to allow the "latest" channel to contain the correct builds when the sources of a jobset are reverted.

Created by Eelco Dolstra on October 2, 2009

S6OISBQ3HPFHAAQ5ENG7N3MNGOPNEJPIFKSSA5N4G6KJQTQBSSLQC

Dependencies

In channels

main

Change contents

Replacement in src/lib/Hydra/Controller/Job.pm at line 29 [8.46]

B:BD[2.1145] → [2.1145:1251]

    $c->stash->{systems} = [$c->stash->{job}->builds->search({}, {select => ["system"], distinct => 1})];

[2.1145]

[8.544]

    $c->stash->{systems} = [$c->stash->{job}->builds->search({iscurrent => 1}, {select => ["system"], distinct => 1})];

Replacement in src/lib/Hydra/Schema/BuildInputs.pm at line 106 [10.1]

B:BD[9.25] → [5.2173:2318]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-07-07 14:36:17
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:02BDWXRn4LMcb0LFjHXqjg

[9.25]

[10.781]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-02 15:59:19
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:3l2Qu/wpPEb/xsXoyeRviQ

Replacement in src/lib/Hydra/Schema/BuildProducts.pm at line 94 [11.4268]

B:BD[11.4922] → [5.3522:3667]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-07-07 14:36:17
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Fqzw8pcHMrUjdJZ/a43D3w

[11.4922]

[11.5064]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-02 15:59:19
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:/AUVD2QjjkeQmFkKEim0Gw

Replacement in src/lib/Hydra/Schema/BuildResultInfo.pm at line 89 [12.1594]

B:BD[12.2382] → [5.4838:4983]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-07-07 14:36:17
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:KjrreyjxFwFTGDzdA9J42w

[12.2382]

[12.2524]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-02 15:59:19
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:L/qLimgzcHeLjsKom3t1XQ

Replacement in src/lib/Hydra/Schema/BuildSchedulingInfo.pm at line 46 [12.3773]

B:BD[12.4473] → [5.5663:5808]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-07-07 14:36:17
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:jgOkt31QNifyPD8Y0rkVBA

[12.4473]

[12.4615]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-02 15:59:19
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:I2cNoG9FOWDlICSy4Ndftw

Replacement in src/lib/Hydra/Schema/BuildSteps.pm at line 94 [13.1675]

B:BD[13.2959] → [5.6999:7144]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-07-07 14:36:17
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:7z14GDq6a8ndBoj3Mx/3TQ

[13.2959]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-02 15:59:19
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:oCn8y9Nsffa6WOnm44lyqQ

Insertion in src/lib/Hydra/Schema/Builds.pm at line 119 [11.5202]

[5.8804]

[11.5911]

  "iscurrent",
  { data_type => "integer", default_value => 0, is_nullable => 1, size => undef },

Replacement in src/lib/Hydra/Schema/Builds.pm at line 166 [11.5202]

B:BD[11.6194] → [5.8903:9048]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-07-07 14:36:17
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:mTc++yn7RST163jLNJkXaw

[11.6194]

[9.62]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-02 15:59:19
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:8r7Yv4O8WF2YU4sOjn0Q8w

Replacement in src/lib/Hydra/Schema/Builds.pm at line 222 [11.5202]

B:BD[6.169] → [6.169:639]

    makeSource('JobStatus' . $name, "select x.id, x.finished, x.timestamp, x.project, x.jobset, x.job, x.nixname, x.description, x.drvpath, x.outpath, x.system, x.longdescription, x.license, x.homepage, x.maintainers, b.id as statusChangeId, b.timestamp as statusChangeTime from (select project, jobset, job, system, max(id) as id from Builds where finished = 1 $constraint group by project, jobset, job, system) as latest natural join Builds x $joinWithStatusChange");

[6.169]

[6.639]

    makeSource('JobStatus' . $name, "select x.id, x.finished, x.timestamp, x.project, x.jobset, x.job, x.nixname, x.description, x.drvpath, x.outpath, x.system, x.longdescription, x.license, x.homepage, x.maintainers, x.isCurrent, b.id as statusChangeId, b.timestamp as statusChangeTime from (select project, jobset, job, system, max(id) as id from Builds where finished = 1 $constraint group by project, jobset, job, system) as latest natural join Builds x $joinWithStatusChange");

Replacement in src/lib/Hydra/Schema/CachedPathInputs.pm at line 50 [14.859]

B:BD[14.1497] → [5.9798:9943]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-07-07 14:36:17
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:sEZCtuR96OmFAZe4ykVTUA

[14.1497]

[14.1639]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-02 15:59:19
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:eLemrXw7iydgI6zhFrghRg

Replacement in src/lib/Hydra/Schema/CachedSubversionInputs.pm at line 43 [14.1780]

B:BD[14.2342] → [5.10363:10508]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-07-07 14:36:17
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ImarwuHMkKrQ2GemxREDig

[14.2342]

[14.2484]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-02 15:59:19
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:f2Xn8X5aO9Gud7LHrc/b2g

Replacement in src/lib/Hydra/Schema/Jobs.pm at line 78 [15.1454]

B:BD[15.2613] → [5.11370:11515]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-07-07 14:36:17
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:OFEAwA4W5q0AF8uZ3JswFQ

[15.2613]

[15.2755]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-02 15:59:19
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:w5CXchrT0/ueNgxnKv6TPg

Replacement in src/lib/Hydra/Schema/JobsetInputAlts.pm at line 72 [16.825]

B:BD[16.1831] → [5.12325:12470]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-07-07 14:36:17
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:kcIcgSux+SzIH7FQs2cnAw

[16.1831]

[16.1973]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-02 15:59:19
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:CQg509K7bBReX30DeMC7ww

Replacement in src/lib/Hydra/Schema/JobsetInputs.pm at line 68 [17.590]

B:BD[17.1681] → [5.12937:13082]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-07-07 14:36:17
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:SkF1SaumgGAQvR9mUbPV+Q

[17.1681]

[17.1823]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-02 15:59:19
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:FzkQQT8t8OET0a0teF3lHA

Replacement in src/lib/Hydra/Schema/Jobsets.pm at line 104 [17.1960]

B:BD[17.2992] → [5.13996:14141]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-07-07 14:36:17
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:lMdNiE6x4qZLK14+jEM7YQ

[17.2992]

[17.3134]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-02 15:59:19
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:eu0jlMKE2aMvQRv4LynlIA

Replacement in src/lib/Hydra/Schema/Projects.pm at line 79 [17.3266]

B:BD[17.3685] → [5.14771:14916]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-07-07 14:36:17
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:lDNoBncP2KhnrfbQIg+Usw

[17.3685]

[17.3827]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-02 15:59:19
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:aBN2ry0QEPIhQu6tlgk7RQ

Replacement in src/lib/Hydra/Schema/ReleaseSetJobs.pm at line 69 [18.5076]

B:BD[18.6070] → [5.15759:15904]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-07-07 14:36:17
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:xaWTZqtzPyMq/xqi0ZFCDg

[18.6070]

[18.6212]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-02 15:59:19
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Mm9VR//LwfM88N54dtmuxg

Replacement in src/lib/Hydra/Schema/ReleaseSets.pm at line 48 [18.6351]

B:BD[18.7142] → [5.16326:16471]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-07-07 14:36:17
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:sYojSdWhlGMAL7Vj/UynBw

[18.7142]

[18.7284]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-02 15:59:19
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:c6FKyR68F1a8wLivK9ztog

Replacement in src/lib/Hydra/Schema/SystemTypes.pm at line 24 [19.1717]

B:BD[19.2105] → [5.16660:16805]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-07-07 14:36:17
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:QYzvQmgXtV3NURhO5j5F4Q

[19.2105]

[19.2247]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-02 15:59:19
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:SYnu+3J84FXFqkSu8jxkPg

Replacement in src/lib/Hydra/Schema/UserRoles.pm at line 31 [20.3263]

B:BD[20.3736] → [5.17039:17184]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-07-07 14:36:17
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:syo00cqS/fp5mJt2jg+YJw

[20.3736]

[20.3878]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-02 15:59:19
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:pRBijh3yc0x4knK6tU4iTw

Replacement in src/lib/Hydra/Schema/Users.pm at line 53 [21.3258]

B:BD[21.3782] → [5.17601:17746]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-07-07 14:36:17
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ZH7GmAkTPdZm7G5aCp746A

[21.3782]

[21.3924]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-02 15:59:19
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:d4m+IH9KxIcgId+XF23txg

Replacement in src/lib/Hydra/Schema.pm at line 11 [11.6376]

B:BD[11.6498] → [5.17747:17892]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-07-07 14:36:17
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:tt53dmgGYiV3yqHvnrSwkg

[11.6498]

[11.6640]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-02 15:59:19
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:uBemU8brohK9UDFJ9KC1iA

Replacement in src/script/hydra_scheduler.pl at line 255 [24.1319]

B:BD[22.756] → [23.0:66]

    my ($project, $jobset, $inputInfo, $nixExprInput, $job) = @_;

[22.756]

[25.805]

    my ($project, $jobset, $inputInfo, $nixExprInput, $job, $currentBuilds) = @_;

Replacement in src/script/hydra_scheduler.pl at line 276 [24.1319]

B:BD[15.5467] → [15.5467:5599]

∅:D[15.5599] → [26.2879:2925]

B:BD[27.9604] → [26.2879:2925]

∅:D[26.2925] → [27.9646:9666]

∅:D[12.12182] → [27.9646:9666]

B:BD[27.9646] → [27.9646:9666]

        # Have we already done this build (in this job)?
        if (scalar($jobInDB->builds->search({outPath => $outPath})) > 0) {
            print "already scheduled/done\n";
            return;

[15.5467]

[27.9666]

        # Have we already done this build (in this job)?  Don't do it
        # again unless it has been garbage-collected.  The latest
        # builds for each platforms are GC roots, so they shouldn't be
        # GCed.  However, if a job has reverted to a previous state,
        # it's possible that a GCed build becomes current again.  In
        # that case we have to rebuild it to ensure that it appears in
        # channels etc.
        my @previousBuilds = $jobInDB->builds->search({outPath => $outPath}, {order_by => "id"});
        if (scalar(@previousBuilds) > 0) {
            foreach my $build (@previousBuilds) {
                if (!$build->finished) {
                    print "already scheduled as build ", $build->id, "\n";
                    $currentBuilds->{$build->id} = 1;
                    return;
                }
            }
            if (isValidPath($outPath)) {
                print "already done as build ", $previousBuilds[0]->id, "\n";
                # Mark the previous build as "current" so that it will
                # appear in the "latest" channel for this
                # project/jobset/job.
                $previousBuilds[0]->update({iscurrent => 1});
                $currentBuilds->{$previousBuilds[0]->id} = 1;
                return;
            }
            print "already done as build ", $previousBuilds[0]->id,
                "; rebuilding because it was garbage-collected\n";

Deletion in src/script/hydra_scheduler.pl at line 306 [24.1319]
∅:D[15.5627] → [26.2926:2961]
B:BD[27.9677] → [26.2926:2961]
∅:D[26.2961] → [27.9950:9959]
∅:D[12.12224] → [27.9950:9959]
B:BD[27.9950] → [27.9950:9959]
```
        print "adding to queue\n";
        
```
Insertion in src/script/hydra_scheduler.pl at line 318 [24.1319]
[27.10425]
[27.10425]
```
            , iscurrent => 1
```

Insertion in src/script/hydra_scheduler.pl at line 321 [24.1319]

[27.10442]

[5.17990]

        print "added to queue as build ", $build->id, "\n";
        
        $currentBuilds->{$build->id} = 1;

Insertion in src/script/hydra_scheduler.pl at line 432 [24.1319]
[22.2866]
[4.234]
```
    my %currentBuilds;
```

Replacement in src/script/hydra_scheduler.pl at line 436 [24.1319]

B:BD[22.2965] → [23.689:759]

        checkJob($project, $jobset, $inputInfo, $nixExprInput, $job);

[22.2965]

[16.7080]

        checkJob($project, $jobset, $inputInfo, $nixExprInput, $job, \%currentBuilds);

Deletion in src/script/hydra_scheduler.pl at line 439 [24.1319]

B:BD[15.5888] → [15.5888:6141]

    # Mark all existing jobs that we haven't seen as inactive.
    my %jobNames;
    $jobNames{$_->{jobName}}++ foreach @{$jobs->{job}};
    
    my %failedJobNames;
    push @{$failedJobNames{$_->{location}}}, $_->{msg} foreach @{$jobs->{error}};

Insertion in src/script/hydra_scheduler.pl at line 440 [24.1319]

[3.1623]

[28.1981]

        
        # Mark all existing jobs that we haven't seen as inactive.
        my %jobNames;
        $jobNames{$_->{jobName}}++ foreach @{$jobs->{job}};
    
        my %failedJobNames;
        push @{$failedJobNames{$_->{location}}}, $_->{msg} foreach @{$jobs->{error}};

Replacement in src/script/hydra_scheduler.pl at line 459 [24.1319]

B:BD[15.6613] → [15.6613:6621]

});

[15.6613]

[15.6621]


        # Clear the "current" flag on all builds that are no longer
        # current.
        foreach my $build ($jobset->builds->search({iscurrent => 1})) {
            print "current is ", $build->id, "\n";
            $build->update({iscurrent => 0}) unless $currentBuilds{$build->id};
        }

Insertion in src/script/hydra_scheduler.pl at line 467 [24.1319]
[15.6630]
[29.689]
```
    });
       
```
Insertion in src/sql/hydra.sql at line 29 [24.1]
[5.18121]
[12.9173]
```
    isCurrent     integer default 0,
```

Replacement in src/sql/hydra.sql at line 414 [24.1]

B:BD[30.3104] → [7.0:107]


create index indexbuild on buildproducts(build)
create index indexbuildtype on buildproducts(build, type)

[30.3104]

create index IndexBuild on BuildProducts(build);
create index IndexBuildType on BuildProducts(build, type);