Hi Eric
Delayed response I know... but just to confirm: in your Rails 2 app, are you
using a deleted_at column? Or actually deleting objects from the database?
--
Pat
On 10/12/2010, at 3:21 PM, Eric wrote:
> 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.
>
--
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.
