Even when running in the console, calculated attribute modification
did not cause delta index update.
person = Person.new
person.last_name = "Smith"
person.save # caused delta index
person.area_code = "617" # assume you have has CRC32("area_code"), :as
=> :area_code, :type => :integer
person.save # did not cause delta index
As I said, I moved these attributes to fields and updated my advanced
search code to use conditions.
I still can't make Passenger happy in development mode even when
everything is running as the same user and the path is right. At least
I'm pretty sure they are.
My config/sphinx.yml for dev:
development:
morphology: stem_en
max_matches: 100000
bin_path: /usr/local/bin
-Dave
On Aug 27, 8:51 am, Pat Allan <[email protected]> wrote:
> Hmm, it could be a bug.
>
> Sphinx can update some attributes (integers, timestamps, booleans) -
> and so if you only change columns that are tied to those types of
> attributes, Thinking Sphinx will not invoke the delta indexing.
>
> However, if there are any associations used, or manual SQL, then delta
> indexing should always be fired. And given that it works via script/
> console, then that suggests to me that there's nothing wrong with that
> code.
>
> Which doesn't really help.
>
> --
> Pat
>
> On 27/08/2009, at 1:36 PM, gobigdave wrote:
>
>
>
>
>
> > FYI, I verified that when Workling/Starling are running in async mode
> > my delta indexes are being properly updated. What is strange is that
> > the workling, httpd, and searchd processes are all running with the
> > same user. I've also verified the path several times, but I will do so
> > again. Very strange...
>
> > Also, I moved the state, country, and area_code attributes to indexes,
> > and now updates to the object properly cause the delta index to be
> > updated. Looking at the thinking_sphinx code it seems that attribute
> > updates should have caused deltas to be updated, but I'm thinking that
> > it may not work with calculated attributes.
>
> > On Aug 26, 11:31 pm, gobigdave <[email protected]> wrote:
> >> I have two issues with delta indexes. First, I can not get them to
> >> update from my dev browser. I do use Passenger even in development,
> >> but I verified that searchd and apache(httpd) are running as the same
> >> user. I also have bin_path set in my sphinx.yml file. If I add new
> >> items from my console, then I can search for the new records fine.
> >> Even when adding records from my browser, my log file has:
>
> >> WorklingDeltaWorker#index:
> >> {:delta_index_name
> >> =
>
> >> "person_delta
> >> ", :uid
> >> =
>
> >> "workling_delta_workers:index:d9ba9a4bbec22daca144db294206d7b2
> >> ", :core_index_name=>"person_core", :document_id=>242557}
> >> ThinkingSphinx::Search.search_for_id is deprecated. Please use
> >> ThinkingSphinx.search_for_id instead.
> >> Querying Sphinx:
>
> >> Any other ideas on what I can check?
>
> >> Two classes for reference:
>
> >> class WorklingDelta < ThinkingSphinx::Deltas::DefaultDelta
>
> >> def index(model, instance = nil)
> >> return true unless ThinkingSphinx.updates_enabled? &&
> >> ThinkingSphinx.deltas_enabled?
> >> return true if instance && !toggled(instance)
>
> >> doc_id = instance ? instance.sphinx_document_id : nil
> >> WorklingDeltaWorker.asynch_index(:delta_index_name =>
> >> delta_index_name(model), :core_index_name => core_index_name
> >> (model), :document_id => doc_id)
>
> >> return true
> >> end
>
> >> end
>
> >> class WorklingDeltaWorker < Workling::Base
>
> >> def index(options = {})
> >> logger.info("WorklingDeltaWorker#index: #{options.inspect}")
> >> ThinkingSphinx::Deltas::DeltaJob.new(options
> >> [:delta_index_name]).perform
> >> if options[:document_id]
> >> ThinkingSphinx::Deltas::FlagAsDeletedJob.new(options
> >> [:core_index_name], options[:document_id]).perform
> >> end
>
> >> return true
> >> end
>
> >> end
>
> >> If you are not familiar with workling, it allows for simple async
> >> processing. In development mode, however, everything is executed
> >> synchronously.
>
> >> The second issue is that the index does not update when I change an
> >> attribute. Here is some of my index:
>
> >> define_index do
>
> >> indexes first_name, last_name, :sortable => true
> >> indexes [title, title1], :as => :title, :sortable => true
> >> indexes description
>
> >> has "CRC32(people.state)", :as => :state, :type => :integer
> >> has "CRC32(people.country)", :as => :country, :type => :integer
> >> has "CRC32(people.area_code)", :as => :area_code, :type
> >> => :integer
>
> >> set_property :delta => WorklingDelta
> >> end
>
> >> When I create a new record from the console, I see the following:
>
> >> using config file '/Users/dave/projects/msc/config/
> >> development.sphinx.conf'...
> >> indexing index 'person_delta'...
> >> collected 1 docs, 0.0 MB
> >> collected 0 attr values
> >> sorted 0.0 Mvalues, 100.0% done
> >> sorted 0.0 Mhits, 100.0% done
> >> total 1 docs, 12 bytes
> >> total 0.235 sec, 51.03 bytes/sec, 4.25 docs/sec
> >> rotating indices: succesfully sent SIGHUP to searchd (pid=32480).
> >> => true
>
> >> However, if I update the state, country, or area_code, then nothing
> >> is
> >> output, and the index is not updated. Note, I have the state,
> >> country,
> >> and area_code as attributes because I want to filter on multiple
> >> values. Is this a known issue? Do I need to move these to indexes and
> >> use 'OR' searches to make this happy?
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
