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