# MySQL Lost Connection Errors **URL:** \ **Category:** Rails\ **Created:** [March 29, 2008, 6:25am UTC](https://www.ruby-forum.com/t/mysql-lost-connection-errors/133239 "2008-03-29T06:25:38Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![S-gw](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/ed655f/32.png) [@S-gw](https://www.ruby-forum.com/u/S-gw)\ **Post date:** [March 29, 2008, 6:25am UTC](https://www.ruby-forum.com/t/mysql-lost-connection-errors/133239/1 "2008-03-29T06:25:38Z")
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. - the database connection is actually going to MySQL Proxy on app01 which balances a master-master cluster. ([http://forge.mysql.com/wiki/MySQL\_Proxy](http://forge.mysql.com/wiki/MySQL_Proxy)) - both machines are new intel Xserves, just now being set up so they’re not busy at all. Looking for new ideas… Thanks, – gw ---
**Author:** ![S-gw](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/ed655f/32.png) [@S-gw](https://www.ruby-forum.com/u/S-gw)\ **Post date:** [March 29, 2008, 8:10am UTC](https://www.ruby-forum.com/t/mysql-lost-connection-errors/133239/2 "2008-03-29T08:10:18Z")
Hi! On Mar 28, 2008, at 10:24 PM, Greg W. wrote: > a password. > > Thanks, > > – gw 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: ~/rubinius \> irb > > require ‘rubygems’ > > =\> false > > require ‘mysql.bundle’ > > =\> true Cheers- - Ezra Z. – Founder & Software Architect – removed\_email\_address@domain.invalid – [EngineYard.com](http://EngineYard.com) ---
**Author:** ![S-gw](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/ed655f/32.png) [@S-gw](https://www.ruby-forum.com/u/S-gw)\ **Post date:** [March 29, 2008, 10:19am UTC](https://www.ruby-forum.com/t/mysql-lost-connection-errors/133239/3 "2008-03-29T10:19:18Z")
> On Mar 28, 2008, at 10:24 PM, Greg W. wrote: > > > 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. I will pursue this line further. Thanks! – gw ---
**Author:** ![S-gw](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/ed655f/32.png) [@S-gw](https://www.ruby-forum.com/u/S-gw)\ **Post date:** [March 29, 2008, 11:27am UTC](https://www.ruby-forum.com/t/mysql-lost-connection-errors/133239/4 "2008-03-29T11:27:51Z")
On Mar 29, 2008, at 2:18 AM, Greg W. wrote: > > 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? – gw ---
**Author:** ![S-gw](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/ed655f/32.png) [@S-gw](https://www.ruby-forum.com/u/S-gw)\ **Post date:** [March 29, 2008, 8:03pm UTC](https://www.ruby-forum.com/t/mysql-lost-connection-errors/133239/5 "2008-03-29T20:03:03Z")
On Mar 29, 2008, at 3:26 AM, Greg W. wrote: > > > pure ruby ones that rails falls back to do this diconnection dance > > or elswhere to ensure the C version gets used instead of the Ruby > version? > > – gw Yeah it should get used automatically if you have it installed. Cheers- - Ezra Z. – Founder & Software Architect – removed\_email\_address@domain.invalid – [EngineYard.com](http://EngineYard.com) ---
**Author:** ![S-gw](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/ed655f/32.png) [@S-gw](https://www.ruby-forum.com/u/S-gw)\ **Post date:** [March 29, 2008, 11:13pm UTC](https://www.ruby-forum.com/t/mysql-lost-connection-errors/133239/6 "2008-03-29T23:13:40Z")
> > > 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: > > [http://groups.google.com/group/rubyonrails-talk/browse\_thread/](http://groups.google.com/group/rubyonrails-talk/browse_thread/) > thread/320984b2a7f117/dae118da427aa979 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. Thanks guys, – gw ---
**Author:** ![S-gw](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/ed655f/32.png) [@S-gw](https://www.ruby-forum.com/u/S-gw)\ **Post date:** [March 29, 2008, 8:12pm UTC](https://www.ruby-forum.com/t/mysql-lost-connection-errors/133239/7 "2008-03-29T20:12:29Z")
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: [http://groups.google.com/group/rubyonrails-talk/browse\_thread/thread/320984b2a7f117/dae118da427aa979](http://groups.google.com/group/rubyonrails-talk/browse_thread/thread/320984b2a7f117/dae118da427aa979)