Closed Bug 452290 Opened 11 years ago Closed 11 years ago
Dupe date entries for csv export of download stats
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
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.
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+
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.