We are currntly running
mongrel v 1.1.4
mongrel_cluster 1.0.5
mysql gem 2.7.5 (built from source)
rails 2.0.2
ruby 1.8.6
mysql version 4.1 this is run on a remote server.
We are consistently getting
“ActiveRecord::StatementInvalid (Mysql::Error: MySQL server has gone
away: SELECT * FROM…”
errors.
When i then try and stop mongrel some (various) of the mongrels are in
error state and refuse to do anything, they do not log any errors. I
cannot stop or restart them and end up having to kill all the processes,
delete the pids and then start them again, where by they are fine for a
couple of hours. It seems to happen aftera period of in activity.
We have set
ActiveRecord::Base.verification_timeout = 14400
mysql timeout is 28800
I am at a loss now as to what i can do to fix the issue. It is not
possible for me to update mysql so this is not an option.
Any idea’s?