Heroku db:pull error "LoadError: cannot load such file -- sqlite3 (Sequel::AdapterNotFound)"

Question

I'm able to run heroku db:pull from my MacBook development environment without any issues, but when I do the command on my Windows 7 machine I get the following error

C:/Program Files (x86)/Heroku/ruby-.9.2/lib/ruby/site_ruby/1.9.1/rubygems/custom_require.rb:36:in `require': LoadError: cannot load such file -- sqlite3 (Sequel::AdapterNotFound)
    from C:/Program Files (x86)/Heroku/ruby-1.9.2/lib/ruby/site_ruby/1.9.1/rubygems/custom_require.rb:36:in `require'
    from C:/Program Files (x86)/Heroku/ruby-1.9.2/lib/ruby/gems/1.9.1/gems/sequel-3.20.0/lib/sequel/adapters/sqlite.rb:1:in `<top (required)>'
    from C:/Program Files (x86)/Heroku/ruby-1.9.2/lib/ruby/site_ruby/1.9.1/rubygems/custom_require.rb:36:in `require'
    from C:/Program Files (x86)/Heroku/ruby-1.9.2/lib/ruby/site_ruby/1.9.1/rubygems/custom_require.rb:36:in `require'
    from C:/Program Files (x86)/Heroku/ruby-1.9.2/lib/ruby/gems/1.9.1/gems/sequel-3.20.0/lib/sequel/core.rb:249:in `block in tsk_require'
    from C:/Program Files (x86)/Heroku/ruby-1.9.2/lib/ruby/gems/1.9.1/gems/sequel-3.20.0/lib/sequel/core.rb:72:in `block in check_requiring_thread'
    from <internal:prelude>:10:in `synchronize'
    from C:/Program Files (x86)/Heroku/ruby-1.9.2/lib/ruby/gems/1.9.1/gems/sequel-3.20.0/lib/sequel/core.rb:69:in `check_requiring_thread'
    from C:/Program Files (x86)/Heroku/ruby-1.9.2/lib/ruby/gems/1.9.1/gems/sequel-3.20.0/lib/sequel/core.rb:249:in `tsk_require'
    from C:/Program Files (x86)/Heroku/ruby-1.9.2/lib/ruby/gems/1.9.1/gems/sequel-3.20.0/lib/sequel/database/connecting.rb:25:in `adapter_class'
    from C:/Program Files (x86)/Heroku/ruby-1.9.2/lib/ruby/gems/1.9.1/gems/sequel-3.20.0/lib/sequel/database/connecting.rb:54:in `connect'
    from C:/Program Files (x86)/Heroku/ruby-1.9.2/lib/ruby/gems/1.9.1/gems/sequel-3.20.0/lib/sequel/core.rb:119:in `connect'
    from C:/Program Files (x86)/Heroku/vendor/gems/taps-0.3.23/lib/taps/schema.rb:69:in `load_indexes'
    from C:/Program Files (x86)/Heroku/vendor/gems/taps-0.3.23/bin/schema:40:in `<main>'

I've the same problem. Also Win7. Gem sqlite3 is installed. How did you fix it? — BBQ Chef, May 29 '13 at 16:08
I tried putting "taps" and "sqlite3" in development gems and it works in my case. — Tu H., May 31 '13 at 09:06

score 8 · Answer 1 · answered Mar 01 '13 at 17:19

8

You probably need to install the sqlite3 gem.

answered Mar 01 '13 at 17:19

Jeremy Evans

11,959
27
26

The gem is included in my Gemfile for the development and test environments. – bodagetta Mar 05 '13 at 18:27

score 3 · Answer 2 · answered Mar 01 '13 at 18:17

3

I would try installing a couple gems:

gem install sqlite3
gem install heroku

answered Mar 01 '13 at 18:17

Andrew Backes

1,884
4
21
37

The Sqlite3 gem is included in my Gemfile and I installed the heroku toolbelt. I also installed the heroku gem and the error persists. – bodagetta Mar 05 '13 at 18:27

score 2 · Answer 3 · answered Feb 03 '15 at 22:43

2

I ran into this same issue. I had already added the sqlite3 gem, but I incorrectly called the the Sequel adapter sqlite3. The correct adapter name is simply sqlite.

answered Feb 03 '15 at 22:43

Andrew

227,796
193
515
708

Thanks; I ran into the same issue using the Sequel gem. – bigtunacan Mar 19 '15 at 14:11

score 0 · Answer 4 · answered Apr 16 '14 at 19:12

0

Try to update gems using the command:

gem update --system

answered Apr 16 '14 at 19:12

g8M

1,253
2
9
8

score 0 · Answer 5 · edited Feb 02 '17 at 00:54

0

Try including the following to the gemfile:

gem 'sequel'

edited Feb 02 '17 at 00:54

ilke444

2,641
1
17
31

answered Feb 01 '17 at 23:28

Владимир Елизаров

62
3

Heroku db:pull error "LoadError: cannot load such file -- sqlite3 (Sequel::AdapterNotFound)"

5 Answers5