767046 - Data request: Flash topcrash by version/OS

Status: RESOLVED FIXED

(Socorro :: Data request, task)

Description

[Benjamin Smedberg]

Alex would like to know: "It would be great to understand whether all (or a very large majority) of 11.3 plugin crashes on Vista/Win7 are happening in the F1398665248 signature."

I think the best way to accomplish this is a pseudo topcrash report of the following sort:

* For the past 5 days
* Take all crashes of type "plugin" where the filename is "NPSWF32_11_3_300_257.dll" (or maybe where the Flash version is 11.3.300.257, I don't know which of those would be more accurate)
* divide them into two groups, Windows XP and >Windows XP
* For each group, group by signature and also give the total number of crashes

Comment 1

[Benjamin Smedberg]

Oh and this is statistical only, so I only need counts per group/signature, not individual report IDs.

Comment 2

[Robert Helmer [:rhelmer]]

Attachment: All winxp crashes with 11.3.300.257 for past 5 days

COPY(SELECT count(*), signature 
FROM reports_clean
JOIN flash_versions USING (flash_version_id)
JOIN signatures USING (signature_id)JOIN os_versions USING (os_version_id)
WHERE process_type = 'plugin'
AND flash_version = '11.3.300.257'
AND os_version_string = 'Windows XP'
AND date_processed > ('2012-06-21'::DATE - INTERVAL '5 days')
GROUP BY signature
ORDER BY count(*) DESC) TO stdout WITH CSV HEADER

Comment 3

[Robert Helmer [:rhelmer]]

Attachment: All win > xp crashes with 11.3.300.257 for past 5 days

COPY(SELECT count(*), signature
FROM reports_clean
JOIN flash_versions USING (flash_version_id)
JOIN signatures USING (signature_id)
JOIN os_versions USING (os_version_id)
WHERE process_type = 'plugin'
AND flash_version = '11.3.300.257'
AND (major_version > 5 OR (major_version = 5 AND minor_version > 1))
AND reports_clean.os_name = 'Windows'
AND date_processed > ('2012-06-21'::DATE - INTERVAL '5 days')
GROUP BY signature
ORDER BY count(*) DESC) TO stdout WITH CSV HEADER

Comment 4

[Benjamin Smedberg]

$ python ./bug767046-parser.py 
Total Crashes: 278397
Total Hangs: 130090
Total F1398665248 Crashes: 265842 (95%)

So basically 95% of all Flash crashes (excluding hangs) on Vista/7 have this signature.