878944 - 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]

+++ This bug was initially created as a clone of Bug #808537 +++

insert into branches values (NULL,"Mozilla-B2g18_v1.1.0hd");
insert into machines values (NULL,6,0,NULL,"Linux_mozilla-b2g18_v1_1_0_hd",1,unix_timestamp());
insert into machines values (NULL,6,0,NULL,"Linux_mozilla-b2g18_v1_1_0_hd_leak_test",1,unix_timestamp());
insert into machines values (NULL,7,0,NULL,"OS_X_10.5.2_mozilla-b2g18_v1_1_0_hd",1,unix_timestamp());
insert into machines values (NULL,7,0,NULL,"OS_X_10.5.2_mozilla-b2g18_v1_1_0_hd_leak_test",1,unix_timestamp());
insert into machines values (NULL,8,0,NULL,"WINNT_5.2_mozilla-b2g18_v1_1_0_hd",1,unix_timestamp());
insert into machines values (NULL,8,0,NULL,"WINNT_5.2_mozilla-b2g18_v1_1_0_hd_leak_test",1,unix_timestamp());
insert into machines values (NULL,19,0,NULL,"WINNT_6.1_mozilla-b2g18_v1_1_0_hd",1,unix_timestamp());
insert into machines values (NULL,19,0,NULL,"WINNT_6.1_mozilla-b2g18_v1_1_0_hd_leak_test",1,unix_timestamp());
insert into machines values (NULL,17,0,NULL,"OS_X_10.6.2_mozilla-b2g18_v1_1_0_hd",1,unix_timestamp());
insert into machines values (NULL,17,0,NULL,"OS_X_10.6.2_mozilla-b2g18_v1_1_0_hd_leak_test",1,unix_timestamp());
insert into machines values (NULL,18,0,NULL,"Linux_x86-64_mozilla-b2g18_v1_1_0_hd",1,unix_timestamp());
insert into machines values (NULL,18,0,NULL,"Linux_x86-64_mozilla-b2g18_v1_1_0_hd_leak_test",1,unix_timestamp());
insert into machines values (NULL,22,0,NULL,"OS_X_10.7_mozilla-b2g18_v1_1_0_hd",1,unix_timestamp());
insert into machines values (NULL,22,0,NULL,"OS_X_10.7_32-bit_mozilla-b2g18_v1_0_1_hd_leak_test",1,unix_timestamp());
insert into machines values (NULL,22,0,NULL,"OS_X_10.7_32-bit_mozilla-b2g18_v1_1_0_hd_leak_test",1,unix_timestamp());
insert into machines values (NULL,22,0,NULL,"OS_X_10.7_64-bit_mozilla-b2g18_v1_1_0_hd_leak_test",1,unix_timestamp());

Comment 1

[Brandon Johnson [:cyborgshadow]]

Completed on both stage and prod. The following tables were inserted into.

stage:
graphs_stage2_prod.machines

prod:
graphs_mozilla_org_new.machines

Thanks!

Comment 2

[hwine]

my bad - I missed on the copy/paste for the branch name. I created the correct branch names (I forgot we had access to add rows to these databases). However, I don't have access to delete. (The rows appear in various web forms, and will cause confusion)

Please delete the row with the underscore in these two database:
 delete from branches where name = "Mozilla-B2g18_v1.1.0hd";

Thanks

Comment 3

[Brandon Johnson [:cyborgshadow]]

Executed on both stage and prod.