Forum: Rails Engines MySQL losts connection, can't refer to User

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
Dcbf676f860477e44b275cae5d6318a4?d=identicon&s=25 Piotr Usewicz (lopmx)
on 2006-03-29 13:23
(Received via mailing list)
Hi

	Another problem here. After the upgrade to 1.1 both rails and engines,
my app on windows crashes very often on requests. It can't refer to User
model or losts connection to mysql. It appears like 2-3 times per 10
requests.

Eg.

Mysql::Error: Lost connection to MySQL server during query: UPDATE
sessions SET `data` =
'BAh7CiINcHJldl91cmkiHS9jYXNlcy9nZXRfY2FzZXM/d2hpY2g9MzoNbGFu\nZ3VhZ2UiCnBsLVBMIg5yZXR1cm4tdG8wOgl1c2VybzoJVXNlcgo6HEBuZXdf\ncmVjb3JkX2JlZm9yZV9zYXZlMDoQQGF0dHJpYnV0ZXN7GiIJc2FsdCItZmVm\nNmNlNTQ5NDg3OGI4NDRjYTQxYzRiNGNkODFmMGI4NzFkMjkwZiIRZGVsZXRl\nX2FmdGVyMCIPdXBkYXRlZF9hdHU6CVRpbWUNq4sagBi6CiUiD2FjY291bnRf\naWQwIhNzZWN1cml0eV90b2tlbiItOWMyNjEwODhhMGQ0Y2U4MTcyMjI1MDNi\nZjQ5OWMzMTA2Yzc4N2E3ZSIJcm9sZTAiDWxhc3RuYW1lIg5HcmFib3dza2ki\nDmZpcnN0bmFtZSILUmFmYcWCIgdpZCIGMSIQZGVzY3JpcHRpb24iACIKcGhv\nbmUiDjYwMzExMDY1NCIMZGVsZXRlZCIGMCIRdG9rZW5fZXhwaXJ5IhgyMDA2\nLTAyLTA1IDE5OjU1OjA5Ig12ZXJpZmllZCIGMSINcG9zaXRpb24iF0lUIFNl\ncml2Y2UgTWFuYWdlciIOcGFyZW50X2lkMCIRbG9nZ2VkX2luX2F0dTsKDauL\nGoAYugolIhRzYWx0ZWRfcGFzc3dvcmQiLWI3ZjcxNTk5ZWQ1MGFlMzdjNDcx\nMzZmMWMzNWEyZTYyZDQyYWMwNWYiCmxvZ2luIg9yZ3JhYm93c2tpIg9jcmVh\ndGVkX2F0IhgyMDA2LTAxLTI4IDIyOjQwOjExIgplbWFpbCIacmdyYWJvd3Nr\naUBleG9yaWdvLnBsOhJAbmV3X3Bhc3N3b3JkRjoLQHJvbGVzbzo/QWN0aXZl\nUmVjb3JkOjpBc3NvY2lhdGlvbnM6Okhhc0FuZEJlbG9uZ3NUb01hbnlBc3
Nv\nY2lhdGlvbgs6EEByZWZsZWN0aW9ubzo0QWN0aXZlUmVjb3JkOjpSZWZsZWN0\naW9uOjpBc3NvY2lhdGlvblJlZmxlY3Rpb24OOg1Ab3B0aW9uc3sGOg9qb2lu\nX3RhYmxlIhB1c2Vyc19yb2xlczoWQHByaW1hcnlfa2V5X25hbWUiDHVzZXJf\naWQ6GEB0aHJvdWdoX3JlZmxlY3Rpb25GOgtAbWFjcm86HGhhc19hbmRfYmVs\nb25nc190b19tYW55Oh1AYXNzb2NpYXRpb25fZm9yZWlnbl9rZXkiDHJvbGVf\naWQ6EEBjbGFzc19uYW1lIglSb2xlOgtAa2xhc3NjCVJvbGU6CkBuYW1lOgpy\nb2xlczoTQGFjdGl2ZV9yZWNvcmRjCVVzZXI6DEB0YXJnZXRbB286CVJvbGUG\nOwl7DCIJbmFtZSIKQWRtaW4iD29tbmlwb3RlbnQiBjEiDHJvbGVfaWQiBjIi\nB2lkIgYyIhBkZXNjcmlwdGlvbiI4VGhlIHN5c3RlbSBhZG1pbmlzdHJhdG9y\nLCB3aXRoIFJFQUwgVUxUSU1BVEUgUE9XRVIuIgx1c2VyX2lkIgYxIhBzeXN0\nZW1fcm9sZSIGMW87HQY7CXsMQD4iCVVzZXJAQCIGMEBCIgYzQEQiBjNARiIt\nVGhlIGRlZmF1bHQgcm9sZSBmb3IgYWxsIGxvZ2dlZC1pbiB1c2Vyc0BIIgYx\nQEoiBjE6C0Bvd25lckAKOg5Aam9pbl9zcWwiPUlOTkVSIEpPSU4gdXNlcnNf\ncm9sZXMgT04gcm9sZXMuaWQgPSB1c2Vyc19yb2xlcy5yb2xlX2lkOgxAbG9h\nZGVkVDoQQGZpbmRlcl9zcWwiHXVzZXJzX3JvbGVzLnVzZXJfaWQgPSAxIDoM\nQGVycm9yc286GUFjdGl2ZVJlY29yZDo6RXJyb3JzBzoKQGJhc2VACjsi
ewAi\nCmZsYXNoSUM6J0FjdGlvbkNvbnRyb2xsZXI6OkZsYXNoOjpGbGFzaEhhc2h7\nAAY6CkB1c2VkewA=\n',
`session_id` = '70cc8a35f2b959ac7b6a037fc52b5ed3', `updated_at` =
'2006-03-29 13:22:09' WHERE id = 965
C:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.0/lib/active_record/connection_adapters/abstract_adapter.rb:120:in
`log'
C:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.0/lib/active_record/connection_adapters/mysql_adapter.rb:185:in
`execute'
C:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.0/lib/active_record/connection_adapters/mysql_adapter.rb:200:in
`update'
C:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.0/lib/active_record/base.rb:1717:in
`update_without_lock'
C:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.0/lib/active_record/locking.rb:33:in
`update_without_callbacks'
C:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.0/lib/active_record/callbacks.rb:274:in
`update_without_timestamps'
C:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.0/lib/active_record/timestamp.rb:39:in
`update'
C:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.0/lib/active_record/base.rb:1712:in
`create_or_update_without_callbacks'
C:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.0/lib/active_record/callbacks.rb:249:in
`create_or_update'
C:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.0/lib/active_record/base.rb:1388:in
`save_without_validation'
C:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.0/lib/active_record/validations.rb:724:in
`save_without_transactions'
C:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.0/lib/active_record/transactions.rb:126:in
`save'
C:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.0/lib/active_record/connection_adapters/abstract/database_statements.rb:51:in
`transaction'
C:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.0/lib/active_record/transactions.rb:91:in
`transaction'
C:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.0/lib/active_record/transactions.rb:118:in
`transaction'
C:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.0/lib/active_record/transactions.rb:126:in
`save'
C:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.0/lib/action_controller/session/active_record_store.rb:307:in
`update'
C:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.0/lib/active_record/base.rb:794:in
`silence'
C:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.0/lib/action_controller/session/active_record_store.rb:307:in
`update'
C:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.0/lib/action_controller/session/active_record_store.rb:314:in
`close' C:/ruby/lib/ruby/1.8/cgi/session.rb:330:in `close'
C:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.0/lib/action_controller/base.rb:982:in
`close_session'
C:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.0/lib/action_controller/base.rb:1024:in
`process_cleanup_without_flash'
C:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.0/lib/action_controller/flash.rb:147:in
`process_cleanup_without_filters'
C:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.0/lib/action_controller/filters.rb:426:in
`process_cleanup_without_session_management_support'
C:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.0/lib/action_controller/session_management.rb:126:in
`process_cleanup_without_components'
C:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.0/lib/action_controller/components.rb:182:in
`process_cleanup'
C:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.0/lib/action_controller/base.rb:383:in
`process_without_filters'
C:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.0/lib/action_controller/filters.rb:364:in
`process_without_session_management_support'
C:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.0/lib/action_controller/session_management.rb:117:in
`process'
C:/ruby/lib/ruby/gems/1.8/gems/rails-1.1.0/lib/dispatcher.rb:38:in
`dispatch'
C:/ruby/lib/ruby/gems/1.8/gems/rails-1.1.0/lib/webrick_server.rb:115:in
`handle_dispatch'
C:/ruby/lib/ruby/gems/1.8/gems/rails-1.1.0/lib/webrick_server.rb:81:in
`service' C:/ruby/lib/ruby/1.8/webrick/httpserver.rb:104:in `service'
C:/ruby/lib/ruby/1.8/webrick/httpserver.rb:65:in `run'
C:/ruby/lib/ruby/1.8/webrick/server.rb:173:in `start_thread'
C:/ruby/lib/ruby/1.8/webrick/server.rb:162:in `start_thread'
C:/ruby/lib/ruby/1.8/webrick/server.rb:95:in `start'
C:/ruby/lib/ruby/1.8/webrick/server.rb:92:in `start'
C:/ruby/lib/ruby/1.8/webrick/server.rb:23:in `start'
C:/ruby/lib/ruby/1.8/webrick/server.rb:82:in `start'
C:/ruby/lib/ruby/gems/1.8/gems/rails-1.1.0/lib/webrick_server.rb:67:in
`dispatch'
C:/ruby/lib/ruby/gems/1.8/gems/rails-1.1.0/lib/commands/servers/webrick.rb:59
C:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:21:in
`require'
C:/ruby/lib/ruby/gems/1.8/gems/activesupport-1.3.0/lib/active_support/dependencies.rb:136:in
`require'
C:/ruby/lib/ruby/gems/1.8/gems/rails-1.1.0/lib/commands/server.rb:30
C:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:21:in
`require'
C:/ruby/lib/ruby/gems/1.8/gems/activesupport-1.3.0/lib/active_support/dependencies.rb:136:in
`require' ./script/server:3 -e:3
This topic is locked and can not be replied to.