If I comment-out all my indices except the real_time one, I get this: rake ts:regenerate Stopped searchd daemon (pid: 6509). Generating configuration to /home/user/projects/my_gemset/config/development.sphinx.conf Failed to start searchd daemon. Check /home/user/projects/my_gemset/log/development.searchd.log. Failed to start searchd. Check the log files for more information. Generating index files for artist_core rake aborted! ThinkingSphinx::ConnectionError: Error connecting to Sphinx via the MySQL protocol. Error connecting to Sphinx via the MySQL protocol. Can't connect to MySQL server on '127.0.0.1' (111) - REPLACE INTO artist_core (id, `sphinx_internal_class_name`, `name`, `comment`, `sphinx_internal_id`, `sphinx_internal_class`, `sphinx_deleted`, `name_sort`) VALUES (2, 'Artist', 'A. Mata', '', 1, 'Artist', 0, 'A. Mata') /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'
If I immediately comment-out the real-time index then enable back the other indices, everything works fine. All this is without touching my thinking_sphinx.yml file On Wed, Oct 15, 2014 at 9:17 PM, J. Garcia <[email protected]> wrote: > 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.
