Re: mysql errors in production after upgrading to rails 2

On 16 May 2008, at 07:27, phil wrote:

>
> And the same query that I get this on:
> ActiveRecord::StatementInvalid (Mysql::Error: Lost connection to MySQL
> server during query:
>
> I can run from the console.
>
> So it definitely seem to be how mongrel is connecting to mysql. I am
> not using the mysql gem (I wasn't before under 1.2.6 either) I am
> connecting with the builtin mysql adaptor.
>

The pure ruby mysql stuff is completely obsolete. Give the gem ago.

Fred

> On May 16, 12:31 am, Matthew Rudy Jacobs <rails-mailing-l...@andreas-
> s.net> wrote:
>> 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 viahttp://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
-~----------~----~----~----~------~----~------~--~---