mysql connection goe away

rubyonrails-talk
1

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?

2

error is "mysql connection gone away"

3

we also get lots of

"ActiveRecord::StatementInvalid (Mysql::Error: Lost connection to MySQL server during query: SELECT * ...."

4

we also get lots of

"ActiveRecord::StatementInvalid (Mysql::Error: Lost connection to
MySQL server during query: SELECT * ...."

Is the server crashing/erroring out (anything interesting in the mysql
connection logs) ?

Fred

5

Nope nothing on the mysql side. Nothing seems to be logged anywhere apart from the activerecord errors.