Add entries for firefox 3.5.5 to socorro

RESOLVED FIXED

Status

mozilla.org Graveyard
Server Operations
P1
critical
RESOLVED FIXED
8 years ago
3 years ago

People

(Reporter: catlee, Assigned: aravind)

Tracking

Details

(Reporter)

Description

8 years ago
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');
(Reporter)

Updated

8 years ago
Blocks: 525814
Severity: minor → major
(Assignee)

Updated

8 years ago
Assignee: server-ops → aravind
(Assignee)

Comment 1

8 years ago
Need morgamic to approve any/all prod sql.
(Reporter)

Updated

8 years ago
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.
(Assignee)

Comment 9

8 years ago
All done.
Status: NEW → RESOLVED
Last Resolved: 8 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.