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.
