958198 - Exploitability matview only saves ratings for topcrashes

Status: VERIFIED FIXED

(Socorro Graveyard :: Middleware, defect)

Description

[Benjamin Smedberg]

Currently the exploitability matview only saves ratings for signatures which are in the TCBS table. This defeats part of the point of the exploitability report, which is to find crashes which may not be high volume but may indicate a potential security issue.

I think I can write this patch.

Comment 1

[Benjamin Smedberg]

https://github.com/mozilla/socorro/pull/1777

Comment 2

[Benjamin Smedberg]

Merged.

Comment 3

[[github robot]]

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

https://github.com/mozilla/socorro/commit/d95735967402c14f3c09591f123b49ce980739d5
Fixes bug 958198 - migration for exploitability matview change to process all signatures

Comment 4

[Selena Deckelmann :selenamarie :selena]

Applied the change to the stage DB and change took effect for 1/12 report run.

breakpad=# select count(*) from exploitability_reports where signature_id NOT IN ( select signature_id from tcbs where report_date = '2014-01-11' ) and report_date = '2014-01-11'; 
 count 
-------
     0
(1 row)

breakpad=# select count(*) from exploitability_reports where signature_id NOT IN ( select signature_id from tcbs where report_date = '2014-01-12' ) and report_date = '2014-01-12'; 
 count 
-------
  8578
(1 row)

breakpad=#

Comment 5

[Matt Brandt [:mbrandt]]

Thank you Selena! Bumping to verified per comment 4.