Hi Pat, Thanks for taking a gander. I took everything out of the object except for a single index which still erred, however once I removed all of the other fields from the table everything worked. Now I'm adding the fields back one by one to see if I can pin point which one caused any trouble. Would it be possible a mysql index could have caused a conflict?
Thanks On May 19, 5:06 pm, Pat Allan <[email protected]> wrote: > Hi Jake > > Just been looking over your original config - there's a lot there! > > I'd try add some fields and attributes back in, bit by bit. See if > there's some point where it doesn't work anymore. I know it's a bit > fiddly, but I had to do this a week or so ago on someone else's data. > Get two terminals going, one in script/console for testing, the other > with all the rake tasks lined up: > rake ts:stop ts:in ts:start > > That way, you make the change to the index, save the file, run the > rake task line, then run the test query in script/console. > > The symbols or method calls should both work fine, provided it's not > an existing method on Object (and there's nothing in the config that > stood out to me). > > Cheers > > -- > Pat > > On 19/05/2009, at 12:02 PM, Jacob wrote: > > > > > > > Well I just ripped everything out of my model and table leaving me > > with nothing but a single column. > > > class Property < ActiveRecord::Base > > define_index do > > indexes :listing_number > > end > > end > > > And suddenly the indexes start working again. Are their specific > > column names that I should be avoiding, or would the type/default/ > > nullable combo be the culprit? > > > Best > > Jake > > > On May 19, 12:34 pm, Jacob <[email protected]> wrote: > >> I was a bit wary of the tutorial using variables rather then symbols, > >> but I just went with it. > >> I did go back and double check the single index on my users table and > >> it turns out it is indexing and I can search. > > >> As for the table that is not indexing, I removed everything from > >> define_index except a single index, using a symbol for the field. I > >> tried stopping sphinx, deleting db/sphinx, indexing and starting, > >> again with no luck. Here is the output and a pastie of the schema. I > >> cannot share the model, but is there something I should be looking > >> for? I'll take gander to see if my model is redefining any sphinx > >> methods. > > >> Table:http://pastie.org/private/v8yfsooycac2jxxx4lz7cg > >> Updated Sphinx conf:http://pastie.org/483000 > > >> Thanks > > >> jacobbas...@dude:~/src/smart$ rake ts:stop > >> (in /home/jacobbasham/src/smart) > >> Sphinx 0.9.8.1-release (r1533) > >> Copyright (c) 2001-2008, Andrew Aksyonoff > > >> using config file '/home/jacobbasham/src/smart/config/ > >> development.sphinx.conf'... > >> stop: succesfully sent SIGTERM to pid 32212 > >> Stopped search daemon (pid 32212). > > >> jacobbas...@dude:~/src/smart$ rm -rf db/sphinx/ > > >> jacobbas...@dude:~/src/smart$ rake ts:index > >> (in /home/jacobbasham/src/smart) > >> Generating Configuration to /home/jacobbasham/src/smart/config/ > >> development.sphinx.conf > >> indexer --config /home/jacobbasham/src/smart/config/ > >> development.sphinx.conf --all > >> Sphinx 0.9.8.1-release (r1533) > >> Copyright (c) 2001-2008, Andrew Aksyonoff > > >> using config file '/home/jacobbasham/src/smart/config/ > >> development.sphinx.conf'... > >> indexing index 'property_core'... > >> collected 700 docs, 0.0 MB > >> collected 0 attr values > >> sorted 0.0 Mvalues, 100.0% done > >> sorted 0.0 Mhits, 100.0% done > >> total 700 docs, 5600 bytes > >> total 0.031 sec, 182898.94 bytes/sec, 22862.37 docs/sec > >> distributed index 'property' can not be directly indexed; skipping. > >> indexing index 'user_core'... > >> collected 45204 docs, 0.0 MB > >> collected 0 attr values > >> sorted 0.0 Mvalues, 100.0% done > >> sorted 0.0 Mhits, 100.0% done > >> total 45204 docs, 423 bytes > >> total 0.152 sec, 2782.16 bytes/sec, 297316.49 docs/sec > >> distributed index 'user' can not be directly indexed; skipping. > > >> jacobbas...@dude:~/src/smart$ rake ts:start > >> (in /home/jacobbasham/src/smart) > >> searchd --pidfile --config /home/jacobbasham/src/smart/config/ > >> development.sphinx.conf > >> Sphinx 0.9.8.1-release (r1533) > >> Copyright (c) 2001-2008, Andrew Aksyonoff > > >> using config file '/home/jacobbasham/src/smart/config/ > >> development.sphinx.conf'... > >> creating server socket on 127.0.0.1:3312 > >> Started successfully (pid 705). > > >> jacobbas...@dude:~/src/smart$ script/console > >> Loading development environment (Rails 2.1.0)>> > >> User.search("[email protected]").first.email > > >> => "[email protected]" > > >>>> Property.first(:conditions => "listing_number is not > >>>> null").listing_number > >> => "06430044" > >>>> Property.search("06430044") > > >> => [] > > >> On May 19, 10:44 am, aitrus <[email protected]> wrote: > > >>> My first inclination would be to try referencing the column names as > >>> symbols. IE, > > >>> indexes :listing_number > > >>> rather than, > > >>> indexes listing_number > > >>> If that still doesn't do the trick, I'd remove the "bitmask" portion > >>> and do a rake ts:stop/index/start, and post the output plus your > >>> table > >>> structure and the model and I'll peek at it some more. > > >>> Scott > > >>> On May 19, 7:22 am, Jacob <[email protected]> wrote: > > >>>> Scott, > > >>>> My original define_index has grown to have some fancy other > >>>> options I > >>>> had to add in (so I can easily index a bitmask) so it will look a > >>>> bit > >>>> funny. Although I have tried ripping everything out but a single > >>>> indexed field, as well as indexing a single field on a different > >>>> model. > > >>>> fancy index:http://pastie.org/482782 > >>>> generated config:http://pastie.org/482784 > > >>>> The second 'test' index is a basic > > >>>> define_index do > >>>> indexes email > >>>> end > > >>>> Jake > > >>>> On May 19, 12:48 am, aitrus <[email protected]> wrote: > > >>>>> Can you pastie your define_index statements, and your table > >>>>> schema? > >>>>> Can ;you also pastie your sphinx.conf that's generated? > > >>>>> Be sure to check the name of your columns. Some may conflict with > >>>>> reserved words in Ruby / Sphinx / whatever. > > >>>>> Also, test your define_index first, with one or two columns and no > >>>>> other fancy options. > > >>>>> Scott > > >>>>> On May 18, 10:21 am, Jacob <[email protected]> wrote: > > >>>>>> This is probably more a question for the Sphinx forum, but I'll > >>>>>> ask > >>>>>> here first. I have defined indexes for two of my models and was > >>>>>> able > >>>>>> to index a couple weeks back. Now when I try and index it looks > >>>>>> like > >>>>>> Sphinx is finding the documents, but isn't indexing anything. The > >>>>>> physical size of the collected documents also looks to be very > >>>>>> off. > >>>>>> I've tried Googling for days and haven't been able to find any > >>>>>> leads. > >>>>>> Does this mean the indexing query is not returning any rows? > > >>>>>> Thanks > >>>>>> Jake > > >>>>>> indexing index 'property_core'... > >>>>>> collected 700 docs, 0.2 MB > >>>>>> collected 0 attr values > >>>>>> sorted 0.0 Mvalues, 100.0% done > >>>>>> sorted 0.0 Mhits, 100.0% done > >>>>>> total 700 docs, 212855 bytes > >>>>>> total 0.144 sec, 1482617.91 bytes/sec, 4875.77 docs/sec > >>>>>> distributed index 'property' can not be directly indexed; > >>>>>> skipping. > >>>>>> indexing index 'user_core'... > >>>>>> collected 45204 docs, 0.0 MB > >>>>>> collected 0 attr values > >>>>>> sorted 0.0 Mvalues, 100.0% done > >>>>>> sorted 0.0 Mhits, 100.0% done > >>>>>> total 45204 docs, 423 bytes > >>>>>> total 0.151 sec, 2795.51 bytes/sec, 298743.00 docs/sec > >>>>>> distributed index 'user' can not be directly indexed; skipping. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
