my @buildIds;

    txn_do($db, sub {
        my %paths;

    $builds = $builds->search({ finished => 1 });

        $builds = $builds->search({ finished => 1 });

    foreach my $build ($builds->search({}, { columns => ["drvpath"] })) {
        next if !isValidPath($build->drvpath);
        registerRoot $build->drvpath;
    }

        foreach my $build ($builds->all) {
            next if !isValidPath($build->drvpath);
            $paths{$_->path} = 1 foreach $build->buildoutputs->all;
            $paths{$_->path} = 1 foreach $build->buildstepoutputs->all;
            push @buildIds, $build->id;
            registerRoot $build->drvpath;
        }

    my $nrRestarted = 0;

        $db->resultset('Builds')->search({ id => \@buildIds })->update(

    txn_do($db, sub {
        $nrRestarted = $builds->update(

        $db->resultset('JobsetEvals')->search({ build => \@buildIds }, { join => 'buildIds' })->update({ nrsucceeded => undef });

        $db->resultset('JobsetEvals')->search(
            { id => { -in => $builds->search({}, { join => { 'jobsetevalmembers' => 'eval' }, select => "jobsetevalmembers.eval", as => "eval", distinct => 1 })->as_query }
            })->update({ nrsucceeded => undef });

        $db->resultset('FailedPaths')->search({ path => [ keys %paths ]})->delete;

        my $cleared = $db->resultset('FailedPaths')->search(
            { path => { -in => $builds->search({}, { join => "buildoutputs", select => "buildoutputs.path", as => "path", distinct => 1 })->as_query }
            })->delete;
        $cleared += $db->resultset('FailedPaths')->search(
            { path => { -in => $builds->search({}, { join => "buildstepoutputs", select => "buildstepoutputs.path", as => "path", distinct => 1 })->as_query }
            })->delete;
        print STDERR "cleared $cleared failed paths\n";

    return scalar(@buildIds);

    return $nrRestarted;