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

Status: VERIFIED FIXED

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

Description

[hwine]

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

Comment 1

[Sheeri Cabral [:sheeri]]

Didn't we give y'all access to do these inserts?

Comment 2

[Justin Wood (:Callek)]

(In reply to Sheeri Cabral [:sheeri] from comment #1)
> Didn't we give y'all access to do these inserts?

Partially - yes, but we can't insert branches.

And since you (IT) need to do that insert, while you were there IT handled the other inserts this past weekend for b2g v1.0.0 needs.

Comment 3

[Sheeri Cabral [:sheeri]]

No worries :D we *can* handle them but we were giving access so y'all didn't have to wait. Will do these now.

Comment 4

[Sheeri Cabral [:sheeri]]

Done on dev and stage.

There doesn't seem to be *confidential* information in branches. Do you want the power to insert into branches too? (I'm OK with that, unless inserting can make things go wonky if someone does the wrong thing)

Comment 5

[hwine]

Thanks! We don't (usually) add branches as often as machines, so that's why the table may have been missed. (b2g is redefining our sense of "usually")

It sure makes sense to me for us to have access to both tables.

Comment 6

[Justin Wood (:Callek)]

(In reply to Hal Wine [:hwine] from comment #5)
> Thanks! We don't (usually) add branches as often as machines, so that's why
> the table may have been missed. (b2g is redefining our sense of "usually")
> 
> It sure makes sense to me for us to have access to both tables.

I'd agree, its a power we *shouldn't* normally need, but it is a power we sometimes need (and more so than in the past lately)

The destructive potential of adding branches as well is very very low, so having releng have that access will simplify this process for all of us into the future. -- Thanks

Shall we do that here, or want a spinoff bug?

Comment 7

[Sheeri Cabral [:sheeri]]

Added INSERT and SELECT privileges on "branches" in production and stage.

Comment 8

[hwine]

Thanks, Sheeri!