835017 - please run the following sql on graphs.m.o and graphs.allizom.org

Status: RESOLVED FIXED

(Data & BI Services Team :: DB: MySQL, task)

Description

[hwine]

insert into branches values (NULL,"Mozilla-B2g18_v1_0_0");
insert into machines values (NULL,6,0,NULL,"Linux_mozilla-b2g18_v1_0_0",1,unix_timestamp());
insert into machines values (NULL,6,0,NULL,"Linux_mozilla-b2g18_v1_0_0_leak_test",1,unix_timestamp());
insert into machines values (NULL,8,0,NULL,"WINNT_5.2_mozilla-b2g18_v1_0_0",1,unix_timestamp());
insert into machines values (NULL,8,0,NULL,"WINNT_5.2_mozilla-b2g18_v1_0_0_leak_test",1,unix_timestamp());
insert into machines values (NULL,19,0,NULL,"WINNT_6.1_mozilla-b2g18_v1_0_0",1,unix_timestamp());
insert into machines values (NULL,19,0,NULL,"WINNT_6.1_mozilla-b2g18_v1_0_0_leak_test",1,unix_timestamp());
insert into machines values (NULL,17,0,NULL,"OS_X_10.6.2_mozilla-b2g18_v1_0_0",1,unix_timestamp());
insert into machines values (NULL,17,0,NULL,"OS_X_10.6.2_mozilla-b2g18_v1_0_0_leak_test",1,unix_timestamp());
insert into machines values (NULL,18,0,NULL,"Linux_x86-64_mozilla-b2g18_v1_0_0",1,unix_timestamp());
insert into machines values (NULL,18,0,NULL,"Linux_x86-64_mozilla-b2g18_v1_0_0_leak_test",1,unix_timestamp());
insert into machines values (NULL,22,0,NULL,"OS_X_10.7_mozilla-b2g18_v1_0_0",1,unix_timestamp());
insert into machines values (NULL,22,0,NULL,"OS_X_10.7_32-bit_mozilla-b2g18_v1_0_0_leak_test",1,unix_timestamp());
insert into machines values (NULL,22,0,NULL,"OS_X_10.7_64-bit_mozilla-b2g18_v1_0_0_leak_test",1,unix_timestamp());

Comment 1

[hwine]

NOTE: I believe the entries may have been made for the machines table. (I was reminded we had some access to add to staging and production now, and attempted that.)

However, we don't have access to add branches. So the first insert needs to be done.

Comment 2

[Matt Pressman [:mpressman]]

The inserts into the machines table were indeed already completed on prod, Here is the result for the insert into branches:

mysql> insert into branches values (NULL,"Mozilla-B2g18_v1_0_0");
Query OK, 1 row affected (0.00 sec)

Comment 3

[Matt Pressman [:mpressman]]

prod and stage complete

Comment 4

[Rick Bryce [:rbryce]]

Thanks for jumping in Matt

Comment 5

[Justin Wood (:Callek)]

Confirmed, looks good -- thank you