forgot password?
Forum Home > Installation > Windows > Thread
   
 
Restart Tracks every morning
 
mcraven
Posted: 07 May 2009 03:34 PM   [ Ignore ]  
Newbie
Rank
Total Posts:  10
Joined  2009-04-02

I have Tracks 1.7 installed on a Windows Server 2003 system using Apache and MySQL. I use it all day long. Then every morning when I come in to work I try to re-login to the server but I get an error. I have found the only way to fix it is to restart Tracks and Apache. The resulting log file is attached. Any Idea what is going on?

Regards,
Mark C.

P.S. - Why can’t you attach a text file or a higher resolution image?

Image Attachments
production.png
Click thumbnail to see full-size image
Profile
 
 
Reinier Balt
Posted: 07 May 2009 06:07 PM   [ Ignore ]   [ # 1 ]  
Sr. Member
RankRankRankRank
Total Posts:  882
Joined  2006-10-05

sorry, but I cannot read the trace. Perhaps just copy-and-paste into the post?
Profile
 
 
mcraven
Posted: 07 May 2009 06:14 PM   [ Ignore ]   [ # 2 ]  
Newbie
Rank
Total Posts:  10
Joined  2009-04-02

Too big for a single post. First half:

/!\ FAILSAFE /!\  Thu May 07 08:12:09 -0700 2009
  Status: 500 Internal Server Error
  Invalid argument
    d:/ruby/lib/ruby/1.8/mysql.rb:1042:in `flush'
    d:/ruby/lib/ruby/1.8/mysql.rb:1042:in `write'
    d:/ruby/lib/ruby/1.8/mysql.rb:462:in `write'
    d:/ruby/lib/ruby/1.8/mysql.rb:436:in `command'
    d:/ruby/lib/ruby/1.8/mysql.rb:307:in `stat'
    d:/tracks/vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:264:in `active?'
    d:/tracks/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:136:in `verify!'
    d:/tracks/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:256:in `checkout_and_verify'
    d:/tracks/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:252:in `checkout_existing_connection'
    d:/tracks/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:186:in `checkout'
    d:/tracks/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:184:in `loop'
    d:/tracks/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:184:in `checkout'
    d:/ruby/lib/ruby/1.8/monitor.rb:242:in `synchronize'
    d:/tracks/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:183:in `checkout'
    d:/tracks/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:98:in `connection'
    d:/tracks/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:326:in `retrieve_connection'
    d:/tracks/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:121:in `retrieve_connection'
    d:/tracks/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:113:in `connection'
    d:/tracks/vendor/rails/activerecord/lib/active_record/base.rb:2934:in `quoted_table_name'
    d:/tracks/vendor/rails/activerecord/lib/active_record/base.rb:1626:in `construct_finder_sql'
    d:/tracks/vendor/rails/activerecord/lib/active_record/base.rb:1490:in `find_every'
    d:/tracks/vendor/rails/activerecord/lib/active_record/base.rb:1452:in `find_initial'
    d:/tracks/vendor/rails/activerecord/lib/active_record/base.rb:587:in `find'
    d:/tracks/vendor/rails/actionpack/lib/action_controller/session/active_record_store.rb:113:in `find_by_session_id'
    d:/tracks/vendor/rails/actionpack/lib/action_controller/session/active_record_store.rb:288:in `initialize'
    d:/tracks/vendor/rails/activerecord/lib/active_record/base.rb:1398:in `silence'
    d:/tracks/vendor/rails/actionpack/lib/action_controller/session/active_record_store.rb:288:in `initialize'
    d:/ruby/lib/ruby/1.8/cgi/session.rb:273:in `new'
    d:/ruby/lib/ruby/1.8/cgi/session.rb:273:in `initialize_without_cgi_reader'
    d:/tracks/vendor/rails/actionpack/lib/action_controller/cgi_ext/session.rb:19:in `initialize'
    d:/tracks/vendor/rails/actionpack/lib/action_controller/cgi_process.rb:94:in `new'
    d:/tracks/vendor/rails/actionpack/lib/action_controller/cgi_process.rb:94:in `session'
    d:/tracks/vendor/rails/actionpack/lib/action_controller/cgi_process.rb:130:in `stale_session_check!' 
Profile
 
 
mcraven
Posted: 07 May 2009 06:15 PM   [ Ignore ]   [ # 3 ]  
Newbie
Rank
Total Posts:  10
Joined  2009-04-02

Second half:

d:/tracks/vendor/rails/actionpack/lib/action_controller/cgi_process.rb:78:in `session'
    d:/tracks/vendor/rails/actionpack/lib/action_controller/base.rb:1205:in `assign_shortcuts_without_flash'
    d:/tracks/vendor/rails/actionpack/lib/action_controller/flash.rb:166:in `assign_shortcuts'
    d:/tracks/vendor/rails/actionpack/lib/action_controller/base.rb:519:in `process_without_filters'
    d:/tracks/vendor/rails/actionpack/lib/action_controller/filters.rb:606:in `process_without_session_management_support'
    d:/tracks/vendor/rails/actionpack/lib/action_controller/session_management.rb:134:in `process'
    d:/tracks/vendor/rails/actionpack/lib/action_controller/base.rb:392:in `process'
    d:/tracks/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:183:in `handle_request'
    d:/tracks/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:110:in `dispatch_unlocked'
    d:/tracks/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:123:in `dispatch'
    d:/tracks/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:122:in `synchronize'
    d:/tracks/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:122:in `dispatch'
    d:/tracks/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:132:in `dispatch_cgi'
    d:/tracks/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:39:in `dispatch'
    d:/tracks/vendor/rails/railties/lib/webrick_server.rb:103:in `handle_dispatch'
    d:/tracks/vendor/rails/railties/lib/webrick_server.rb:74:in `service'
    d:/ruby/lib/ruby/1.8/webrick/httpserver.rb:104:in `service'
    d:/ruby/lib/ruby/1.8/webrick/httpserver.rb:65:in `run'
    d:/ruby/lib/ruby/1.8/webrick/server.rb:173:in `start_thread'
    d:/ruby/lib/ruby/1.8/webrick/server.rb:162:in `start'
    d:/ruby/lib/ruby/1.8/webrick/server.rb:162:in `start_thread'
    d:/ruby/lib/ruby/1.8/webrick/server.rb:95:in `start'
    d:/ruby/lib/ruby/1.8/webrick/server.rb:92:in `each'
    d:/ruby/lib/ruby/1.8/webrick/server.rb:92:in `start'
    d:/ruby/lib/ruby/1.8/webrick/server.rb:23:in `start'
    d:/ruby/lib/ruby/1.8/webrick/server.rb:82:in `start'
    d:/tracks/vendor/rails/railties/lib/webrick_server.rb:60:in `dispatch'
    d:/tracks/vendor/rails/railties/lib/commands/servers/webrick.rb:66
    d:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `gem_original_require'
    d:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `require'
    d:/tracks/vendor/rails/activesupport/lib/active_support/dependencies.rb:153:in `require'
    d:/tracks/vendor/rails/activesupport/lib/active_support/dependencies.rb:521:in `new_constants_in'
    d:/tracks/vendor/rails/activesupport/lib/active_support/dependencies.rb:153:in `require'
    d:/tracks/vendor/rails/railties/lib/commands/server.rb:49
    d:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `gem_original_require'
    d:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `require'
    script/server:3 

Hope that helps.

Regards,
Mark C.
Profile
 
 
Reinier Balt
Posted: 07 May 2009 06:57 PM   [ Ignore ]   [ # 4 ]  
Sr. Member
RankRankRankRank
Total Posts:  882
Joined  2006-10-05

looks to me that the connection with mysql is lost and rails cannot recover.

You could google around how to enable automatic reconnect to mysql in rails apps.
Profile
 
 
mcraven
Posted: 14 May 2009 03:54 PM   [ Ignore ]   [ # 5 ]  
Newbie
Rank
Total Posts:  10
Joined  2009-04-02

Rails 2.3 includes an option that can be set in the database.yml file to enable reconnect for MySQL.

Mark C.
Profile
 
 
Reinier Balt
Posted: 14 May 2009 07:51 PM   [ Ignore ]   [ # 6 ]  
Sr. Member
RankRankRankRank
Total Posts:  882
Joined  2006-10-05

do you know which option?
Profile
 
 
mcraven
Posted: 14 May 2009 08:10 PM   [ Ignore ]   [ # 7 ]  
Newbie
Rank
Total Posts:  10
Joined  2009-04-02

Take a look here:
http://guides.rubyonrails.org/2_3_release_notes.html#reconnecting-mysql-connections

Mark C.
Profile
 
 
   
 
 
‹‹ Installation on Godaddy Server      Windows Installation for Tracks 1.7 for basic pc user ››