Hi Olly Can you confirm for us that delta updates are happening? I think the output should be in the nginx/apache logs. Also, can you run through a simple example of updating a record that's not initially in the delta index, then (wait a few seconds for Sphinx to update) search for a word that you've just added and see if you get the search result?
Seeing the define_index block for the model you use for that test will be helpful as well. Cheers -- Pat On 20/07/2010, at 2:42 AM, Olly Legg wrote: > I'm trying to fix delta indexes on Rails application. I *think* that > it had been working before, but can't be certain. > > It seems as if the delta indexes are being updated, but the aren't > being used in the search. > > It is running Passenger, but I have checked the PATH and also set the > bin_path. > > <%= ENV["PATH"] %> => "/usr/local/bin:/usr/bin:/bin" > which searchd => /usr/local/bin/searchd > which indexer => /usr/local/bin/indexer > > The index directory looks like this. As you can see the delta indexes > are being modified. The modification times also correspond with the > output in log (log/searchd.log). > > -rw-r--r-- 1 deployuser deployuser 34816 2010-07-19 14:06 > project_core.spa > -rw-r--r-- 1 deployuser deployuser 3461052 2010-07-19 14:06 > project_core.spd > -rw-r--r-- 1 deployuser deployuser 875 2010-07-19 14:06 > project_core.sph > -rw-r--r-- 1 deployuser deployuser 286218 2010-07-19 14:06 > project_core.spi > -rw------- 1 deployuser deployuser 0 2010-07-19 16:43 > project_core.spl > -rw-r--r-- 1 deployuser deployuser 13056 2010-07-19 14:06 > project_core.spm > -rw-r--r-- 1 deployuser deployuser 3910794 2010-07-19 14:06 > project_core.spp > -rw-r--r-- 1 deployuser deployuser 128 2010-07-19 17:25 > project_delta.spa > -rw-r--r-- 1 deployuser deployuser 24425 2010-07-19 17:25 > project_delta.spd > -rw-r--r-- 1 deployuser deployuser 875 2010-07-19 17:25 > project_delta.sph > -rw-r--r-- 1 deployuser deployuser 16421 2010-07-19 17:25 > project_delta.spi > -rw------- 1 deployuser deployuser 0 2010-07-19 17:25 > project_delta.spl > -rw-r--r-- 1 deployuser deployuser 48 2010-07-19 17:25 > project_delta.spm > -rw-r--r-- 1 deployuser deployuser 20970 2010-07-19 17:25 > project_delta.spp > -rw-r--r-- 1 deployuser deployuser 24580 2010-07-19 12:03 > user_core.spa > -rw-r--r-- 1 deployuser deployuser 597977 2010-07-19 12:03 > user_core.spd > -rw-r--r-- 1 deployuser deployuser 247 2010-07-19 12:03 > user_core.sph > -rw-r--r-- 1 deployuser deployuser 265048 2010-07-19 12:03 > user_core.spi > -rw------- 1 deployuser deployuser 0 2010-07-19 16:43 > user_core.spl > -rw-r--r-- 1 deployuser deployuser 14748 2010-07-19 12:03 > user_core.spm > -rw-r--r-- 1 deployuser deployuser 503353 2010-07-19 12:03 > user_core.spp > > I'm confident that it isn't page or fragment caching. > > I am running slightly older versions of a sphinx (0.9.8-rc2) and > thinking-sphinx (1.2.8). > > Can anyone think of anything that might be causing these symptoms? Any > troubleshooting steps that may have overlooked? > > -- > You received this message because you are subscribed to the Google Groups > "Thinking Sphinx" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/thinking-sphinx?hl=en. > -- You received this message because you are subscribed to the Google Groups "Thinking Sphinx" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/thinking-sphinx?hl=en.
