857486 - Still scheduling 'WINNT 6.1 x86-64 mozilla-central pgo-build' but no builder

Status: RESOLVED FIXED

(Release Engineering :: Release Automation: Other, defect, P4)

Description

[Nick Thomas [:nthomas] (UTC+12)]

See https://secure.pub.build.mozilla.org/buildapi/pending for the most recent examples, I culled the earlier ones out assuming they were just left overs. There's no builder to do the job.

Comment 1

[Armen [:armenzg]]

14:17 catlee: self-serve doesn't know what builders are enabled
14:17 catlee: so it looks over the past day? week? of builds to figure out what builds to trigger
14:25 catlee: armenzg: you can wait 2 weeks and then delete all the pending jobs
14:25 catlee: or delete 2 weeks of builds prior to today
which lead me to write this SQL statement:
delete from buildrequests where buildername like 'WINNT 6.1 x86-64%pgo-build' and complete=1 and submitted_at>'1363372336';

Should I execute such command? could there be any consequences?

The date is equivalent to this:
GMT: Fri, 15 Mar 2013 18:32:16 GMT

Comment 2

[Armen [:armenzg]]

I'm leaving towards leaving it as is and remove in two weeks time.

Comment 3

[Nick Thomas [:nthomas] (UTC+12)]

Yes, that's fine. I'll probably kill pending jobs every few days just to keep that tidy.

I wonder if we can have self-serve poll an information service instead of the db for the set of builders for a task. The info service could get data from some kind of script like builder_list.py and a master instance, updated on merges to production.

Comment 4

[Armen [:armenzg]]

No pending jobs left.
Thanks to whoever have been doing the cleanup.