Mysql connection goe away

Rails
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

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

5

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