Hi Andrew Not sure what the cause is at the moment, but let's start with the following: * What's your define_index block for Dog? * Do you have anything in config/sphinx.yml? * Just to confirm (although you've implied it), everything's fine in development mode? * What database are you using? And are you running on Windows or a *nix system for your development machine? (Let's keep the focus there, so if we fix that, we can try the same thing on the production machine)
Cheers -- Pat On 20/04/2009, at 10:43 AM, Andrew wrote: > > 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 -~----------~----~----~----~------~----~------~--~---
