add graph server sql definitions for new additional talos test 'tp5_scroll' to graphs.mozilla.org and graphs.allizom.org

RESOLVED FIXED

Status

Data & BI Services Team
DB: MySQL
RESOLVED FIXED
4 years ago
4 years ago

People

(Reporter: jmaher, Assigned: mpressman)

Tracking

Details

(Reporter)

Description

4 years ago
can you please update these two databases ("graphs_mozilla_org_new" and "graphs_stage2_prod") with this sql:
insert into tests values (NULL,"tp5o_scroll_paint","TP5 Scroll",1,1,15);

Comment 1

4 years ago
(In reply to Joel Maher (:jmaher) from comment #0)
> insert into tests values (NULL,"tp5o_scroll_paint","TP5 Scroll",1,1,15);

For the uneducated:

Why tp5o_scroll_paint rather and not tp5o_scroll ?

what are 1,1,15 ?
(Reporter)

Comment 2

4 years ago
tp5o is using mozafterpaint, so tp5o_scroll_paint is what is reported to graph server.

1,1,15 = (is_chrome, is_active, pageset_id)

unfortunately we don't really do much with these values, but I do try to make them realistic :)
(Assignee)

Updated

4 years ago
Assignee: server-ops-database → mpressman
(Assignee)

Comment 3

4 years ago
graphs_stage2_prod insert completed:
mysql> insert into tests values (NULL,"tp5o_scroll_paint","TP5 Scroll",1,1,15);
Query OK, 1 row affected (0.00 sec)
(Assignee)

Comment 4

4 years ago
graphs_mozilla_org_new insert completed:
mysql> insert into tests values (NULL,"tp5o_scroll_paint","TP5 Scroll",1,1,15);
Query OK, 1 row affected (0.00 sec)

Comment 5

4 years ago
(In reply to Joel Maher (:jmaher) from comment #2)
> tp5o is using mozafterpaint, so tp5o_scroll_paint is what is reported to
> graph server.

tp5o maybe uses mozafterpaint, but tp5o_scroll doesn't. mozafterpaint can't even be relevant with tests which report their own measurements, like tp5o_scroll (or tscrollx, or TART) does. It can only be relevant when measuring page load times, which tp5o_scroll doesn't do.


> 1,1,15 = (is_chrome, is_active, pageset_id)
> 
> unfortunately we don't really do much with these values, but I do try to
> make them realistic :)

Realistic is always good :p

So I think I get is_chrome and is_active. is pageset_id just a running number/id of the test/suite?

Though I'm not sure in what sense the word "realistic" is applied to any of those...

Comment 6

4 years ago
Also, both this bug and also bug 1025013 deal only with graph server, I think.

Do we need to also add stuff for datazilla? or does datazilla automatically adds whatever talos sends it, and therefore tp5 scroll will appear automatically?
(Reporter)

Comment 7

4 years ago
datazilla doesn't need hardcoded definitions :)
(Reporter)

Comment 8

4 years ago
ah, and I need to do this without a _paint appended as well:
insert into tests values (NULL,"tp5o_scroll","TP5 Scroll",1,1,15);

mpressman, can you do that for both databases?  Sorry for the double request today :(
Flags: needinfo?(mpressman)
(Assignee)

Comment 9

4 years ago
insert into graphs_stage2_prod completed:
 
mysql> insert into tests values (NULL,"tp5o_scroll","TP5 Scroll",1,1,15);
Query OK, 1 row affected (0.00 sec)

insert into graphs_mozilla_org_new completed:
mysql> insert into tests values (NULL,"tp5o_scroll","TP5 Scroll",1,1,15);
Query OK, 1 row affected (0.00 sec)
Status: NEW → RESOLVED
Last Resolved: 4 years ago
Flags: needinfo?(mpressman)
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.