# Mysql::Error: Lost connection to MySQL server during query: SELECT \* FROM sessions WHERE (session\_i

**URL:** <https://www.ruby-forum.com/t/mysql-lost-connection-to-mysql-server-during-query-select-from-sessions-where-session-i/126011>\
**Category:** Rails\
**Created:** [January 14, 2008, 5:50pm UTC](https://www.ruby-forum.com/t/mysql-lost-connection-to-mysql-server-during-query-select-from-sessions-where-session-i/126011 "2008-01-14T17:50:31Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![chanhuai](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/22d042/32.png) [@chanhuai](https://www.ruby-forum.com/u/chanhuai)\
**Post date:** [January 14, 2008, 5:50pm UTC](https://www.ruby-forum.com/t/mysql-lost-connection-to-mysql-server-during-query-select-from-sessions-where-session-i/126011/1 "2008-01-14T17:50:31Z")

</div>

Hi  
i keep on getting this error when i try to GET one of the page in my  
website. any idea where went wrong. was it something wrong with the  
server?  
Mysql::Error: Lost connection to MySQL server during query: SELECT \*  
FROM sessions WHERE (session\_id = ‘55f84af9071afac179e25506d37fab42’)  
LIMIT 1

Here’s the complete error message  
Processing AdminController#list (for 127.0.0.1 at 2008-01-15 00:14:59)  
[GET]  
Session ID: 55f84af9071afac179e25506d37fab42  
Parameters: {“action”=\>“list”, “controller”=\>“admin”}  
^[[4;35;1mMembership Load (0.002293)^[[0m ^[[0mSELECT \* FROM  
memberships ^[[0m  
^[[4;36;1mMembership Columns (0.006878)^[[0m ^[[0;1mSHOW FIELDS  
FROM memberships^[[0m  
^[[4;35;1mUser Columns (0.032467)^[[0m ^[[0mSHOW FIELDS FROM  
users^[[0m  
^[[4;36;1mUser Load (0.009823)^[[0m ^[[0;1mSELECT \* FROM users  
WHERE (users.`id` = 1) LIMIT 1^[[0m  
^[[4;35;1mUser Load (0.005218)^[[0m ^[[0mSELECT \* FROM users WHERE  
(users.`id` = 1) LIMIT 1^[[0m  
^[[4;36;1mCategory Load (0.002756)^[[0m ^[[0;1mSELECT \* FROM  
categories ^[[0m  
^[[4;35;1mCategory Columns (0.009436)^[[0m ^[[0mSHOW FIELDS FROM  
categories^[[0m  
^[[4;36;1mBrand Load (0.002521)^[[0m ^[[0;1mSELECT \* FROM brands  
^[[0m  
^[[4;35;1mBrand Columns (0.010849)^[[0m ^[[0mSHOW FIELDS FROM  
brands^[[0m  
^[[4;36;1mProduct Columns (0.009531)^[[0m ^[[0;1mSHOW FIELDS FROM  
products^[[0m  
^[[4;35;1mSQL (0.002523)^[[0m ^[[0mSELECT count(\*) AS count\_all  
FROM products ^[[0m  
^[[4;36;1mProduct Load (0.003852)^[[0m ^[[0;1mSELECT \* FROM  
products LIMIT 0, 20^[[0m  
Rendering within layouts/admin  
Rendering admin/list  
Rendered admin/\_left\_sidebar (0.00582)  
^[[4;35;1mBrand Load (0.002364)^[[0m ^[[0mSELECT \* FROM brands  
WHERE (brands.`id` = 11) ^[[0m  
^[[4;36;1mCategory Load (0.002333)^[[0m ^[[0;1mSELECT \* FROM  
categories WHERE (categories.`id` = 2) ^[[0m  
^[[4;35;1mCategory Load (0.002326)^[[0m ^[[0mSELECT \* FROM  
categories WHERE (categories.`id` = 1) ^[[0m  
^[[4;36;1mTag Columns (0.006939)^[[0m ^[[0;1mSHOW FIELDS FROM  
tags^[[0m  
^[[4;35;1mTag Load (0.004283)^[[0m ^[[0mSELECT \* FROM tags WHERE  
(tags.`id` = 26) ^[[0m  
Rendered /admin/\_tabs (0.00646)  
Completed in 0.38937 (2 reqs/sec) | Rendering: 0.06513 (16%) | DB:  
0.11639 (29%) | 200 OK [[http://localhost/admin/list](http://localhost/admin/list)]  
Mysql::Error: Lost connection to MySQL server during query: SELECT \*  
FROM sessions WHERE (session\_id = ‘55f84af9071afac179e25506d37fab42’)  
LIMIT 1  
./script/…/config/…/vendor/rails/activerecord/lib/active\_record/  
connection\_adapters/abstract\_adapter.rb:128:in `log’^M  
./script/…/config/…/vendor/rails/activerecord/lib/active\_record/  
connection\_adapters/mysql\_adapter.rb:243:in `execute’^M  
./script/…/config/…/vendor/rails/activerecord/lib/active\_record/  
connection\_adapters/mysql\_adapter.rb:399:in `select’  
./script/…/config/…/vendor/rails/activerecord/lib/active\_record/  
connection\_adapters/abstract/database\_statements.rb:7:in  
`select\_all’^M  
./script/…/config/…/vendor/rails/activerecord/lib/active\_record/  
base.rb:427:in `find\_by\_sql’^M  
./script/…/config/…/vendor/rails/activerecord/lib/active\_record/  
base.rb:997:in `find\_every’^M  
./script/…/config/…/vendor/rails/activerecord/lib/active\_record/  
base.rb:991:in `find\_initial’^M  
./script/…/config/…/vendor/rails/activerecord/lib/active\_record/  
base.rb:417:in `find’^M  
./script/…/config/…/vendor/rails/actionpack/lib/action\_controller/  
session/active\_record\_store.rb:115:in `find\_by\_session\_id’^M  
./script/…/config/…/vendor/rails/actionpack/lib/action\_controller/  
session/active\_record\_store.rb:288:in `initialize’^M  
./script/…/config/…/vendor/rails/activerecord/lib/active\_record/  
base.rb:867:in `silence’^M  
./script/…/config/…/vendor/rails/actionpack/lib/action\_controller/  
session/active\_record\_store.rb:288:in `initialize’^M  
/opt/local/lib/ruby/1.8/cgi/session.rb:273:in `new’^M  
/opt/local/lib/ruby/1.8/cgi/session.rb:273:in  
`initialize\_without\_dynamic\_session\_expiration’^M  
./script/…/config/…/vendor/plugins/dynamic\_session\_exp/lib/  
dynamic\_session\_expiry.rb:34:in `initialize’^M  
./script/…/config/…/vendor/rails/actionpack/lib/action\_controller/  
cgi\_process.rb:123:in `new’^M  
./script/…/config/…/vendor/rails/actionpack/lib/action\_controller/  
cgi\_process.rb:123:in `session’^M  
./script/…/config/…/vendor/rails/actionpack/lib/action\_controller/  
cgi\_process.rb:155:in `stale\_session\_check!‘^M  
./script/…/config/…/vendor/rails/actionpack/lib/action\_controller/  
cgi\_process.rb:110:in `session’^M  
./script/…/config/…/vendor/rails/actionpack/lib/action\_controller/  
base.rb:1052:in `assign\_shortcuts\_without\_flash’^M  
./script/…/config/…/vendor/rails/actionpack/lib/action\_controller/  
flash.rb:140:in `assign\_shortcuts’^M  
./script/…/config/…/vendor/rails/actionpack/lib/action\_controller/  
base.rb:424:in `process\_without\_filters’^M  
./script/…/config/…/vendor/rails/actionpack/lib/action\_controller/  
filters.rb:624:in `process\_without\_session\_management\_support’^M  
./script/…/config/…/vendor/rails/actionpack/lib/action\_controller/  
session\_management.rb:114:in `process’^M  
./script/…/config/…/vendor/rails/actionpack/lib/action\_controller/  
base.rb:330:in `process’^M  
./script/…/config/…/vendor/rails/railties/lib/dispatcher.rb:41:in  
`dispatch’^M  
./script/…/config/…/vendor/rails/railties/lib/webrick\_server.rb:  
113:in `handle\_dispatch’^M  
./script/…/config/…/vendor/rails/railties/lib/webrick\_server.rb:  
79:in `service’^M  
/opt/local/lib/ruby/1.8/webrick/httpserver.rb:104:in `service’^M  
/opt/local/lib/ruby/1.8/webrick/httpserver.rb:65:in `run’^M  
/opt/local/lib/ruby/1.8/webrick/server.rb:173:in `start\_thread’^M  
/opt/local/lib/ruby/1.8/webrick/server.rb:162:in `start’^M/opt/local/  
lib/ruby/1.8/webrick/server.rb:162:in `start\_thread’^M  
/opt/local/lib/ruby/1.8/webrick/server.rb:95:in `start’^M  
/opt/local/lib/ruby/1.8/webrick/server.rb:92:in `each’^M  
/opt/local/lib/ruby/1.8/webrick/server.rb:92:in `start’^M  
/opt/local/lib/ruby/1.8/webrick/server.rb:23:in `start’^M  
/opt/local/lib/ruby/1.8/webrick/server.rb:82:in `start’^M  
./script/…/config/…/vendor/rails/railties/lib/webrick\_server.rb:  
63:in `dispatch’^M  
./script/…/config/…/vendor/rails/railties/lib/commands/servers/  
webrick.rb:59^M  
/opt/local/lib/ruby/site\_ruby/1.8/rubygems/custom\_require.rb:27:in  
`gem\_original\_require’^M  
/opt/local/lib/ruby/site\_ruby/1.8/rubygems/custom\_require.rb:27:in  
`require’^M  
./script/…/config/…/vendor/rails/activesupport/lib/active\_support/  
dependencies.rb:498:in `require’^M  
./script/…/config/…/vendor/rails/activesupport/lib/active\_support/  
dependencies.rb:345:in `new\_constants\_in’^M  
./script/…/config/…/vendor/rails/activesupport/lib/active\_support/  
dependencies.rb:498:in `require’^M  
./script/…/config/…/vendor/rails/railties/lib/commands/server.rb:  
39^M  
script/server:3:in `require’^M  
script/server:3
