Are Sphinx & thinking_sphinx really stable? Not indexing Columns

Posted by seb on Stack Overflow See other posts from Stack Overflow or by seb
Published on 2009-07-16T14:32:21Z Indexed on 2010/05/29 13:02 UTC
Read the original article Hit count: 334

Filed under:
|

I'm encountering strange behaviour from thinking_sphinx/sphinx.

My define_index block is about 100 lines, so quite a lot of columns i'm indexing. For full-text searching I only need about 10 attributes, for sorting and filtering I have another approximately 50 columns, mostly floats and integers.

By filtering I mean using the "with" or "without" options.

Searching does not really work consistently. All of a sudden, one attribute fails to filter. Or if I add a new one, it does not work. Only after a lot of tinkering it suddenly starts working. I cannot really reproduce it. Steps I that sometimes lead me to success where:

  • rm -rf db/sphinx
  • change the attribute definition e.g. has some_attribute => has some_attribute, :sortable => true or => has some_attribute, :sortable => true, :as => "some_attribute"
  • restarting the server
  • assigning a new :as name => has some_attribute, :as => "some_attribute_new"

(yes, I did rake ts:rebuild or rake ts:in after every step)

Does anybody else encounter similar problems?

© Stack Overflow or respective owner

Related posts about sphinx

Related posts about thinking-sphinx