Closed Bug 525957 Opened 13 years ago Closed 13 years ago

Add entries for firefox 3.5.5 to socorro

Categories

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

All
Other
task

Tracking

(Not tracked)

RESOLVED FIXED

People

(Reporter: catlee, Assigned: aravind)

References

Details

insert into productdims (product, version, branch, release) values ('Firefox','3.5.5', '1.9.1', 'major');
insert into productdims (product, version, branch, release) values ('Firefox','3.5.6pre', '1.9.1', 'development');
Blocks: 525814
Severity: minor → major
Assignee: server-ops → aravind
Need morgamic to approve any/all prod sql.
Severity: major → critical
Priority: -- → P1
They are missing the product visibility table -- can you guys add the SQL for that?
It would be better if they provide the start and end dates that define the time window when materialized views should be collected. Or I could guess...
Start date is today.  We don't have an end date yet.
In addition to the sql in the initial bug, do this, per the information at http://code.google.com/p/socorro/wiki/TrackNewProductVersion. I am assuming that 90 days is correct. Alterations can be made later, if needed

INSERT INTO product_visibility (productdims_id,start_date,end_date) 
     SELECT id, '2009-11-05' as start_date, '2010-02-03' as end_date 
     FROM productdims 
     WHERE product = 'Firefox' AND version = '3.5.5';

INSERT INTO product_visibility (productdims_id,start_date,end_date) 
     SELECT id, '2009-11-05' as start_date, '2010-02-03' as end_date 
     FROM productdims 
     WHERE product = 'Firefox' AND version = '3.5.6pre';
Looks good.  Thanks, Frank.
Anything holding this bug up ?
Nope, IT just needs to run it.
All done.
Status: NEW → RESOLVED
Closed: 13 years ago
Resolution: --- → FIXED
Product: mozilla.org → mozilla.org Graveyard
You need to log in before you can comment on or make changes to this bug.