917823 - Remove 7-day constraint from rapid beta aggregates and any build-based aggregate for daily reports

Status: RESOLVED FIXED

(Socorro :: Database, task)

Description

[Selena Deckelmann :selenamarie :selena]

After much discussion, the two week constraint on rapid betas is now considered undesirable. 

We're removing this. Should be followed by a fix for bug 916791.

Comment 1

[Selena Deckelmann :selenamarie :selena]

Evaluated the following stored procs: 

socorro/external/postgresql/raw_sql/procs/update_product_versions.sql:  only affects product_versions.sunset_date, currently set to same date as parent

socorro/external/postgresql/raw_sql/procs/update_crashes_by_user.sql: no restriction by date
socorro/external/postgresql/raw_sql/procs/update_crashes_by_user_build.sql: had a 7 day restriction
socorro/external/postgresql/raw_sql/procs/update_home_page_graph.sql: no restriction by date
socorro/external/postgresql/raw_sql/procs/update_home_page_graph_build.sql: had a 7 day restriction
socorro/external/postgresql/raw_sql/procs/update_tcbs_build.sql: had a 7 day restriction
socorro/external/postgresql/raw_sql/procs/update_tcbs.sql: no restriction by date

So, I haven't found the two week restriction yet.

Comment 2

[Laura Thomson :laura]

Probably not landing for 69.

Comment 3

[Selena Deckelmann :selenamarie :selena]

Attachment: https://github.com/mozilla/socorro/pull/1764

Comment 4

[[github robot]]

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

https://github.com/mozilla/socorro/commit/87df77326b6f1e2bd5d51bbb6917a7587aec4aca
Fixes bug 917823 - remove 7 day constraint on builds included in aggregates

https://github.com/mozilla/socorro/commit/95c6cf28226d17a1c63e095982cfcd160a5cecb4
Migration for bug 917823

https://github.com/mozilla/socorro/commit/0068b61351158ff3333556b45e2b903d7d28ce02
Merge pull request #1764 from selenamarie/bug917823-remove-2week-only-rapid-beta

Fixes bug 917823 - remove 7 day constraint on builds included in select matviews