Closed Bug 976069 Opened 12 years ago Closed 12 years ago

Implement 12 mo expiration for raw crash, processed crash data

Categories

(Socorro :: Database, task)

x86
macOS
task
Not set
normal

Tracking

(Not tracked)

RESOLVED FIXED

People

(Reporter: selenamarie, Assigned: selenamarie)

Details

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

Attachments

(1 file)

This will match what HBase does. Thinking this should be a crontabber job run weekly.
Assignee: nobody → sdeckelmann
Summary: Implement 6mo expiration for raw crash, processed crash data → Implement 12 mo expiration for raw crash, processed crash data
Target Milestone: --- → 79
First pass will just be to fix our functions so that they can run without locking the parent tables. It's remotely possible that a long-running query might result from this running concurrently with other activity on the database. Basically, we might confuse the planner by taking away a table that a plan had wanted to use. However, the automation win seems worth the risk.
Commits pushed to master at https://github.com/mozilla/socorro https://github.com/mozilla/socorro/commit/967793bd1442e3308e47fba1e4e01e8651d36d36 Fixes bug 976069 - add raw and processed crash partitions to cleanup routines https://github.com/mozilla/socorro/commit/489e6a41bf2e40fdc79e5fa5bc9fa8feb99be130 Migration for bug 976069 update functions https://github.com/mozilla/socorro/commit/d46a2a983b5e9fd217de7809209ee99bc82c1fa7 Merge pull request #1963 from selenamarie/bug976069-raw-and-processed-crash-expiry Fixes bug 976069 - add raw and processed crash partitions to cleanup routines
Status: NEW → RESOLVED
Closed: 12 years ago
Resolution: --- → FIXED
Whiteboard: [qa-][DB change]
You need to log in before you can comment on or make changes to this bug.

Attachment

General

Created:
Updated:
Size: