Some have reported that changing the ActiveRecord verification_timeout value doesn't help with this problem. Try increasing the interactive_timeout and/or wait_timeout in your MySQL server and see if that helps.
Pete DeLaurentis wrote: > Thanks for the tip. We're not using log rotation and have already > tried adjusting the activerecord timeout. > > One thing not tried yet: the mysql gem > > -Pete > > > > On Jul 30, 2007, at 11:57 PM, Piyush Ranjan wrote: > >> had there been a error, things would have been very easier then :P >> >> On 7/30/07, Matt Zukowski <[EMAIL PROTECTED] > wrote: >> Check two things: >> >> - Database connection might be getting closed by the DB server (we've >> had this exact problem with MySQL) >> - Logs might be getting rotated (although you'd probably get a different >> error if this were the case) >> >> >> Olly Lylo wrote: >> > Hi >> > I posted this to the Ruby on Rails Talk group but I thought I'd >> post it here >> > too as it's probably a more appropriate group. Hope this is ok. >> > >> > I'm running a 2-instance Mongrel cluster behind Apache 2.2.4 with >> Rails >> > 1.2.3. If no requests are received by the application for several >> hours >> > (this usually happens overnight) then Mongrel stops >> > responding and no requests are detected by Rails (at least nothing >> is in the >> > Rails log). Nothing untoward is in the Mongrel log. >> > >> > If you try and visit the application, the request times out with a >> 502 Proxy >> > Error. Apache is still up and running and serving static files >> without a >> > problem, but the following is present in the Apache error log (from >> trying >> > to hit the SessionController, identified by / sessions) which may >> provide a >> > clue: >> > >> > [Sun Jul 29 08:37:36 2007] [error] proxy: error reading status >> line from >> > remote server 127.0.0.1 >> > [Sun Jul 29 08:37:36 2007] [error] proxy: Error reading from >> remote >> > server returned by /sessions >> > >> > Restarting the Mongrel cluster resolves the problem until the next >> time it >> > happens. I have done a lot of reading about this issue online and >> a number >> > of sources -- including the Mongrel FAQ -- point to being able to >> fix a >> > 'hanging mongrel' situation by setting this value in environment.rb: >> > >> > ActiveRecord::Base.verification_timeout = 14400 >> > >> > This make the ActiveRecord timeout value less than the MySQL >> default of >> > 28800. I have made this change and it doesn't appear to make a >> difference. >> > >> > Can anyone advise me on what to try next to diagnose this issue? >> > I'm quickly running out of ideas and I'd appreciate a bit of help! >> > >> > Here are the vitals from our Ubuntu 6.0.6 server: >> > >> > MySQL >> > Ver 14.12 Distrib 5.0.22, for pc-linux-gnu (x86_64) using >> readline >> > 5.1 >> > connect_timeout 5 >> > interactive_timeout 28800 >> > max_connect_errors 10 >> > max_connections 100 >> > max_user_connections 0 >> > wait_timeout 28800 >> > >> > ruby 1.8.6 (2007-03-13 patchlevel 0) [x86_64-linux] >> > cgi_multipart_eof_fix (2.2) >> > fastthread (1.0) >> > mongrel (1.0.1) >> > mongrel_cluster (1.0.2) >> > >> > Apache/2.2.4 (Unix) >> > >> > Mongrel Cluster Config: >> > port: "8000" >> > environment: production >> > address: 127.0.0.1 >> > pid_file: log/mongrel.pid >> > servers: 2 >> > user: [the user] >> > group: [the group] >> > >> > Apache Load Balancer setup: >> > <Proxy balancer://appname_cluster> >> > BalancerMember http://127.0.0.1:8000 >> > BalancerMember http://127.0.0.1:8001 >> > </Proxy> >> > >> > Apache Loaded Modules: >> > core_module (static) >> > authn_file_module (static) >> > authn_default_module (static) >> > authz_host_module (static) >> > authz_groupfile_module (static) >> > authz_user_module (static) >> > authz_default_module (static) >> > auth_basic_module (static) >> > cache_module (static) >> > include_module (static) >> > filter_module (static) >> > deflate_module (static) >> > log_config_module (static) >> > env_module (static) >> > headers_module (static) >> > setenvif_module (static) >> > proxy_module (static) >> > proxy_connect_module (static) >> > proxy_ftp_module (static) >> > proxy_http_module (static) >> > proxy_ajp_module (static) >> > proxy_balancer_module (static) >> > ssl_module (static) >> > mpm_prefork_module (static) >> > http_module (static) >> > mime_module (static) >> > status_module (static) >> > autoindex_module (static) >> > asis_module (static) >> > cgi_module (static) >> > negotiation_module (static) >> > dir_module (static) >> > actions_module (static) >> > userdir_module (static) >> > alias_module (static) >> > rewrite_module (static) >> > so_module (static) >> > php5_module (shared) >> > info_module (shared) >> > >> > >> > >> ------------------------------------------------------------------------ >> > >> > _______________________________________________ >> > Mongrel-users mailing list >> > [email protected] >> > http://rubyforge.org/mailman/listinfo/mongrel-users >> >> >> >> This e-mail message is privileged, confidential and subject to >> copyright. Any unauthorized use or disclosure is prohibited. >> Le contenu du pr'esent courriel est privil'egi'e, confidentiel et >> soumis `a des droits d'auteur. Il est interdit de l'utiliser ou de le >> divulguer sans autorisation. >> >> >> _______________________________________________ >> Mongrel-users mailing list >> [email protected] >> http://rubyforge.org/mailman/listinfo/mongrel-users > > > ------------------------------------------------------------------------ > > _______________________________________________ > Mongrel-users mailing list > [email protected] > http://rubyforge.org/mailman/listinfo/mongrel-users _______________________________________________ Mongrel-users mailing list [email protected] http://rubyforge.org/mailman/listinfo/mongrel-users
