Rails 3.1.0 cannot connect to sqlite database on Mac Lion

Rails
1

I’m running Rails 3.2.3 on Mac Lion with sqlite 3.7.7 and ruby
1.9.3p125. I need to back down rails to 3.1.0 for a project but when I
do that a simple index page give me a
ActiveRecord::ConnectionNotEstablished

error.

Rails 3.2.3 works, 3.1.0 not. Any ideas?

Just to show you it’s nothing fancy…

Gem file is only:

source ‘https://rubygems.org’

gem ‘rails’, ‘3.1.0’

Bundle edge Rails instead:

gem ‘rails’, :git => ‘git://github.com/rails/rails.git’

gem ‘sqlite3’

Gems used only for assets and not required

in production environments by default.

group :assets do
gem ‘sass-rails’
gem ‘coffee-rails’

See https://github.com/sstephenson/execjs#readme for more supported

runtimes

gem ‘therubyracer’, :platform => :ruby

gem ‘uglifier’, ‘>= 1.0.3’
end

gem ‘jquery-rails’

Routes:
root :to => “home#index”

home controller:
class HomeController < ApplicationController
def index
end

end

2

On 16 May 2012 03:42, Scott E. [email protected] wrote:

I’m running Rails 3.2.3 on Mac Lion with sqlite 3.7.7 and ruby 1.9.3p125.
I need to back down rails to 3.1.0 for a project but when I do that a
simple index page give me a ActiveRecord::ConnectionNotEstablished
error.

What does
bundle exec db:migrate
give you?

3

Make sure your config/database.yml referes to proper database
credentials,
i.e username, password, socket.

On Wed, May 16, 2012 at 9:22 AM, Jeremy W. [email protected]
wrote:

What does

gem ‘sqlite3’

gem ‘therubyracer’, :platform => :ruby

class HomeController < ApplicationController
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.

–
Rodrigo Alves V.
Software Developer, Bemind

4

They seem to be ok. When I take off the 3.1.0 from the rails gem in the
Gemfile, it connects just fine with no other changes.

5

On Tue, May 15, 2012 at 7:42 PM, Scott E. [email protected]
wrote:

I’m running Rails 3.2.3 on Mac Lion with sqlite 3.7.7 and ruby 1.9.3p125. I
need to back down rails to 3.1.0 for a project

What does “back down” mean? Are you running bundle install after
changing your Gemfile? (Personally I would blow away Gemfile.lock
first.)

Regardless, are you using rvm? If not, you should be if you’re doing
work on projects using different versions of Rails.

What’s the complete error trace?

–
Hassan S. ------------------------ [email protected]

twitter: @hassan

6

On Wed, May 16, 2012 at 6:40 PM, Scott E. [email protected]
wrote:

I don’t mess with rvm at all. It stays at:

Then what’s the point? Use it as intended: create a new gemset just
for this 3.1 app and do a clean bundle install. Then copy in your app
and see what happens.

I just did exactly that (except I created a new test app) and it worked
out of the box (Ruby 1.9.3-p125, Rails 3.1, SQLite3, Lion).

–
Hassan S. ------------------------ [email protected]

twitter: @hassan

7

Somewhere on your code you are forcing a establish_connection, that’s
the
problem. At least the backtrace is exactly the same I was getting with
this
problem. When I investigated this issue I found out that the sqlite3
backend hasnt got implemented the close() method, so your
establish_connection will fail, because the database will be kept open.

Try to remove any establish_connection added manually, and try if it
works.

I stumbled across this problem before, and I even started a thread on
rails-core about this issue.

8

Back down just means changing the Gemfile line from

gem ‘rails’, ‘3.2.3’ change to ---->> gem ‘rails’, ‘3.1.0’

then bundle update. Nothing else.

Tried deleting Gemfile.lock. That did not help.

The reason I am doing this is I have to use a gem that won’t work with
3.2.3, requires 3.1.0

I don’t mess with rvm at all. It stays at:

new-host-7:jbe_debug scott$ rvm list

rvm rubies

ruby-1.9.2-p290 [ x86_64 ]
=* ruby-1.9.3-p125 [ x86_64 ]

=> - current

=* - current && default

* - default

The stacktrace is:

