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.
