Redmine

Hello all,

I am having a problem and I don't know if Redmine is the cause or just a victim of the problem but every so often, once or twice a month the Server starts swapping for no apparent reason.

Current Install¶

Centos 5.7
Linux xe-redmine 2.6.18-274.3.1.el5xen #1 SMP Tue Sep 6 20:57:11 EDT 2011 x86_64 x86_64 x86_64 GNU/Linux
8Gb of RAM/1Gb dedicated to InnoDB
4 cpus
10-20 concurrent users
Plenty of diskspace

Here is the error that caused the 500 internal error

Error 1¶

Processing IssuesController#index to atom (for xxx.xxx.xxx.xxx at 2012-01-02 23:21:05) [GET]
  Parameters: {"format"=>"atom", "action"=>"index", "query_id"=>"23", "controller"=>"issues", "key"=>"5032a2a3904b7e7dc71741cb2907cecef797e6e5"}
Rendering common/feed.atom
Completed in 742ms (View: 702, DB: 2) | 200 OK [https://projects.xxxxxxx.xx/issues.atom?key=5032a2a3904b7e7dc71741cb2907cecef797e6e5&query_id=23]

Processing IssuesController#index to atom (for xxx.xxx.xxx.xxx at 2012-01-02 23:21:06) [GET]
  Parameters: {"format"=>"atom", "action"=>"index", "query_id"=>"53", "controller"=>"issues", "key"=>"5032a2a3904b7e7dc71741cb2907cecef797e6e5"}
Rendering common/feed.atom
Completed in 1356ms (View: 1228, DB: 8) | 200 OK [https://projects.xxxxxxx.xx/issues.atom?key=5032a2a3904b7e7dc71741cb2907cecef797e6e5&query_id=53]
/!\ FAILSAFE /!\  Mon Jan 02 23:21:56 +0100 2012
  Status: 500 Internal Server Error

Error 2¶

ActiveRecord::StatementInvalid (Mysql::Error: Incorrect information in file: './redmine/settings.frm': SELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` ):
  app/models/setting.rb:152:in `check_cache'
  app/controllers/application_controller.rb:62:in `user_setup'
  public/dispatch.fcgi:24

But MySQL was erroring out because the machine was already swapping. Once I restarted the server, MySQL stopped complaining about settings.frm

Any ideas?