Hey guys-

I'm really stumped here.  I'm using
rails 3.0.3
thinking-sphinx (2.0.1)
riddle (1.2.1)
ts-delayed-delta (1.1.1)
delayed_job (2.1.2)

I'm using delayed job to process my delta updates.

Here's the problem I have.  I have a table organizations with a
timestamped deleted_at field.

- create a new organisation
- rebuild the sphinx indices
- delete the new organization
- delayed job is triggered
- now call Organization.search '', :with => {:deleted_at => 0}

Note that the deleted Organization is still returned.  Rebuilding the
sphinx indices clears out that record.
If I create an Organization and the delayed job delta index picks up
the change, then a delete occurs, the record stays deleted.

I've tried with Sphinx 0.9.9 and Sphinx 0.9.8.1.


I have an existing rails 2 application (working on the upgrade).
Rather than delayed job, it uses inprocess delta indexing.   I tried
the same scenario sketched out above and the record was indeed deleted
as expected.

Does this ring any bells?  I'd love to find a solution to this.
Thanks!

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