ThinkingSphinx::QueryExecutionError (closed MySQL connection) every day

We get this error message every day.
1]: ThinkingSphinx::QueryExecutionError (closed MySQL connection):
2013-08-16T03:14:08.605246+00:00 app[web.1]: app/controllers/licenses_controller.rb:137:in `destroy_school'
2013-08-16T03:14:08.605246+00:00 app[web.1]: app/controllers/licenses_controller.rb:317:in `block in destroy_licenses'
2013-08-16T03:14:08.605246+00:00 app[web.1]: app/controllers/licenses_controller.rb:307:in `destroy_licenses'

When we restart heroku server it will turn to works good for a while, but it will get this error for several hours later.

We find a solution https://groups.google.com/forum/#!topic/thinking-sphinx/5Zddl3kbt6o

  gem 'thinking-sphinx', '~> 3.0.4',
    :git => 'git://github.com/pat/thinking-sphinx.git',
    :branch => 'master',
    :ref => '0c404e756d'

But i need wait for several hours to wait for the result.

Our server is http://careereagle.herokuapp.com

  1. Hi Brook

    What you've done is the right approach… if you still hit these problems though, let me know.

    Kind regards,

    Pat

Reply to this discussion Internal reply only staff will see it

Markdown

Attaching KB article:

» »

Read more…

Attach files

Up to 10MB each.

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

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