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)
Data & BI Services Team
DB: MySQL
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 | ||
Updated•13 years ago
|
Assignee: server-ops-database → mpressman
Assignee | ||
Comment 1•13 years ago
|
||
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
Reporter | ||
Comment 2•13 years ago
|
||
Thanks!
Reporter | ||
Comment 3•13 years ago
|
||
did this make it to graphs.mozilla.com as well?
Reporter | ||
Comment 4•13 years ago
|
||
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 → ---
Comment 5•13 years ago
|
||
checking this now.
Comment 6•13 years ago
|
||
mysql> select * from tests where pageset_id=18;
Empty set (0.00 sec)
Looks like it's not there. Will add.
Comment 7•13 years ago
|
||
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.
Reporter | ||
Comment 8•13 years ago
|
||
Thanks! I will verify here shortly if it works.
Reporter | ||
Comment 9•13 years ago
|
||
verified tests on mozilla-central can use tspaint_places*
Status: REOPENED → RESOLVED
Closed: 13 years ago → 13 years ago
Resolution: --- → FIXED
Updated•10 years ago
|
Product: mozilla.org → Data & BI Services Team
You need to log in
before you can comment on or make changes to this bug.
Description
•