Ok, so, I figured out the issue. Unfortunately, it wasn't directly related to any of the suggestions, but the suggestions got me on the right track.
I keep my index in a shared folder so that it doesn't have to be rebuilt for every deploy. As a result, I need to do some symlinking like Wade mentions in this article ->http://www.updrift.com/article/deploying-a-rails-app-with-thinking-sphinx . Unfortunately, I had a couple of copy/paste errors with that symlink task and stopping/starting the search daemon that worked together just right to throw things into disarray without completely breaking down. The index essentially ended up being hidden from the search daemon after a deploy. All is well now, and I'm hoping to write up an extensive post about the trials and tribulations within the next week or so. Thanks for all of the help, Pat. TS is fantastic, and I couldn't be happier with it. Cheers, Garrett On Feb 5, 2009, at 4:40 AM, Pat Allan wrote: > > Hi Garrett > > Apparently (for passenger) the rake tasks are fine, but within a Rails > app there's a different path? > > If you find out the location of your searchd and indexer tools using > 'which searchd', then set bin_path to that, hopefully from then on, > you'll see indexer output. > > eg, on my mac: > # which searchd > /usr/local/bin/searchd > > then in config/sphinx.yml > > production: > bin_path: "/usr/local/bin/" > > Cheers > > -- > Pat > > On 05/02/2009, at 11:37 AM, Garrett Dimon wrote: > >> >> Hmm. I am not seeing the indexing output after creating or deleting >> indexed records. >> >> So the path issue may be the problem. However, the indexing rake >> tasks >> run fine, and anytime I run the index, all of the changes show up in >> the search results. >> >> How would I go about verifying if it is a path issue? >> >> Thanks, >> Garrett >> >> On Feb 4, 2009, at 10:22 PM, Pat Allan wrote: >> >>> >>> Just to elaborate on my thinking - it could be a PATH issue, which >>> apparently happens on some passenger-run installations. You might >>> need >>> to set bin_path in config/sphinx.yml (settings per environment, like >>> config/database.yml) - but if you're seeing the sphinx indexing >>> output >>> when you create a model, then this isn't the problem... >>> >>> -- >>> Pat >>> >>> On 05/02/2009, at 11:16 AM, Pat Allan wrote: >>> >>>> >>>> Just to confirm, are you seeing the delta processing output on >>>> production? >>>> >>>> -- >>>> Pat >>>> >>>> On 05/02/2009, at 11:13 AM, Garrett Dimon wrote: >>>> >>>>> >>>>> Yes, I saw the other thread, but I wasn't sure if it was related >>>>> or >>>>> not. In production (hosted at Rails Machine), where I'm >>>>> encountering >>>>> the problem, the results are: >>>>> >>>>> ------------------------ >>>>> >>>>> Sphinx 0.9.8.1-release (r1533) >>>>> Copyright (c) 2001-2008, Andrew Aksyonoff >>>>> >>>>> using config file 'config/production.sphinx.conf'... >>>>> index 'issue_delta': query '': returned 0 matches of 0 total in >>>>> 0.000 >>>>> sec >>>>> >>>>> words: >>>>> >>>>> ------------------------ >>>>> >>>>> In development(Running on Leopard), where it seems to be working >>>>> correctly, I appear to be getting what I presume would be normal >>>>> results... >>>>> >>>>> ------------------------ >>>>> >>>>> Sphinx 0.9.8.1-release (r1533) >>>>> Copyright (c) 2001-2008, Andrew Aksyonoff >>>>> >>>>> using config file 'config/development.sphinx.conf'... >>>>> index 'issue_delta': query '': returned 7 matches of 7 total in >>>>> 0.000 >>>>> sec >>>>> >>>>> displaying matches: >>>>> 1. document=780633885, weight=1, id=780633885, created_at=Sun Nov >>>>> 16 >>>>> 20:30:42 2008, updated_at=Sun Feb 1 22:18:16 2009, >>>>> project_id=587538417, status_id=1, priority_id=3, >>>>> opener_id=222450192, >>>>> assignee_id=963567508, account_id=304507787, >>>>> sphinx_internal_id=780633885, class_crc=3547073594, >>>>> subclass_crcs=(3547073594), sphinx_deleted=0 >>>>> id=780633885 >>>>> subject=In hac habitasse platea dictumst >>>>> description=Lorem ipsum dolor sit amet, consectetuer adipiscing >>>>> elit. >>>>> Cras mi quam, scelerisque a, adipiscing id, auctor ac, metus. >>>>> Maecenas >>>>> pellentesque ipsum in tortor. In hac habitasse platea dictumst. >>>>> Duis >>>>> dapibus. Duis dictum, quam et porttitor malesuada, sapien massa >>>>> fermentum dolor, non tincidunt lorem dolor vel tellus. Aenean a >>>>> libero >>>>> ut arcu ullamcorper posuere. Maecenas euismod. Curabitur neque. >>>>> Etiam >>>>> eu tellus nec est viverra mollis. Aliquam sagittis sagittis >>>>> tortor. >>>>> assignee_id=963567508 >>>>> opener_id=222450192 >>>>> category_id=63742976 >>>>> project_id=587538417 >>>>> created_at=2008-11-16 20:30:42 >>>>> updated_at=2009-02-01 22:18:16 >>>>> deleted_at=(null) >>>>> number=2 >>>>> account_id=304507787 >>>>> status_id=1 >>>>> priority_id=3 >>>>> delta=1 >>>>> >>>>> >>>>> ------------------------ >>>>> >>>>> >>>>> On Feb 4, 2009, at 9:52 PM, Pat Allan wrote: >>>>> >>>>>> >>>>>> Hi Garrett >>>>>> >>>>>> Going by another recent thread, you're definitely not the only >>>>>> one >>>>>> having this problem. I appreciate the research you've already >>>>>> done - >>>>>> although the results aren't giving me much to go off. >>>>>> >>>>>> Next step is to test outside of Ruby, I guess. Once Sphinx is >>>>>> running, >>>>>> try the following (assuming from RAILS_ROOT): >>>>>> >>>>>> search --config config/development.sphinx.conf --index >>>>>> issue_delta >>>>>> phrase >>>>>> >>>>>> What's the output? >>>>>> >>>>>> Cheers >>>>>> >>>>>> -- >>>>>> Pat >>>>>> >>>>>> On 05/02/2009, at 7:51 AM, Garrett Dimon wrote: >>>>>> >>>>>>> >>>>>>> I've been running Thinking Sphinx for a couple of days now, >>>>>>> and I >>>>>>> keep >>>>>>> running into situations where the Delta Index isn't happening. >>>>>>> The >>>>>>> kicker is that it will occasionally work. (It seems to be after >>>>>>> deploys, but I can't say for sure whether that's just >>>>>>> coincidence.) >>>>>>> >>>>>>> Here's all of the relevant information that I can think of and >>>>>>> things >>>>>>> that I've tried so far... >>>>>>> >>>>>>> - I've tried giving it a minute or two to see if the delta is >>>>>>> just >>>>>>> lagging, but that results still didn't show up. >>>>>>> - It appears that database record is being updated correctly and >>>>>>> setting the delta column, however the results aren't showing up >>>>>>> unless >>>>>>> I reindex. >>>>>>> - I've gone into script/console, manually created a client and >>>>>>> searched for the phrase in the delta using >>>>>>> client.query("phrase", >>>>>>> "issue_delta") where issue is my model. That returned no >>>>>>> results, >>>>>>> but >>>>>>> an ActiveRecord find did turn up the result and the delta was >>>>>>> set >>>>>>> to >>>>>>> true. >>>>>>> >>>>>>> The problem has come and gone, but most recently it seems like >>>>>>> it's >>>>>>> sticking around. So, given that I haven't been able to find the >>>>>>> solution anywhere else, I figured this was my best bet. >>>>>>> >>>>>>> Thanks in advance for any help provided. >>>>>>> >>>>>>>> >>>>>> >>>>>> >>>>>>> >>>>> >>>>> >>>>>> >>>> >>>> >>>>> >>> >>> >>>> >> >> >>> > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
