Hi Horibo Are you running the latest version of Thinking Sphinx? I realise the docs say 0.9.5, but internally the code's 1.1.6.
Also, thinking_sphinx:index:delta is only for the datetime_delta approach. That won't have any impact on the normal delta setup. If you're running the latest TS and it's still happening, does the problem occur in script/console? What's the output there when you create a new instance of an indexed model? Do you see anything from the Sphinx indexer task? It is odd that a restart makes everything work... Cheers -- Pat -- Pat e: [email protected] || m: +614 1327 3337 w: http://freelancing-gods.com || t: twitter.com/pat discworld: http://ausdwcon.org || skype: patallan On 15/04/2009, at 10:18 PM, horibo wrote: > > I have to add: > > If I stop and restart the searchd without re-indexing, the new rows > are shown. > > Thanks for any advice! > > Horibo > > On Apr 15, 10:37 am, horibo <[email protected]> wrote: >> Hello, >> >> we used TS a couple of weeks in our environment. All was working >> well. >> But the database is growing and we want to switch to delta indexing >> instead of re-indexing every hour. First of all, get this to work on >> my development machine. >> >> I added a "delta" column to my tables. The field is set in the >> expected way. Every time, an entry is updated, the field changes to >> "1". I can see, that Sphinx is touching the "*delta*" files under >> project/db/sphinx/development/ >> >> But new rows in the database are not displayed. Tried to do a >> "thinking_sphinx:index:delta" at the command prompt. No output is >> generated and the new rows are still not displayed on a search. The >> bin_path is set right in sphinx.yml. >> >> What am I doing wrong? Any advice will be welcome! >> >> This is my development environment: >> Windows XP Professional >> Rails 2.2.2 >> Sphinx 0.9.8.1 >> TS 0.9.5 >> MySQL 5.0.67 >> >> Thanks >> Horibo > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
