Error running index on Heroku

Joe Weakley

03 May, 2013 08:16 PM

Hello,
When I try to run flying-sphinx index on Heroku, I am getting the following error:

ERROR: index 'user_profiles_core': sql_connect: could not translate host name to address: Name or service not known

What could be causing this error?

  1. #1 Posted by Pat Allan Support staff on 03 May, 2013 08:21 PM

    Hi Joe

    What versions of flying-sphinx, thinking-sphinx and rails are you using? Also, what's your app's name?

    Kind regards,

    Pat

  2. #2 Posted by Joe Weakley on 03 May, 2013 08:24 PM

    Sorry about skipping those little details:

    flying-sphinx (0.8.2)
    thinking-sphinx (2.0.13)
    rails (3.1.12)

    The app's name is hotmoose.

    Thanks for the quick reply

  3. #3 Posted by Pat Allan Support staff on 03 May, 2013 08:27 PM

    First things first: I'd highly recommend updating to at least flying-sphinx 0.8.5 and thinking-sphinx 2.0.14 - I have a feeling there was a bug with pre-0.8.4 releases of the FS gem.

    I'm actually working on updates to both gems to improve reliability generally, but certainly things should work well with 0.8.5.

    If that doesn't help, let me know.

  4. #4 Posted by Joe Weakley on 03 May, 2013 09:11 PM

    So i have followed the instructions (added mysql2, made sure sphinx is compiled with MySQL support, and moved the indices to the new locations) to upgrade to flying-sphinx (0.8.5) and thinking-sphinx (3.0.2), but now I am getting the following error: uninitialized constant ThinkingSphinx::PostgreSQLAdapter (NameError). Any ideas?

  5. #5 Posted by Pat Allan Support staff on 03 May, 2013 09:18 PM

    Ah, if you're using 3.0.2, you'll need the latest flying-sphinx from GitHub:

    gem 'flying-sphinx',
  :git    => 'git://github.com/flying-sphinx/flying-sphinx.git',
  :branch => 'master',
  :ref    => '8d94436c5c'

  6. #6 Posted by Joe Weakley on 06 May, 2013 05:11 PM

    Thanks for the help.
    We ended up using thinking-sphinx(2.0.14) which worked wonderfully (once we remembered to start the daemon).

  7. Pat Allan closed this discussion on 13 Jan, 2014 11:23 PM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac

Recent Discussions

Recent Articles