Well, I've read a LOT about Delta Index not working in production
because of permissions errors, but my problem is not that (I think).
Here are the facts:
This was the migration:
class AddDeltaIndexToCimgs < ActiveRecord::Migration
def change
add_column :cimgs, :delta, :boolean, default: true, null: false
end
end
This is the define_index:
define_index do
indexes search_cache
has :approved
set_property delta: true
end
Then I run rake:stop, rake:reindex, and rake:start
Then I search for something already in the database with:
Cimg.search query, with: {approved: true}
And it works as expected...
But when I create new records, I can't find them.
I checked the database and the delta column for those records is set
to true (also the approved column, though anyway I tested without it)
In the development.log it says the following after creating a new
record:
(41.1ms) COMMIT
Sphinx Query (14.5ms)
Sphinx Found 0 results
Here is the generated configuration file: http://pastebin.com/z0fHr43k
I checked the db/sphinx folder and a lot of files with the name
cimg_delta are created.
Im using:
Sphinx version: 2.0.7
Thinking Sphinx version: 2.0.5
Rails version: 3.1.0.rc8
Ruby version: 1.9.2p290
I don't know what else to say, that's all what I know so far.
I don't know if the problem is that the records are not indexed or are
not being searched, but I don't know how to dump the delta index =/
I tried to submit the index_delta manually calling it in a record, but
that didn't worked either.
--
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.
