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.
