[Mongrel] Mongrel dying daily with Ruby 1.8.6

Pete DeLaurentis pete at nextengine.com
Wed Apr 4 13:37:50 EDT 2007


> What you have to do is set:
>
> ActiveRecord::Base.verification_timeout = 14400
>
> Or to any value that is lower than the MySQL server's
> interactive_timeout setting. This will make sure that ActiveRecord
> checks the connection often enough to reset the connection.

Sweet.  Thanks Luis.  This is exactly what I'm looking for.

-Pete




On Apr 4, 2007, at 9:38 AM, Luis Lavena wrote:

> On 4/4/07, kaushik.ghose <kaushik.ghose at gmail.com> wrote:
>> Pete DeLaurentis wrote:
>>
>>> Here's a question: Is anyone running ruby1.8.6 succesfully with  
>>> mongrel?
>> On Windows Vista I'm running Mongrel with Ruby 1.8.6, rails 1.2.3  
>> as a
>> service. I have no problems with the service shutting down or  
>> becoming
>> unresponsive. I run this on a laptop, (with hibernation) uptime  
>> upto 50
>> hrs hasn't been a problem.
>>
>
> Hehehe, is good to know that you are up and running Kaus ;-)
>
>> The "500 Internal Server Error" rings a bell, but I can't remember  
>> what
>> was causing it and the issue has been resolved for me.
>>
>
> Maybe MySql timeout? from mongrel faq [1]
>
> Q. Mongrel stops working if it's left alone for a long time.
>
> If you find that Mongrel stops working after a long idle time and
> you're using MySQL then you're hitting a bug in the MySQL driver that
> doesn't properly timeout connections. What happens is the MySQL server
> side of the connection times out and closes, but the MySQL client
> doesn't detect this and just sits there.
>
> What you have to do is set:
>
> ActiveRecord::Base.verification_timeout = 14400
>
> Or to any value that is lower than the MySQL server's
> interactive_timeout setting. This will make sure that ActiveRecord
> checks the connection often enough to reset the connection.
>
>
> [1] http://mongrel.rubyforge.org/faq.html
>
> -- 
> Luis Lavena
> Multimedia systems
> -
> Leaders are made, they are not born. They are made by hard effort,
> which is the price which all of us must pay to achieve any goal that
> is worthwhile.
> Vince Lombardi
> _______________________________________________
> Mongrel-users mailing list
> Mongrel-users at rubyforge.org
> http://rubyforge.org/mailman/listinfo/mongrel-users



More information about the Mongrel-users mailing list