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.
