Project

General

Profile

Actions

Defect #8907

closed

Redmine spontaneously stops running and returns 500 errors under Passenger

Added by Steve Voida almost 14 years ago. Updated over 13 years ago.

Status:
Closed
Priority:
High
Assignee:
-
Category:
-
Target version:
-
Start date:
2011-07-26
Due date:
% Done:

0%

Estimated time:
Resolution:
Invalid
Affected version:

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...)

Actions

Also available in: Atom PDF