Production Socorro topcrashbyurlfacts table add unique constraint and remove duplicates

RESOLVED FIXED

Status

RESOLVED FIXED
10 years ago
7 years ago

People

(Reporter: ozten, Unassigned)

Tracking

Trunk
x86
Mac OS X

Firefox Tracking Flags

(Not tracked)

Details

(Reporter)

Description

10 years ago
In the last 2 days the topcrashbyurlfacts grew by 35x. The mtbffacts table experience similar exponential growth.

We need to add unique constraint to topcrashbyurlfacts on
day, productdims_id, urldims_id, and signaturedims_id


We need to add unique constraint to mtbffacts on
day, productdims_id

In order to do this we will probably need to cleanup the data first, then add the constraints.
(Reporter)

Comment 1

10 years ago
production has deleted all data for bad days.
delete from mtbffacts where day = '2009-04-11' or day = '2009-04-12' or day = '2009-04-13';
Just a note to remember we need to update schema.py to reflect added unique constraints
(Reporter)

Updated

10 years ago
Assignee: ozten.bugs → nobody
Status: NEW → RESOLVED
Last Resolved: 9 years ago
Resolution: --- → FIXED
Component: Socorro → General
Product: Webtools → Socorro
You need to log in before you can comment on or make changes to this bug.