Closed Bug 617057 Opened 14 years ago Closed 14 years ago

Socorro - remove references to deprecated 'topcrashurlfactsreports' table

Categories

(Socorro :: General, task)

x86_64
Linux
task
Not set
normal

Tracking

(Not tracked)

RESOLVED FIXED

People

(Reporter: lars, Assigned: jberkus)

References

Details

(Whiteboard: [qa-])

jberkus noticed in the database logs that the 'topcrashurlfactsreports' table is a write only data sink. The 'topCrashesByUrl' cron job writes to that table, but nothing ever reads the data inserted into it. There should be a little research done to see if we can just eliminate it.
http://mozilla.privatepaste.com/baf66c8cd0 (10:36:20 AM) jberkus: and that one seq scan is from when I did a pg_dump
This was never assgned to anyone, so it never happened. Assigning it and making it live, since we're still getting records in that table.
Assignee: nobody → rhelmer
Target Milestone: --- → 2.3
The cron job has been fixed. I'm now assigning the bug to myself so that I can drop the table and get rid of it.
Assignee: rhelmer → josh
Whiteboard: [2.2.6]
Depends on: 690891
Target Milestone: 2.3 → 2.4
This was committed and run as part of 2.2.6. I don't understand why it's been reopened; that table is gone.
Status: NEW → RESOLVED
Closed: 14 years ago
Resolution: --- → FIXED
Component: Socorro → General
Product: Webtools → Socorro
Whiteboard: [2.2.6] → [qa-]
Target Milestone: 2.4 → 2.3
You need to log in before you can comment on or make changes to this bug.