Hi Everyone -
I have a rails 0.10.1 application deployed on a Windows 2003 server
under XAMPP Lite 1.4.12. Running under CGI, the application works fine
(a bit slow, obviously, but no problems).
When I run under FastCGI, the app is fine until I leave it alone for a
few hours. For example, last night I switched it to FastCGI and
everything seemed to be working fine. When I woke up this morning, the
app died with an Application Error. According to the logs, nothing
happened between the time it worked last night and the time it failed
this morning.
Here''s the log of the successful run last night:
--- Begin Log ---
Processing SurveyController#list (for 10.7.0.3 at Wed Mar 09 22:55:05
Eastern Standard Time 2005)
Parameters: {"action"=>"list",
"controller"=>"survey",
"survey/list.html/list"=>nil}
StudentSurvey Count (0.000000) SELECT COUNT(*) FROM student_surveys
StudentSurvey Load (0.016000) SELECT * FROM student_surveys ORDER BY
last_name asc, first_name, created_at LIMIT 20 OFFSET 0
Rendering survey/list within layouts/survey
CcoachRanking Load (0.000000) SELECT * FROM ccoach_rankings WHERE id =
7 LIMIT 1
CcoachRanking Load (0.000000) SELECT * FROM ccoach_rankings WHERE id =
10 LIMIT 1
CcoachRanking Load (0.000000) SELECT * FROM ccoach_rankings WHERE id =
9 LIMIT 1
CcoachRanking Load (0.000000) SELECT * FROM ccoach_rankings WHERE id =
9 LIMIT 1
CcoachRanking Load (0.000000) SELECT * FROM ccoach_rankings WHERE id =
7 LIMIT 1
Rendering layouts/survey (200 OK)
Completed in 0.047000 (21 reqs/sec) | Rendering: 0.031000 (65%) | DB:
0.016000 (34%)
--- End Log ---
And here''s the log of the failure:
--- Begin Log ---
Processing SurveyController#list (for 10.7.0.3 at Thu Mar 10 08:02:24
Eastern Standard Time 2005)
Parameters: {"action"=>"list",
"controller"=>"survey",
"survey/list.html/list"=>nil}
StudentSurvey Count (0.000000) Invalid argument: SELECT COUNT(*) FROM
student_surveys
ActiveRecord::StatementInvalid (Invalid argument: SELECT COUNT(*) FROM
student_surveys ):
C:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.8.0/lib/active_record/
connection_adapters/abstract_adapter.rb:409:in `log''
C:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.8.0/lib/active_record/
connection_adapters/mysql_adapter.rb:116:in `execute''
C:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.8.0/lib/active_record/
connection_adapters/mysql_adapter.rb:194:in `select''
C:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.8.0/lib/active_record/
connection_adapters/mysql_adapter.rb:98:in `select_one''
C:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.8.0/lib/active_record/
base.rb:446:in `count_by_sql''
C:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.8.0/lib/active_record/
base.rb:439:in `count''
/app/helpers/pagination_helper.rb:222:in
`count_collection_for_pagination''
/app/helpers/pagination_helper.rb:238:in
`paginator_and_collection_for''
/app/helpers/pagination_helper.rb:179:in `paginate''
C:/clg003/survey/app/controllers/survey_controller.rb:49:in `list''
C:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.5.1/lib/action_controller/
base.rb:678:in `send''
C:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.5.1/lib/action_controller/
base.rb:678:in `perform_action_without_filters''
C:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.5.1/lib/action_controller/
filters.rb:294:in `perform_action_without_benchmark''
C:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.5.1/lib/action_controller/
benchmarking.rb:30:in `perform_action_without_rescue''
C:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.5.1/lib/action_controller/
benchmarking.rb:30:in `measure''
C:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.5.1/lib/action_controller/
benchmarking.rb:30:in `perform_action_without_rescue''
C:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.5.1/lib/action_controller/
rescue.rb:79:in `perform_action''
C:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.5.1/lib/action_controller/
base.rb:320:in `send''
C:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.5.1/lib/action_controller/
base.rb:320:in `process''
C:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.5.1/lib/action_controller/
base.rb:263:in `process''
C:/ruby/lib/ruby/gems/1.8/gems/rails-0.10.1/lib/dispatcher.rb:32:in
`dispatch''
C:/clg003/survey/public/dispatch.fcgi:7
C:/clg003/survey/public/dispatch.fcgi:7:in `each_cgi''
C:/ruby/lib/ruby/site_ruby/1.8/fcgi.rb:597:in `each''
C:/ruby/lib/ruby/site_ruby/1.8/fcgi.rb:597:in `each_cgi''
C:/clg003/survey/public/dispatch.fcgi:7
--- End Log ---
Any ideas on where to start on debugging this one?
- Sean
