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