Show a count of distinct install times per signature

RESOLVED FIXED in 50

Status

P1
normal
RESOLVED FIXED
6 years ago
6 years ago

People

(Reporter: kairo, Assigned: brandon)

Tracking

unspecified

Firefox Tracking Flags

(Not tracked)

Details

(Reporter)

Description

6 years ago
As we (intentionally) don't have identifiers of users/installations in crash reports, we usually take distinct install times as an approximation of how many installations are seeing an issue.

We should expose a count of distinct install times per signature in the UI, one way I can imagine that is to have an additional column in the product/version section of the Signature Summary where we list how many distinct installation time stamps we're seeing for this signature and product version.


Laura, as this is a pretty common request we're getting from release management, can we have this scheduled in a way that we get it rather early after the new UI has been shipped?

Comment 1

6 years ago
We should probably add this to the Signature Summary.
Target Milestone: --- → 40
(Reporter)

Comment 2

6 years ago
FYI, I posted an SQL query of how I extracted that data for one case we had in bug 838603 comment #22 (I needed to use the reports table there as I actually wanted a match against app notes). One-off requests for that data can be done with queries like that until we get this implemented in the proper UI. :)

Updated

6 years ago
Assignee: nobody → bsavage
Priority: -- → P1
Target Milestone: 40 → 43
(Assignee)

Updated

6 years ago
Target Milestone: 43 → 44
(Assignee)

Updated

6 years ago
Target Milestone: 44 → 46
(Reporter)

Comment 3

6 years ago
One thing that might be a bit fiddly here is that this measure isn't fully additive between days, as if the same installation is crashing once every day, you get 1 installation counted if you analyze a 7-day example at once, but 7 if you add up per-day samples of the same data.

See below queries to see how this matters in practice:

breakpad=> SELECT version,COUNT(*) as crashes,COUNT(DISTINCT client_crash_date - install_age  * interval '1 second') as installations FROM reports WHERE product='Firefox' AND signature LIKE 'mozilla::dom::DocumentBinding::CreateInterfaceObjects%' AND utc_day_is(date_processed, '2013-04-28') GROUP BY version;
 version | crashes | installations 
---------+---------+---------------
 21.0    |   18377 |          7460
(1 row)

breakpad=> SELECT version,COUNT(*) as crashes,COUNT(DISTINCT client_crash_date - install_age  * interval '1 second') as installations FROM reports WHERE product='Firefox' AND signature LIKE 'mozilla::dom::DocumentBinding::CreateInterfaceObjects%' AND date_processed BETWEEN '2013-04-24' AND '2013-04-29' GROUP BY version;
 version | crashes | installations 
---------+---------+---------------
 21.0    |   44123 |         12495
(1 row)
(Assignee)

Comment 4

6 years ago
After talking with KaiRo and espressive, we're going to meet to discuss the best way to proceed on displaying useful data for Crashkill. Meeting scheduled for next Tuesday.
Target Milestone: 46 → 47
(Assignee)

Updated

6 years ago
Target Milestone: 47 → 48

Comment 5

6 years ago
Commit pushed to master at https://github.com/mozilla/socorro

https://github.com/mozilla/socorro/commit/7d57ed74b54b1f0739efa3e388222763df0ea119
Merge pull request #1258 from brandonsavage/bugzilla-upgrade

Updating the Bugzilla API from 1.1 to 1.3 in the default configuration. (Fixes Bug 838251)

Updated

6 years ago
Status: NEW → RESOLVED
Last Resolved: 6 years ago
Resolution: --- → FIXED
(Assignee)

Comment 6

6 years ago
Wrong bug mentioned in the commit message. :(
Status: RESOLVED → REOPENED
Resolution: FIXED → ---
(Assignee)

Updated

6 years ago
Target Milestone: 48 → 49

Comment 7

6 years ago
Commits pushed to master at https://github.com/mozilla/socorro

https://github.com/mozilla/socorro/commit/ffd23c8452d6f660169531dc4955380af81ec18b
Adding middleware required for bug 838251.

https://github.com/mozilla/socorro/commit/7ed5d9f68f5f2dc7c8b1abbe413d7b979ece5331
Merge pull request #1267 from brandonsavage/bug838251-middleware

Adding middleware required for bug 838251.

Comment 8

6 years ago
Commits pushed to master at https://github.com/mozilla/socorro-crashstats

https://github.com/mozilla/socorro-crashstats/commit/f0c64c0db13f56e4fad8b5856da9217386d98cef
Fixes Bug 838251 - Adds distinct install per signature to signature summary.

https://github.com/mozilla/socorro-crashstats/commit/0bcb38a7771ebc7c9f181a2f48c4c93a7e2350b0
Merge pull request #353 from brandonsavage/bug838251

Fixes Bug 838251 - Adds distinct install per signature to signature summary

Updated

6 years ago
Status: REOPENED → RESOLVED
Last Resolved: 6 years ago6 years ago
Resolution: --- → FIXED
(Assignee)

Updated

6 years ago
Target Milestone: 49 → 50
You need to log in before you can comment on or make changes to this bug.