Re: mysql errors in production after upgrading to rails 2

phil wrote:
> I'm trying to upgrade our production server to rails 2. I've already
> done this on my dev machine (osx) and it worked fine. But now, with
> everything at the same version, but running in production mode, the
> production machine - a CentOS5 box - is getting loads of:
> ActiveRecord::StatementInvalid (Mysql::Error: Lost connection to MySQL
> server during query
> errors.
> 
> i"ve looked around but not found any valid reason why this should be
> happening. the mysql is version 5.0.22. Ruby 1.8.6 rails 2.0.2.
> 
> Without solving this I guess we are going back to Rails 1.2.6, but the
> real problem is that it is causing my boss and team to question the
> entire stability of Rails!
> 
> I've just set the server to run in development mode and it works a
> treat!!! What is up with that?

what else have you tried?

you tried running in production mode locally?
you tried "ruby script/console production" on the box?
is this mongrel and apache?
or what?

is it every query?
or just some special long queries?
--

-- 
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk@...
To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe@...
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---