526256 - Prod Socorro DB execute SQL

Status: RESOLVED FIXED

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

Description

[Austin King [:ozten]]

In order to fix Bug#526250 Can you execute the following query:
SELECT * FROM productdims pd
LEFT OUTER JOIN product_visibility ON product_visibility.productdims_id = pd.id
WHERE pd.product = 'Firefox' AND pd.version = '3.5.4';

Comment 1

[Austin King [:ozten]]

Based on the output, I'll have a follow up query too. Thanks.

Comment 2

[Aravind Gottipati [:aravind]]

breakpad=> SELECT * FROM productdims pd
LEFT OUTER JOIN product_visibility ON product_visibility.productdims_id = pd.id
WHERE pd.product = 'Firefox' AND pd.version = '3.5.4';
 id  | product | version | branch | release | productdims_id | start_date | end_date | ignore 
-----+---------+---------+--------+---------+----------------+------------+----------+--------
 143 | Firefox | 3.5.4   | 1.9.1  | major   |                |            |          | 
(1 row)

Time: 2.966 ms
breakpad=>

Comment 3

[Austin King [:ozten]]

Please execute

INSERT INTO product_visibility (productdims_id, start_date, end_date, ignore) VALUES
(143, '2009-10-27 00:00:00', '2009-12-27 00:00:00', false);

Comment 4

[Shyam Mani [:fox2mike]]

breakpad=# INSERT INTO product_visibility (productdims_id, start_date, end_date, ignore)
breakpad-# VALUES
breakpad-# (143, '2009-10-27 00:00:00', '2009-12-27 00:00:00', false);
INSERT 0 1

Done.

Comment 5

[Aravind Gottipati [:aravind]]

In the future, please do not update prod db without morgamics explicit approval.  This should have been run through staging first anyway.

Comment 6

[Aravind Gottipati [:aravind]]

Please open a diff bug if there is more to be done.

Comment 7

[Austin King [:ozten]]

(In reply to comment #5)
My bad. Sorry.