Reconnect to a lost database connection using an exception block trick (ruby, rails, mysql, activerecord)

Reconnect

  def my_task
    while(true) do
      begin
        database_access_here
      rescue Exception => ex
        begin
          ActiveRecord::Base.connection.reconnect!
        rescue
          sleep 10
          retry     # will retry the reconnect
        else
          retry     # will retry the database_access_here call
        end
      end
    end
  end