Defect #8907
closedRedmine spontaneously stops running and returns 500 errors under Passenger
0%
Description
Redmine seems to be spontaneously crashing under Passenger 3.0.7 on OSX 10.6.8. I've tried updating various system components and re-migrating the database, but with no avail.
Typically, if I restart the Apache server, things run fine for some indeterminate period of time, after which point I start getting 500 errors back from the server.
(Sorry -- new to Rails and Passenger, so if more information is needed, I can provide it!)
Database version MySQL Community Server 5.5.14 Webserver environment Apache/2.2.17 (Unix) mod_ssl/2.2.17 OpenSSL/0.9.8r SVN/1.6.16 Phusion_Passenger/3.0.7 mod_perl/2.0.4 Perl/v5.10.0 Ruby version 1.8.7 (universal-darwin10.0) RubyGems version 1.3.7 Rack version 1.1.1 Rails version 2.3.11 Active Record version 2.3.11 Active Resource version 2.3.11 Action Mailer version 2.3.11 Active Support version 2.3.11 Edge Rails revision unknown Application root /Library/WebServer/RailsApps/redmine Environment production Database adapter mysql Database schema version 20110511000000
Here are the relevant bits from the production.log. Note the time elapsed between the successful welcome page render (02:18:03) and the failure (11:22:06).
Processing WelcomeController#index (for 72.194.118.152 at 2011-07-26 02:18:03) [GET] Parameters: {"action"=>"index", "controller"=>"welcome"} Rendering template within layouts/base Rendering welcome/index Completed in 24ms (View: 11, DB: 7) | 200 OK [https://<<servername>>/code] /!\ FAILSAFE /!\ Tue Jul 26 11:22:06 -0700 2011 Status: 500 Internal Server Error Broken pipe /Library/Ruby/Site/1.8/mysql/protocol.rb:617:in `flush' /Library/Ruby/Site/1.8/mysql/protocol.rb:617:in `write' /System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/1.8/timeout.rb:53:in `timeout' /Library/Ruby/Site/1.8/mysql/protocol.rb:616:in `write' /Library/Ruby/Site/1.8/mysql/protocol.rb:640:in `simple_command' /Library/Ruby/Site/1.8/mysql/protocol.rb:545:in `synchronize' /Library/Ruby/Site/1.8/mysql/protocol.rb:638:in `simple_command' /Library/Ruby/Site/1.8/mysql/protocol.rb:413:in `statistics_command' /Library/Ruby/Site/1.8/mysql.rb:502:in `stat' /Library/WebServer/RailsApps/redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:277:in `active?' /Library/WebServer/RailsApps/redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:152:in `verify!' /Library/WebServer/RailsApps/redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:256:in `checkout_and_verify' /Library/WebServer/RailsApps/redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:252:in `checkout_existing_connection' /Library/WebServer/RailsApps/redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:186:in `checkout' /Library/WebServer/RailsApps/redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:184:in `loop' /Library/WebServer/RailsApps/redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:184:in `checkout' /System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/1.8/monitor.rb:242:in `synchronize' /Library/WebServer/RailsApps/redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:183:in `checkout' /Library/WebServer/RailsApps/redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:98:in `connection' /Library/WebServer/RailsApps/redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:326:in `retrieve_connection' /Library/WebServer/RailsApps/redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:123:in `retrieve_connection' /Library/WebServer/RailsApps/redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:115:in `connection' /Library/WebServer/RailsApps/redmine/vendor/rails/activerecord/lib/active_record/query_cache.rb:9:in `cache' /Library/WebServer/RailsApps/redmine/vendor/rails/activerecord/lib/active_record/query_cache.rb:28:in `call' /Library/WebServer/RailsApps/redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:361:in `call' /Library/WebServer/RailsApps/redmine/vendor/rails/actionpack/lib/action_controller/string_coercion.rb:25:in `call' /Library/Ruby/Gems/1.8/gems/rack-1.1.1/lib/rack/head.rb:9:in `call' /Library/Ruby/Gems/1.8/gems/rack-1.1.1/lib/rack/methodoverride.rb:24:in `call' /Library/WebServer/RailsApps/redmine/vendor/rails/actionpack/lib/action_controller/params_parser.rb:15:in `call' /Library/WebServer/RailsApps/redmine/vendor/rails/actionpack/lib/action_controller/session/cookie_store.rb:99:in `call' /Library/WebServer/RailsApps/redmine/vendor/rails/actionpack/lib/action_controller/failsafe.rb:26:in `call' /Library/Ruby/Gems/1.8/gems/rack-1.1.1/lib/rack/lock.rb:11:in `call' /Library/Ruby/Gems/1.8/gems/rack-1.1.1/lib/rack/lock.rb:11:in `synchronize' /Library/Ruby/Gems/1.8/gems/rack-1.1.1/lib/rack/lock.rb:11:in `call' /Library/WebServer/RailsApps/redmine/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:106:in `call' /Library/Ruby/Gems/1.8/gems/passenger-3.0.7/lib/phusion_passenger/rack/request_handler.rb:96:in `process_request' /Library/Ruby/Gems/1.8/gems/passenger-3.0.7/lib/phusion_passenger/abstract_request_handler.rb:513:in `accept_and_process_next_request' /Library/Ruby/Gems/1.8/gems/passenger-3.0.7/lib/phusion_passenger/abstract_request_handler.rb:274:in `main_loop' /Library/Ruby/Gems/1.8/gems/passenger-3.0.7/lib/phusion_passenger/classic_rails/application_spawner.rb:321:in `start_request_handler' /Library/Ruby/Gems/1.8/gems/passenger-3.0.7/lib/phusion_passenger/classic_rails/application_spawner.rb:275:in `send' /Library/Ruby/Gems/1.8/gems/passenger-3.0.7/lib/phusion_passenger/classic_rails/application_spawner.rb:275:in `handle_spawn_application' /Library/Ruby/Gems/1.8/gems/passenger-3.0.7/lib/phusion_passenger/utils.rb:479:in `safe_fork' /Library/Ruby/Gems/1.8/gems/passenger-3.0.7/lib/phusion_passenger/classic_rails/application_spawner.rb:270:in `handle_spawn_application' /Library/Ruby/Gems/1.8/gems/passenger-3.0.7/lib/phusion_passenger/abstract_server.rb:357:in `__send__' /Library/Ruby/Gems/1.8/gems/passenger-3.0.7/lib/phusion_passenger/abstract_server.rb:357:in `server_main_loop' /Library/Ruby/Gems/1.8/gems/passenger-3.0.7/lib/phusion_passenger/abstract_server.rb:206:in `start_synchronously' /Library/Ruby/Gems/1.8/gems/passenger-3.0.7/lib/phusion_passenger/abstract_server.rb:180:in `start' /Library/Ruby/Gems/1.8/gems/passenger-3.0.7/lib/phusion_passenger/classic_rails/application_spawner.rb:149:in `start' /Library/Ruby/Gems/1.8/gems/passenger-3.0.7/lib/phusion_passenger/spawn_manager.rb:219:in `spawn_rails_application' /Library/Ruby/Gems/1.8/gems/passenger-3.0.7/lib/phusion_passenger/abstract_server_collection.rb:132:in `lookup_or_add' /Library/Ruby/Gems/1.8/gems/passenger-3.0.7/lib/phusion_passenger/spawn_manager.rb:214:in `spawn_rails_application' /Library/Ruby/Gems/1.8/gems/passenger-3.0.7/lib/phusion_passenger/abstract_server_collection.rb:82:in `synchronize' /Library/Ruby/Gems/1.8/gems/passenger-3.0.7/lib/phusion_passenger/abstract_server_collection.rb:79:in `synchronize' /Library/Ruby/Gems/1.8/gems/passenger-3.0.7/lib/phusion_passenger/spawn_manager.rb:213:in `spawn_rails_application' /Library/Ruby/Gems/1.8/gems/passenger-3.0.7/lib/phusion_passenger/spawn_manager.rb:132:in `spawn_application' /Library/Ruby/Gems/1.8/gems/passenger-3.0.7/lib/phusion_passenger/spawn_manager.rb:275:in `handle_spawn_application' /Library/Ruby/Gems/1.8/gems/passenger-3.0.7/lib/phusion_passenger/abstract_server.rb:357:in `__send__' /Library/Ruby/Gems/1.8/gems/passenger-3.0.7/lib/phusion_passenger/abstract_server.rb:357:in `server_main_loop' /Library/Ruby/Gems/1.8/gems/passenger-3.0.7/lib/phusion_passenger/abstract_server.rb:206:in `start_synchronously' /Library/Ruby/Gems/1.8/gems/passenger-3.0.7/helper-scripts/passenger-spawn-server:99 Processing WelcomeController#index (for 169.234.7.45 at 2011-07-26 11:32:08) [GET] Parameters: {"action"=>"index", "controller"=>"welcome"} Rendering template within layouts/base Rendering welcome/index Completed in 162ms (View: 67, DB: 57) | 200 OK [https://cheddar.ics.uci.edu/code]
The only other potentially relevant bit I can come up with is that I've implemented the steps listed in the tutorial "HowTo configure Redmine for advanced Subversion integration" and am running both Redmine.pm to provide access control to the SVN repos and respoman (as a LaunchCtl task) to automatically generate repositories. This might account for the seemingly spontaneous nature of the failures, but I've followed all the directions as closely as I can and don't see anything particularly amiss in the Apache logs to suggest that this is the source of the problem. (The Apache logs are strangely silent on all of this...)