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.
