511538 - Turn sphinx on on preview

Status: VERIFIED FIXED

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

Description

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

Follow https://wiki.mozilla.org/AMO:Developers/Sphinx to enable indexing on preview.

The https://preview.addons.mozilla.org/en-US/firefox/api/1.5/search/test should show up with some results when it works.

Comment 1

[Wil Clouser [:clouserw]]

The sphinx search code has been committed and this is now blocking QA.  Code freeze is on the 17th of this month.

Let us know if we can help or if the instructions aren't clear (since we'll have to do this in production at the end of the month).  Thanks.

Comment 2

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

FYI, I'm at a conference next week (sept 7-), but I'll do my best to keep up with any bugmail in terms of assisting getting sphinx up.

-d

Comment 3

[Wil Clouser [:clouserw]]

It's been a week and we've had no feedback.  Bumping to major.

Comment 4

[chizu]

Package is built, working out how we're going to deploy it. Should have stage up by tomorrow.

Comment 5

[chizu]

The new sphinx box is setup. I've setup the config from https://wiki.mozilla.org/AMO:Developers/Sphinx for preview, but to start indexing it looks like the SQL still needs to be run and /addons/trunk/site/app/config/sql/sphinx.sql doesn't exist anymore.

Comment 6

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

I need to fix those instructions, production dbs should be up to date as everything is in remora.sql or in the latest migrations.

If you open remora.sql and run the last two "create view"s that should be all you need.

If you have any errors or anything pastie them and I'll have a look - I'll try to be on IRC tomorrow (Friday).

Comment 7

[chizu]

...
ERROR 1054 (42S22): Unknown column 'name.autoid' in 'field list'

Looks like it also needs a newer version of the translations table.

Comment 8

[Wil Clouser [:clouserw]]

(In reply to comment #7)
> ...
> ERROR 1054 (42S22): Unknown column 'name.autoid' in 'field list'
> 
> Looks like it also needs a newer version of the translations table.

Fixed.

Comment 9

[chizu]

Updated, indexed, rotating successfully. And it's working, woo.

Comment 10

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

Verified FIXED; Sphinx is most certainly on -- might need some further tweaking/bug fixes, but that's separate.