I feel somewhat confident that both the search daemon and the site are running as the same user. Interestingly, I fired up script/server and searchd (via rake ts:run) using RAILS_ENV = production in my local development environment (regenerated indices first) and replicated the issue. Should I be looking for differences between development.sphinx.conf and production.sphinx.conf? A quick diff didn't show anything interesting, but I can keep barking up that tree.
On Apr 17, 8:28 pm, Ryan Bigg <[email protected]> wrote: > Who are you running the search daemon as and who are you running the > site as? I had an issue where I was running the daemon as root and the > site as a user called "store". Store didn't have permissions to access > root's indexes so when I edited records they were magically > disappearing. You may have the same issue. > > ----- > Ryan Bigg > Mocra - Premier iPhone and Ruby on Rails Consultants > w -http://mocra.com > e - [email protected] > p - +61 432 937 289 or +61 7 3102 3237 > skype - radarlistener > > On 18/04/2009, at 6:25 AM, Andrew wrote: > > > > > Hello, > > > I've been having some difficulties with thinking_sphinx and delta > > indexing on my production server. Everything works fine in test, and > > I've been hammering at this all day and not gotten to a solution. I > > first attempted to solve this with a bin_path in my config/sphinx.yml, > > so I put that in, and then I had to mess with a bunch of issues > > regarding user permissions, but now even though everything seems to be > > working (the logs don't show any errors anywhere), when I save my > > indexed model, it stops showing up in search results (because delta is > > set to true). I am using simple delta functionality, (set :delta => > > true in my index), and when I save my model, I get these two line- > > pairs in searchd.log: > > > [Fri Apr 17 16:18:11.869 2009] [ 7128] rotating indices (seamless=1) > > [Fri Apr 17 16:18:11.869 2009] [ 7128] rotating finished > > [Fri Apr 17 16:18:12.240 2009] [ 7128] rotating indices (seamless=1) > > [Fri Apr 17 16:18:12.240 2009] [ 7128] rotating finished > > > I think that's the main index and the delta index being rotated, but I > > can't tell. Production log looks like this between my edit and update > > actions: > > > Sphinx 0.9.8.1-release (r1533) > > Copyright (c) 2001-2008, Andrew Aksyonoff > > > using config file '/seq/annotation/kennel/releases/20090417164316/ > > config/production.sphinx.conf'... > > indexing index 'dog_delta'... > > collected 3 docs, 0.0 MB > > collected 0 attr values > > sorted 0.0 Mvalues, 100.0% done > > sorted 0.0 Mhits, 94.3% done > > total 3 docs, 183 bytes > > total 0.435 sec, 420.80 bytes/sec, 6.90 docs/sec > > rotating indices: succesfully sent SIGHUP to searchd (pid=7128). > > Sphinx 0.9.8.1-release (r1533) > > Copyright (c) 2001-2008, Andrew Aksyonoff > > > using config file '/seq/annotation/kennel/releases/20090417164316/ > > config/production.sphinx.conf'... > > indexing index 'dog_delta'... > > collected 3 docs, 0.0 MB > > collected 0 attr values > > sorted 0.0 Mvalues, 100.0% done > > sorted 0.0 Mhits, 94.0% done > > total 3 docs, 181 bytes > > total 0.298 sec, 607.20 bytes/sec, 10.06 docs/sec > > rotating indices: succesfully sent SIGHUP to searchd (pid=7128). > > > I'm using rails 2.1.1, sphinx 0.9.8.1, and thinking_sphinx 0.9.5. > > > Does anyone have an idea for what the matter is with my deltas? > > Everything in development works fine, which leads me to suspect it's > > an environment thing, but frankly I'm running out of things to check. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
