Okay, the data looks right - if that's straight after a ts:in call,  
yeah (ie: the one change it shows is the object you created)?

Can you try the following in script/console:

Post.create(:text => "barboo")
client = Riddle::Client.new "localhost", 3312 # change if necessary
client.query("barboo", "post_delta")

Also, how old is the version of TS you're using?

-- 
Pat

On 04/02/2009, at 2:39 PM, Ryan Bigg wrote:

>
> This is the output from when I create:
>
>>> Post.create(:text => "barboo")
> Sphinx 0.9.8-release (r1371)
> Copyright (c) 2001-2008, Andrew Aksyonoff
>
> using config file '/Users/ryanbigg/Sites/rboard/config/
> production.sphinx.conf'...
> indexing index 'post_delta'...
> collected 1 docs, 0.0 MB
> collected 0 attr values
> sorted 0.0 Mvalues, nan% done
> total 1 docs, 0 bytes
> total 0.024 sec, 0.00 bytes/sec, 41.23 docs/sec
> rotating indices: succesfully sent SIGHUP to searchd (pid=19356).
> => #<Post id: 20799, text: "barboo",>
>>> sleep(2)
>>> Post.search("barboo")
> => []
>
>
>
>
>
>
>
>
> On 04/02/2009, at 1:22 PM, Pat Allan wrote:
>
>>
>> If you're seeing the output, then it's not a PATH issue, because
>> you're able to access the tools. What's the output of the delta
>> indexing?
>>
>> (And overnight is overkill - my cucumber tests wait a second or two)
>>
>> -- 
>> Pat
>>
>> On 04/02/2009, at 4:57 AM, Ryan Bigg wrote:
>>
>>>
>>> Yeah I'm seeing the delta indexing message come up when I insert and
>>> delete a record. I've left it overnight and tried running it again
>>> this morning but it's not finding the record.
>>>
>>> Solomon, what did you use to add it to the PATH?
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> On 04/02/2009, at 12:16 AM, Pat Allan wrote:
>>>
>>>>
>>>> Hi Ryan
>>>>
>>>> One other thing to keep in mind - Sphinx takes a few seconds to
>>>> catch
>>>> up between delta indexing and results being available. So when
>>>> you're
>>>> running search after create, allow for that in testing.
>>>>
>>>> That said, you should probably be seeing the output of the delta
>>>> index
>>>> (although in the log instead of console? Can't remember, and it's
>>>> late), so Solomon's suggestion sounds like a good place to start.
>>>>
>>>> Cheers
>>>>
>>>> -- 
>>>> Pat
>>>>
>>>> On 03/02/2009, at 8:13 PM, Solomon White wrote:
>>>>
>>>>> Ryan--
>>>>>
>>>>> What is your environment?  This sounds exactly like what I was
>>>>> seeing, and my problem turned out to be that the command to rotate
>>>>> the indexes was not in the PATH whilst running under Phusion
>>>>> Passenger.
>>>>>
>>>>>
>>>>> Hope this helps,
>>>>>
>>>>> Solomon
>>>>>
>>>>> On Tue, Feb 3, 2009 at 2:52 AM, Ryan Bigg  
>>>>> <[email protected]>
>>>>> wrote:
>>>>>
>>>>> I'm trying to do a search on recently created posts and this
>>>>> appears
>>>>> not to work when I have set_property :delta => true (it also has
>>>>> indexes :text) on my post model. I do the following:
>>>>>
>>>>> rake ts:in
>>>>> script/console
>>>>>>> Post.search("foobar")
>>>>> => []
>>>>>>> Post.create(:text => "foobar")
>>>>> => <Post object>
>>>>>>> Post.search("foobar")
>>>>> => []
>>>>>
>>>>> Why does the second search return nothing? I thought delta- 
>>>>> indexing
>>>>> was supposed to pick up that kind of stuff?
>>>>>
>>>>> What's even stranger is that when I exit out of script/console and
>>>>> then run rake ts:in, the post is shown in the search results:
>>>>>
>>>>> rake ts:in
>>>>> script/console
>>>>>>> Post.search("foobar")
>>>>> => [<post object>]
>>>>> => Post.find_by_text("foobar").destroy
>>>>> => []
>>>>>
>>>>> And then when i go and delete it, the post is no longer shown in
>>>>> the
>>>>> results! This is how delta indexing SHOULD work in my mind, but  
>>>>> why
>>>>> is
>>>>> not working for when I CREATE a post?
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>>
>>>>
>>>>
>>>>>
>>>
>>>
>>>>
>>
>>
>>>
>
>
> >


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

Reply via email to