[Boulder-Denver Ruby Group] Rails DB Con timeout

[Bruce Williams]

On 11/9/06, Kyle <inboulder at gmail.com> wrote:
> Hi,
> I'm new to rails and put together my first rails app at
> http://69.55.233.76/journal .
> I'm experiencing a bit of a problem though in that if nobody hits the
> app for a few hours the DB connection times out. Does anyone have
> experience fixing this? I've read about this problem online and
> updated everything rails, gems, etc. The behavior manifests as
> 'Application Error (rails)' if nobody has accessed the app for awhile,
> but then starts working again on a browser refresh. (before updating
> rails it timed out indefinitely)
> I'm using the latest MySQL, Rails, Ruby ver, running on Fedora core 4.
> The behavior is the same on mongrel and Webrick
>

Kyle,

Maybe take a look at http://dev.rubyonrails.org/ticket/428; it's an
old ticket, but there are some links and recommended courses of action
there (especially if you're using FastCGI for some reason);.  It may
be as easy as a my.cnf change.

Hope that helps.

Cheers,
Bruce