Rails - Sep 2005 - RE: ActiveRecord::StatementInvalid error after app has beenrunning for a while

I have this problem as well... After so many hours of inactivity, I get
"statement invalid" and if I restart Apache or WEBrick, everything
works
fine again.  

What steps can I take to fix this? I don''t want to have to restart the
server!

-Brian


-----Original Message-----
From: rails-bounces-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org
[mailto:rails-bounces-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org] On
Behalf Of Steve Downey
Sent: Wednesday, August 31, 2005 2:11 PM
To: tom-RNG44s5WON3LoSKbeXgoW6xOck334EZe@public.gmane.org;
rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org
Subject: Re: [Rails] ActiveRecord::StatementInvalid error after app has
beenrunning for a while


Thomas Parslow wrote:
>Hi,
>
>I''m having a bit of a problem with a rails app and I wonder if
anyone
>can help.
>
>It seems to run fine for a while, but if it''s left running too long
>(left running as a fastcgi or webrick process that is) it starts 
>failing with an "ActiveRecord::StatementInvalid" error
(i''ve included
>the full error from the log file below).
>
>I''m seeing this on both WEBrick on Windows XP (development
>environment) and Apache 2 with Fast CGI on Windows 2000 (production). 
>Both using MySQL 4.1.13.
>
>Does anyone have any idea what the problem could be?
>
>  
>
I seem to remember someone saying that MySql (on Windows?) will 
disconnect after some amount of time (8 hours) if there is no activity.

Could that be your problem?
_______________________________________________
Rails mailing list
Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org
http://lists.rubyonrails.org/mailman/listinfo/rails