514479 - Upgrade SUMO Sphinx engine to the latest version

Status: VERIFIED FIXED

(support.mozilla.org :: Search, defect)

Description

[Paul Craciunoiu [:paulc]]

For advanced search options on SUMO (see bug 501880), we need the ability to use OR in filters. However, this is not supported in our current version of Sphinx (0.9.8.1 I believe).

We would like to upgrade to the latest version, which is 0.9.9rc2 at the time of this bug filing.

Comment 1

[Paul Craciunoiu [:paulc]]

I'm bumping this to major just so we can get an estimated timeline. We could really use this by the time of our next release -- 1.4 milestone, which is anticipated around Sept 17.
IT: if you can give us an estimate, that would be great.

Note that AMO is already using this version, and maybe that helps. Bug 498999 and bug 509148 may be of assistance.

Comment 2

[Paul Craciunoiu [:paulc]]

I did this easily and without trouble. Steps I took on my local copy:

1.  wget http://www.sphinxsearch.com/downloads/sphinx-0.9.9-rc2.tar.gz
2.  tar zxvf sphinx-0.9.9-rc2.tar.gz
3.  cd sphinx-0.9.9-rc2
4.  ./configure --prefix=/usr/local/sphinx
5.  sudo make
6.a sudo make install

Optional steps which should be already done on upgrades (from bug 463708)
6.b Make sure that the folder /usr/local/sphinx/bin is in the search path.
6.c Create /usr/local/sphinx/index. This folder and files in it must be
writable/readable by the apache web server user, and be on a reasonably large
volume (space considerations).
6.d Replace /usr/local/sphinx/etc/sphinx.conf with the contents of sphinx.conf from bug 463708

Finally:

7. Execute the search daemon /usr/local/sphinx/bin/searchd. Configure the
search daemon to start up automatically.

On the webdev end, we need to replace sphinxapi.php with a new one, but search should still work until that happens.
We should test this process on stage. Pending an estimate first, though.

Comment 3

[chizu]

Package rebuilt for RHEL. Updated on stage, but that's gated on 515222 before it can be tested.

Comment 4

[chizu]

New sphinx setup/version is ready for production and 515222 is long since fixed. Let me know when this is tested and can go production.

Comment 5

[chizu]

Rolled back in stage, pending fixes.

Comment 6

[Laura Thomson :laura]

We're holding this for Q4.  It does not block 511423.  Staging and prod servers for Fennec should run the older version.

Comment 7

[matthew zeier [:mrz]]

Please re-open when there's IT action.

Comment 8

[Paul Craciunoiu [:paulc]]

Thanks mrz. Assigning to James for now.

Comment 9

[James Socol [:jsocol, :james]]

http://sumo-forumux.stage.mozilla.com is already running on the Sphinx cluster. We're in fine shape to make this change to production during the 1.5 push.

Comment 10

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

(In reply to comment #9)
> http://sumo-forumux.stage.mozilla.com is already running on the Sphinx cluster.
> We're in fine shape to make this change to production during the 1.5 push.

And now http://support-stage.mozilla.org, right?  Can I safely verify this?

Comment 11

[James Socol [:jsocol, :james]]

Yep, we moved support-stage over today.

Comment 12

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

Thanks, verified -- guess this was more of a tracking/doc bug for you guys.