1308891 - Rewrite Build Graph using SuperSearch

Status: RESOLVED INVALID

(Socorro :: Webapp, task)

Description

[Marco Castelluccio [:marco]]

The graph is never generated for 'Beta' (and I think 'Release' as well).
The 'Beta' result is always 'No results were found.'.

E.g. https://crash-stats.mozilla.com/signature/?product=Firefox&signature=std%3A%3Alist%3CT%3E%3A%3Aclear%20|%20CDeviceChild%3CT%3E%3A%3A~CDeviceChild%3CT%3E#graph

Comment 1

[Peter Bengtsson [:peterbe]]

Attachment: Screen Shot 2016-10-10 at 10.54.03 AM.png

I get a JavaScript error just opening that tab.

Comment 2

[Peter Bengtsson [:peterbe]]

But unrelated to the JavaScript errors, 
https://crash-stats.mozilla.com/signature/graphdata/beta/?product=Firefox&signature=std%3A%3Alist%3CT%3E%3A%3Aclear%20%7C%20CDeviceChild%3CT%3E%3A%3A~CDeviceChild%3CT%3E&date=%3E%3D2016-10-03T14%3A52%3A00.000Z&date=%3C2016-10-10T14%3A52%3A00.000Z 
yields 0 results.

Comment 3

[Peter Bengtsson [:peterbe]]

Attachment: Screen Shot 2016-10-10 at 10.55.54 AM.png

Clearly there are crashes under those release channels (see right-most column)

Comment 4

[Peter Bengtsson [:peterbe]]

Adrian,

There's no python error or anything. There simply is no records of 'beta' in crash_adu_by_build_signature. 
Here's for stage:

breakpad=> SELECT
breakpad->     channel,
breakpad->     count(channel) as count
breakpad-> FROM crash_adu_by_build_signature
breakpad-> WHERE adu_date BETWEEN '2016-08-04' AND '2016-10-09'
breakpad-> AND product_name = 'Firefox'
breakpad-> -- AND channel = 'beta'
breakpad-> AND signature = 'std::list<T>::clear | CDeviceChild<T>::~CDeviceChild<T>'
breakpad-> group by channel
breakpad-> ORDER BY count
breakpad-> ;
 channel | count
---------+-------
 aurora  |   132
 nightly |   148
(2 rows)


For that signature, there's plenty of crashes on beta. Just nothing in the ADU<->Signature mapping. See attached screenshot.

Comment 5

[Peter Bengtsson [:peterbe]]

Attachment: Screen Shot 2016-10-10 at 3.56.27 PM.png

Note the "Release channel" aggregate.

Comment 6

[Peter Bengtsson [:peterbe]]

In fact, the are no rows in crash_adu_by_build_signature where channel='beta' and signature<>''.
Sounds like a bug in how that stored procedure produces the data. Sigh.

Comment 7

[[DEACTIVATED] Adrian Gaudebert]

To be honest, I'm actually surprised someone is using that graph... :) I believe we will want to rewrite it anyway, since it's using Postgres as a crash data source. Ideally it should use SuperSearch for crash data and marry that with ADI data from postgres.

Comment 8

[Peter Bengtsson [:peterbe]]

We removed the Build Graph tab in https://bugzilla.mozilla.org/show_bug.cgi?id=1375431