# Please help - Rails hanging on mysql connection

**URL:** <https://www.ruby-forum.com/t/please-help-rails-hanging-on-mysql-connection/61594>\
**Category:** Rails\
**Created:** [January 15, 2006, 8:49pm UTC](https://www.ruby-forum.com/t/please-help-rails-hanging-on-mysql-connection/61594 "2006-01-15T20:49:11Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![madscene](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/5f9b8f/32.png) [@madscene](https://www.ruby-forum.com/u/madscene)\
**Post date:** [January 15, 2006, 8:49pm UTC](https://www.ruby-forum.com/t/please-help-rails-hanging-on-mysql-connection/61594/1 "2006-01-15T20:49:11Z")

</div>

Trying to get Rails and mysql running on OS X, and I’m a Nuby.  
Everything ran smoothly when I first installed, but after rebooting  
things were out of whack. I finally got back into mysql after  
re-installing, and at first when I tried to connect with Rails/Ruby I  
got a message that my client was not up to date. So after reading some  
info online, I set my mysql passwords with OLD\_PASSWORD. At that point,  
Rails just started to hang when I tried to connect. Can anyone help?  
Here is the error I get below. I only get this error to show up if I  
stop the browser (it hangs while trying to load) and refresh. Tests and  
other direct calls to the DB just hang (for example, the test says  
“Starting” and then doesn’t do anything for minutes on end (simple  
test).

NoMethodError in Organize#index

You have a nil object when you didn’t expect it!  
The error occured while evaluating nil.each\_hash

RAILS\_ROOT: script/…/config/…  
Application Trace | Framework Trace | Full Trace

/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active\_record/connection\_adapters/mysql\_adapter.rb:325:in  
`select' /usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/mysql_adapter.rb:175:in`select\_one’  
/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active\_record/connection\_adapters/abstract/database\_statements.rb:16:in  
`select_value' /usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/base.rb:518:in`count\_by\_sql’  
/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active\_record/base.rb:511:in  
`count' /usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/pagination.rb:167:in`count\_collection\_for\_pagination’  
/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action\_controller/pagination.rb:188:in  
`paginator_and_collection_for' /usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/pagination.rb:124:in`paginate’  
./script/…/config/…/app/controllers/organize\_controller.rb:8:in `list' ./script/../config/../app/controllers/organize_controller.rb:3:in`index’

/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active\_record/connection\_adapters/mysql\_adapter.rb:325:in  
`select' /usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/mysql_adapter.rb:175:in`select\_one’  
/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active\_record/connection\_adapters/abstract/database\_statements.rb:16:in  
`select_value' /usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/base.rb:518:in`count\_by\_sql’  
/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active\_record/base.rb:511:in  
`count' /usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/pagination.rb:167:in`count\_collection\_for\_pagination’  
/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action\_controller/pagination.rb:188:in  
`paginator_and_collection_for' /usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/pagination.rb:124:in`paginate’  
/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action\_controller/base.rb:853:in  
`send' /usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/base.rb:853:in`perform\_action\_without\_filters’  
/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action\_controller/filters.rb:332:in  
`perform_action_without_benchmark' /usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/benchmarking.rb:69:in`perform\_action\_without\_rescue’  
/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action\_controller/benchmarking.rb:69:in  
`measure' /usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/benchmarking.rb:69:in`perform\_action\_without\_rescue’  
/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action\_controller/rescue.rb:82:in  
`perform_action' /usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/base.rb:369:in`send’  
/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action\_controller/base.rb:369:in  
`process_without_session_management_support' /usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/session_management.rb:116:in`process’  
/usr/lib/ruby/gems/1.8/gems/rails-1.0.0/lib/dispatcher.rb:38:in  
`dispatch' /usr/lib/ruby/gems/1.8/gems/rails-1.0.0/lib/webrick_server.rb:117:in`handle\_dispatch’  
/usr/lib/ruby/gems/1.8/gems/rails-1.0.0/lib/webrick\_server.rb:83:in  
`service' /usr/lib/ruby/1.8/webrick/httpserver.rb:104:in`service’  
/usr/lib/ruby/1.8/webrick/httpserver.rb:65:in `run' /usr/lib/ruby/1.8/webrick/server.rb:155:in`start\_thread’  
/usr/lib/ruby/1.8/webrick/server.rb:144:in `start' /usr/lib/ruby/1.8/webrick/server.rb:144:in`start\_thread’  
/usr/lib/ruby/1.8/webrick/server.rb:94:in `start' /usr/lib/ruby/1.8/webrick/server.rb:89:in`each’  
/usr/lib/ruby/1.8/webrick/server.rb:89:in `start' /usr/lib/ruby/1.8/webrick/server.rb:79:in`start’  
/usr/lib/ruby/1.8/webrick/server.rb:79:in `start' /usr/lib/ruby/gems/1.8/gems/rails-1.0.0/lib/webrick_server.rb:69:in`dispatch’  
/usr/lib/ruby/gems/1.8/gems/rails-1.0.0/lib/commands/servers/webrick.rb:59  
/usr/lib/ruby/site\_ruby/1.8/rubygems/custom\_require.rb:18:in `require__' /usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:18:in`require’  
/usr/lib/ruby/gems/1.8/gems/activesupport-1.2.5/lib/active\_support/dependencies.rb:214:in  
`require' /usr/lib/ruby/gems/1.8/gems/rails-1.0.0/lib/commands/server.rb:28 /usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:18:in`require\_\_’  
/usr/lib/ruby/site\_ruby/1.8/rubygems/custom\_require.rb:18:in `require' /usr/lib/ruby/gems/1.8/gems/activesupport-1.2.5/lib/active_support/dependencies.rb:214:in`require’  
script/server:3

/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active\_record/connection\_adapters/mysql\_adapter.rb:325:in  
`select' /usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/mysql_adapter.rb:175:in`select\_one’  
/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active\_record/connection\_adapters/abstract/database\_statements.rb:16:in  
`select_value' /usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/base.rb:518:in`count\_by\_sql’  
/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active\_record/base.rb:511:in  
`count' /usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/pagination.rb:167:in`count\_collection\_for\_pagination’  
/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action\_controller/pagination.rb:188:in  
`paginator_and_collection_for' /usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/pagination.rb:124:in`paginate’  
./script/…/config/…/app/controllers/organize\_controller.rb:8:in `list' ./script/../config/../app/controllers/organize_controller.rb:3:in`index’  
/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action\_controller/base.rb:853:in  
`send' /usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/base.rb:853:in`perform\_action\_without\_filters’  
/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action\_controller/filters.rb:332:in  
`perform_action_without_benchmark' /usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/benchmarking.rb:69:in`perform\_action\_without\_rescue’  
/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action\_controller/benchmarking.rb:69:in  
`measure' /usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/benchmarking.rb:69:in`perform\_action\_without\_rescue’  
/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action\_controller/rescue.rb:82:in  
`perform_action' /usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/base.rb:369:in`send’  
/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action\_controller/base.rb:369:in  
`process_without_session_management_support' /usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/session_management.rb:116:in`process’  
/usr/lib/ruby/gems/1.8/gems/rails-1.0.0/lib/dispatcher.rb:38:in  
`dispatch' /usr/lib/ruby/gems/1.8/gems/rails-1.0.0/lib/webrick_server.rb:117:in`handle\_dispatch’  
/usr/lib/ruby/gems/1.8/gems/rails-1.0.0/lib/webrick\_server.rb:83:in  
`service' /usr/lib/ruby/1.8/webrick/httpserver.rb:104:in`service’  
/usr/lib/ruby/1.8/webrick/httpserver.rb:65:in `run' /usr/lib/ruby/1.8/webrick/server.rb:155:in`start\_thread’  
/usr/lib/ruby/1.8/webrick/server.rb:144:in `start' /usr/lib/ruby/1.8/webrick/server.rb:144:in`start\_thread’  
/usr/lib/ruby/1.8/webrick/server.rb:94:in `start' /usr/lib/ruby/1.8/webrick/server.rb:89:in`each’  
/usr/lib/ruby/1.8/webrick/server.rb:89:in `start' /usr/lib/ruby/1.8/webrick/server.rb:79:in`start’  
/usr/lib/ruby/1.8/webrick/server.rb:79:in `start' /usr/lib/ruby/gems/1.8/gems/rails-1.0.0/lib/webrick_server.rb:69:in`dispatch’  
/usr/lib/ruby/gems/1.8/gems/rails-1.0.0/lib/commands/servers/webrick.rb:59  
/usr/lib/ruby/site\_ruby/1.8/rubygems/custom\_require.rb:18:in `require__' /usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:18:in`require’  
/usr/lib/ruby/gems/1.8/gems/activesupport-1.2.5/lib/active\_support/dependencies.rb:214:in  
`require' /usr/lib/ruby/gems/1.8/gems/rails-1.0.0/lib/commands/server.rb:28 /usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:18:in`require\_\_’  
/usr/lib/ruby/site\_ruby/1.8/rubygems/custom\_require.rb:18:in `require' /usr/lib/ruby/gems/1.8/gems/activesupport-1.2.5/lib/active_support/dependencies.rb:214:in`require’  
script/server:3

Request

Parameters: None

Show session dump

* * *

flash: !ruby/hash:ActionController::Flash::FlashHash {}

Response  
Headers: {“cookie”=\>[], “Cache-Control”=\>“no-cache”}

---

<div class="post-metadata">

**Author:** ![madscene](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/5f9b8f/32.png) [@madscene](https://www.ruby-forum.com/u/madscene)\
**Post date:** [January 15, 2006, 9:02pm UTC](https://www.ruby-forum.com/t/please-help-rails-hanging-on-mysql-connection/61594/2 "2006-01-15T21:02:35Z")

</div>

On Jan 15, 2006, at 12:49 PM, Brian D. wrote:

> stop the browser (it hangs while trying to load) and refresh.  
> Tests and  
> other direct calls to the DB just hang (for example, the test says  
> “Starting” and then doesn’t do anything for minutes on end (simple  
> test).

I had a similar problem. What version of MySQL are you using, and  
how did you install it? I eventually backed out everything I had  
done, installed the binary distribution of MySQL 5, and got it all  
working again.

I have listed links to the resources I used to get this all working  
on my blog.

[http://blog.dragonsharp.com/?p=18](http://blog.dragonsharp.com/?p=18)

–

Regards, Lori

---

<div class="post-metadata">

**Author:** ![madscene](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/5f9b8f/32.png) [@madscene](https://www.ruby-forum.com/u/madscene)\
**Post date:** [January 15, 2006, 11:58pm UTC](https://www.ruby-forum.com/t/please-help-rails-hanging-on-mysql-connection/61594/3 "2006-01-15T23:58:10Z")

</div>

> I had a similar problem. What version of MySQL are you using, and  
> how did you install it? I eventually backed out everything I had  
> done, installed the binary distribution of MySQL 5, and got it all  
> working again.

Lori, thanks!! Thanks to those sites, I am back up and running. Being  
an OS X newb, I have next to no idea what I did, why it worked at first,  
then stopped, etc. I just ordered O’Reilly’s Running Mac OS X Tiger,  
which is supposed to be a good intro to OS X for windows losers. Hoping  
not to feel so clueless on the “other side.”

Thanks again!

Brian