Closed Bug 1036730 Opened 10 years ago Closed 9 years ago

total_for_sig/total_for_os overcounting for module/addons correlations

Categories

(Socorro Graveyard :: Middleware, defect)

Product:
Socorro Graveyard
Component:
Middleware
Type:
defect
Priority:
Not set
Severity:
normal

Tracking

(Not tracked)

Status:
RESOLVED INVALID

People

(Reporter: rhelmer, Assigned: rhelmer)

Details

These reports are generated using json_array_elements:
https://github.com/mozilla/socorro/blob/master/socorro/external/postgresql/raw_sql/procs/update_correlations_module.sql#L53

Which is going to generate a separate row for each addon or module in a crash, which is not 1:1 addon/module:crash (there can be 1..n modules/addons per crash in the report)

This works OK for CPU arch/cores because there's only one per crash.

So, we need to calculate the total_for_sig/total_for_os differently in the SQL query.
We didn't end up using the PG-based correlations.
Status: NEW → RESOLVED
Closed: 9 years ago
Resolution: --- → INVALID
Product: Socorro → Socorro Graveyard
You need to log in before you can comment on or make changes to this bug.