# MySQL losts connection, can't refer to User

**URL:** <https://www.ruby-forum.com/t/mysql-losts-connection-cant-refer-to-user/56227>\
**Category:** Engines\
**Created:** [March 29, 2006, 1:23pm UTC](https://www.ruby-forum.com/t/mysql-losts-connection-cant-refer-to-user/56227 "2006-03-29T13:23:03Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![lopmx](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/l/258eb7/32.png) [@lopmx](https://www.ruby-forum.com/u/lopmx)\
**Post date:** [March 29, 2006, 1:23pm UTC](https://www.ruby-forum.com/t/mysql-losts-connection-cant-refer-to-user/56227/1 "2006-03-29T13:23:03Z")

</div>

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
