657878 - [sumo-prod] Sphinx config is out of date

Status: RESOLVED FIXED

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

Description

[Kadir Topal [:atopal]]

The search results only show forum threads, no KB articles

Comment 1

[James Socol [:jsocol, :james]]

Kadir, do you have an example URL that should return both?

Comment 2

[James Socol [:jsocol, :james]]

The production sphinx index is missing the 'is_archived' bit for articles--looks like we forgot to update the sphinx configs for prod last night during the push.

Would someone mind grabbing the configs/sphinx/sphinx.conf from tag 2.8.3, updating it on pm-app-sphinx0{1-2} and reindexing?

Thanks!

Comment 3

[Shyam Mani [:fox2mike]]

Have swag? Shall poke!

Comment 4

[Shyam Mani [:fox2mike]]

Done.

This was done on both machines : 

[root@pp-app-sphinx02 ~]# puppetd -t
info: Retrieving plugin
info: Loading facts in hp_array_utils
info: Loading facts in available_package_updates
info: Loading facts in hp_array_utils
info: Loading facts in available_package_updates
info: Caching catalog for pp-app-sphinx02.phx.mozilla.com
info: Applying configuration version '14811'
--- /data/sphinx/support/sphinx.conf	2011-02-15 16:18:32.000000000 -0800
+++ /tmp/puppet-file.5291.0	2011-05-18 06:47:24.000000000 -0700
@@ -273,6 +273,7 @@
         d.html AS content, \
         d.category, \
         d.slug, \
+        d.is_archived, \
         r.summary, \
         r.keywords, \
         UNIX_TIMESTAMP(r.created) AS updated \
@@ -288,6 +289,7 @@
     sql_attr_timestamp = updated
     sql_attr_uint = locale
     sql_attr_uint = category
+    sql_attr_bool = is_archived
 
     sql_attr_multi = uint tag from query; SELECT \
         d.id, \
info: FileBucket adding {md5}a1ba8e6c5bd4d0d76da300b5513f127a
info: /Stage[main]/Sphinx-generic/Sphinx-config[support]/File[/data/sphinx/support/sphinx.conf]: Filebucketed /data/sphinx/support/sphinx.conf to main with sum a1ba8e6c5bd4d0d76da300b5513f127a
notice: /Stage[main]/Sphinx-generic/Sphinx-config[support]/File[/data/sphinx/support/sphinx.conf]/content: content changed '{md5}a1ba8e6c5bd4d0d76da300b5513f127a' to '{md5}de5c3526e309e3a6e51e2cb2b1b7fe52'
notice: Finished catalog run in 7.40 seconds
[root@pp-app-sphinx02 ~]# su -s /bin/sh -c "/data/bin/sphinx-reindex support" daemon
Sphinx 0.9.9-release (r2117)
Copyright (c) 2001-2009, Andrew Aksyonoff

using config file '/data/sphinx/support/sphinx.conf'...
FATAL: failed to lock pid file '/data/sphinx/support/bin/searchd.pid': Resource temporarily unavailable (searchd already running?)
Sphinx 0.9.9-release (r2117)
Copyright (c) 2001-2009, Andrew Aksyonoff

using config file '/data/sphinx/support/sphinx.conf'...
indexing index 'questions'...
collected 159063 docs, 109.8 MB
collected 703613 attr values
sorted 0.7 Mvalues, 100.0% done
sorted 10.9 Mhits, 100.0% done
WARNING: duplicate document ids found
total 159063 docs, 109797436 bytes
total 27.733 sec, 3959049 bytes/sec, 5735.45 docs/sec
indexing index 'discussion_forums'...
collected 35087 docs, 5.8 MB
sorted 0.6 Mhits, 100.0% done
total 35087 docs, 5841364 bytes
total 1.952 sec, 2991113 bytes/sec, 17966.55 docs/sec
indexing index 'wiki_pages'...
collected 5500 docs, 19.8 MB
collected 32385 attr values
sorted 0.0 Mvalues, 100.0% done
sorted 2.8 Mhits, 100.0% done
total 5500 docs, 19798672 bytes
total 4.189 sec, 4725708 bytes/sec, 1312.78 docs/sec
total 60 reads, 0.038 sec, 1498.7 kb/call avg, 0.6 msec/call avg
total 205 writes, 0.257 sec, 968.5 kb/call avg, 1.2 msec/call avg
rotating indices: succesfully sent SIGHUP to searchd (pid=2818).