Closed Bug 452290 Opened 11 years ago Closed 11 years ago

Dupe date entries for csv export of download stats

Categories

(addons.mozilla.org Graveyard :: Statistics, defect)

defect
Not set

Tracking

(Not tracked)

RESOLVED FIXED

People

(Reporter: rbango, Assigned: morgamic)

References

Details

Attachments

(1 file, 1 obsolete file)

This csv export is showing two 8/19 entries:

https://addons.mozilla.org/en-US/statistics/csv/3590/downloads

Basil has reported that he's seen this same thing on other add-ons
Duplicate of this bug: 455764
Attached patch v1, remove duplicated (obsolete) — Splinter Review
9/15 and 9/16 had multiple duplicate entries caused by an IP switch (see bug 455628).  This run-once script will repair duplicate entries for those days.  If it happens again, we can update the dates array.  I will file another bug for fixing the stats script to make sure it doesn't fail unpredictably in the case where the slave or master are not accessible.
Attachment #339614 - Flags: review?(fligtar)
Assignee: nobody → morgamic
Attachment #339614 - Attachment is obsolete: true
Status: NEW → ASSIGNED
Attachment #339619 - Flags: review?(fligtar)
Attachment #339614 - Flags: review?(fligtar)
OS: Mac OS X → All
Hardware: PC → All
Comment on attachment 339619 [details] [diff] [review]
v2, fixed date in delete query

Looks good. I sorta wish it was easier to run the script for a specific date via the command line or have it check for all duplicate dates, because as this bug mentions, there are other dates besides those 2 that have duplicates.
Attachment #339619 - Flags: review?(fligtar) → review+
r18471
Status: ASSIGNED → RESOLVED
Closed: 11 years ago
Resolution: --- → FIXED
Filed an IT bug to run this in production -- bug 456396.
Product: addons.mozilla.org → addons.mozilla.org Graveyard
You need to log in before you can comment on or make changes to this bug.