# MySQL "Closed Stream"

**URL:** <https://www.ruby-forum.com/t/mysql-closed-stream/174167>\
**Category:** Rails\
**Created:** [August 21, 2009, 5:07pm UTC](https://www.ruby-forum.com/t/mysql-closed-stream/174167 "2009-08-21T17:07:32Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![rubyrubyruby\_onrail](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/7feea3/32.png) [@rubyrubyruby\_onrail](https://www.ruby-forum.com/u/rubyrubyruby_onrail)\
**Post date:** [August 21, 2009, 5:07pm UTC](https://www.ruby-forum.com/t/mysql-closed-stream/174167/1 "2009-08-21T17:07:32Z")

</div>

I have an app that is giving a “closed stream” error when I reload a  
view or  
visit it a second time. Typically the page loads fine the first time,  
but  
then it fails. It is working fine on another machine. I’m running Rails  
2.3.3, Ruby 1.8.7.

blade\_settings.rb:8 calls a named\_scope at entity.rb:14. Even after  
removing the named scope and explicitly getting an object for testing,  
the same error still occurs.

The stack:

/usr/local/lib/ruby/1.8/mysql.rb:1032:in `sync=' /usr/local/lib/ruby/1.8/mysql.rb:1032:in`write’  
/usr/local/lib/ruby/1.8/mysql.rb:1092:in `finalizer' /usr/local/lib/ruby/1.8/mysql.rb:578:in`call’  
/usr/local/lib/ruby/1.8/mysql.rb:578:in `start' /usr/local/lib/ruby/1.8/mysql.rb:578:in`free’  
/Users/chris/Workspace/RedPhone/vendor/rails/activerecord/lib/active\_record/connection\_adapters/mysql\_adapter.rb:468:in  
`columns' /Users/chris/Workspace/RedPhone/vendor/rails/activerecord/lib/active_record/base.rb:1275:in`columns\_without\_redhillonrails\_core’  
/Users/chris/Workspace/RedPhone/vendor/plugins/redhillonrails\_core/lib/red\_hill\_consulting/core/active\_record/base.rb:25:in  
`columns' /Users/chris/Workspace/RedPhone/vendor/rails/activerecord/lib/active_record/base.rb:1288:in`column\_names’  
/Users/chris/Workspace/RedPhone/vendor/rails/activerecord/lib/active\_record/base.rb:1301:in  
`column_methods_hash' /Users/chris/Workspace/RedPhone/vendor/rails/activerecord/lib/active_record/base.rb:1990:in`all\_attributes\_exists?’  
/Users/chris/Workspace/RedPhone/vendor/rails/activesupport/lib/active\_support/dependencies.rb:380:in  
`all?' /Users/chris/Workspace/RedPhone/vendor/rails/activerecord/lib/active_record/base.rb:1990:in`each’  
/Users/chris/Workspace/RedPhone/vendor/rails/activerecord/lib/active\_record/base.rb:1990:in  
`all?' /Users/chris/Workspace/RedPhone/vendor/rails/activerecord/lib/active_record/base.rb:1990:in`all\_attributes\_exists?’  
/Users/chris/Workspace/RedPhone/vendor/rails/activerecord/lib/active\_record/base.rb:1846:in  
`method_missing' /Users/chris/Workspace/RedPhone/app/models/entity.rb:14 /Users/chris/Workspace/RedPhone/app/models/blade_settings.rb:8:in`blade’  
/Users/chris/Workspace/RedPhone/app/helpers/layout\_helper.rb:17:in  
`nav_menu' /Users/chris/Workspace/RedPhone/app/views/layouts/application.html.erb:22:in`\_run\_erb\_app47views47layouts47application46html46erb’

---

<div class="post-metadata">

**Author:** ![rubyrubyruby\_onrail](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/7feea3/32.png) [@rubyrubyruby\_onrail](https://www.ruby-forum.com/u/rubyrubyruby_onrail)\
**Post date:** [September 4, 2009, 1:17pm UTC](https://www.ruby-forum.com/t/mysql-closed-stream/174167/2 "2009-09-04T13:17:45Z")

</div>

Did you find an answer to this?

I have never seen this issue, but started to get it now after  
upgrading to Snow Leopard and 64-bits MySQL. I have recompiled the  
mysql gem to 64-bits also.

BR  
MartOn

On Aug 21, 3:45 pm, Christopher W. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)