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