589607 - Zombie tests building up for WINNT 5.2 opt tests

Status: RESOLVED FIXED

(Release Engineering :: General, defect, P2)

Description

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

Bug 557918 disabled the opt tests on the Win2k3 machines in favor of the minis. The builder masters were reconfig'd but not the scheduler, so we've been accumulating jobs we don't want to run in the db. I've now reconfig'd the scheduler master to prevent more being added but we should clean up the db so that http://build.mozilla.org/builds/pending.html isn't full of bogus information. 

To prevent distorting the waittime metrics I think we'd want to remove those jobs completely. Since there's a non-trivial chance I'll delete something (the whole dB!) accidentally I'm deferring to catlee.

Comment 1

[Chris AtLee [:catlee]]

"select * from buildrequests where buildername like 'WINNT 5.2 % opt %' and complete=0 and claimed_at=0;" finds 1875 rows.

I propose running "update buildrequests set complete=1, results=2, complete_at = unix_timestamp(now()) where buildername like 'WINNT 5.2 % opt %' and complete=0 and claimed_at=0;"

This is basically what cancellator.py does.

Comment 2

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

Sounds fine, only using the time we turned off the tests for complete_at as we discussed.

Comment 3

[Chris AtLee [:catlee]]

The change was pushed at Thu 19 Aug 2010 01:28:25 PM EDT == 1282238905 epoch time.  I'll run the query with that.

update buildrequests set complete=1, results=2, complete_at = 1282238905 where buildername like 'WINNT 5.2 % opt %' and complete=0 and claimed_at=0;
Query OK, 1875 rows affected (0.07 sec)
Rows matched: 1875  Changed: 1875  Warnings: 0