If you have two different Sphinx installations, I'm guessing one is in your own path, but the older one is available in cron's path - you should make sure the directory with the version of Sphinx you want to use (probably the more recent one) is in cron's path as well as yours.
-- Pat On 06/02/2012, at 10:05 PM, Arun Kumar Nachimuthu wrote: > Hi Pat, > > Thank you for the fix. But we still have the issue. We have finally found > what is creating the problem. When we run rake ts:in from command line, > thinking sphinx is generating proper config file. But we also have a cron > task which calls rake ts:in once every 30 minutes. When this is run, it > regenerates the config file and the config file has "sql_attr_str2ordinal = > sphinx_internal_class" instead of "sql_attr_string = sphinx_internal_class". > I checked whether we have installed any older version of Riddle or Thinking > Sphinx. But we do not have any older gems installed. We use Ruby 1.8.7 REE > with RVM. Can you guess what might be the issue? > > Regards, > Kumar > > > > On Wed, Feb 1, 2012 at 12:22 PM, Pat Allan <[email protected]> wrote: > > You'll need to use both TS and Riddle from the Github sources: > > gem 'riddle', > :git => 'git://github.com/freelancing-god/riddle.git', > :ref => '2cbed1cbeec4c38cf219a3cd43afcd6942ab9b3b' > gem 'thinking-sphinx', > :git => 'git://github.com/freelancing-god/thinking-sphinx.git', > :ref => '3efd9d1fd672a38b4b1ee91b92be51f36c88ea21' > > Cheers > > -- > Pat > > On 01/02/2012, at 2:00 AM, Arun Kumar Nachimuthu wrote: > > > Hi Pat, > > > > Thank you very much for the update. Can I use this commit from Github for > > thinking sphinx version 1.4.11 which is the gem I'm using? > > > > Regards, > > Kumar > > > > > > > > On Mon, Jan 30, 2012 at 6:08 PM, Pat Allan <[email protected]> > > wrote: > > > > I've just patched both Riddle and Thinking Sphinx to support Sphinx 2.0.3 - > > feel free to give them a spin (both from Github - no new gem releases just > > yet). > > > > That said, if Sphinx 2.0.1-beta is working well for you, maybe just stick > > with that :) > > > > -- > > Pat > > > > On 30/01/2012, at 5:34 PM, Arun Kumar Nachimuthu wrote: > > > > > Hi Pat, > > > > > > With Sphinx 2.0.1-beta it seems to work fine. I think the problem occurs > > > only with sphinx 2.0.3. > > > > > > Regards, > > > Kumar > > > > > > > > > > > > On Sun, Jan 29, 2012 at 1:28 PM, Pat Allan <[email protected]> > > > wrote: > > > I've not yet taken 2.0.3 for a spin yet - no idea how well it goes with > > > Riddle and Thinking Sphinx (although given it works locally for you, I'm > > > not convinced it's the cause here). Still, can you try 2.0.1 or 1.10 > > > instead? > > > > > > -- > > > Pat > > > > > > On 24/01/2012, at 10:02 PM, Arun Kumar Nachimuthu wrote: > > > > > > > Both the environments are having the same sphinx version. It is Sphinx > > > > 2.0.3 in staging also. > > > > > > > > Regards, > > > > Kumar > > > > > > > > > > > > > > > > On Tue, Jan 24, 2012 at 4:27 PM, Pat Allan <[email protected]> > > > > wrote: > > > > > > > > Are you using the same version of Sphinx in both environments? I know > > > > you mentioned 2.0.3 before, just not sure if it's for dev or staging. > > > > > > > > -- > > > > Pat > > > > > > > > On 24/01/2012, at 1:10 AM, Arun Kumar Nachimuthu wrote: > > > > > > > > > Sorry. I made a mistake. This is the output. > > > > > > > > > > > > > > > {:matches=>[{:index=>0, :doc=>33, :attributes=>{"sphinx_deleted"=>0, > > > > > "sphinx_internal_class"=>0, "class_crc"=>642995056, > > > > > "sphinx_internal_id"=>4}, :weight=>1}, {:index=>1, :doc=>135, > > > > > :attributes=>{"sphinx_deleted"=>0, "sphinx_internal_class"=>0, > > > > > "class_crc"=>765557111, "sphinx_internal_id"=>16}, :weight=>1}], > > > > > :status=>0, :time=>0.003, :total_found=>2, :total=>2, > > > > > :words=>{"merlagautham"=>{:hits=>2, :docs=>2}}, > > > > > :fields=>["first_name", "last_name", "address"], > > > > > :attribute_names=>["sphinx_internal_id", "sphinx_deleted", > > > > > "class_crc", "sphinx_internal_class"], > > > > > :attributes=>{"sphinx_deleted"=>1, "sphinx_internal_class"=>3, > > > > > "class_crc"=>1, "sphinx_internal_id"=>1}} > > > > > > > > > > > > > > > > > > > > > > > > > Regards, > > > > > Kumar > > > > > > > > > > > > > > > > > > > > On Mon, Jan 23, 2012 at 7:29 PM, Arun Kumar Nachimuthu > > > > > <[email protected]> wrote: > > > > > {:matches=>[{:index=>0, :doc=>33, :attributes=>{"sphinx_deleted"=>0, > > > > > "sphinx_internal_class"=>"Email", "class_crc"=>642995056, > > > > > "sphinx_internal_id"=>4}, :weight=>3}], :status=>0, :time=>0.01, > > > > > :total_found=>1, :total=>1, :words=>{"com"=>{:hits=>4493, > > > > > :docs=>3960}, "chronus"=>{:hits=>11, :docs=>11}, > > > > > "merlagautham"=>{:hits=>2, :docs=>2}}, :fields=>["address"], > > > > > :attribute_names=>["sphinx_internal_id", "sphinx_deleted", > > > > > "class_crc", "sphinx_internal_class"], > > > > > :attributes=>{"sphinx_deleted"=>1, "sphinx_internal_class"=>7, > > > > > "class_crc"=>1, "sphinx_internal_id"=>1}} > > > > > > > > > > > > > > > Regards, > > > > > Kumar > > > > > > > > > > > > > > > > > > > > > > > > > On Mon, Jan 23, 2012 at 6:42 PM, Pat Allan > > > > > <[email protected]> wrote: > > > > > > > > > > Right. What's the search you're running that's causing the error? Can > > > > > you run it with this option added: > > > > > :ids_only => true > > > > > > > > > > And we'll need to see the raw results from Sphinx: > > > > > ThinkingSphinx.search(term, :ids_only => true).results > > > > > > > > > > -- > > > > > Pat > > > > > > > > > > On 23/01/2012, at 11:58 PM, Arun Kumar Nachimuthu wrote: > > > > > > > > > > > > > > > > > here is the output for the second command > > > > > > > > > > > > > > > > > > {3922178124=>"CachedCv", 1273912828=>"Invention", > > > > > > 765557111=>"User", 3502178354=>"Inventor", 642995056=>"Email", > > > > > > 2001272654=>"Member", 1008032517=>"InventionRequest", > > > > > > 1516878456=>"SalesforceContact", > > > > > > 134992153=>"SalesforceOrganization"} > > > > > > > > > > > > > > > > > > But I got an error for the first command > > > > > > > > > > > > NoMethodError: undefined method `define_indexes' for > > > > > > ThinkingSphinx:Module > > > > > > from (irb):1 > > > > > > > > > > > > > > > > > > Regards, > > > > > > Kumar > > > > > > > > > > > > > > > > > > > > > > > > On Mon, Jan 23, 2012 at 5:43 PM, Pat Allan > > > > > > <[email protected]> wrote: > > > > > > > > > > > > Huh, right… that's not what I was expecting with this error. > > > > > > Interesting… > > > > > > > > > > > > Okay, can you try the following in script/console on your staging > > > > > > server: > > > > > > > > > > > > ThinkingSphinx.define_indexes > > > > > > ThinkingSphinx::Configuration.instance.models_by_crc > > > > > > > > > > > > What's the output of the second command? > > > > > > > > > > > > -- > > > > > > Pat > > > > > > > > > > > > On 23/01/2012, at 7:50 PM, Arun Kumar Nachimuthu wrote: > > > > > > > > > > > > > We do not use STI in any of our indexed models. > > > > > > > > > > > > > > Regards, > > > > > > > Kumar > > > > > > > > > > > > > > > > > > > > > > > > > > > > On Sun, Jan 22, 2012 at 10:43 AM, Pat Allan > > > > > > > <[email protected]> wrote: > > > > > > > > > > > > > > And are any of your models using STI? If so, are there any NULL > > > > > > > values in their type column? > > > > > > > > > > > > > > -- > > > > > > > Pat > > > > > > > > > > > > > > On 22/01/2012, at 4:08 PM, Arun Kumar Nachimuthu wrote: > > > > > > > > > > > > > > > Yes. We use ruby 1.8.7 REE and mysql 5.1 in both dev and > > > > > > > > staging. > > > > > > > > > > > > > > > > > > > > > > > > Regards, > > > > > > > > Kumar > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > On Sun, Jan 22, 2012 at 10:05 AM, Pat Allan > > > > > > > > <[email protected]> wrote: > > > > > > > > > > > > > > > > Are you using the same versions of Ruby in dev and staging? And > > > > > > > > the same databases? > > > > > > > > > > > > > > > > -- > > > > > > > > Pat > > > > > > > > > > > > > > > > On 19/01/2012, at 8:45 PM, Arun Kumar Nachimuthu wrote: > > > > > > > > > > > > > > > > > I face an issue only with my staging environment. This does > > > > > > > > > not happen > > > > > > > > > in my dev mode. > > > > > > > > > > > > > > > > > > When I try to use ThinkingSphinx.search(term), I get a > > > > > > > > > traceback like > > > > > > > > > the > > > > > > > > > > > > > > > > > > following: > > > > > > > > > > > > > > > > > > [GEM_ROOT]/gems/thinking-sphinx-1.4.11/lib/thinking_sphinx/search.rb: > > > > > > > > > 934:in `class_from_crc' > > > > > > > > > [GEM_ROOT]/gems/thinking-sphinx-1.4.11/lib/thinking_sphinx/search.rb: > > > > > > > > > 913:in `instances_from_matches' > > > > > > > > > [GEM_ROOT]/gems/activesupport-2.3.11/lib/active_support/ > > > > > > > > > ordered_hash.rb:115:in `each' > > > > > > > > > [GEM_ROOT]/gems/activesupport-2.3.11/lib/active_support/ > > > > > > > > > ordered_hash.rb:115:in `each' > > > > > > > > > [GEM_ROOT]/gems/thinking-sphinx-1.4.11/lib/thinking_sphinx/search.rb: > > > > > > > > > 911:in `instances_from_matches' > > > > > > > > > [GEM_ROOT]/gems/thinking-sphinx-1.4.11/lib/thinking_sphinx/search.rb: > > > > > > > > > 434:in `compose_results' > > > > > > > > > [GEM_ROOT]/gems/thinking-sphinx-1.4.11/lib/thinking_sphinx/search.rb: > > > > > > > > > 424:in `populate' > > > > > > > > > [GEM_ROOT]/gems/thinking-sphinx-1.4.11/lib/thinking_sphinx/search.rb: > > > > > > > > > 562:in `call' > > > > > > > > > [GEM_ROOT]/gems/thinking-sphinx-1.4.11/lib/thinking_sphinx/search.rb: > > > > > > > > > 562:in `retry_on_stale_index' > > > > > > > > > [GEM_ROOT]/gems/thinking-sphinx-1.4.11/lib/thinking_sphinx/search.rb: > > > > > > > > > 404:in `populate' > > > > > > > > > [GEM_ROOT]/gems/thinking-sphinx-1.4.11/lib/thinking_sphinx/search.rb: > > > > > > > > > 167:in `method_missing' > > > > > > > > > > > > > > > > > > > > > > > > > > > My environment: > > > > > > > > > * rails (2.3.11) > > > > > > > > > * riddle (1.5.1) as a gem > > > > > > > > > * thinking-sphinx (1.4.11) as a gem > > > > > > > > > * sphinx (2.0.3) > > > > > > > > > > > > > > > > > > Here is my sphinx.yml > > > > > > > > > > > > > > > > > > development: > > > > > > > > > stopwords: <%= RAILS_ROOT%>/config/stopwords.txt > > > > > > > > > mem_limit: 1024M > > > > > > > > > min_word_len: 3 > > > > > > > > > max_matches: 30000 > > > > > > > > > max_filter_values: 300000 > > > > > > > > > > > > > > > > > > staging: > > > > > > > > > config_file: ../../sphinx_index/staging/sphinx.conf > > > > > > > > > searchd_file_path: ../../sphinx_index/staging/ > > > > > > > > > stopwords: <%= RAILS_ROOT%>/config/stopwords.txt > > > > > > > > > mem_limit: 1024M > > > > > > > > > max_matches: 30000 > > > > > > > > > max_filter_values: 300000 > > > > > > > > > bin_path: /usr/local/bin > > > > > > > > > > > > > > > > > > > > > > > > > > > I saw in github a similar problem which got fixed for TS 2.x > > > > > > > > > version(https://github.com/freelancing-god/thinking-sphinx/issues/ > > > > > > > > > 268). I would assume this was fixed for 1.4.11 version as > > > > > > > > > well. What > > > > > > > > > might have caused this issue? > > > > > > > > > > > > > > > > > > -- > > > > > > > > > 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. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > > > > 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. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > > > > 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. > > > > > > > > > > > > > > > > > > > > > -- > > > > > > > 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. > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > > > 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. > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > > 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. > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > > 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. > > > > > > > > > > > > > > > -- > > > > > 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. > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > 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. > > > > > > > > > > > > > > > > -- > > > > 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. > > > > > > > > > > > > > > > > -- > > > > 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. > > > > > > -- > > > 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. > > > > > > > > > > > > -- > > > 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. > > > > > > > > -- > > 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. > > > > > > > > -- > > 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. > > > > -- > 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. > > > > -- > 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. -- 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.
