Author: eelco Date: Mon Nov 22 12:46:40 2010 New Revision: 24808 URL: https://svn.nixos.org/websvn/nix/?rev=24808&sc=1
Log: Modified: hydra/branches/gc/doc/dev-notes.txt Modified: hydra/branches/gc/doc/dev-notes.txt ============================================================================== --- hydra/branches/gc/doc/dev-notes.txt Mon Nov 22 12:45:59 2010 (r24807) +++ hydra/branches/gc/doc/dev-notes.txt Mon Nov 22 12:46:40 2010 (r24808) @@ -128,10 +128,10 @@ Or with Postgres: - (restarting all aborted builds with ID > 42000) - $ psql -h buildfarm.st.ewi.tudelft.nl -U hydra hydra -t -c 'select x.id from builds x join buildresultinfo r on r.id = x.id where finished = 1 and buildstatus = 3 and x.id > 42000' > ids + (restarting all aborted builds with ID > 750000) + $ psql -A -F ' ' -h webdsl.org hydra -t -c 'select x.id, x.drvpath from builds x join buildresultinfo r on r.id = x.id where finished = 1 and buildstatus = 3 and x.id > 750000' > ids - $ for i in $(cat ids); do echo $i; PGPASSWORD=... psql -h buildfarm.st.ewi.tudelft.nl -U hydra hydra -t -c "begin transaction; insert into buildschedulinginfo (id, priority, busy, locker) values($i, 100, 0, ''); delete from buildresultinfo where id = $i; update builds set finished = 0 where id = $i; commit transaction;"; done + $ while read id drvPath; do echo $id; [ -e $drvPath ] && psql -h webdsl.org hydra -t -c "begin transaction; insert into buildschedulinginfo (id, priority, busy, locker) values($id, 100, 0, ''); delete from buildresultinfo where id = $id; update builds set finished = 0 where id = $id; commit transaction;"; done < ids * select * from (select project, jobset, job, system, max(timestamp) timestamp from builds where finished = 1 group by project, jobset, job, system) x join builds y on x.timestamp = y.timestamp and x.project = y.project and x.jobset = y.jobset and x.job = y.job and x.system = y.system; _______________________________________________ nix-commits mailing list [email protected] http://mail.cs.uu.nl/mailman/listinfo/nix-commits
