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)
Tracking
(Not tracked)
RESOLVED
FIXED
72
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.
Assignee | ||
Comment 1•11 years ago
|
||
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
Assignee | ||
Updated•11 years ago
|
Target Milestone: 70 → 72
Assignee | ||
Updated•11 years ago
|
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
Assignee | ||
Comment 3•11 years ago
|
||
Attachment #8355644 -
Flags: review?(mail)
Comment 4•11 years ago
|
||
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
Updated•11 years ago
|
Status: NEW → RESOLVED
Closed: 11 years ago
Resolution: --- → FIXED
Assignee | ||
Updated•11 years ago
|
Whiteboard: [DB Change]
Assignee | ||
Updated•11 years ago
|
Attachment #8355644 -
Flags: review?(mail) → review+
You need to log in
before you can comment on or make changes to this bug.
Description
•