Closed Bug 772083 Opened 13 years ago Closed 13 years ago

update graphs.mozilla.com and graphs.allizom.com with updated test definitions

Categories

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

task
Not set
normal

Tracking

(Not tracked)

RESOLVED FIXED

People

(Reporter: jmaher, Assigned: mpressman)

References

Details

Here is the raw sql that I need added. The one thing I am not sure about is the first block where we have 'insert into pagesets'. I suspect the data.sql file was not in parity with the live database. The goal here is to have pageset Kraken be ID 18. Here is the sql: insert into pagesets values (NULL, "TScroll"); insert into pagesets values (NULL, "Dromaeo Suites"); insert into pagesets values (NULL, "A11y"); insert into pagesets values (NULL, "Tp 4 Mobile"); insert into pagesets values (NULL, "Tp v5 April 2010 (100 pages)"); insert into pagesets values (NULL, "SunSpider091"); insert into pagesets values (NULL, "V8_7"); insert into pagesets values (NULL, "Kraken"); insert into tests values (NULL,"tspaint_places_generated_med","Ts Paint, MED Dirty Profile",1,1,NULL); insert into tests values (NULL,"tspaint_places_generated_max","Ts Paint, MAX Dirty Profile",1,1,NULL); insert into tests values (NULL,"sunspider","SunSpider 0.9.1",1,1,16); insert into tests values (NULL,"sunspider_nochrome","SunSpider 0.9.1 NoChrome",0,1,16); insert into tests values (NULL,"v8_7","V8 version 7",1,1,17); insert into tests values (NULL,"v8_7_nochrome","V8 version 7, NoChrome",1,1,17); insert into tests values (NULL,"kraken","Kraken Benchmark",1,1,18); insert into tests values (NULL,"kraken_nochrome","Kraken Benchmark NoChrome",1,1,18);
Assignee: server-ops-database → mpressman
mysql> select * from pagesets where name='Kraken'; +----+--------+ | id | name | +----+--------+ | 18 | Kraken | +----+--------+ 1 row in set (0.00 sec) The first block ^^ sql insert completed for stage.
Status: NEW → RESOLVED
Closed: 13 years ago
Resolution: --- → FIXED
Thanks!
did this make it to graphs.mozilla.com as well?
we get errors in graphs.mozilla.org that tspaint_places_generated_med is not a valid name. Did this get run on that box? insert into tests values (NULL,"tspaint_places_generated_med","Ts Paint, MED Dirty Profile",1,1,NULL);
Status: RESOLVED → REOPENED
Resolution: FIXED → ---
checking this now.
mysql> select * from tests where pageset_id=18; Empty set (0.00 sec) Looks like it's not there. Will add.
It should be there now: mysql> select * from tests where pageset_id=18; +-----+-----------------+---------------------------+-----------+-----------+------------+ | id | name | pretty_name | is_chrome | is_active | pageset_id | +-----+-----------------+---------------------------+-----------+-----------+------------+ | 232 | kraken | Kraken Benchmark | 1 | 1 | 18 | | 233 | kraken_nochrome | Kraken Benchmark NoChrome | 1 | 1 | 18 | +-----+-----------------+---------------------------+-----------+-----------+------------+ 2 rows in set (0.00 sec) I *only* did this on production - can you verify, and if it works for you, please resolve? I apologize for the problems.
Thanks! I will verify here shortly if it works.
verified tests on mozilla-central can use tspaint_places*
Status: REOPENED → RESOLVED
Closed: 13 years ago13 years ago
Resolution: --- → FIXED
Product: mozilla.org → Data & BI Services Team
You need to log in before you can comment on or make changes to this bug.