16 May 02:42
Re: mysql errors in production after upgrading to rails 2
From: Ryan Bigg (Radar <radarlistener@...>
Subject: Re: mysql errors in production after upgrading to rails 2
Newsgroups: gmane.comp.lang.ruby.rails
Date: 2008-05-16 00:42:13 GMT
Subject: Re: mysql errors in production after upgrading to rails 2
Newsgroups: gmane.comp.lang.ruby.rails
Date: 2008-05-16 00:42:13 GMT
I think this is more of an ActiveRecord problem, because I was getting the same thing when I was using my IRC bot to log channels into a database through ActiveRecord. It usually happened for no apparent reason, but every few mintues it would drop a query, very annoying. Switched over to sqlite3 which seemed to work fine, but I'm guessing you don't want to do this.
The only thing I can suggest is changing database servers, perhaps to postgres?
On Fri, May 16, 2008 at 8:01 AM, Matthew Rudy Jacobs <rails-mailing-list-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> wrote:
what else have you tried?
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?
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/.
--
Ryan Bigg
http://www.frozenplague.net
Feel free to add me to MSN and/or GTalk as this email.
--~--~---------~--~----~------------~-------~--~----~
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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---
RSS Feed