Delta indexes not working on servers when using Thinking Sphinx

Question

I'm using delta indexing for my Thinking Sphinx indexes in my Rails project. In my machine (Mac OS X) it's working fine. I change a record and it immediately finds it. On the servers (Debian) it doesn't.

I did run a sql query for delta = true and the I've got the expected recently changed records, so that part is working. In the log/searchd.query.log I see the proper request:

[Fri Oct 22 10:25:29.193 2010] 0.000 sec [all/3/rel 0 (0,20)] [customer_core,customer_delta] Jonas4

Any ideas what else could it be?

Thanks.

Answer 1

Hi there

I'll answer here, even though you've posted to the support list as well...

Which user is running the TS rake tasks? And which user owns the Rails site on your server? They should be the same.

Also: are you using Passenger? If so, you'll want to make sure the bin_path setting is set in your config/sphinx.yml file. The documentation runs through both points.

Let me know if neither of these things help matters.