Well, I guess the good news is at least I'm not crazy. For now it seems like frequent reindexing and hoping for the fix in 0.9.9 will probably be the best bet.
Thanks for the quick response, and the great plugin, David On Feb 12, 2:17 am, Pat Allan <[email protected]> wrote: > Ah, I'm aware of this issue... the problem is Sphinx's str2ordinal > (read: string) attributes are only calculated on a per-index basis. > Which means delta index and core index ordering are calculated > separately. > > I've been thinking on how to get around this, and Sphinx does allow > updates to attributes - but only integer, boolean and datetime > attributes. Not str2ordinal, not floats. Otherwise, we could run a > task in the background that recalculated ordering across the two > indexes instead of just scanning one. Even then, it's a bit hackish. > > I'll put a post on the Sphinx forums, see if we can get str2ordinal > updating into 0.9.9 before the proper release. > > Cheers > > -- > Pat > > On 12/02/2009, at 9:02 PM, David Faber wrote: > > > > > Hey Guys, > > > I'm having a somewhat similar problem with searches involving the > > (default approach to the) delta index. While the text-search actually > > seems to be doing what it should, ordering by attributes on records in > > the delta index is behaving a bit unpredictably. > > > Here's an example of the problem, I tried to make it as concise but > > thorough as possible, hopefully its still clear though. > > > I've defined an index in a model called Brand like this: > > define_index do > > indexes name, :sortable => true > > set_property :delta => true > > end > > > Then I added a couple records, and did a full index with rake ts:in, > > so the delta is empty and the core is up to date. Here's the output > > of a script that reproduced the problem: > > > ==> @brand1: #<Brand id: 1, name: "Microsoft", delta: false, > > created_at: "2009-02-12 09:53:08", updated_at: "2009-02-12 09:53:08"> > > ==> @brand2: #<Brand id: 2, name: "Apple", delta: false, created_at: > > "2009-02-12 09:53:08", updated_at: "2009-02-12 09:53:08"> > > ==> Execute: "Brand.search(:order => 'name asc')" > > ==> Result: [#<Brand id: 2, name: "Apple", delta: false, created_at: > > "2009-02-12 09:53:08", updated_at: "2009-02-12 09:53:08">, #<Brand id: > > 1, name: "Microsoft", delta: false, created_at: "2009-02-12 09:53:08", > > updated_at: "2009-02-12 09:53:08">] > > ==> Change @brand1 name to "Xerox" > > Sphinx 0.9.8-release (r1371) > > Copyright (c) 2001-2008, Andrew Aksyonoff > > > using config file '/Users/faber/tmp/broken_sphinx/rails/config/ > > development.sphinx.conf'... > > indexing index 'brand_delta'... > > collected 1 docs, 0.0 MB > > collected 0 attr values > > sorted 0.0 Mvalues, 100.0% done > > sorted 0.0 Mhits, 100.0% done > > total 1 docs, 5 bytes > > total 0.014 sec, 348.82 bytes/sec, 69.76 docs/sec > > rotating indices: succesfully sent SIGHUP to searchd (pid=33881). > > ==> Wait for 10 seconds > > ==> Execute: "Brand.search(:order => 'name asc')" > > ==> Result: [#<Brand id: 1, name: "Xerox", delta: true, created_at: > > "2009-02-12 09:53:08", updated_at: "2009-02-12 09:53:12">, #<Brand id: > > 2, name: "Apple", delta: false, created_at: "2009-02-12 09:53:08", > > updated_at: "2009-02-12 09:53:08">] > > ==> Execute: "Brand.search('xerox')" > > ==> Result: [#<Brand id: 1, name: "Xerox", delta: true, created_at: > > "2009-02-12 09:53:08", updated_at: "2009-02-12 09:53:12">] > > ==> Execute: "Brand.create(:name => 'Aardvark')" > > Sphinx 0.9.8-release (r1371) > > Copyright (c) 2001-2008, Andrew Aksyonoff > > > using config file '/Users/faber/tmp/broken_sphinx/rails/config/ > > development.sphinx.conf'... > > indexing index 'brand_delta'... > > collected 2 docs, 0.0 MB > > collected 0 attr values > > sorted 0.0 Mvalues, 100.0% done > > sorted 0.0 Mhits, 100.0% done > > total 2 docs, 13 bytes > > total 0.016 sec, 792.39 bytes/sec, 121.91 docs/sec > > rotating indices: succesfully sent SIGHUP to searchd (pid=33881). > > ==> Result: #<Brand id: 3, name: "Aardvark", delta: true, created_at: > > "2009-02-12 09:53:22", updated_at: "2009-02-12 09:53:22"> > > ==> Wait for 10 seconds > > ==> Execute: "Brand.search(:order => 'name asc')" > > ==> Result: [#<Brand id: 2, name: "Apple", delta: false, created_at: > > "2009-02-12 09:53:08", updated_at: "2009-02-12 09:53:08">, #<Brand id: > > 3, name: "Aardvark", delta: true, created_at: "2009-02-12 09:53:22", > > updated_at: "2009-02-12 09:53:22">, #<Brand id: 1, name: "Xerox", > > delta: true, created_at: "2009-02-12 09:53:08", updated_at: > > "2009-02-12 09:53:12">] > > > (Apologies for the big ugly bunch of text) This shows that the sorting > > by name works initially, then doesn't seem to work with entries > > indexed in the delta. If after this I ran rake ts:in again, > > everything would work again. > > > Can you see where I'm going wrong? I've never noticed this problem > > working with thinking-sphinx before, but I don't really have a huge > > amount of experience with it so maybe it's been happening all along. > > FYI, I'm running Sphinx 0.9.8 (r1371), Rails 2.2.2, Ruby 1.8.6, and > > ThinkingSphinx 1.1.5 on a Macbook Pro. > > > Thanks so much, I appreciate all your work, > > David > > > On Feb 11, 6:21 pm, Pat Allan <[email protected]> wrote: > >> Hmm, okay. What version of Rails are you using, and what's the output > >> of the following: > > >> e = Expense.new :amount=>1, :creator_id=>1, :business_id=>1 > >> e.due_date = Date.today > >> e.save > >> e.send(:should_toggle_delta?) > >> Expense.index_delta(e) > >> client = Riddle::Client.new "localhost", 11002 > >> client.query "", "expense_delta" > > >> Cheers > > >> -- > >> Pat > > >> On 12/02/2009, at 12:20 AM, Steven Bristol wrote: > > >>> On Wed, Feb 11, 2009 at 12:04 AM, Pat Allan <p...@freelancing- > >>> gods.com> wrote: > > >>>> No worries... (although it wasn't so much a holiday - at least part > >>>> of > >>>> the time - more working-from-Cambodia). > > >>>> So, we're not seeing the output of the delta task (just to confirm: > >>>> you're using the default delta approach, yeah?)... to check whether > >>>> there's path issues, what's the output of the following in script/ > >>>> console: > >>>> `indexer` > > >>>> If that complains about missing args, path is fine. If it complains > >>>> that it doesn't know about the executable indexer, then it's a path > >>>> problem. > > >>>> Cheers > > >>>> -- > >>>> Pat > > >>> Yes, the default delta approach. (AFAIK, I'm only aware of one delta > >>> approach.) Here is my define: > >>> define_index do > >>> indexes amount, title, check_number, notes, business_id > >>> indexes [client.name, client.company_name], :as=>:client_name > >>> indexes [payee.name, payee.company_name], :as=>:payee_name > >>> indexes [employee.name, > >>> employee.company_name], :as=>:employee_name > >>> indexes [contractor.name, > >>> contractor.company_name], :as=>:contractor_name > >>> indexes expense_category.name, :as=>:expense_category_name > >>> where "repeated_template = false" > >>> set_property :delta => true > >>> set_property :enable_star => true > >>> set_property :morphology => 'none' > >>> end > >>> It complained about missing args. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
