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.
