558444 - update production graphs db (remove snow leopard data)

Status: RESOLVED FIXED

(mozilla.org Graveyard :: Server Operations, task)

Description

[alice nodelman [:alice] [:anode]]

This is a major change, so we should ensure that there is a current back up of the db before this changes is applied.

sql here: https://bug557910.bugzilla.mozilla.org/attachment.cgi?id=438124

from bug 557910.

Comment 1

[alice nodelman [:alice] [:anode]]

Increasing to major as this is blocking other releng work.

Comment 2

[John O'Duinn [:joduinn] (please use "needinfo?" flag)]

raising to blocker, as this is blocking rollout of unittest-on-talos for 10.6. Can this be done today?

Comment 3

[alice nodelman [:alice] [:anode]]

The snow leopard machines are currently disabled and are not sending results -
as such I do not believe that the graph server will have to be down for this to
be applied.

Comment 4

[timellis]

Done!

http://timellis.pastebin.mozilla.org/714468 says:

mysql> create temporary table id_list (id int, foreign key (id) references test_runs(id), foreign key (id) references test_run_values (test_run_id));
Query OK, 0 rows affected (0.00 sec)

mysql>
mysql> insert into id_list select test_runs.id from test_runs, machines where test_runs.machine_id = machines.id and machines.name like '%talos-r3-snow%';
Query OK, 41321 rows affected (3.47 sec)
Records: 41321  Duplicates: 0  Warnings: 0

mysql>
mysql> delete from test_run_values where test_run_values.test_run_id in (select id from id_list);
Query OK, 1179988 rows affected (9 min 59.06 sec)

mysql>
mysql> delete from test_runs where test_runs.id in (select id from id_list);
Query OK, 41321 rows affected (19.86 sec)

mysql>
mysql> drop table id_list;
Query OK, 0 rows affected (0.05 sec)