Mongrel stops responding a few times per days. Restarting Mongrel helps.

Added by Vadim Epstein about 8 years ago

Hi,

I use Redmine 0.8.4.stable (MySQL).

Mongrel stops responding a few times per days. Restarting Mongrel helps and Redmine works again.

This happens to Mongrel which is used for redmine only. Other instances of Mongrel used for other purposes work fine.

Do you have any idea how this happens and how to solve?

Thanks,

Vadim

Replies (8)

RE: Mongrel stops responding a few times per days. Restarting Mongrel helps. - Added by Vadim Epstein about 8 years ago

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

RE: Mongrel stops responding a few times per days. Restarting Mongrel helps. - Added by Kirill Ponomarev about 8 years ago

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.

RE: Mongrel stops responding a few times per days. Restarting Mongrel helps. - Added by Vadim Epstein about 8 years ago

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

RE: Mongrel stops responding a few times per days. Restarting Mongrel helps. - Added by Kirill Ponomarev about 8 years ago

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

RE: Mongrel stops responding a few times per days. Restarting Mongrel helps. - Added by Vadim Epstein about 8 years ago

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

RE: Mongrel stops responding a few times per days. Restarting Mongrel helps. - Added by Vadim Epstein almost 8 years ago

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.

(1-8/8)