Closed Bug 524435 Opened 10 years ago Closed 10 years ago

Add Thunderbird 3.0 and 3.0.1pre to crash-stats.m.c

Categories

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

task
Not set

Tracking

(Not tracked)

RESOLVED FIXED

People

(Reporter: standard8, Assigned: fox2mike)

References

Details

Please add Thunderbird 3.0 and 3.0.1pre to the crash-stats version list. Assuming sql is still the same it should be:

insert into branches(product,version,branch)
values('Thunderbird','3.0','1.9.1');
insert into branches(product,version,branch)
values('Thunderbird','3.0.1pre',1.9.1')
morgamic, ack?
Assignee: server-ops → shyam
Frank or Lars - can you provide the right SQL please?
Eventually, folks will know this URL, and then we will get the admin interface and start over. But for now: 
http://code.google.com/p/socorro/wiki/TrackNewProductVersion

We need more data: The Thunderbird team needs to let us know when to start and stop collecting materialized view summary data.

In this case, the first part of the two-step dance is:

INSERT INTO productdims (product, version, branch, release) 
   VALUES ('Thunderbird','3.0','1.9.1','major');
INSERT INTO productdims (product, version, branch, release) ('Thunderbird','3.0.1pre','1.9.1','development');

We cannot complete the process without the start and stop dates for each version.
(In reply to comment #3)
> Eventually, folks will know this URL, and then we will get the admin interface
> and start over.

That's fine, is there a way to subscribe to updates/changes? I have a semi-automated bug creator that I can just template all the required information into.

Also do you have the bug # for the admin interface?

> In this case, the first part of the two-step dance is:
> 
> INSERT INTO productdims (product, version, branch, release) 
>    VALUES ('Thunderbird','3.0','1.9.1','major');
> INSERT INTO productdims (product, version, branch, release)
> ('Thunderbird','3.0.1pre','1.9.1','development');
> 
> We cannot complete the process without the start and stop dates for each
> version.

So I think you want:

INSERT INTO product_visibility (productdims_id,start_date,end_date) 
     SELECT id, '2009-11-05' as start_date, '2010-01-05' as end_date 
     FROM productdims 
     WHERE product = 'Thunderbird' AND version = '3.0';

INSERT INTO product_visibility (productdims_id,start_date,end_date) 
     SELECT id, '2009-11-05' as start_date, '2010-01-05' as end_date 
     FROM productdims 
     WHERE product = 'Thunderbird' AND version = '3.0.1pre';
Your sql looks right.

track LDAP auth at bug #522349
track 'branch administration' at bug #454620
So the SQL in comment #3 and #4 need to go in?
Yep - gogo!
All done.

breakpad=# INSERT INTO productdims (product, version, branch, release) 
breakpad-#    VALUES ('Thunderbird','3.0','1.9.1','major');
INSERT 0 1
breakpad=# INSERT INTO productdims (product, version, branch, release)
VALUES ('Thunderbird','3.0.1pre','1.9.1','development');
INSERT 0 1
breakpad=# INSERT INTO product_visibility (productdims_id,start_date,end_date) 
breakpad-#      SELECT id, '2009-11-05' as start_date, '2010-01-05' as end_date 
breakpad-#      FROM productdims 
breakpad-#      WHERE product = 'Thunderbird' AND version = '3.0';
INSERT 0 1
breakpad=# 
breakpad=# INSERT INTO product_visibility (productdims_id,start_date,end_date) 
breakpad-#      SELECT id, '2009-11-05' as start_date, '2010-01-05' as end_date 
breakpad-#      FROM productdims 
breakpad-#      WHERE product = 'Thunderbird' AND version = '3.0.1pre';
INSERT 0 1
Status: NEW → RESOLVED
Closed: 10 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.