Posted By

esad on 11/26/07

Tagged

mysql rails activerecord monkeypatch

Versions (?)

Who likes this?

2 people have marked this snippet as a favorite

darthomir
webstic

A monkey-patch to activerecord to reconnect after it loses the connection to the mysql server

/ Published in: Ruby

Expand | Embed | Plain Text

# Patch Mysql adapter so that it reconnects after discovering an lost connection error
 
module ActiveRecord::ConnectionAdapters
  class MysqlAdapter
    alias :orig_execute :execute 
    def execute(sql,name=nil)
      orig_execute(sql,name)
      rescue ActiveRecord::StatementInvalid => exception
        if LOST_CONNECTION_ERROR_MESSAGES.any? { |msg| exception.message. =~ /#{msg}/ } 
          reconnect!
          retry
        else
          raise
        end
    end
  end
end

Report this snippet Tweet

Comments

Subscribe to comments

Posted By: fjfish on December 8, 2008

Just one thing:

You might want to try maybe 3 times and then pass the exception up anyway, if the database really has gone away this will sit there looping forever. Usually I also wait a second or so before retrying something like this, but this might not be that good an idea if you're trying to respond to an http request.

Comment:

You need to login to post a comment.