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 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.
