Yes, the original model was used for single table inheritance so it
required a column called 'type'. You can see it in the index definition:
define_index do
indexes :first_name, :sortable => true
indexes :last_name, :sortable => true
indexes :message
has created_at
has dist90038
where "*type* in
('ContactShow','DoctorContact','ProcedureRequest','TellUs')"
end
On Wed, Oct 16, 2013 at 8:36 AM, Pat Allan <[email protected]> wrote:
> Okay, so this is odd: class_crc for each of those records is 1240653847 -
> and yet, 'ContactArchive'.to_crc32 is 3196374234.
>
> … do you have a type column in this ContactArchive model?
>
> On 16/10/2013, at 5:38 AM, Stan Shore <[email protected]> wrote:
>
> I've got more for you. I looked up that weird error and found out that it
> is a known bug in the search command. One person said they got around it
> by adding the --noinfo option. Sure enough when I ran it that way I got
> results (I've switched back to the contact_archives table which was the one
> that I originally contacted you about):
>
> search --noinfo --config
> ~/Applications/doctvadm/config/development.sphinx.conf --index
> contact_archive_core worried
> Sphinx 2.0.9-release (rel20-r4115)
> Copyright (c) 2001-2013, Andrew Aksyonoff
> Copyright (c) 2008-2013, Sphinx Technologies Inc (http://sphinxsearch.com)
>
> using config file
> '/home/stan/Applications/doctvadm/config/development.sphinx.conf'...
> index 'contact_archive_core': query 'worried ': returned 1000 matches of
> 4284 total in 0.001 sec
>
> displaying matches:
> 1. document=649145, weight=2590, sphinx_internal_id=72127,
> sphinx_deleted=0, class_crc=1240653847, sphinx_internal_class=TellUs,
> first_name_sort=Annonymous, last_name_sort=Worried, created_at=Mon Nov 24
> 15:49:53 2008, dist90038=999999.000000
> 2. document=2610353, weight=2590, sphinx_internal_id=290039,
> sphinx_deleted=0, class_crc=1240653847, sphinx_internal_class=TellUs,
> first_name_sort=really, last_name_sort=worried, created_at=Sun May 3
> 15:15:53 2009, dist90038=999999.000000
> 3. document=624035, weight=1610, sphinx_internal_id=69337,
> sphinx_deleted=0, class_crc=1240653847, sphinx_internal_class=TellUs,
> first_name_sort=Louise Evans, last_name_sort=Evans, created_at=Fri Nov 21
> 14:45:05 2008, dist90038=999999.000000
> 4. document=899012, weight=1610, sphinx_internal_id=99890,
> sphinx_deleted=0, class_crc=1240653847, sphinx_internal_class=TellUs,
> first_name_sort=Rachelle , last_name_sort=Petitclerc, created_at=Mon Dec 15
> 19:25:37 2008, dist90038=999999.000000
> 5. document=1166717, weight=1610, sphinx_internal_id=129635,
> sphinx_deleted=0, class_crc=1240653847, sphinx_internal_class=TellUs,
> first_name_sort=tammy, last_name_sort=lessard, created_at=Sat Jan 10
> 15:40:16 2009, dist90038=999999.000000
> 6. document=3604520, weight=1610, sphinx_internal_id=400502,
> sphinx_deleted=0, class_crc=1240653847, sphinx_internal_class=TellUs,
> first_name_sort=sharon, last_name_sort=lopez, created_at=Sat Aug 29
> 00:37:52 2009, dist90038=999999.000000
> 7. document=216290, weight=1603, sphinx_internal_id=24032,
> sphinx_deleted=0, class_crc=1240653847, sphinx_internal_class=TellUs,
> first_name_sort=Amanda, last_name_sort=Simmonds, created_at=Fri Oct 10
> 18:00:24 2008, dist90038=999999.000000
> 8. document=217055, weight=1603, sphinx_internal_id=24117,
> sphinx_deleted=0, class_crc=1240653847, sphinx_internal_class=TellUs,
> first_name_sort=Anna-Maria, last_name_sort=Martin, created_at=Fri Oct 10
> 19:35:08 2008, dist90038=999999.000000
> 9. document=352919, weight=1603, sphinx_internal_id=39213,
> sphinx_deleted=0, class_crc=2362243532,
> sphinx_internal_class=ProcedureRequest, first_name_sort=Melanie,
> last_name_sort=Roy, created_at=Wed Oct 29 19:48:12 2008,
> dist90038=999999.000000
> 10. document=611759, weight=1603, sphinx_internal_id=67973,
> sphinx_deleted=0, class_crc=1240653847, sphinx_internal_class=TellUs,
> first_name_sort=Jackie, last_name_sort=Vella, created_at=Thu Nov 20
> 16:26:23 2008, dist90038=999999.000000
> 11. document=867350, weight=1603, sphinx_internal_id=96372,
> sphinx_deleted=0, class_crc=1240653847, sphinx_internal_class=TellUs,
> first_name_sort=natashia, last_name_sort=mews, created_at=Thu Dec 11
> 13:44:31 2008, dist90038=999999.000000
> 12. document=1090136, weight=1603, sphinx_internal_id=121126,
> sphinx_deleted=0, class_crc=1240653847, sphinx_internal_class=TellUs,
> first_name_sort=Darren, last_name_sort=Hamilton, created_at=Mon Jan 5
> 18:37:01 2009, dist90038=999999.000000
> 13. document=1092827, weight=1603, sphinx_internal_id=121425,
> sphinx_deleted=0, class_crc=1829651295,
> sphinx_internal_class=DoctorContact, first_name_sort=Daphne,
> last_name_sort=Sheehan, created_at=Mon Jan 5 19:55:36 2009,
> dist90038=999999.000000
> 14. document=1285616, weight=1603, sphinx_internal_id=142846,
> sphinx_deleted=0, class_crc=1240653847, sphinx_internal_class=TellUs,
> first_name_sort=Shannon, last_name_sort=Berger, created_at=Thu Jan 22
> 10:27:17 2009, dist90038=999999.000000
> 15. document=1382537, weight=1603, sphinx_internal_id=153615,
> sphinx_deleted=0, class_crc=1829651295,
> sphinx_internal_class=DoctorContact, first_name_sort=Ginny,
> last_name_sort=Naviello, created_at=Wed Jan 28 21:43:01 2009,
> dist90038=999999.000000
> 16. document=1705232, weight=1603, sphinx_internal_id=189470,
> sphinx_deleted=0, class_crc=1829651295,
> sphinx_internal_class=DoctorContact, first_name_sort=Amy,
> last_name_sort=Edwards, created_at=Mon Feb 23 06:41:22 2009,
> dist90038=999999.000000
> 17. document=1838666, weight=1603, sphinx_internal_id=204296,
> sphinx_deleted=0, class_crc=1240653847, sphinx_internal_class=TellUs,
> first_name_sort=Amanda, last_name_sort=Abraham, created_at=Thu Mar 5
> 23:38:42 2009, dist90038=999999.000000
> 18. document=2045162, weight=1603, sphinx_internal_id=227240,
> sphinx_deleted=0, class_crc=1240653847, sphinx_internal_class=TellUs,
> first_name_sort=Shanen, last_name_sort=Phillips, created_at=Tue Mar 24
> 16:48:04 2009, dist90038=999999.000000
> 19. document=2542052, weight=1603, sphinx_internal_id=282450,
> sphinx_deleted=0, class_crc=1240653847, sphinx_internal_class=TellUs,
> first_name_sort=Ramona, last_name_sort=Dominguez, created_at=Tue Apr 28
> 15:16:32 2009, dist90038=999999.000000
> 20. document=2565101, weight=1603, sphinx_internal_id=285011,
> sphinx_deleted=0, class_crc=1240653847, sphinx_internal_class=TellUs,
> first_name_sort=Camilla, last_name_sort=Salomonsson, created_at=Wed Apr 29
> 17:40:17 2009, dist90038=999999.000000
>
> words:
> 1. 'worried': 4284 documents, 4668 hits
>
> As you can see, Sphinx is successfully finding the search term that
> Thinking Sphinx is not (after starting the demon and loading the console):
>
> >> ContactArchive.search 'worried'
> => []
>
> And, again, a mysql query returns similar results:
>
> mysql> select count(*) from contact_archives where message like
> '%worried%';
> +----------+
> | count(*) |
> +----------+
> | 4287 |
> +----------+
> 1 row in set (0.18 sec)
>
> Thoughts?
>
>
> On Tue, Oct 15, 2013 at 2:21 PM, Stan Shore <[email protected]> wrote:
>
>> I set up a test table with one row in it to try and simplify things (as
>> well as eliminate the effects of pt-archiver, which was use to archive the
>> records). After indexing the table I ran Sphinx's indextool on the word
>> worried and got the following:
>>
>> indextool --config ~/Applications/doctvadm/config/development.sphinx.conf
>> --dumphitlist contact_test_core worried
>> Sphinx 2.0.9-release (rel20-r4115)
>> Copyright (c) 2001-2013, Andrew Aksyonoff
>> Copyright (c) 2008-2013, Sphinx Technologies Inc (http://sphinxsearch.com
>> )
>>
>> using config file
>> '/home/stan/Applications/doctvadm/config/development.sphinx.conf'...
>> dumping hitlist for index 'contact_test_core' keyword 'worried'...
>> keyword=worried, tok=worried, wordid=443981280
>> doc=12, hit=0x02000014
>>
>> One hit -- exactly correct, so the index was built properly (using rake
>> ts:index).
>>
>> When I tried to search for worried, however:
>>
>> search --config ~/Applications/doctvadm/config/development.sphinx.conf
>> --index contact_test_core worried
>> Sphinx 2.0.9-release (rel20-r4115)
>> Copyright (c) 2001-2013, Andrew Aksyonoff
>> Copyright (c) 2008-2013, Sphinx Technologies Inc (http://sphinxsearch.com
>> )
>>
>> using config file
>> '/home/stan/Applications/doctvadm/config/development.sphinx.conf'...
>> index 'contact_test_core': search error: .
>>
>> I got a search error. The error message ('.') was kinda useless. But
>> I'm not sure that this search was meaningful because if I run the same
>> search on the table that is working in the console I still get the error:
>>
>> search --config ~/Applications/doctvadm/config/development.sphinx.conf
>> --index contact_info_core worried
>> Sphinx 2.0.9-release (rel20-r4115)
>> Copyright (c) 2001-2013, Andrew Aksyonoff
>> Copyright (c) 2008-2013, Sphinx Technologies Inc (http://sphinxsearch.com
>> )
>>
>> using config file
>> '/home/stan/Applications/doctvadm/config/development.sphinx.conf'...
>> index 'contact_info_core': search error: .
>>
>> In fact I get the same error if I don't specify any index at all (forcing
>> a search on all indexes):
>>
>> search --config ~/Applications/doctvadm/config/development.sphinx.conf
>> worriedSphinx 2.0.9-release (rel20-r4115)
>> Copyright (c) 2001-2013, Andrew Aksyonoff
>> Copyright (c) 2008-2013, Sphinx Technologies Inc (http://sphinxsearch.com
>> )
>>
>> using config file
>> '/home/stan/Applications/doctvadm/config/development.sphinx.conf'...
>> index 'ce_forum_core': search error: .
>>
>> Which leads to two questions:
>>
>> - Am I constructing the sphinx search command incorrectly?
>> - Is the version of sphinx that I'm using (2.0.9) incompatible with
>> Thinking Sphinx 1.5.0?
>>
>> I'm sorry that I cannot set up a stripped-down example for you but there
>> are client-related restrictions that would make that extremely difficult.
>> I am absolutely mystified by these problems. It seems that since I
>> upgraded Sphinx and Thinking Sphinx only tables whose indexes were defined
>> before the upgrades can be re-indexed. I know that make no sense as I have
>> been deleted the configuration file and recreating it from scratch but it
>> also make no sense that for three table with identical setups
>> (contact_infos, contact_archives and contact_test) only the original can be
>> searched (although clearly all 3 are getting indexed).
>>
>> Thanks again for all your help.
>>
>>
>>
>>
>> On Mon, Oct 14, 2013 at 7:38 PM, Pat Allan <[email protected]>wrote:
>>
>>> I don't think so - but 1.4.10 was released a *long* time ago, so it's
>>> hard to be certain. I'm pretty sure the latest versions of dependencies
>>> will work with 1.5.0 though.
>>>
>>> On 15/10/2013, at 2:24 AM, Stan Shore <[email protected]> wrote:
>>>
>>> Are there any limitations on the version of Riddle for 2.3? Any of the
>>> other gem dependencies?
>>>
>>>
>>>
>>> On Fri, Oct 11, 2013 at 7:57 PM, Pat Allan <[email protected]>wrote:
>>>
>>>> Hi Stan
>>>>
>>>> Is there any chance you could create a basic test app that reproduces
>>>> the issue? I can't see any reason why the behaviour would be different, and
>>>> it's a bit hard to debug any further without access to either your app or a
>>>> test app that has the same problem.
>>>>
>>>> With regards to gem versions, you can't use anything that's 2.x or 3.x
>>>> - so, the latest that's friendly for Rails 2.3 is 1.5.0.
>>>>
>>>> --
>>>> Pat
>>>>
>>>> On 12/10/2013, at 3:41 AM, Stan Shore <[email protected]> wrote:
>>>>
>>>> I wanted to give you a little more info. I recreated this archived
>>>> table on my test server (I was originally working on my development
>>>> machine) and encountered the same results! The Thinking Sphinx version was
>>>> the same, the Sphinx version was different (2.0.9 on my dev machine, 0.9.9
>>>> on the test server). I don't know that this info helps, but I just wanted
>>>> you to know.
>>>>
>>>> Regards,
>>>>
>>>> Stan
>>>>
>>>>
>>>> On Fri, Oct 11, 2013 at 12:09 PM, Stan Shore <[email protected]>wrote:
>>>>
>>>>> It doesn't get any simpler. The index definitions are identical:
>>>>>
>>>>> define_index do
>>>>> indexes :first_name, :sortable => true
>>>>> indexes :last_name, :sortable => true
>>>>> indexes :message
>>>>>
>>>>> has created_at
>>>>> has dist90038
>>>>>
>>>>> where "type in
>>>>> ('ContactShow','DoctorContact','ProcedureRequest','TellUs')"
>>>>>
>>>>> end
>>>>>
>>>>> By the way, I tried removing the has statements and the where
>>>>> statement and reconfiguring and reindexing with the same results. Even if
>>>>> I try the simplest search:
>>>>>
>>>>> ContactInfo.search('worried')
>>>>> ContactArchive.search('worried')
>>>>>
>>>>> The first one works, the second one doesn't.
>>>>>
>>>>> Seems crazy but there it is.
>>>>>
>>>>> I'm wondering about versions. What gem version for Thinking Sphinx
>>>>> and Riddle should I be using for Rails 2.3.15?
>>>>>
>>>>> Regards,
>>>>>
>>>>> Stan
>>>>>
>>>>>
>>>>>
>>>>> On Wed, Oct 9, 2013 at 11:39 PM, Pat Allan
>>>>> <[email protected]>wrote:
>>>>>
>>>>>> Can you show us the index definitions for both models, and the
>>>>>> queries you're running?
>>>>>>
>>>>>> On 09/10/2013, at 4:28 AM, stasch <[email protected]> wrote:
>>>>>>
>>>>>> I've got two tables in the same database that are identical in
>>>>>> structure - columns, indexes, permissions (one is an archive of the
>>>>>> other). The model files are not identical but the associations and index
>>>>>> declarations are. The archive model contains a subset of the
>>>>>> functionality
>>>>>> of the original, but I have already gone so far as to reduce the model
>>>>>> file
>>>>>> for the archive to just the associations and index declarations. When I
>>>>>> rebuild the indexes after deleting all files in the index directory both
>>>>>> models are processed without complaint. The index files are created
>>>>>> with
>>>>>> identical permissions. But when I do a simple search (for the word
>>>>>> 'worried') on each the original file returns many results, the archive
>>>>>> file
>>>>>> returns no results. When I use the error method to check for errors on
>>>>>> the
>>>>>> result set it returns nil. When I look in the query log it shows that
>>>>>> the
>>>>>> query was successfully executed and returned 0 results. But when I do a
>>>>>> sql query on the indexed field in the archive file it returns over 3000
>>>>>> results (select count(*) from contact_archive where message like '%
>>>>>> worried
>>>>>> %').
>>>>>>
>>>>>> My environment is Ruby 1.8.7, Rails 2.3.15 and Thinking Sphinx
>>>>>> 1.4.10. Any help would be greatly appreciated.
>>>>>>
>>>>>> --
>>>>>> You received this message because you are subscribed to the Google
>>>>>> Groups "Thinking Sphinx" group.
>>>>>> To unsubscribe from this group and stop receiving emails from it,
>>>>>> send an email to [email protected].
>>>>>> To post to this group, send email to [email protected]
>>>>>> .
>>>>>> Visit this group at http://groups.google.com/group/thinking-sphinx.
>>>>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> You received this message because you are subscribed to a topic in
>>>>>> the Google Groups "Thinking Sphinx" group.
>>>>>> To unsubscribe from this topic, visit
>>>>>> https://groups.google.com/d/topic/thinking-sphinx/tVmRxNDkM3M/unsubscribe
>>>>>> .
>>>>>> To unsubscribe from this group and all its topics, send an email to
>>>>>> [email protected].
>>>>>> To post to this group, send email to [email protected]
>>>>>> .
>>>>>> Visit this group at http://groups.google.com/group/thinking-sphinx.
>>>>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>>>>
>>>>>
>>>>>
>>>>
>>>> --
>>>> You received this message because you are subscribed to the Google
>>>> Groups "Thinking Sphinx" group.
>>>> To unsubscribe from this group and stop receiving emails from it, send
>>>> an email to [email protected].
>>>> To post to this group, send email to [email protected].
>>>> Visit this group at http://groups.google.com/group/thinking-sphinx.
>>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>>
>>>>
>>>>
>>>> --
>>>> You received this message because you are subscribed to a topic in the
>>>> Google Groups "Thinking Sphinx" group.
>>>> To unsubscribe from this topic, visit
>>>> https://groups.google.com/d/topic/thinking-sphinx/tVmRxNDkM3M/unsubscribe
>>>> .
>>>> To unsubscribe from this group and all its topics, send an email to
>>>> [email protected].
>>>> To post to this group, send email to [email protected].
>>>> Visit this group at http://groups.google.com/group/thinking-sphinx.
>>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>>
>>>
>>>
>>> --
>>> You received this message because you are subscribed to the Google
>>> Groups "Thinking Sphinx" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to [email protected].
>>> To post to this group, send email to [email protected].
>>> Visit this group at http://groups.google.com/group/thinking-sphinx.
>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>
>>>
>>>
>>> --
>>> You received this message because you are subscribed to a topic in the
>>> Google Groups "Thinking Sphinx" group.
>>> To unsubscribe from this topic, visit
>>> https://groups.google.com/d/topic/thinking-sphinx/tVmRxNDkM3M/unsubscribe
>>> .
>>> To unsubscribe from this group and all its topics, send an email to
>>> [email protected].
>>> To post to this group, send email to [email protected].
>>> Visit this group at http://groups.google.com/group/thinking-sphinx.
>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>
>>
>>
>
> --
> You received this message because you are subscribed to the Google Groups
> "Thinking Sphinx" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> To post to this group, send email to [email protected].
> Visit this group at http://groups.google.com/group/thinking-sphinx.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
> --
> You received this message because you are subscribed to a topic in the
> Google Groups "Thinking Sphinx" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/thinking-sphinx/tVmRxNDkM3M/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> [email protected].
> To post to this group, send email to [email protected].
> Visit this group at http://groups.google.com/group/thinking-sphinx.
> For more options, visit https://groups.google.com/groups/opt_out.
>
--
You received this message because you are subscribed to the Google Groups
"Thinking Sphinx" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/thinking-sphinx.
For more options, visit https://groups.google.com/groups/opt_out.
