Closed Bug 905346 Opened 11 years ago Closed 11 years ago

Fix "without timezone" constraints on partitions

Categories

(Socorro :: Database, task)

Product:
Socorro
Component:
Database
Platform:
x86_64
Linux
Type:
task
Priority:
Not set
Severity:
normal

Tracking

(Not tracked)

Status:
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: 11 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: 11 years ago → 11 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.