tags:

views:

237

answers:

1
+1  Q: 

sphinx is returning stale results

Environment:

Memcached, Rails 2.2.2 + cache_money, Sphinx + thinking sphinx

The following yields stale results:
- add a record; mysql contains the correct data
- the record is probably cached in memory at this point
- re-index sphinx
- sphinx returns the proper result with the correct data
- edit the record
- the cache is invalidated properly, mysql contains the correct, updated data
- re-index sphinx again
- sphinx is now stale

Re-indexing sphinx, clearing memcached, and/or editing the questionable records all have no effect. Disabling the cache layer all together (cache_money plus memcached) also has no effect.

A: 

Does your delta query just get new, unindexed rows from your table(s), or is it grabbing every row with a modified time greater than a specified value?

BipedalShark  2009-11-18 20:43:50
the former; weird thing is the problem is no longer a problem... just cleared up.
Kyle  2009-11-25 17:45:59
It sounds like the entire table(s) was reindexed. If your delta query is only grabbing new rows, changes in UPDATEd rows won't be reflected in the full-text index.
BipedalShark  2009-11-26 00:10:59

related questions

Is there a rake task for backing up the data in your database?
How to represent cross-model information in MVC?
WYSIWYG editor gem for Rails?
Best Solution For Authentication in Ruby on Rails
Acts-as-readable Rails plugin Issue
Associating source and search keywords with account creation
Any tips on getting Rails to run with an Access back-end?
Being as DRY as possible in a Ruby on Rails App
How Do You Secure database.yml?
What IDE to use for developing in Ruby on Rails on windows?
Is Ruby On Rails ready for the Enterprise?
OpenID authentication in Ruby on Rails
Why Doesn't My Cron Job Work Properly?
Why does sqlite3-ruby-1.2.2 not work on OS X?
Ruby mixins and calling super methods
Why all the Active Record hate?
Haml: how do I set a dymanic class value?
Learning Ruby on Rails any good for Grails?
How to sell Python to a client/boss/person with lots of cash
How do I create a new Ruby on Rails application using MySQL instead of SQLite?
Ruby On Rails with Windows Vista - Best Setup?
What is good forum software to add to an existing Rails application?
How do I fix 'Unprocessed view path found' error with ExceptionNotifier plugin in rails 2.1?
Frequent SystemExit in Ruby when making HTTP calls
Implementation of "Remember me" in a Rails application.