I have active_record indexes for other models. For this model, it is the only one I have.
On Wed, Oct 15, 2014 at 9:00 PM, Pat Allan <[email protected]> wrote: > And you’ve only got the one index defined? > > On 15 Oct 2014, at 2:58 pm, J. Garcia <[email protected]> wrote: > > I followed your recommendation and got the same result. > > On Wed, Oct 15, 2014 at 8:40 PM, Pat Allan <[email protected]> > wrote: > >> Not quite sure what’s happening here… certainly you seem to be taking the >> right approach. >> >> Can you run `rake ts:stop`, and then `ps aux | grep searchd` to confirm >> there’s no Sphinx daemons running? Then try `rake ts:regenerate` after that >> and see if it behaves properly. >> >> — >> Pat >> >> On 15 Oct 2014, at 8:19 am, J. Garcia <[email protected]> wrote: >> >> I am trying to convert an index to a real time index. >> >> My index definition is like this one: >> >> ThinkingSphinx::Index.define :artist, :with => :real_time do >> indexes name, :sortable => true >> indexes comment >> end >> >> My config is like this: >> development: >> host: 127.0.0.1 >> mysql41: 9306 >> utf8: true >> bin_path: /usr/bin >> mem_limit: 2047M >> searchd_binary_name: searchd >> indexer_binary_name: indexer >> enable_star: true >> min_prefix_len: 3 >> >> When I run rake ts:regenerate I get a long stacktrace, a fragment of >> which is below >> Any help would be appreciated. >> >> Generating configuration to >> /home/user/my_app/config/development.sphinx.conf >> Started searchd successfully (pid: 25748). >> Generating index files for artist_core >> rake aborted! >> ThinkingSphinx::SphinxError: no such index 'artist_core' - REPLACE INTO >> artist_core (id, `sphinx_internal_class_name`, `name`, `comment`, >> `sphinx_internal_id`, `sphinx_internal_class`, `sphinx_deleted`, >> `name_sort`) VALUES (12, 'Artist', 'One Artist', '', 1, 'Artist', 0, 'One >> Artist') >> /home/user/.rvm/gems/ruby-2.1.2@my_gemset/gems/thinking-sphinx-3.1.1/lib/thinking_sphinx/connection.rb:91:in >> `rescue in query' >> /home/user/.rvm/gems/ruby-2.1.2@my_gemset/gems/thinking-sphinx-3.1.1/lib/thinking_sphinx/connection.rb:94:in >> `query' >> /home/user/.rvm/gems/ruby-2.1.2@my_gemset/gems/thinking-sphinx-3.1.1/lib/thinking_sphinx/connection.rb:71:in >> `execute' >> /home/user/.rvm/gems/ruby-2.1.2@my_gemset/gems/thinking-sphinx-3.1.1/lib/thinking_sphinx/real_time/transcriber.rb:20:in >> `block (2 levels) in copy' >> /home/user/.rvm/gems/ruby-2.1.2@my_gemset/gems/thinking-sphinx-3.1.1/lib/thinking_sphinx/connection.rb:37:in >> `block in take' >> /home/user/.rvm/gems/ruby-2.1.2@my_gemset/gems/innertube-1.1.0/lib/innertube.rb:138:in >> `take' >> /home/user/.rvm/gems/ruby-2.1.2@my_gemset/gems/thinking-sphinx-3.1.1/lib/thinking_sphinx/connection.rb:35:in >> `take' >> /home/user/.rvm/gems/ruby-2.1.2@my_gemset/gems/thinking-sphinx-3.1.1/lib/thinking_sphinx/real_time/transcriber.rb:19:in >> `block in copy' >> /home/user/.rvm/gems/ruby-2.1.2@my_gemset/gems/activesupport-3.2.18/lib/active_support/notifications.rb:123:in >> `block in instrument' >> /home/user/.rvm/gems/ruby-2.1.2@my_gemset/gems/activesupport-3.2.18/lib/active_support/notifications/instrumenter.rb:20:in >> `instrument' >> /home/user/.rvm/gems/ruby-2.1.2@my_gemset/gems/activesupport-3.2.18/lib/active_support/notifications.rb:123:in >> `instrument' >> /home/user/.rvm/gems/ruby-2.1.2@my_gemset/gems/thinking-sphinx-3.1.1/lib/thinking_sphinx/logger.rb:3:in >> `log' >> /home/user/.rvm/gems/ruby-2.1.2@my_gemset/gems/thinking-sphinx-3.1.1/lib/thinking_sphinx/real_time/transcriber.rb:18:in >> `copy' >> /home/user/.rvm/gems/ruby-2.1.2@my_gemset/gems/thinking-sphinx-3.1.1/lib/thinking_sphinx/real_time/populator.rb:16:in >> `block in populate' >> /home/user/.rvm/gems/ruby-2.1.2@my_gemset/gems/activerecord-3.2.18/lib/active_record/relation/batches.rb:21:in >> `block (2 levels) in >> >> -- >> 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. >> For more options, visit https://groups.google.com/d/optout. >> >> >> >> -- >> You received this message because you are subscribed to a topic in the >> Google Groups "Thinking Sphinx" group. >> To unsubscribe from this topic, visit >> https://groups.google.com/d/topic/thinking-sphinx/-l68CIosNdg/unsubscribe >> . >> To unsubscribe from this group and all its topics, 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. >> For more options, visit https://groups.google.com/d/optout. >> > > > -- > 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. > For more options, visit https://groups.google.com/d/optout. > > > -- > You received this message because you are subscribed to a topic in the > Google Groups "Thinking Sphinx" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/thinking-sphinx/-l68CIosNdg/unsubscribe. > To unsubscribe from this group and all its topics, 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. > For more options, visit https://groups.google.com/d/optout. > -- 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. For more options, visit https://groups.google.com/d/optout.
