Lost connection to MySQL server during query: SHOW FIELDS FROM orders

I am getting an intermittent error, the one above. I have not gone into
production, i am still in development. I seem to lose connection to the
MySQL server. If I do a refresh it comes back and all is fine.

I have not been able to duplicate this. It simply occurs perhaps 1 out
of ten times. Is this a characteristic of the development mode? I am
using WEBrick.
thanks, minka.

Here is the error:
ActiveRecord::StatementInvalid in ProductsController#save_order
Mysql::Error: Lost connection to MySQL server during query: SHOW FIELDS
FROM orders

Here is a partial trace:
RAILS_ROOT: script/../config/..
Application Trace | Framework Trace | Full Trace

app/controllers/products_controller.rb:87:in `save_order'

It might be related to using the ruby mysql bindings instead of the native C bindings for your platform. Install the 'mysql' gem. It will build a native code extension callable from ruby which eliminates most mysql connection drops.

After installing the gem, make sure it is active by doing the following (swiped this from a post earlier this week!):

cremes$ irb
irb(main):001:0> require 'rubygems'
=> true
irb(main):002:0> require 'mysql'
=> false
irb(main):003:0> puts Mysql::VERSION
=> nil


If all else fails, try pre-loading your models if you are storing whole
objects in the session. I was having what appeared to be intermittent
db issues but the problem was the serialization of objects to the

class ApplicationController < ActionController::Base
      model :order, :member, :cart

Good luck,