Search code examples
mysqlrubyruby-on-rails-3forkmysql2

Using fork in Ruby on Rails for creating parallel process


I have a Rails 3 app in production with Passenger on Apache. I have this code:

class Billing < ActiveRecord::Base
  after_save :sendEmails

  private
    def sendEmails
      fork do 
        UserMailer.clientBilling(self.user, self).deliver
      end
    end
end

In localhost, when the app creates a billing, after it is saved, the app sends an email to the user, everything works fine. But in the server, after the app creates a billing, it throws me errors related to the gem MySQL2, errors like "MySQL server has gone away" or "Connection lost", and the app doesn't send the emails. If I remove the fork it works fine, but I want to use fork, I want to create a separated process because it takes to long when sending emails. What could be the problem?


Solution

  • The problem is that a forked process inherits some of its parent's resources, such as its file descriptors. In particular one such shared resource is the MySQL connection. When the child process finishes its email sending and exits it closes the MySQL connection, which closes the parent processes connection.

    If you do continue down this path (and it is frought with similar subtleties) then you need to do something like this:

    # Clear existing connections before forking to ensure they do not get inherited.
    ::ActiveRecord::Base.clear_all_connections! 
    
    fork do
      # Establish a new connection for each fork.
      ::ActiveRecord::Base.establish_connection 
      
      # The rest of the code for each fork...
    end
    

    You'll have to do similar thing with services like memcached or mongodb if you use those.