Socorro - remove references to deprecated 'topcrashurlfactsreports' table

RESOLVED FIXED in 2.3

Status

RESOLVED FIXED
8 years ago
7 years ago

People

(Reporter: lars, Assigned: jberkus)

Tracking

x86_64
Linux

Firefox Tracking Flags

(Not tracked)

Details

(Whiteboard: [qa-])

(Reporter)

Description

8 years ago
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.
(Reporter)

Comment 1

8 years ago
http://mozilla.privatepaste.com/baf66c8cd0

(10:36:20 AM) jberkus: and that one seq scan is from when I did a pg_dump
(Assignee)

Comment 2

7 years ago
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
(Assignee)

Comment 3

7 years ago
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
(Assignee)

Updated

7 years ago
Whiteboard: [2.2.6]
(Assignee)

Updated

7 years ago
Depends on: 690891

Updated

7 years ago
Target Milestone: 2.3 → 2.4
(Assignee)

Comment 4

7 years ago
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
Last Resolved: 7 years ago
Resolution: --- → FIXED
Component: Socorro → General
Product: Webtools → Socorro

Updated

7 years ago
Whiteboard: [2.2.6] → [qa-]
(Assignee)

Updated

7 years ago
Target Milestone: 2.4 → 2.3
You need to log in before you can comment on or make changes to this bug.