"MySQL server has gone away" with Ruby on Rails

Question

After our Ruby on Rails application has run for a while, it starts throwing 500s with "MySQL server has gone away". Often this happens overnight. It's started doing this recently, with no obvious change in our server configuration.

 Mysql::Error: MySQL server has gone away: SELECT * FROM `widgets`

Restarting the mongrels (not the MySQL server) fixes it.

How can we fix this?

question from:https://stackoverflow.com/questions/100631/mysql-server-has-gone-away-with-ruby-on-rails

Answer 1

Ruby on Rails 2.3 has a reconnect option for your database connection:

production:
  # Your settings
  reconnect: true

See:

• Ruby on Rails 2.3 Release Notes, sub section 4.8 Reconnecting MySQL Connections.

• MySQL auto-reconnect revisited

Good luck!