Need ideas for MySQL Lost connection Errors

rubyonrails-talk
1

Read through many of the prior messages (most from mid 2006), and I don't see any that apply to my setup.

I'm experiencing an intermittent appearance of "Mysql::Error: Lost connection to MySQL server during query"

The usual blames I saw were change from MySQL 4.0 to 4.1 so password type mistmatch, old version of a mysql gem, tabs in database.yml. None of these apply.

As I say, intermittent. Several requests are just fine, then I get a Proxy Error message. go look in the production.log, and see the Mysql::Error entry.

fresh install of OS X 10.5.2 on box "app01" we'll call it.

fresh install of OS X 10.5.2 on box "data01" we'll call it.

using built-in MySQL on "data01" for now (5.0.45).

installed a Rails app on "app01" with a frozen 1.2.3 in /vendor.

database.yml defines the connection using "host:" with an IP address and a password.

the password in MySQL is verified to be a new style password.

both machines are new intel Xserves, just now being set up so they're not busy at all.

Looking for new ideas...

Thanks, -- gw

2

Try this in your environmnet.rb files:

ActiveRecord::Base.verification_timeout = 14400

Also make sure you have the mysql gem installed

gem install mysql -- --with-mysql-dir=/usr/local/mysql