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.
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.
Sorry, not a “proxy error” – just the standard 500 ISE
Try this in your environmnet.rb files:
ActiveRecord::Base.verification_timeout = 14400
Read up on that. Doesn’t seem to be the problem. When I say
intermittent, I mean a handful of back to back queries work fine, then
one doesn’t. The time frame of these numbers doesn’t seem to be relevant
to what I am seeing.
Still, I did it of course. Changed the value, restarted mongrel cluster.
Loaded a page, whacked reload, and got the same error.
Also make sure you have the mysql gem installed
gem install mysql – --with-mysql-dir=/usr/local/mysql
yep – all that stuff is loaded (built-in versions, so different
location, but it’s all there)
– gw
This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.