478308 - Provide raw data for Firefox 3.0.4 and 3.0.5 MTBF reports

Status: RESOLVED FIXED

(mozilla.org Graveyard :: Server Operations, task)

Description

[Samuel Sidler (old account; do not CC)]

Even before bug 478305 is fixed, we'd like to manipulate the MTBF data a bit. Please provide the data points for both Firefox 3.0.4 and 3.0.5.

Austin: Can you work up the sql for this?

Comment 1

[Austin King [:ozten]]

SELECT '3.0.4' AS version, * FROM mtbffacts WHERE productdims_id = (
  SELECT id FROM productdims 
  WHERE product = 'Firefox'
  AND   version = '3.0.4'
  AND   os_name = 'ALL'
)
ORDER BY day ASC;

SELECT '3.0.5' AS version, * FROM mtbffacts WHERE productdims_id = (
  SELECT id FROM productdims 
  WHERE product = 'Firefox'
  AND   version = '3.0.5'
  AND   os_name = 'ALL'
)
ORDER BY day ASC;

Comment 2

[chris hofmann]

3.0.6 please.

Comment 3

[chris hofmann]

er, 3.0.6 too please.

Comment 4

[Austin King [:ozten]]

Added dependency on 478302. Here is additional SQL for 3.0.6.

SELECT '3.0.6' AS version, * FROM mtbffacts WHERE productdims_id = (
  SELECT id FROM productdims 
  WHERE product = 'Firefox'
  AND   version = '3.0.6'
  AND   os_name = 'ALL'
)
ORDER BY day ASC;

Comment 5

[chizu]

Attachment: mtbf query output

Comment 6

[Daniel Veditz [:dveditz]]

Odd data...

Did 3.0.5 get tons crashier? 3.0.4 was showing 60-70K reports a day, 3.0.5 and 3.0.6 are more like 100K a day. I guess there was a Major Update in there, but it didn't increase our FF3 user base by that percentage.

What's up with the 3.0.6 "0 unique users" reporting hundreds of thousands of crashes?

Comment 7

[Samuel Sidler (old account; do not CC)]

Dan, you can now grab the CSV on the MTBF reports on crash-stats.

We *did* get that many more reported crashes, but our MTBF went up 3.0.5. For 3.0.6, we no longer can count unique users because we turned of the GUID...