Closed
Bug 681476
Opened 13 years ago
Closed 12 years ago
stop collecting frame data in PG
Categories
(Socorro :: General, task)
Tracking
(Not tracked)
RESOLVED
FIXED
2.4.4
People
(Reporter: jberkus, Assigned: jberkus)
References
Details
(Whiteboard: [qa-])
Despite the fact that we no longer use frame data anywhere in the Socorro UI, we are continuing to accumulate it in PostgreSQL, to the tune of 3GB per week. We should stop this. Steps to correct: 0. Approve getting rid of frames data from Postgres (Laura, Kairo) 1. Modify processors to stop inserting into frames (lars) 2. modify cronjob to stop partitioning frames (rhelmer) 3. Drop frames table (jberkus)
Comment 1•13 years ago
|
||
0: a=laura
Assignee | ||
Updated•13 years ago
|
Assignee: laura → lars
Updated•13 years ago
|
Target Milestone: --- → 2.3.1
Comment 2•13 years ago
|
||
Commit pushed to https://github.com/mozilla/socorro https://github.com/mozilla/socorro/commit/f55cca401613a71c9b72113a6a2f513f2e3b82a5 Merge pull request #77 from twobraids/master Bug 681476 - stopped the processor from writing to the frames table.
Updated•13 years ago
|
Status: NEW → RESOLVED
Closed: 13 years ago
Resolution: --- → FIXED
Assignee | ||
Comment 3•13 years ago
|
||
Above resolution does not make it clear whether the cronjobs have been modified or not. Certainly I have not yet dropped the tables. As such, reopening. Will pick up this bug when rhelmer gets back.
Status: RESOLVED → REOPENED
Resolution: FIXED → ---
Target Milestone: 2.3.1 → 2.4
Comment 4•13 years ago
|
||
Thanks jberkus: looking at the notes from comment 0 we still need to implement. 2. modify cronjob to stop partitioning frames (may be done but haven't verified yet) 3. Drop frames table
Updated•12 years ago
|
Component: Socorro → General
Product: Webtools → Socorro
Updated•12 years ago
|
Target Milestone: 2.4 → 2.4.2
Assignee | ||
Comment 5•12 years ago
|
||
This is waiting on configman, which we will probably get in 2.4.1
Comment 6•12 years ago
|
||
waiting on deployment of Bug 701253 or :lonnen's cron system
Assignee: lars → nobody
Blocks: 701253
Updated•12 years ago
|
Assignee | ||
Comment 7•12 years ago
|
||
Script written for this and checked in.
Assignee | ||
Comment 8•12 years ago
|
||
CHanges deployed to crash-stats-dev.
Status: REOPENED → RESOLVED
Closed: 13 years ago → 12 years ago
Resolution: --- → FIXED
Assignee | ||
Comment 9•12 years ago
|
||
Not testable by QA, since Frames have not been visible for some time.
Whiteboard: [qa-]
Assignee | ||
Comment 10•12 years ago
|
||
Reopening this. Dropping the frames table failed in production due to deadlocks. This needs to be rewritten so that it drops the foreign keys first, then the table.
Status: RESOLVED → REOPENED
Resolution: FIXED → ---
Target Milestone: 2.4.3 → 2.4.4
Comment 11•12 years ago
|
||
Going to do this in prod on 3/1, that's in bug 731698.
Updated•12 years ago
|
Status: REOPENED → RESOLVED
Closed: 12 years ago → 12 years ago
Resolution: --- → FIXED
Assignee | ||
Comment 12•12 years ago
|
||
This was done on 3/1
You need to log in
before you can comment on or make changes to this bug.
Description
•