Definitely an odd issue. I'd recommend calling your id field something else...
indexes :id, :as => :model_id Or something like that, see if that helps, because having two columns called the same thing will likely confuse Sphinx (although why that's only started to happen now, I've got no idea). Also, if you're copying the index files across, perhaps copy the config file across as well? The more I think about it, the more I think the confs being in different orders could be the cause - TS calculates an offset for each document to ensure there's unique ids, and that's based on the number of indexed models, and the order of them according to TS. It has recently come up on this list a week or so ago, that different orders means different offsets, and so that could be what's screwing things up. I'll try to find time to patch things to ensure the ordering is consistent (ie: alphabetical), but that might not happen super-quick. In the meantime, copy the conf file across as well. -- Pat On 24/08/2009, at 5:40 PM, Alan wrote: > > I'm running into some very inconsistent behavior, and I'm trying to > track down the potential culprit. > > The situation is that on multiple machines(linux distros) running the > same sphinx binaries/ts plugin, on one machine the index seems to be > missing a good chunk of data(this *seems* to have just happened out of > no where). It looks to be an issue with the indexer as when I copy > over the indices from the good to bad instances, ThinkingSphinx starts > to return the right information. The only thing i can spot is that the > conf files have models listed in different orders. > > somebody pointed out that I was indexing an "id" field, and the conf > file has sql that generates output with two id fields because of it. > This wouldn't explain why it works on the one machine and not the > other, but juuust in case it matters? > > Has anyone experienced similar problems give the symptoms I have > given? > > To recap, here are the things that I think might be potential issues. > 1. Is it problematic to index an ID field? > 2. Any chance that the order of models in a conf file cause this sort > of issue? > 3. I also noticed the model.spa file on the "bad" machine seems to be > a lot larger. > > Note that I'm running the same sphinx binaries/ts plugin, and the > second machine that works is working against a dump file from the > first machine(that stopped indexing correctly all of a sudden). > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
