I’m experiencing an intermittent appearance of
“Mysql::Error: Lost connection to MySQL server during query”
Read through many of the prior messages (most from mid 2006), and I
don’t see any that apply to my setup.
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.
Someone also previously suggested adding this to environment.rb:
ActiveRecord::Base.verification_timeout = 14400
I did that, but it made no difference.
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. All requests are within a couple seconds of each
other just bouncing around pages.
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.
Have you verified that you have the native C ruby-mysql bindings? the
pure ruby ones that rails falls back to do this diconnection dance all
the time. You can verify by requireing mysql.bundle and see if it fails:
I’m experiencing an intermittent appearance of
“Mysql::Error: Lost connection to MySQL server during query”
=> true
Hmmm… I compiled that for my dev system, and so my dev system says
true, but indeed these Xserves say false – kinda lame for Apple to
have not included the C versions.
the time. You can verify by requireing mysql.bundle and see if it
true, but indeed these Xserves say false – kinda lame for Apple to
have not included the C versions.
I will pursue this line further. Thanks!
OK, dumb question, having finally found the right witchcraft for
installing this on my platform, my question is whether ruby/rails
will use it automatically? Do I have to do anything in environment.rb
or elswhere to ensure the C version gets used instead of the Ruby
version?
Do I have to do anything…to ensure the C version gets used
instead of the Ruby
version?
Yeah it should get used automatically if you have it installed.
Thanks. It looks like this fixed the problem, but I wanted to be sure
it’s wasn’t just because it was in a good mood.
Just thought I’d add a note in here that could help, I started getting
this error once when I was adding too much stuff to session. The
thread is here:
good to know. Probably not applicable for me as this app has been
running fine on another set of servers (setup by someone else), and
I’m just trying to relocate it.
Just thought I’d add a note in here that could help, I started getting
this error once when I was adding too much stuff to session. The
thread is here: