Closed Bug 917823 Opened 11 years ago Closed 11 years ago

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

Categories

(Socorro :: Database, task)

x86_64
Linux
task
Not set
normal

Tracking

(Not tracked)

RESOLVED FIXED

People

(Reporter: selenamarie, Assigned: selenamarie)

Details

(Whiteboard: [DB Change])

Attachments

(1 file)

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.
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.
Target Milestone: --- → 69
Probably not landing for 69.
Target Milestone: 69 → 70
Target Milestone: 70 → 72
Summary: Remove 2-week constraint from rapid beta aggregates → Remove 7-day constraint from rapid beta aggregates and any build-based aggregate for daily reports
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
Status: NEW → RESOLVED
Closed: 11 years ago
Resolution: --- → FIXED
Whiteboard: [DB Change]
Attachment #8355644 - Flags: review?(mail) → review+
You need to log in before you can comment on or make changes to this bug.

Attachment

General

Created:
Updated:
Size: