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