"Deprecation warning: Database connections will not be closed automatically"

[rxbynerd]

I'm using Puma with Sinatra and ActiveRecord, and I've noticed a few lines being written to STDERR which I'm stuck with:

DEPRECATION WARNING: Database connections will not be closed automatically, please close your
database connection at the end of the thread by calling `close` on your
connection.  For example: ActiveRecord::Base.connection.close
. (called from mon_synchronize at /usr/local/lib/ruby/1.9.1/monitor.rb:211)

I'm using MRI, I can't test this on jRuby because less.rb demands therubyracer, which won't compile ⚡ 😞 ⚡

Is there a fix for this?

[evanphx]

What version of ActiveRecord are you using?

[evanphx]

You need to use the ActiveRecord rack middleware ActiveRecord:: ConnectionAdapters::ConnectionManagement so that the connections are closed down properly.

[rxbynerd]

OK, thank you

Sorry, it looks like GitHub didn't get my reply email

[evanphx]

No problem!

Evan Phoenix // evan@phx.io

On Wednesday, April 11, 2012 at 11:08 AM, Luke Carpenter wrote:

OK, thank you

Sorry, it looks like GitHub didn't get my reply email

---

Reply to this email directly or view it on GitHub:
#59 (comment)

[philostler]

For the record I get the same in JRuby (1.7.0.preview2)

Fixed by adding use ActiveRecord::ConnectionAdapters::ConnectionManagement before all my Sinatra apps in my config.ru file

[davesag]

Thanks! I was getting this too but only occasionally.

[cyrusg]

"use ActiveRecord::ConnectionAdapters::ConnectionManagement" solved my issues with ClearDB on Heroku.