activerecord (3.1.0)
lib/active_record/connection_adapters/abstract/connection_pool.rb:409:in
retrieve_connection' activerecord (3.1.0) lib/active_record/connection_adapters/abstract/connection_specification.rb:107:in retrieve_connection’
activerecord (3.1.0)
lib/active_record/connection_adapters/abstract/connection_specification.rb:89:in
connection' activerecord (3.1.0) lib/active_record/query_cache.rb:65:in rescue in
call’
activerecord (3.1.0) lib/active_record/query_cache.rb:59:in call' activerecord (3.1.0) lib/active_record/connection_adapters/abstract/connection_pool.rb:477:in call’
actionpack (3.1.0) lib/action_dispatch/middleware/callbacks.rb:29:in
block in call' activesupport (3.1.0) lib/active_support/callbacks.rb:392:in _run_call_callbacks’
activesupport (3.1.0) lib/active_support/callbacks.rb:81:in
run_callbacks' actionpack (3.1.0) lib/action_dispatch/middleware/callbacks.rb:28:in call’
actionpack (3.1.0) lib/action_dispatch/middleware/reloader.rb:68:in
call' rack (1.3.6) lib/rack/sendfile.rb:101:in call’
actionpack (3.1.0) lib/action_dispatch/middleware/remote_ip.rb:48:in
call' actionpack (3.1.0) lib/action_dispatch/middleware/show_exceptions.rb:47:in call’
railties (3.1.0) lib/rails/rack/logger.rb:13:in call' rack (1.3.6) lib/rack/methodoverride.rb:24:in call’
rack (1.3.6) lib/rack/runtime.rb:17:in call' activesupport (3.1.0) lib/active_support/cache/strategy/local_cache.rb:72:in call’
rack (1.3.6) lib/rack/lock.rb:15:in call' actionpack (3.1.0) lib/action_dispatch/middleware/static.rb:53:in call’
railties (3.1.0) lib/rails/engine.rb:455:in call' railties (3.1.0) lib/rails/rack/content_length.rb:16:in call’
railties (3.1.0) lib/rails/rack/log_tailer.rb:14:in call' rack (1.3.6) lib/rack/handler/webrick.rb:59:in service’
/Users/scott/.rvm/rubies/ruby-1.9.3-p125/lib/ruby/1.9.1/webrick/httpserver.rb:138:in
service' /Users/scott/.rvm/rubies/ruby-1.9.3-p125/lib/ruby/1.9.1/webrick/httpserver.rb:94:in run’
/Users/scott/.rvm/rubies/ruby-1.9.3-p125/lib/ruby/1.9.1/webrick/server.rb:191:in
`block in start_thread’

The bundle update does:

Fetching gem metadata from https://rubygems.org/…
Using rake (0.9.2.2)
Using multi_json (1.3.5)
Using activesupport (3.1.0)
Using bcrypt-ruby (3.0.1)
Using builder (3.0.0)
Using i18n (0.6.0)
Using activemodel (3.1.0)
Using erubis (2.7.0)
Using rack (1.3.6)
Using rack-cache (1.0.3)
Using rack-mount (0.8.3)
Using rack-test (0.6.1)
Using hike (1.2.1)
Using tilt (1.3.3)
Using sprockets (2.0.4)
Using actionpack (3.1.0)
Using mime-types (1.18)
Using polyglot (0.3.3)
Using treetop (1.4.10)
Using mail (2.3.3)
Using actionmailer (3.1.0)
Using arel (2.2.3)
Using tzinfo (0.3.33)
Using activerecord (3.1.0)
Using activeresource (3.1.0)
Using bundler (1.1.3)
Using coffee-script-source (1.3.3)
Using execjs (1.3.2)
Using coffee-script (2.2.0)
Using rack-ssl (1.3.2)
Using json (1.7.3)
Using rdoc (3.12)
Using thor (0.14.6)
Using railties (3.1.0)
Using coffee-rails (3.1.1)
Using jquery-rails (1.0.19)
Using rails (3.1.0)
Using sass (3.1.18)
Using sass-rails (3.1.6)
Using sqlite3 (1.3.6)
Using uglifier (1.2.4)
Your bundle is updated! Use bundle show [gemname] to see where a
bundled gem is installed.