457954 - Searches on preview are failing

Status: VERIFIED FIXED

(addons.mozilla.org Graveyard :: Public Pages, defect)

Description

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

Searches for "AdBlock" on https://preview.addons.mozilla.org/en-US/firefox/search?q=adblock&cat=all aren't finding "AdBlock" or "AdBlock Plus" -- both of which should exist.

For that matter, it doesn't appear that searches are returning any results at all...

Comment 1

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

xb95: could you take a gander?

Comment 2

[Mark Smith [:xb95]]

mysql> select id, locale, status, name, summary from text_search_summary;
Empty set (0.00 sec)

I'm not sure how this table gets populated, but it's totally empty right now.  I.e., there's no data to search on.

Comment 3

[Fred Wenzel [:wenzel]]

Like so many other things on AMO, it's a "cronjobbed" maintenance task: $AMO/bin/update-search-views.php -- if that's not run, either the actual data and the search view diverge, or the search view is never even published in the first place.

Do you want to copy that cron job from production, where (I hope) it is scheduled to run periodically?

Comment 4

[Reed Loden [:reed]]

(In reply to comment #3)
> Do you want to copy that cron job from production, where (I hope) it is
> scheduled to run periodically?

|php -f update-search-views.php| is run on the 12,32,52 minutes of every hour on both production and staging AMO instances.

Comment 5

[Wil Clouser [:clouserw]]

This appears to be fixed - it's not clear if Reed fixed it or if he's saying the cron jobs were already there.

I'm resolving the bug though because even if the jobs were already there I don't think it's something webdev can debug.

Comment 6

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

This has been working fine for a while; verified.