My issue turned out to be a missing index on one of the sub-tables being indexed. Once I added the index the indexer flew through the indexing process.
On Oct 9, 12:35 pm, Steve Eichert <[EMAIL PROTECTED]> wrote: > I've just encountered the same thing. I was successfully able to run > an index in my production environment a couple weeks ago, however, > I've recently redeployed some updates to the app and when I try and re- > index it gets to the Collected X,0000 docs, 0.4 MB and just stops. > > Does anyone have any suggestions for how to debug what is causing the > indexer to stop and hang? > > - Steve > > On Sep 30, 11:43 pm, Pat Allan <[EMAIL PROTECTED]> wrote: > > > Hi Derek > > > It is a bit of odd problem. First off, what's your index definition? > > Are there any potentially large multi-value attributes? > > > Cheers > > > -- > > Pat > > > On 23/09/2008, at 7:00 AM, MailerHQ wrote: > > > > My goal is to be able to perform a single search over multiple > > > unrelated models. I'll display the results and highlight the type of > > > information found (each individual model) in the results. > > > > I know I can do this because I've created a couple of tests with only > > > a handful of records in each table and then used... > > > @results = ThinkingSphinx::Search.search 'whatever' > > > > However, I find that when running thinking_sphinx:index on a table > > > with just short of 100,000 records it's hanging after the "collected' > > > stage. I'm certain this didn't happen earlier on in development when I > > > was indexing just one table. > > > > I spotted the problem when I started indexing more than one large > > > table, and thought it was related to having more than one table or > > > that there was a problem with the second table I was indexing. Having > > > stripped things back to index just the original table the problem is > > > still there. > > > > $ rake ts:index > > > ... > > > indexing index 'my_table_core'... > > > collected 88000 docs, 203.0 MB > > > > Can anyone suggest a cause or point out how I run the indexing with > > > some debugging in place? > > > > Thanks in advance, > > > Derek --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
