<mark_weaver>here's the one I used last time: update builds set finished=1, iscachedbuild=0, buildStatus=4, starttime=1442724293, stoptime=1442724293 where finished=0 and busy=0 and jobset='core-updates' and id not in (select build from jobsetevalmembers where eval = 107038);
<mark_weaver>those big numbers are the result of running "date -u +%s" on hydra
<mark_weaver>and of course, you use the appropriate evaluation id
<mark_weaver>some of that is based on looking at the code in hydra's web interface for cancelling jobs, but with modifications.
<mark_weaver>it's in the readline history for 'psql' on hydra. I search for it via "C-r iscached"
<mark_weaver>someone who knows more about postgresql could probably write a better query. my knowledge of postgresql is weak, and my knowledge of relational databases is also quite rusty. suggestions welcome!
<mark_weaver>and of course, the evaluation id is the newest one, the one whose jobs you want to keep.
<umbilical>anyway I couldnt find any solution, and I was stupid on the first place for forgetting to change sdX in the config file, so it didn't automate whatever I'd then have to do. So I'm starting over with a single partition as you suggested, for simplicity and making sure I now changed the sdX to sda