Mongrel freeze

rubyonrails-talk
1

Hi,

I am having a problem with mongrel not responding after a period of inactivity. Searching the various logs and such, it seems to be a problem with mysql. The facts: - I am running CentOS5 - I do not have a warning about using the non-production mysql driver at the top of my log, so I presume I am using the C version from the gem install. - I added this statement to my production.rb file located at config/ environments: ActiveRecord::Base.verification_timeout = 30 In fact, I tried this first at 14400 as suggested in the Mongrel FAQ, to no better result. - I set the wait_timeout mysql variable to 604000 using set global wait_timeout = 604000. This value sticks when set. - I set the wait_timeout mysql variable to 604000 using set wait_timeout = 604000. This value sticks only as long as my mysql session is open. Show variables like "wait_timeout" yields 604000. However, when I close that session and go back in, the value is back to 28800.

When the problem occurs, the production.log shows "Broken Pipe".

Restarting mongrel fixes it.

I presume the wait_timeout variable is to blame. The mysql documentation says it will get it's value from the global wait_timeout setting, but that is not happening.

I also tried setting the interactive_timeout, but that had no impact.

Thanks.

2

I am also have problems with mongrel freezing.

Environment:   Debian on 2.6.25-2-486   Rails 2.1.0   Mongrel 1.1.5

I have 2 rails sites running on this box, both with 1 mongrel each. The first does not use ActiveRecord at all and has no problems.

The 2nd one freeze are a few hours period of inactivity. It is also heavily using send_file() to send files between 1MB to 5MB. I am not sure if that has anything to do with it.

In the mongrel.log there is nothing reported after it freezes. It just shows the last request. In the rails log the same thing.

When I try to go to the site Firefox just sits there waiting and after a few minutes it just times out.

Thanks, John