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