Hi Chris Unfortunately, I've never seen this problem before... it's certainly an odd one. I know it's probably hard to reproduce, but if you can log what the value of Model.search(args).results is, that'd be fantastic - as that's the raw Sphinx results (as a bundle of hashes and arrays), and should confirm whether the problem is happening in TS or Sphinx - though I'm pretty certain it's the latter.
It's probably worth searching/asking on the Sphinx forums as well: http://sphinxsearch.com/forum/forum.html?id=1 Good luck! -- Pat On 09/07/2010, at 4:48 PM, Chris McCann wrote: > We're having an issue in a Rails 2.3.5 app with thinking_sphinx 1.3.16 > in terms of inconsistent search results for the same inputs to TS. > We're using MySQL 5.1.41. > > I've checked the parameters passed into the model's .search() method > on every call. With identical inputs the correct results are usually > returned, but on occasion some of the expected results will be > missing. This is on a development database that only I am hitting, so > there's nothing happening to the underlying data between these search > calls. > > The development log also shows that sphinx is returning different > results from the same inputs (my debug statements prefaced with >>>): > >>>> search_options => {:page=>1, :per_page=>10, :sort_mode=>:desc, >>>> :order=>"created_at", :with=>{:specialty_ids=>[29], :location_ids=>[6, 2, >>>> 3, 4, 5]}} > > Sphinx Querying: '' > Sphinx (0.002381s) Found 4 results > >>>> search_options => {:page=>1, :per_page=>10, :sort_mode=>:desc, >>>> :order=>"created_at", :with=>{:specialty_ids=>[29], :location_ids=>[6, 2, >>>> 3, 4, 5]}} > > Sphinx Querying: '' > Sphinx (0.002279s) Found 0 results > > We are using the :retry_stale => true setting as well. > > I'm at a loss for how to spelunk into the thinking_sphinx code to sort > out what's going wrong. If anyone has seen this behavior I'd love to > hear what you did to fix or investigate it. If not, any suggestions > for a way forward to sort this out would be much appreciated. > > Cheers, > > Chris > > -- > 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.
