Thinking sphinx returning bad results (many documents missing).

Question

I am developing Ruby on Rails application which uses Thinking Sphinx. Unfortunately, from time to time (few times per month) search tends to return bad results (many documents missing). Reindexing helps, but this is not a solution for production.

I am experiencing bad results even when I am typing simple queries into rails console (like ThinkingSphinx.search 'skalee'). Sphinx search tool returns proper results, so indexing apparently works properly.

When I type in ThinkingSphinx.search('skalee').results[:words] I see proper numbers of hits (for example, term found in 30 documents) but ThinkingSphinx.search('skalee').results[:matches] contains, let's say, 2 documents. The numbers in results[:words] are equal to those I am getting with search.

I am using delayed delta but this problem is appearing even when I am not running ts:dd.

Answer 1

Just happened to stumble across this:

http://freelancing-god.github.com/ts/en/common_issues.html#deltas

Perhaps your user permissions are off?