Rails crashes over night?


#1

Rails mailing list
removed_email_address@domain.invalid
http://lists.rubyonrails.org/mailman/listinfo/rails


#2

On Mon, 12 Dec 2005, Stephan van Erp wrote:

I’m running Ruby on Rails on Fedora Core 4 with lighttpd and fastcgi. I also
used the login generator (don’t know if relevant). I have the following
problem: At day time I work on the server and create/modify ruby files on
the server, all pages work fine. Than the next day I want to open de server
I get the error at the end of this message (on all pages, including non
protected).

If I restart lighttpd everything works again. Any ideas on how to fix this?
This happens every day…

switch to postgresql? seriously - this alone might fix.

we have alot of issues here (noaa) with mysql dropping connections for
24/7
type applications. i’ve never seen it happen with postgres,
however.

regards.

-a


#3

Stephan van Erp schrieb:

If I restart lighttpd everything works again. Any ideas on how to fix
this? This happens every day…

I had such behaviour years ago in a piece of java server I’ve written.
It was a timeout issue on the sql server (mysql) side. Did you hold any
connections to speed up something?

My problem was, that my open connection wasn’t close propably and the
mysql server disconnected. So the next query produced a error like yours
(of course, the exception was a bit different as it was thrown out of my
java system).

I’m a little bit suprised because I haven’t a huge experience with RoR
yet and my guess was, that AR handle the connection prober (?!).

HTH,


#4

AFAIK if connection to MySQL database is dropped then mysql-connector
JDBC
driver tries to reconnect several times to server. Only then it drops
exception.

I would be really cool to see such functionality in ActiveRecord (or
mysql
driver??) because this problem with connection timeout very annoying me
as
well.


#5

Anatol P. schrieb:

AFAIK if connection to MySQL database is dropped then mysql-connector
JDBC driver tries to reconnect several times to server. Only then it
drops exception.

I would be really cool to see such functionality in ActiveRecord (or
mysql driver??) because this problem with connection timeout very
annoying me as well.

Yes, you have to pass an argument to the JDBC driver . In which case
this affects the ruby mysql driver as well was not tested by me.

g,

Daniel Völkerts
Protected by Anti Pesto.