517952 - Download statistics are zero for 2009-08-31 and 2009-09-01

Status: VERIFIED FIXED

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

Description

[Scott McCammon [:mccammos]]

Supposedly the global_stats maintenance script failed on these two days, and the counts have been 0 ever since. Note that the 0 count days are 1 day off if you go by the timeplot hover values (see bug 514543).

Running the following SQL should rectify the situation and remove the hole from the downloads graph:

REPLACE INTO global_stats (name, count, date) VALUES ('addon_downloads_new', (SELECT IFNULL(SUM(count), 0) FROM download_counts WHERE date = '2009-08-31'), '2009-08-31');

REPLACE INTO global_stats (name, count, date) VALUES ('addon_downloads_new', (SELECT IFNULL(SUM(count), 0) FROM download_counts WHERE date = '2009-09-01'), '2009-09-01');

Comment 1

[Wil Clouser [:clouserw]]

If you create a migration with this in it (just pick a revision and then add a comment that says it has nothing to do with that) it'll get picked up when we push.

Comment 2

[Scott McCammon [:mccammos]]

Attachment: db migration

A fine suggestion by clouserw: here is a db migration that should fill in the holes.

Comment 3

[Scott McCammon [:mccammos]]

Fixed in r52042.

Preview metrics data seems to be outdated, so this probably can't be verified until the 5.1 push to production.

Comment 4

[Stephen Donner [:stephend] Not actively reading bugmail]

Attachment: Post-fix screenshot

Comment 5

[Stephen Donner [:stephend] Not actively reading bugmail]

Verified FIXED on https://addons.mozilla.org/en-US/firefox/statistics/