Advanced Search

Return to Snippet

Revision: 4318
at November 26, 2007 01:01 by esad
Initial Code 
# 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
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

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

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
mysql, rails

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
Ruby