Yes, the delta indexing output is visible in console, and when running script/server.
I just had a small breakthrough on additional examination of the httpd error.log. On startup I get this: [Fri Oct 01 10:41:43 2010] [notice] Apache/2.2.9 (Unix) DAV/2 Phusion_Passenger/2.2.15 mod_ssl/2.2.9 OpenSSL/0.9.8b configured -- resuming normal operations /usr/local/lib/ruby/gems/1.8/gems/rails-2.3.5/lib/rails/ gem_dependency.rb:119:Warning: Gem::Dependency#version_requirements is deprecated and will be removed on or after August 2010. Use #requirement Sphinx cannot be found on your system. You may need to configure the following settings in your config/sphinx.yml file: * bin_path * searchd_binary_name * indexer_binary_name For more information, read the documentation: http://freelancing-god.github.com/ts/en/advanced_config.html Every time I perform an action that runs a search, this shows in the error.log: <error.log> Riddle cannot detect Sphinx on your machine, and so can't determine which version of Sphinx you are planning on using. Please use one of the following lines after "require 'riddle'" to avoid this warning. require 'riddle/0.9.8' # or require 'riddle/0.9.9' # or require 'riddle/1.10' </error.log> When I perform an action that should trigger a delta, I see this: <error.log> /usr/local/bin/indexer: error while loading shared libraries: libpq.so. 5: cannot open shared object file: No such file or directory </error.log> That last one leads me to believe that the LD_LIBRARY_PATH variable is not properly set. I am going to set that in environment.rb and see if that helps. Next I will set it in httpd.conf. Let me know if you have seen this before, there may be another place I need to set it. On Oct 1, 10:20 am, Pat Allan <[email protected]> wrote: > Hi Matt > > So when you try it in script/console, you see the delta indexing output? Is > there *anything* beyond that warning in the Apache error log? What about > searchd.log? > > Cheers > > -- > Pat > > On 02/10/2010, at 12:04 AM, mpokress wrote: > > > > > It does not work with Apache/Phusion, only with script/console. That > > is the warning I see in the Apache error log. > > > On Oct 1, 9:42 am, Pat Allan <[email protected]> wrote: > >> Hi Matt > > >> Just to clarify: beyond the warning from Thinking Sphinx/Riddle, does > >> delta indexing work? Are altered records available in search results a few > >> seconds after they've been changed? > > >> -- > >> Pat > > >> On 01/10/2010, at 11:31 PM, mpokress wrote: > > >>> Pat- > > >>> Running that path, I get the correct path: "/usr/local/bin". > > >>> This particular machine is running Sphinx 0.9.9 and TS 1.3.20 (plugin > >>> not gem). I have the same problem with 0.9.8 and 1.3.16, I just > >>> wanted to test against the newest stuff and not add confusion due to > >>> out of date software. > > >>> What you say about Passenger is consistent with what I thought. Prior > >>> to explicitly setting the user I did see that the Passenger spawner > >>> was running as the correct user, I jut wanted to remove all doubt. > > >>> I do believe that somehow the Passenger/Rails environment is not > >>> picking up the path. I just don't know where else to set it. > > >>> Thanks, > > >>> Matt > > >>> On Oct 1, 9:04 am, Pat Allan <[email protected]> wrote: > >>>> Hi Matt > > >>>> Maybe you've edited the spacing in the email, or maybe YAML isn't fussy > >>>> - but should it be two spaces indentation? (ie: each key/value pair > >>>> under production). > > >>>> I guess let's start with double-checking the bin_path value is coming > >>>> through correctly - in script/console on your server, does the following > >>>> output '/usr/local/bin'? > > >>>> ThinkingSphinx::Configuration.instance.bin_path > > >>>> Also: which versions of Sphinx and Thinking Sphinx are you using? > > >>>> And you shouldn't need to set the user explicitly in Apache - Passenger > >>>> automatically detects the user from the owner of the Rails app files. > >>>> The overall Apache process can still run as root. > > >>>> Cheers > > >>>> -- > >>>> Pat > > >>>> On 01/10/2010, at 6:44 AM, mpokress wrote: > > >>>>> Something to add to this: > > >>>>> I see this in my apache error log every time a search is executed: > > >>>>> Riddle cannot detect Sphinx on your machine, and so can't determine > >>>>> which > >>>>> version of Sphinx you are planning on using. Please use one of the > >>>>> following > >>>>> lines after "require 'riddle'" to avoid this warning. > > >>>>> require 'riddle/0.9.8' > >>>>> # or > >>>>> require 'riddle/0.9.9' > >>>>> # or > >>>>> require 'riddle/1.10' > > >>>>> Running TS 1.3.20 and Sphinx 0.9.9. Have the same problems in > >>>>> environments with 0.9.8 and 1.3.16. > > >>>>> Matt > > >>>>> On Sep 30, 4:29 pm, mpokress <[email protected]> wrote: > >>>>>> Good afternoon- > > >>>>>> I have read a number of threads that make reference to the issue I am > >>>>>> having - delta indexing does not work in production. Like many, it > >>>>>> works without issue under script/server or script/console. In > >>>>>> production (Apache/Passenger) it does not. > > >>>>>> For this example, let's say my rails app is owned by "matt". The > >>>>>> binaries are in /usr/local/bin, and the relevant section os sphinx.yml > >>>>>> is this: > > >>>>>> production: > >>>>>> mem_limit: 512M > >>>>>> enable_star: 1 > >>>>>> min_infix_len: 3 > >>>>>> max_matches: 100000 > >>>>>> bin_path: /usr/local/bin > >>>>>> charset_table: "+, -, 0..9, A..Z->a..z, _, a..z, U+410..U+42F->U > >>>>>> +430..U+44F, U+430..U+44F" > > >>>>>> I have set the apache directives to force it to run as "matt" (not too > >>>>>> comfortable with this). These directives are snipped from the globals > >>>>>> section of the httpd.conf. > > >>>>>> User matt > >>>>>> Group matt > >>>>>> PassengerDefaultUser matt > > >>>>>> I really appreciate any help. This has been driving me absolutely > >>>>>> nuts for two days, and I really tried to RTFM/RTFP (posts) before > >>>>>> asking a question that seems to have been answered many times. > > >>>>>> Best, > > >>>>>> Matt > > >>>>> -- > >>>>> 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 > >>>>> athttp://groups.google.com/group/thinking-sphinx?hl=en. > > >>> -- > >>> 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 > >>> athttp://groups.google.com/group/thinking-sphinx?hl=en. > > > -- > > 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 > > athttp://groups.google.com/group/thinking-sphinx?hl=en. -- 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.
