We recently have been making an effort to managing our dependencies
with Bundler in our Rails 2.3.2 app.
About 6 months ago we implemented ThinkingSphinx, and have been very
happy with it thus far.
Strangely, after we deployed our Bundler release to our QA
environment, we started seeing errors like the one below whenever we
try to save or update a record of indexed model.
This is strange because we never setup delta indexing, so I would not
expect any sphinx-related callbacks to be executed on saves/updates/
destroys/creates.
>> a.save
Riddle::ResponseError: searchd error (status: 1): index address_core:
attribute 'sphinx_internal_id' can not be updated (must be boolean,
integer, timestamp, or MVA)
from /opt/local/ruby-enterprise-1.8.6-20090610/lib/ruby/gems/1.8/gems/
riddle-1.0.8/lib/riddle/client.rb:582:in `request'
from /opt/local/ruby-enterprise-1.8.6-20090610/lib/ruby/gems/1.8/gems/
riddle-1.0.8/lib/riddle/client.rb:384:in `update'
from /opt/local/ruby-enterprise-1.8.6-20090610/lib/ruby/gems/1.8/gems/
thinking-sphinx-1.3.14/lib/thinking_sphinx/active_record/
attribute_updates.rb:26:in `update_attribute_values'
from /opt/local/ruby-enterprise-1.8.6-20090610/lib/ruby/gems/1.8/gems/
thinking-sphinx-1.3.14/lib/thinking_sphinx/active_record/
attribute_updates.rb:19:in `each'
from /opt/local/ruby-enterprise-1.8.6-20090610/lib/ruby/gems/1.8/gems/
thinking-sphinx-1.3.14/lib/thinking_sphinx/active_record/
attribute_updates.rb:19:in `update_attribute_values'
from /opt/local/ruby-enterprise-1.8.6-20090610/lib/ruby/gems/1.8/gems/
activesupport-2.3.2/lib/active_support/callbacks.rb:178:in `send'
from /opt/local/ruby-enterprise-1.8.6-20090610/lib/ruby/gems/1.8/gems/
activesupport-2.3.2/lib/active_support/callbacks.rb:178:in
`evaluate_method'
from /opt/local/ruby-enterprise-1.8.6-20090610/lib/ruby/gems/1.8/gems/
activesupport-2.3.2/lib/active_support/callbacks.rb:166:in `call'
from /opt/local/ruby-enterprise-1.8.6-20090610/lib/ruby/gems/1.8/gems/
activesupport-2.3.2/lib/active_support/callbacks.rb:93:in `run'
from /opt/local/ruby-enterprise-1.8.6-20090610/lib/ruby/gems/1.8/gems/
activesupport-2.3.2/lib/active_support/callbacks.rb:92:in `each'
from /opt/local/ruby-enterprise-1.8.6-20090610/lib/ruby/gems/1.8/gems/
activesupport-2.3.2/lib/active_support/callbacks.rb:92:in `send'
from /opt/local/ruby-enterprise-1.8.6-20090610/lib/ruby/gems/1.8/gems/
activesupport-2.3.2/lib/active_support/callbacks.rb:92:in `run'
from /opt/local/ruby-enterprise-1.8.6-20090610/lib/ruby/gems/1.8/gems/
activesupport-2.3.2/lib/active_support/callbacks.rb:276:in
`run_callbacks'
from /opt/local/ruby-enterprise-1.8.6-20090610/lib/ruby/gems/1.8/gems/
activerecord-2.3.2/lib/active_record/callbacks.rb:344:in `callback'
from /home/ip/.bundle/ruby/1.8/gems/after_commit-1.0.7/lib/
after_commit/connection_adapters.rb:129:in `send'
from /home/ip/.bundle/ruby/1.8/gems/after_commit-1.0.7/lib/
after_commit/connection_adapters.rb:129:in
`trigger_after_commit_callbacks'
from /home/ip/.bundle/ruby/1.8/gems/after_commit-1.0.7/lib/
after_commit/connection_adapters.rb:128:in `each'
from /home/ip/.bundle/ruby/1.8/gems/after_commit-1.0.7/lib/
after_commit/connection_adapters.rb:128:in
`trigger_after_commit_callbacks'
from /home/ip/.bundle/ruby/1.8/gems/after_commit-1.0.7/lib/
after_commit/connection_adapters.rb:36:in `commit_db_transaction'
from /opt/local/ruby-enterprise-1.8.6-20090610/lib/ruby/gems/1.8/gems/
activerecord-2.3.2/lib/active_record/connection_adapters/abstract/
database_statements.rb:159:in `transaction_without_callback'
from /home/ip/.bundle/ruby/1.8/gems/after_commit-1.0.7/lib/
after_commit/connection_adapters.rb:12:in `transaction'
from /opt/local/ruby-enterprise-1.8.6-20090610/lib/ruby/gems/1.8/gems/
activerecord-2.3.2/lib/active_record/transactions.rb:182:in
`transaction'
from /opt/local/ruby-enterprise-1.8.6-20090610/lib/ruby/gems/1.8/gems/
activerecord-2.3.2/lib/active_record/transactions.rb:228:in
`with_transaction_returning_status'
from /opt/local/ruby-enterprise-1.8.6-20090610/lib/ruby/gems/1.8/gems/
activerecord-2.3.2/lib/active_record/transactions.rb:196:in `save'
from /opt/local/ruby-enterprise-1.8.6-20090610/lib/ruby/gems/1.8/gems/
activerecord-2.3.2/lib/active_record/transactions.rb:208:in
`rollback_active_record_state!'
from /opt/local/ruby-enterprise-1.8.6-20090610/lib/ruby/gems/1.8/gems/
activerecord-2.3.2/lib/active_record/transactions.rb:196:in `save'
class Address < ActiveRecord::Base
define_index do
indexes business(:name), :as => :name, :sortable => true
indexes business.categories_and_tags(:name), :as => :category
indexes :city_id, :type => :integer
indexes zip_code
has business.categories_and_tags(:id), :as => :category_id
has "RADIANS(lat)", :as => :latitude, :type => :float
has "RADIANS(lon)", :as => :longitude, :type => :float
has 'city_id', :as => 'city', :type => :integer
has "COUNT(business.reviews.id)", :as => :review_count, :type
=> :integer
has "CEIL(1/business.merchant.merchant_id)", :as
=> :claimed, :type => :integer
has "CEIL(1/business.cs_customer.available_cap)", :as
=> :available_cap, :type => :integer
end
# etc ...
end
-Steve
--
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.
