{"header":{"message":"hydra-backfill-ids: create to add jobset_id values to Builds and Jobs","description":"Vacuum every 10 iterations, update 10k at a time.","timestamp":"2020-02-06T02:12:49Z","authors":[{"email":"graham@grahamc.com","name":"Graham Christensen"}]},"hash":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC","authors":[],"deps":{"hashes":[["5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC","hydra-backfill-ids: create to add jobset_id values to Builds and Jobs"],["AA",null],["Y6H7Y3OTXVLF6PJ5BR6WXS7KVS4VMTUKRYVM6FALKMY3DCBYEJSQC","Capture the path to `guile', when available."],["FV2M6MOTAP4BJMEKU5XUDVEACWEJGEIRCCE2MRY3F6SF2SFOE3MQC","hydra: use autoconf/-make"],["D5QIOJGPKQJIYBUCSC3MFJ3TXLPNZ2XMI37GXMFRVRFWWR2VMTFAC","* Move everything up one directory."]],"deps":["Y6H7Y3OTXVLF6PJ5BR6WXS7KVS4VMTUKRYVM6FALKMY3DCBYEJSQC"],"known":[]},"hunks":[{"Edit":{"inode":{"change":4,"pos":2198648},"path":"src/script/Makefile.am","line":6,"atom":{"NewVertex":{"up_context":[{"change":2,"pos":403}],"down_context":[{"change":2,"pos":403}],"flag":"BLOCK","start":0,"end":26,"inode":{"change":4,"pos":2198648}}},"contents":[{"Add":{"text":" hydra-backfill-ids\t\t\t\t\\","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:25"}}]}},{"FileAdd":{"meta":{"basename":"hydra-backfill-ids","metadata":64},"context":[{"change":5,"pos":2543}],"contents":[{"Add":{"text":"#! /usr/bin/env perl","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:49"}},{"Add":{"text":"","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:50"}},{"Add":{"text":"use strict;","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:62"}},{"Add":{"text":"use utf8;","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:72"}},{"Add":{"text":"use Hydra::Model::DB;","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:94"}},{"Add":{"text":"","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:95"}},{"Add":{"text":"STDOUT->autoflush();","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:116"}},{"Add":{"text":"STDERR->autoflush(1);","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:138"}},{"Add":{"text":"binmode STDERR, \":encoding(utf8)\";","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:173"}},{"Add":{"text":"","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:174"}},{"Add":{"text":"my $db = Hydra::Model::DB->new();","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:208"}},{"Add":{"text":"my $vacuum = $db->storage->dbh->prepare(\"VACUUM;\");","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:260"}},{"Add":{"text":"","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:261"}},{"Add":{"text":"my $dryRun = defined $ENV{'HYDRA_DRY_RUN'};","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:305"}},{"Add":{"text":"","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:306"}},{"Add":{"text":"my $batchSize = 10000;","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:329"}},{"Add":{"text":"my $iterationsPerVacuum = 500;","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:360"}},{"Add":{"text":"","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:361"}},{"Add":{"text":"sub backfillJobsJobsetId {","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:388"}},{"Add":{"text":" my ($skipLocked) = @_;","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:415"}},{"Add":{"text":" my $logPrefix;","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:434"}},{"Add":{"text":"","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:435"}},{"Add":{"text":" if ($skipLocked) {","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:458"}},{"Add":{"text":" $logPrefix = \"(pass 1/2)\";","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:493"}},{"Add":{"text":" } else {","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:506"}},{"Add":{"text":" $logPrefix = \"(pass 2/2)\";","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:541"}},{"Add":{"text":" }","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:547"}},{"Add":{"text":"","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:548"}},{"Add":{"text":" print STDERR \"$logPrefix Backfilling Jobs records where jobset_id is NULL...\\n\";","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:633"}},{"Add":{"text":"","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:634"}},{"Add":{"text":" my $totalToGoSth = $db->storage->dbh->prepare(<execute();","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:781"}},{"Add":{"text":" my ($totalToGo) = $totalToGoSth->fetchrow_array;","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:834"}},{"Add":{"text":"","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:835"}},{"Add":{"text":" my $skipLockedStmt = $skipLocked ? \"FOR UPDATE SKIP LOCKED\" : \"\";","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:905"}},{"Add":{"text":" my $update10kJobs = $db->storage->dbh->prepare(<execute($batchSize);","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:1528"}},{"Add":{"text":" print STDERR \"$logPrefix (batch #$iteration; $totalToGo remaining) Jobs.jobset_id: affected $affected rows...\\n\";","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:1650"}},{"Add":{"text":" $totalToGo -= $affected;","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:1683"}},{"Add":{"text":"","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:1684"}},{"Add":{"text":" if ($iteration % $iterationsPerVacuum == 0) {","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:1738"}},{"Add":{"text":" print STDERR \"$logPrefix (batch #$iteration) Vacuuming...\\n\";","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:1812"}},{"Add":{"text":" $vacuum->execute();","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:1844"}},{"Add":{"text":" }","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:1854"}},{"Add":{"text":" } while ($affected > 0);","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:1883"}},{"Add":{"text":"","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:1884"}},{"Add":{"text":"","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:1885"}},{"Add":{"text":" if ($skipLocked) {","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:1908"}},{"Add":{"text":" backfillJobsJobsetId(0);","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:1941"}},{"Add":{"text":" }","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:1947"}},{"Add":{"text":"}","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:1949"}},{"Add":{"text":"","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:1950"}},{"Add":{"text":"","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:1951"}},{"Add":{"text":"sub backfillBuildsJobsetId {","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:1980"}},{"Add":{"text":" my ($skipLocked) = @_;","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:2007"}},{"Add":{"text":" my $logPrefix;","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:2026"}},{"Add":{"text":"","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:2027"}},{"Add":{"text":" if ($skipLocked) {","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:2050"}},{"Add":{"text":" $logPrefix = \"(pass 1/2)\";","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:2085"}},{"Add":{"text":" print STDERR \"$logPrefix Backfilling unlocked Builds records where jobset_id is NULL...\\n\";","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:2185"}},{"Add":{"text":" } else {","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:2198"}},{"Add":{"text":" $logPrefix = \"(pass 2/2)\";","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:2233"}},{"Add":{"text":" print STDERR \"$logPrefix Backfilling all Builds records where jobset_id is NULL...\\n\";","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:2328"}},{"Add":{"text":" }","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:2334"}},{"Add":{"text":"","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:2335"}},{"Add":{"text":" my $skipLockedStmt = $skipLocked ? \"FOR UPDATE SKIP LOCKED\" : \"\";","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:2405"}},{"Add":{"text":" my $update10kBuilds = $db->storage->dbh->prepare(<<\"QUERY\");","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:2470"}},{"Add":{"text":"WITH updateprogress AS (","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:2495"}},{"Add":{"text":" UPDATE builds","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:2511"}},{"Add":{"text":" SET jobset_id = (","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:2531"}},{"Add":{"text":" SELECT jobsets.id","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:2553"}},{"Add":{"text":" FROM jobsets","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:2570"}},{"Add":{"text":" WHERE jobsets.name = builds.jobset","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:2609"}},{"Add":{"text":" AND jobsets.project = builds.project","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:2652"}},{"Add":{"text":" )","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:2656"}},{"Add":{"text":" WHERE builds.id in (","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:2679"}},{"Add":{"text":" SELECT buildprime.id","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:2704"}},{"Add":{"text":" FROM builds buildprime","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:2731"}},{"Add":{"text":" WHERE buildprime.jobset_id IS NULL","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:2770"}},{"Add":{"text":" AND buildprime.id >= ?","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:2799"}},{"Add":{"text":" ORDER BY buildprime.id","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:2826"}},{"Add":{"text":" $skipLockedStmt","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:2846"}},{"Add":{"text":" LIMIT ?","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:2858"}},{"Add":{"text":" )","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:2862"}},{"Add":{"text":" RETURNING id","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:2877"}},{"Add":{"text":")","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:2879"}},{"Add":{"text":"SELECT","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:2886"}},{"Add":{"text":" count(*) AS affected,","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:2910"}},{"Add":{"text":" max(updateprogress.id) AS highest_id","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:2949"}},{"Add":{"text":"FROM updateprogress;","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:2970"}},{"Add":{"text":"","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:2971"}},{"Add":{"text":"QUERY","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:2977"}},{"Add":{"text":"","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:2978"}},{"Add":{"text":" my $lowestNullIdSth = $db->storage->dbh->prepare(<execute();","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:3147"}},{"Add":{"text":" my ($highestId) = $lowestNullIdSth->fetchrow_array;","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:3203"}},{"Add":{"text":"","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:3204"}},{"Add":{"text":" my $totalToGoSth = $db->storage->dbh->prepare(<= ?","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:3328"}},{"Add":{"text":"QUERY","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:3334"}},{"Add":{"text":" $totalToGoSth->execute($highestId);","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:3374"}},{"Add":{"text":" my ($totalToGo) = $totalToGoSth->fetchrow_array;","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:3427"}},{"Add":{"text":"","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:3428"}},{"Add":{"text":" print STDERR \"$logPrefix Total Builds records without a jobset_id: $totalToGo, starting at $highestId\\n\";","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:3538"}},{"Add":{"text":"","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:3539"}},{"Add":{"text":" my $iteration = 0;","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:3562"}},{"Add":{"text":" my $affected;","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:3580"}},{"Add":{"text":" do {","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:3589"}},{"Add":{"text":" my $previousHighId = $highestId;","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:3630"}},{"Add":{"text":" $iteration++;","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:3652"}},{"Add":{"text":" $update10kBuilds->execute($highestId, $batchSize);","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:3711"}},{"Add":{"text":" ($affected, $highestId) = $update10kBuilds->fetchrow_array;","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:3779"}},{"Add":{"text":"","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:3780"}},{"Add":{"text":" print STDERR \"$logPrefix (batch #$iteration; $totalToGo remaining) Builds.jobset_id: affected $affected rows; max ID: $previousHighId -> $highestId\\n\";","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:3940"}},{"Add":{"text":" $totalToGo -= $affected;","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:3973"}},{"Add":{"text":"","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:3974"}},{"Add":{"text":" if ($iteration % $iterationsPerVacuum == 0) {","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:4028"}},{"Add":{"text":" print STDERR \"$logPrefix (batch #$iteration) Vacuuming...\\n\";","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:4102"}},{"Add":{"text":" $vacuum->execute();","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:4134"}},{"Add":{"text":" }","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:4144"}},{"Add":{"text":" } while ($affected > 0);","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:4173"}},{"Add":{"text":"","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:4174"}},{"Add":{"text":" if ($skipLocked) {","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:4197"}},{"Add":{"text":" backfillBuildsJobsetId(0);","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:4232"}},{"Add":{"text":" }","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:4238"}},{"Add":{"text":"}","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:4240"}},{"Add":{"text":"","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:4241"}},{"Add":{"text":"die \"syntax: $0\\n\" unless @ARGV == 0;","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:4279"}},{"Add":{"text":"","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:4280"}},{"Add":{"text":"print STDERR \"Beginning with a VACUUM\\n\";","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:4322"}},{"Add":{"text":"$vacuum->execute();","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:4342"}},{"Add":{"text":"","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:4343"}},{"Add":{"text":"backfillJobsJobsetId(1);","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:4368"}},{"Add":{"text":"backfillBuildsJobsetId(1);","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:4395"}},{"Add":{"text":"","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:4396"}},{"Add":{"text":"print STDERR \"Ending with a VACUUM\\n\";","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:4435"}},{"Add":{"text":"$vacuum->execute();","pos":"5M6YEYUJNC7GT2PIIDSR6LCPOM2TAD6JE6YZQG5PHCMNVCXC36EQC:4455"}}]}}],"owner":"grahamc","repo":"hydra2","token":"NWEod5V5EyBpEO2ACJO9gSIxUl7WchX9vzP9pZ/smuM=","login":null}

…

Dependencies

Change contents

Review