1045447 - Cleanup strays in scheduler db (bogus m-i win pgo, Mulet)

Status: RESOLVED FIXED

(Release Engineering :: General, defect, P2)

Description

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

At some point someone must have requested an arbitrary build of  
  Windows XP 32-bit mozilla-inbound pgo-build
which isn't a real thing. When sheriffs force pgo builds they get a pending request for that.

Need to remove the records in the buildrequests table to fix it up:

mysql> delete from buildrequests where buildername = 'Windows XP 32-bit mozilla-inbound pgo-build';
Query OK, 44 rows affected (0.44 sec)

Comment 1

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

# this one was a little over-zealous
mysql> delete from buildrequests where buildername = 'OS X Mulet try build';
Query OK, 456 rows affected (0.45 sec)

# repeat for these with extra complete=0 condition
Rev4 MacOSX Mulet Snow Leopard 10.6 try opt test mochitest-? - 35
Rev4 MacOSX Mulet Snow Leopard 10.6 try opt test mochitest-browser-chrome-% - 27
Rev4 MacOSX Mulet Snow Leopard 10.6 try opt test mochitest-devtools-chrome - 10
Rev4 MacOSX Mulet Snow Leopard 10.6 try opt test mochitest-other - 9
Rev4 MacOSX Mulet Snow Leopard 10.6 try opt test reftest - 10
Rev4 MacOSX Mulet Snow Leopard 10.6 try opt test jsreftest - 8
Rev4 MacOSX Mulet Snow Leopard 10.6 try opt test crashtest - 5
Rev4 MacOSX Mulet Snow Leopard 10.6 try opt test xpcshell - 6
Rev4 MacOSX Mulet Snow Leopard 10.6 try opt test cppunit - 4
Rev4 MacOSX Mulet Snow Leopard 10.6 try opt test jittest - 4
Rev4 MacOSX Mulet Snow Leopard 10.6 try talos% - 12


Assorted misc of unknown origin:
mysql> delete from buildrequests where buildername='Android 2.2 Tegra try opt test mochitest-3' and complete=0;
Query OK, 2 rows affected (0.04 sec)

mysql> delete from buildrequests where buildername='Android 2.2 Armv6 Tegra try opt test plain-reftest-3' and complete=0;
Query OK, 2 rows affected (0.04 sec)

mysql> delete from buildrequests where buildername='b2g_emulator_vm try debug test mochitest-1' and complete=0;
Query OK, 1 row affected (0.02 sec)