_______________________________________________ Rails mailing list Rails@lists.rubyonrails.org http://lists.rubyonrails.org/mailman/listinfo/rails
on 2005-12-12 19:46
on 2005-12-12 20:16
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
on 2005-12-12 20:49
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,
on 2005-12-12 23:47
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.
on 2005-12-13 18:05
Anatol Pomozov 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.