well, right now... i am running a cron myself with 'rake ts:index -- rotate' which loads the deltas and makes them available on search, but i am positive it's not the right way cause when i try to do a full index, i get the error stated above that the resource (status_update_delta.tmp.spl) is not available.
I tried to read the sphinx documentation and see if there is anything i can read about the file structure and who invokes what.. but apparently it's not there... Pat, i appreciate your help and i will wait for you to finish the 'deployment' and 'indexing' sections of the new documentation. If you can please, pay close attention to the parts where you explain about users and how you should setup your own environment.... i know it's kind of rude to ask, but a sample app with thinking_sphinx, deltas, cron jobs and capistrano instructions would be more than awesome. On May 25, 2:38 am, Pat Allan <[email protected]> wrote: > I'm running out of ideas, I'm afraid - I've not seen .tmp in a index > name before (only .old and .new). > > -- > Pat > > On 24/05/2009, at 8:36 PM, Elad Meidar wrote: > > > > > nop, it's not ok yet... > > > even when running as root.... the indexer fails.. > > > Sphinx 0.9.8.1-release (r1533) > > Copyright (c) 2001-2008, Andrew Aksyonoff > > > using config file '/var/www/statussearch2/releases/20090523013634/ > > config/production.sphinx.conf'... > > indexing index 'status_update_delta'... > > FATAL: failed to lock /var/www/statussearch2/releases/20090523013634/ > > db/sphinx/production/status_update_delta.tmp.spl: Resource temporarily > > unavailable, will not index. Try --rotate option. > > > that's the automated indexer instance... i made sure that nothing else > > is running.. > > > On May 24, 10:32 pm, Pat Allan <[email protected]> wrote: > >> Well, I guess if it works, that's great. > > >> Ideally, it's best to have it all running as web, but I guess > >> pragmatism sometimes comes before potential security issues - I know > >> my deployment approaches aren't perfect either. > > >> -- > >> Pat > > >> On 24/05/2009, at 7:21 PM, Elad Meidar wrote: > > >>> ok, so i moved everything to run under root (server + ts:index)... > > >>> and now it seems that the deltas are working fine... i'll try to re- > >>> index everything later on and see if that goes successful. > > >>> On May 24, 9:08 pm, Pat Allan <[email protected]> wrote: > >>>> Rails is running on Passenger, and it's Rails (via Thinking Sphinx) > >>>> that makes the call to indexer using the status_update_delta > >>>> parameter. > > >>>> If you can get Passenger running on the web user instead of root, > >>>> that > >>>> should probably fix the problem. > > >>>> Cheers > > >>>> -- > >>>> Pat > > >>>> On 24/05/2009, at 6:04 PM, Elad Meidar wrote: > > >>>>> i am not running that command i posted before (indexer with > >>>>> status_update_delta parameter)... what do you mean 'invoked by the > >>>>> stack' ? rake ? passenger? > > >>>>> On May 24, 7:47 pm, Pat Allan <[email protected]> wrote: > >>>>>> delta indexing is invoked by the rails stack, not a rake task, so > >>>>>> that means passenger in this > >>>>>> case, and so it's using passenger's permissions to run indexer. I > >>>>>> think that's the source of the problem. > > >>>>>> -- > >>>>>> Pat > > >>>>>> On 24/05/2009, at 4:40 PM, Elad Meidar wrote: --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
