547761 - Preview index seems stale

Status: RESOLVED INVALID

(mozilla.org Graveyard :: Server Operations, task)

Description

[Dave Dash [:davedash, :dd] (assign all bugs to mbrandt)]

There seems to be stale data in Preview.

In sphinx:

SELECT addon_id, weeklydownloads FROM addons WHERE category = 72 GROUP BY addon_id ORDER BY weeklydownloads DESC;

I see that:
| id       | weight | addon_id | weeklydownloads |
| 10654401 |      1 |     5791 |           16012 | 
|  2776201 |      1 |     3456 |           13466 | 
| 31672701 |      1 |     9825 |           12721 | 

the weeklydownloads for 5791 and 9825 do not match what's in the addons_reskin db.

Thus resulting in bugs like the following:

https://bugzilla.mozilla.org/show_bug.cgi?id=547109

The most likely cause is that sphinx's index hasn't been rotated for a while, so I'd like to know when it was last updated.

Comment 1

[Dave Dash [:davedash, :dd] (assign all bugs to mbrandt)]

it was a problem with the conf file, which I just updated.