Finally solved the issue. Crontab was not picking any sphinx version. I made thinking sphinx as a plugin and forced it to load *require 'riddle/2.0.1'. *The problem went away after that. * * * *Regards, Kumar
On Mon, Feb 6, 2012 at 4:39 PM, Pat Allan <[email protected]> wrote: > > 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. > > -- 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.
