717797 - Please have a Crash report listing by bug numbers (top crashes by bug)

Status: RESOLVED WONTFIX

(Socorro :: Webapp, task)

Description

[Naoki Hirata :nhirata (please use needinfo instead of cc)]

Please have a Top Crash report listing by bug numbers.

looking at the crash signatures, sometimes multiple bugs have the same crash signatures due to skiplist needing to be adjusted.  It would also help to see the reverse end from the bug number listings.

Comment 2

[Benjamin Smedberg]

Going to run some summaries from which we can generate this data.

Comment 3

[Benjamin Smedberg]

Here's what I've got so far: https://crash-analysis.mozilla.com/bsmedberg/20120827/topcrashbybug-aurora.txt

scoobidiver, is this data useful as-is? As it stands since a signature can map to multiple bugs, you can't really rank things #1/#2, but we can still assign percentages-of-total.

Comment 4

[Scoobidiver (away)]

(In reply to Benjamin Smedberg  [:bsmedberg] from comment #3) 
> scoobidiver, is this data useful as-is? As it stands since a signature can
> map to multiple bugs, you can't really rank things #1/#2, but we can still
> assign percentages-of-total.
Here are my first thoughts:
* Bugs with the same signatures and count should be in the same row.
* Give a rank to all bugs except bugs that are already counted higher (e.g. don't rank Bug 779657/Bug 779830).
* Show the percentage of total.
* Limit it to 300 bugs like top crashers.

Comment 5

[Wayne Mery (:wsmwk)]

I like it.

(In reply to Scoobidiver from comment #4)
> (In reply to Benjamin Smedberg  [:bsmedberg] from comment #3) 
> > scoobidiver, is this data useful as-is? As it stands since a signature can
> > map to multiple bugs, you can't really rank things #1/#2, but we can still
> > assign percentages-of-total.
> Here are my first thoughts:
> * Bugs with the same signatures and count should be in the same row.
> * Give a rank to all bugs except bugs that are already counted higher (e.g.
> don't rank Bug 779657/Bug 779830).
> * Show the percentage of total.
> * Limit it to 300 bugs like top crashers.

Comment 6

[Selena Deckelmann :selenamarie :selena]

Something like this might provide the information we're looking for: 

SELECT 
        product_version_id,
        report_count,
        signature_id,
        bug_id,
        sum(report_count) OVER( PARTITION BY signature_id )
from tcbs
        JOIN signatures USING (signature_id)
        JOIN bug_associations USING (signature)
where report_date = '2013-08-31'
group by signature_id, bug_id, report_count, product_version_id
order by sum DESC, product_version_id
;


I'll play around with this and see if I can present the information the way Scoobidiver asked.