Redmine

I have the same problem. I found some interesting information in FAQ: http://mongrel.rubyforge.org/wiki/FAQ

Thanks for the link. This is the general FAQ however.
Please share your experience if you manage to solve this problem.

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.

It seems need create patch for redmine to change timeout. But I do not know Ruby.

Kirill, do you have progress on this issue?

Does anyone else can advise how to change ActiveRecord::Base.verification_timeout = 14400 in Redmine in order to avoid this this bug in the MySQL driver that causes Mongrel stopping to work after a long idle time?

Thank you in advance

No, I don't. Maybe you need to report this issue as bug.

Done.

http://www.redmine.org/issues/4144

I have played with this parametered as advised here but this does not help. Mongrel stops working after some time and requires restart.

The following workaround was found.

Script has been configured to access list of projects page every 3 minutes.
As far as I understand this forces mogrel to keep mysql connection up and thus redmine works.