Closed Bug 905346 Opened 9 years ago Closed 9 years ago

Fix "without timezone" constraints on partitions

Categories

(Socorro :: Database, task)

x86_64
Linux
task
Not set
normal

Tracking

(Not tracked)

RESOLVED FIXED

People

(Reporter: selenamarie, Assigned: selenamarie)

References

Details

(Whiteboard: [DB Changes] [qa-])

We've got a bunch of partitions that have specified "timestamp without timezone" causing queries to be unusually slow (scanning too many partitions). 

Need to determine a plan for fixing this - either by recreating the partitions, or probably by adding a new constraint and dropping the old, incorrect one.

Also need to revise the partition code to include the correct timezone clause.
Will do some work on this today. Had a thread about wonky queries last week.
Commits pushed to master at https://github.com/mozilla/socorro

https://github.com/mozilla/socorro/commit/910fd2584861b76837a246360187aa262994846f
Fixes Bug 905346: make timezone constraints correct for partitions
* Migration for fixing timezones for partition creation in two functions
* Includes migration for fixing old, bad constraints back to 2012

https://github.com/mozilla/socorro/commit/3ef253378157499bbec7f079a3cf937b03501ae5
Merge pull request #1467 from selenamarie/bug905346-fix-timezone-constraints

Bug905346 fix timezone constraints
Status: NEW → RESOLVED
Closed: 9 years ago
Resolution: --- → FIXED
Blocks: 912527
Failing on release build.
Status: RESOLVED → REOPENED
Resolution: FIXED → ---
Whiteboard: [DB Changes] [qa-]
Commits pushed to master at https://github.com/mozilla/socorro

https://github.com/mozilla/socorro/commit/b06d96d6e452e465c190bf2246380cea8f67e823
Fixes Bug 905346: fix cut/paste errors in query

https://github.com/mozilla/socorro/commit/446b29a5f6ea3df5bec9d01b3b0bbe39b2f5ad9f
Merge pull request #1469 from selenamarie/bug905346-fix-timezone-constraints

Fixes Bug 905346: fix cut/paste errors in query
Status: REOPENED → RESOLVED
Closed: 9 years ago9 years ago
Resolution: --- → FIXED
Ran on prod! Need to still find a time to do August and September, but future partitions will be correct! Yay.
You need to log in before you can comment on or make changes to this bug.