Mysql connection goe away

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?

error is “mysql connection gone away”

we also get lots of

“ActiveRecord::StatementInvalid (Mysql::Error: Lost connection to MySQL
server during query: SELECT * …”

On 10 Apr 2008, at 19:17, Shaun Longhurst wrote:

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

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