http://mongrel.rubyforge.org/faq.html
From the FAQ:
Q: Mongrel stops working if it's left alone for a long time.
If you find that Mongrel stops working after a long idle time and you're using MySQL then you're hitting a bug in the MySQL driver that doesn't properly timeout connections. What happens is the MySQL server side of the connection times out and closes, but the MySQL client doesn't detect this and just sits there.
What you have to do is set:
ActiveRecord::Base.verification_timeout = 14400Or to any value that is lower than the MySQL server's interactive_timeout setting. This will make sure that ActiveRecord checks the connection often enough to reset the connection.
On 7/11/06, Ian Holsman <[EMAIL PROTECTED]> wrote:Hi guys.
I'm on the latest SVN trunk (1123) and using mysql 5.0.19.
I'm not sure what is going on.. as I just moved hosting providers and
not if it is that or typo.
regards
Ian
ActiveRecord::StatementInvalid (Mysql::Error: Lost connection to
MySQL server during query: UPDATE sessions SET `sessid` =
'6b08673361b2d7cd5780f3593d3e592a', `data` =
'BAh7CDoOcmV0dXJuX3RvMDoJdXNlcm86CVVzZXIGOhBAYXR0cmlidXRlc3sQ
\nIhZub3RpZnlfdmlhX2phYmJlciIGMCIJbmFtZSIQSWFuIEhvbHNtYW4iHW5v
\ndGlmeV93YXRjaF9teV9hcnRpY2xlczAiFW5vdGlmeV92aWFfZW1haWwiBjAi
\nB2lkIgYyIgtqYWJiZXIiFmtyeXRvbkBqYWJiZXIub3JnIhdub3RpZnlfb25f
\nY29tbWVudHMiBjAiDXBhc3N3b3JkIi1hYTU5ZjMzMTUwZTRmMzhkMjM5ZDE0
\nY2MwNjA4NzRmNWE2ZWI3NDQ3Igpsb2dpbiIJaWFuaCIbbm90aWZ5X29uX25l
\nd19hcnRpY2xlcyIGMCIKZW1haWwiACIKZmxhc2hJQzonQWN0aW9uQ29udHJv
\nbGxlcjo6Rmxhc2g6OkZsYXNoSGFzaHsABjoKQHVzZWR7AA==\n', `updated_at` =
'2006-07-11 21:35:40' WHERE id = 64708):
/vendor/rails/activerecord/lib/active_record/connection_adapters/
abstract_adapter.rb:120:in `log'
/vendor/rails/activerecord/lib/active_record/connection_adapters/
mysql_adapter.rb:184:in `execute'
/vendor/rails/activerecord/lib/active_record/connection_adapters/
mysql_adapter.rb:199:in `update'
/vendor/rails/activerecord/lib/active_record/base.rb:1723:in
`update_without_lock'
/vendor/rails/activerecord/lib/active_record/locking.rb:33:in
`update_without_callbacks'
/vendor/rails/activerecord/lib/active_record/callbacks.rb:274:in
`update_without_timestamps'
/vendor/rails/activerecord/lib/active_record/timestamp.rb:39:in
`update'
/vendor/rails/activerecord/lib/active_record/base.rb:1718:in
`create_or_update_without_callbacks'
/vendor/rails/activerecord/lib/active_record/callbacks.rb:249:in
`create_or_update'
/vendor/rails/activerecord/lib/active_record/base.rb:1392:in
`save_without_validation'
/vendor/rails/activerecord/lib/active_record/validations.rb:
724:in `save_without_transactions'
/vendor/rails/activerecord/lib/active_record/transactions.rb:
126:in `save'
/vendor/rails/activerecord/lib/active_record/connection_adapters/
abstract/database_statements.rb:51:in `transaction'
/vendor/rails/activerecord/lib/active_record/transactions.rb:
91:in `transaction'
/vendor/rails/activerecord/lib/active_record/transactions.rb:
118:in `transaction'
/vendor/rails/activerecord/lib/active_record/transactions.rb:
126:in `save'
/vendor/rails/actionpack/lib/action_controller/session/
active_record_store.rb:307:in `update'
/vendor/rails/activerecord/lib/active_record/base.rb:794:in
`silence'
/vendor/rails/actionpack/lib/action_controller/session/
active_record_store.rb:307:in `update'
/vendor/rails/actionpack/lib/action_controller/session/
active_record_store.rb:314:in `close'
/usr/local/lib/ruby/1.8/cgi/session.rb:330:in `close'
/vendor/rails/actionpack/lib/action_controller/base.rb:984:in
`close_session'
/vendor/rails/actionpack/lib/action_controller/base.rb:1026:in
`process_cleanup_without_flash'
/vendor/rails/actionpack/lib/action_controller/flash.rb:147:in
`process_cleanup_without_filters'
/vendor/rails/actionpack/lib/action_controller/filters.rb:439:in
`process_cleanup_without_session_management_support'
/vendor/rails/actionpack/lib/action_controller/
session_management.rb:126:in `process_cleanup_without_components'
/vendor/rails/actionpack/lib/action_controller/components.rb:
182:in `process_cleanup'
/vendor/rails/actionpack/lib/action_controller/base.rb:385:in
`process_without_filters'
/vendor/rails/actionpack/lib/action_controller/filters.rb:377:in
`process_without_session_management_support'
/vendor/rails/actionpack/lib/action_controller/
session_management.rb:117:in `process'
/vendor/rails/railties/lib/dispatcher.rb:38:in `dispatch'
/usr/local/lib/ruby/gems/1.8/gems/mongrel- 0.3.13.3/lib/mongrel/
rails.rb:73:in `process'
/usr/local/lib/ruby/gems/1.8/gems/mongrel-0.3.13.3/lib/
mongrel.rb:551:in `process_client'
/usr/local/lib/ruby/gems/1.8/gems/mongrel- 0.3.13.3/lib/
mongrel.rb:550:in `process_client'
/usr/local/lib/ruby/gems/1.8/gems/mongrel-0.3.13.3/lib/
mongrel.rb:636:in `run'
/usr/local/lib/ruby/gems/1.8/gems/mongrel- 0.3.13.3/lib/
mongrel.rb:636:in `run'
/usr/local/lib/ruby/gems/1.8/gems/mongrel-0.3.13.3/lib/
mongrel.rb:625:in `run'
/usr/local/lib/ruby/gems/1.8/gems/mongrel- 0.3.13.3/lib/
mongrel.rb:956:in `run'
/usr/local/lib/ruby/gems/1.8/gems/mongrel-0.3.13.3/lib/
mongrel.rb:955:in `run'
/usr/local/lib/ruby/gems/1.8/gems/mongrel- 0.3.13.3/bin/
mongrel_rails:127:in `run'
/usr/local/lib/ruby/gems/1.8/gems/mongrel-0.3.13.3/lib/mongrel/
command.rb:199:in `run'
/usr/local/lib/ruby/gems/1.8/gems/mongrel-0.3.13.3/bin/
mongrel_rails:235
/usr/local/bin/mongrel_rails:18
_______________________________________________
Typo-list mailing list
[email protected]
http://rubyforge.org/mailman/listinfo/typo-list
_______________________________________________ Typo-list mailing list [email protected] http://rubyforge.org/mailman/listinfo/typo-list
