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
