Hi Phil Just to confirm: is your Rails app, your database and Sphinx all on the same machine? If not, you'll need to switch to Delayed Job/Resque for processing deltas, and have that happen on the machine which hosts Sphinx (so it can access the Sphinx files directly).
Also: in your current set up, if everything's on the one server, you may find some clues in the Passenger or nginx logs (such as Sphinx indexing output). Hope that provides some clarity on where to start debugging. Cheers -- Pat On 05/06/2013, at 8:18 AM, Philip Jeffs wrote: > Hello there, > > We just added some new models to our app, all of which have delta indexes > enabled. Everything works perfectly in development, but on the production > cluster (passenger + nginx), deltas don't appear to be working on the new > models. On the older models everything works fine, and the configuration is > pretty much identical. > > Here's the sphinx.yml: > > development: > max_matches: 999999 > > production: > address: 69.55.55.184 > max_matches: 999999 > bin_path: '/usr/local/bin' > searchd_binary_name: '/usr/local/bin/searchd' > indexer_binary_name: '/usr/local/bin/indexer' > version: 2.0.4 > > And here's an example of one of the model (name: Order) definitions that > doesn't work: > > define_index do > indexes :id, :sortable => true > has :advertiser_id > has order_items(:issue_id), :as => :issue_id > has "CRC32(status)", :as => :status, :type => :integer > has :publication_list, :as => :publication_id, :type => :multi > set_property :enable_star => 1 > set_property :min_prefix_len => 2 > set_property :delta => true > end > > I've tailed the production logs, when creating an order and I don't see > anything relating to deltas being shown. Is there any other way I can see > what Sphinx is doing when the model is created? > > Thanks in advance, > Phil. > > > -- > You received this message because you are subscribed to the Google Groups > "Thinking Sphinx" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/thinking-sphinx?hl=en. > For more options, visit https://groups.google.com/groups/opt_out. > > -- You received this message because you are subscribed to the Google Groups "Thinking Sphinx" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/thinking-sphinx?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
