How soon after the delta indexing happening are you running the search? Sometimes it can take a second or two for Sphinx to catch up.
That said, the indexing output shows one record being processed, so it's a bit odd why nothing's appearing. Can you run me through how you're going about testing this? How are you changing a company? What are you then searching for? -- Pat On 01/11/2011, at 8:53 PM, tingiri wrote: > Thanks Pat. I can see the indexing happen automatically now. > Sorry, it was a typo. > The define_index block actually has > set_property :delta => true > Here is another issue I am currently having. > We have two models that have delta indexing turned on(Item and > Company). Delta indexing works fine for the item model but not for > the > company model. [Item => belongs_to :company and Company => > has_many :items] > Here is the define_index block on the Item model: > define_index do indexes company(:name), :as => :company, :facet => > true > set_property :delta => true > end > Here is the define_index block on the Company model: > define_index do > indexes name, :sortable => true > set_property :delta => true > end > When ever a company record gets updated and the delta is set to true, > I can see on the console ts trying to index and rotating the index. > But the search is not returning those records. > I can see the following getting logged in searchd.log when delta is > set to true: > [Tue Nov 1 12:47:25.494 2011] [ 4687] rotating indices (seamless=1) > [Tue Nov 1 12:47:25.499 2011] [ 4687] rotating index 'company_delta': > success > [Tue Nov 1 12:47:25.499 2011] [ 4687] rotating finished > Here is the output for define_indexes and index_delta on console for > one of the model that is not returning results after delta indexing: >>> Company.define_indexes > => true >>> Company.index_delta > > Sphinx 0.9.9-release (r2117) > Copyright (c) 2001-2009, Andrew Aksyonoff > using config file '/home/rajesh/projects/norris/config/ > development.sphinx.conf'... > indexing index 'company_delta'... > collected 1 docs, 0.0 MB > sorted 0.0 Mhits, 97.8% done > total 1 docs, 26 bytes > total 0.531 sec, 48 bytes/sec, 1.88 docs/sec > total 5 reads, 0.000 sec, 0.1 kb/call avg, 0.0 msec/call avg > total 10 writes, 0.000 sec, 0.2 kb/call avg, 0.0 msec/call avg > rotating indices: succesfully sent SIGHUP to searchd (pid=4687). > => true > I wonder if the index is not being created properly or if something > else is wrong. > > -- > 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.
