Ah, permissions error. Are you indexing the files with a different user to what the web process is being run by? This is necessary for delta indexing, so passenger can update the index files.
-- Pat On 30/07/2009, at 6:09 PM, Michael wrote: > > ok so i did some more mucking around in the console. this is the error > i get. > > indexing index 'project_delta'... > collected 8 docs, 0.0 MB > collected 0 attr values > sorted 0.0 Mvalues, 100.0% done > sorted 0.0 Mhits, 100.0% done > total 8 docs, 3055 bytes > total 0.016 sec, 190925.58 bytes/sec, 499.97 docs/sec > WARNING: access denied to PID 6236. > WARNING: indices NOT rotated. > > > It was giving me some permission errors like this > > ATAL: failed to open PATHTOSITE/releases/20090729221806/db/sphinx/ > production/project_delta.spl: Permission denied, will not index. Try > -- > rotate option. > > But i fixed that up with chmod. > > > > On Jul 30, 11:52 am, Pat Allan <[email protected]> wrote: >> Michael: >> Just to be clear: the bin_path should be set to /usr/local/bin - >> searchd is appended by Thinking Sphinx automatically. >> Does delta indexing work via script/console for you? >> >> Mattias: >> I don't think the PATH problem is something that happens with >> mongrels. >> Is there any output in production.log when a change is made? >> >> -- >> Pat >> >> On 30/07/2009, at 10:36 AM, Mattias wrote: >> >> >> >>> Hi Michael, >> >>> I'm having the exact same problem. There was a post about this not >>> too >>> long agohttp://to.ly/nGzwhich refers to the instructions you've >>> cited. I''ve also tried setting the bin path to '/usr/local/ >>> bin' (which searchd gives me the same output you're receiving), >>> however this yields no improvement. >> >>> On my local machine, on development mode, it works like a charm. >>> Same >>> goes using script/console in the production environment on my >>> production machine. The query log outputs something like the >>> following: >> >>> [Thu Jul 30 05:07:55.539 2009] 0.000 sec [scan/2/rel 1 (0,20)] >>> [activity_core] >> >>> everytime a change is made using the console. However, via the web >>> interface, it just won't work. Any pointers would be greatly >>> appreciated. >> >>> I'm running mongrel_cluster behind Apache 2.2 via ec2onrails, if >>> that >>> is of any interest. I'll inform you of any updates and would >>> appreciate if you did so too =) >> >>> Thanks in advance, >>> Mattias >> >>> On 30 Juli, 02:15, Michael <[email protected]> wrote: >>>> I can't get deltas working in production for my site and its >>>> driving >>>> me nuts. >> >>>> If i run the index rake task then it works fine ZERO errors but for >>>> somereason the delta index does not update on its own. >> >>>> I say the post onhttp://freelancing-god.github.com/ts/en/common_issues.html >>>> about using deltas with passenger and followed those instructions >>>> but >>>> that did not solve the problem. >> >>>> ---------------------------------------------------------------- >>>> Running Delta Indexing with Passenger >> >>>> If you’re using Phusion Passenger on your production server, with >>>> delta indexing on some models, a common issue people find is that >>>> their delta indexes don’t get processed. This is because Passenger >>>> has >>>> it’s own PATH set up, and can’t execute the Sphinx binaries >>>> (indexer >>>> and searchd) implicitly. >> >>>> The way around this is to find out where your binaries are on the >>>> server: >> >>>> which searchd >> >>>> And then set the bin_path option in your config/sphinx.yml file for >>>> the production environment: >> >>>> production: >>>> bin_path: '/usr/local/bin' >>>> ---------------------------------------------------------------- >> >>>> When i run "which searchd" i get "/usr/local/bin/searchd" >>>> I tired the yml file with both "/usr/local/bin" and "/usr/local/ >>>> bin/ >>>> searchd" just to be safe but the results were the same. >> >>>> This is driving me nuts. any help would really really be >>>> appreciated >> >>>> Thanks, >>>> Mike > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
