1238129 - Retire WebappRuntime and WebappRuntimeMobile products from Socorro

Status: VERIFIED FIXED

(Socorro :: General, task)

Description

[Robert Kaiser]

Just like we are retiring Fennec in bug 1189493, we should retire the WebappRuntime and WebappRuntimeMobile products as well as they are being removed (see dependencies) and never had significant crash volume to analyze.

Comment 1

[Peter Bengtsson [:peterbe]]

Attachment: Link to Github pull-request: https://github.com/mozilla/socorro/pull/3153

Comment 2

[[github robot]]

Commits pushed to master at https://github.com/mozilla/socorro

https://github.com/mozilla/socorro/commit/ffd6cf4eaed70fe772f6f760db7f7a313d91b458
fixes bug 1238129 - Retire WebappRuntime and WebappRuntimeMobile products from Socorro

https://github.com/mozilla/socorro/commit/895b3ae901041e246d44384f49a63bf9d3031ffc
Merge pull request #3153 from peterbe/bug-1238129-retire-webappruntime-and-webappruntimemobile-products-from-socorro

fixes bug 1238129 - Retire WebappRuntime and WebappRuntimeMobile prod…

Comment 3

[Matt Brandt [:mbrandt]]

When will we see these changes on prod?

Comment 4

[Peter Bengtsson [:peterbe]]

On prod, there hasn't been a product_versions entry for WebappRuntime or WebappRuntimeMobile since the 25th of Jan, which makes sense, because around then we probably applied the alembic migration.

However, the last sunset date for WebappRuntime and WebappRuntimeMobile is 2016-05-23 and 2016-05-25 respectively. 

The easiest thing right now would be to simply nudge those dates to todays date and sim sala bim it will stop being an option in the drop-downs. 

I'll try to line up with Adrian tomorrow to execute that on stage and prod directly. 

(Leaving it re-opened so we act rather than having to wait till late May)

Comment 5

[Peter Bengtsson [:peterbe]]

Ok. This is what we applied on the stage DB:

breakpad=> select product_name, sunset_date from product_versions where product_name in ('WebappRuntime','WebappRuntimeMobile') and sunset_date > now() order by sunset_date desc;
 product_name  | sunset_date
---------------+-------------
 WebappRuntime | 2016-05-10
 WebappRuntime | 2016-04-27
 WebappRuntime | 2016-04-25
 WebappRuntime | 2016-04-20
(4 rows)

breakpad=> begin;
BEGIN
breakpad=> update product_versions set sunset_date = now() - interval '1 day' where product_name in ('WebappRuntime','WebappRuntimeMobile') and sunset_date > now();
UPDATE 4
breakpad=> select product_name, sunset_date from product_versions where product_name in ('WebappRuntime','WebappRuntimeMobile') and sunset_date > now() order by sunset_date desc;
 product_name | sunset_date
--------------+-------------
(0 rows)

breakpad=> select product_name, sunset_date from product_versions where product_name in ('WebappRuntime','WebappRuntimeMobile') and sunset_date > now() order by sunset_date desc;
 product_name | sunset_date
--------------+-------------
(0 rows)

breakpad=> commit;
COMMIT

Comment 6

[Peter Bengtsson [:peterbe]]

This has been run on prod PG too now::


breakpad=> select product_name, sunset_date from product_versions where product_name in ('WebappRuntime','WebappRuntimeMobile') and sunset_date > now() order by sunset_date desc;
    product_name     | sunset_date
---------------------+-------------
 WebappRuntimeMobile | 2016-05-25
 WebappRuntime       | 2016-05-23
 WebappRuntime       | 2016-05-09
 WebappRuntime       | 2016-04-27
 WebappRuntime       | 2016-04-25
 WebappRuntime       | 2016-04-20
 WebappRuntimeMobile | 2016-04-14
 WebappRuntime       | 2016-04-12
 WebappRuntime       | 2016-03-28
 WebappRuntime       | 2016-03-28
(10 rows)

breakpad=> begin;
BEGIN
breakpad=> update product_versions set sunset_date = now() - interval '1 day' where product_name in ('WebappRuntime','WebappRuntimeMobile') and sunset_date > now();
UPDATE 10
breakpad=> select product_name, sunset_date from product_versions where product_name in ('WebappRuntime','WebappRuntimeMobile') and sunset_date > now() order by sunset_date desc;
 product_name | sunset_date
--------------+-------------
(0 rows)

breakpad=> commit;
COMMIT

Comment 7

[Peter Bengtsson [:peterbe]]

It is now gone from prod too.

Comment 8

[Matt Brandt [:mbrandt]]

Peterbe, nice. Stage and prod have updated. Stephend updated the product lists(s) that our e2e tests key off of, test are passing.

Bumping this to verified