Pushing app to Heroku / / / Older SQLite3


#1
$ git push heroku master

Counting objects: 114, done.
Delta compression using up to 2 threads.
Compressing objects: 100% (99/99), done.
Writing objects: 100% (114/114), 26.38 KiB | 0 bytes/s, done.
Total 114 (delta 4), reused 0 (delta 0)
remote: Compressing source files… done.
remote: Building source:
remote:
remote: ! Warning: Multiple default buildpacks reported the ability to handle this app. The first buildpack in the list below will be used.
remote: Detected buildpacks: Ruby,Node.js
remote: See https://devcenter.heroku.com/articles/buildpacks#buildpack-detect-order
remote: -----> Ruby app detected
remote: -----> Compiling Ruby/Rails
remote: -----> Using Ruby version: ruby-2.5.1
remote: -----> Installing dependencies using bundler 1.15.2
remote: Running: bundle install --without development:test --path vendor/bundle --binstubs vendor/bundle/bin -j4 --deployment
remote: Warning: the running version of Bundler (1.15.2) is older than the version that created the lockfile (1.16.3). We suggest you upgrade to the latest version of Bundler by running gem install bundler.
remote: Fetching gem metadata from https://rubygems.org/
remote: Fetching version metadata from https://rubygems.org/
remote: Fetching dependency metadata from https://rubygems.org/.
remote: Fetching rake 12.3.1
remote: Fetching concurrent-ruby 1.0.5
remote: Fetching minitest 5.11.3
remote: Installing rake 12.3.1
remote: Installing minitest 5.11.3
remote: Installing concurrent-ruby 1.0.5
remote: Fetching thread_safe 0.3.6
remote: Installing thread_safe 0.3.6
remote: Fetching builder 3.2.3
remote: Installing builder 3.2.3
remote: Fetching erubi 1.7.1
remote: Installing erubi 1.7.1
remote: Fetching mini_portile2 2.3.0
remote: Installing mini_portile2 2.3.0
remote: Fetching crass 1.0.4
remote: Installing crass 1.0.4
remote: Fetching rack 2.0.5
remote: Fetching nio4r 2.3.1
remote: Installing rack 2.0.5
remote: Installing nio4r 2.3.1 with native extensions
remote: Fetching websocket-extensions 0.1.3
remote: Installing websocket-extensions 0.1.3
remote: Fetching mini_mime 1.0.0
remote: Installing mini_mime 1.0.0
remote: Fetching arel 9.0.0
remote: Installing arel 9.0.0
remote: Fetching mimemagic 0.3.2
remote: Fetching msgpack 1.2.4
remote: Installing msgpack 1.2.4 with native extensions
remote: Installing mimemagic 0.3.2
remote: Using bundler 1.15.2
remote: Fetching coffee-script-source 1.12.2
remote: Installing coffee-script-source 1.12.2
remote: Fetching execjs 2.7.0
remote: Installing execjs 2.7.0
remote: Fetching method_source 0.9.0
remote: Installing method_source 0.9.0
remote: Fetching thor 0.20.0
remote: Installing thor 0.20.0
remote: Fetching ffi 1.9.25
remote: Installing ffi 1.9.25 with native extensions
remote: Fetching multi_json 1.13.1
remote: Installing multi_json 1.13.1
remote: Fetching puma 3.12.0
remote: Installing puma 3.12.0 with native extensions
remote: Fetching rb-fsevent 0.10.3
remote: Installing rb-fsevent 0.10.3
remote: Fetching tilt 2.0.8
remote: Installing tilt 2.0.8
remote: Fetching sqlite3 1.3.13
remote: Installing sqlite3 1.3.13 with native extensions
remote: Fetching turbolinks-source 5.1.0
remote: Installing turbolinks-source 5.1.0
remote: Fetching tzinfo 1.2.5
remote: Installing tzinfo 1.2.5
remote: Fetching nokogiri 1.8.4
remote: Installing nokogiri 1.8.4 with native extensions
remote: Fetching i18n 1.0.1
remote: Installing i18n 1.0.1
remote: Fetching websocket-driver 0.7.0
remote: Installing websocket-driver 0.7.0 with native extensions
remote: Fetching mail 2.7.0
remote: Installing mail 2.7.0
remote: Fetching rack-test 1.1.0
remote: Installing rack-test 1.1.0
remote: Fetching sprockets 3.7.2
remote: Installing sprockets 3.7.2
remote: Fetching marcel 0.3.2
remote: Installing marcel 0.3.2
remote: Fetching coffee-script 2.4.1
remote: Installing coffee-script 2.4.1
remote: Fetching uglifier 4.1.16
remote: Installing uglifier 4.1.16
remote: Fetching bootsnap 1.3.1
remote: Installing bootsnap 1.3.1 with native extensions
remote: Fetching rb-inotify 0.9.10
remote: Installing rb-inotify 0.9.10
remote: Fetching turbolinks 5.1.1
remote: Installing turbolinks 5.1.1
remote: Fetching activesupport 5.2.0
remote: Installing activesupport 5.2.0
remote: Gem::Ext::BuildError: ERROR: Failed to build gem native extension.
remote:
remote: current directory:
remote: /tmp/build_daf23ee4fa4c8c6a8730a0961ca27bb4/vendor/bundle/ruby/2.5.0/gems/sqlite3-1.3.13/ext/sqlite3
remote: /tmp/build_daf23ee4fa4c8c6a8730a0961ca27bb4/vendor/ruby-2.5.1/bin/ruby -r
remote: ./siteconf20180724-232-19lz89i.rb extconf.rb
remote: checking for sqlite3.h… no
remote: sqlite3.h is missing. Try ‘brew install sqlite3’,
remote: ‘yum install sqlite-devel’ or ‘apt-get install libsqlite3-dev’
remote: and check your shared library search path (the
remote: location where your sqlite3 shared library is located).
remote: *** extconf.rb failed ***
remote: Could not create Makefile due to some reason, probably lack of necessary
remote: libraries and/or headers. Check the mkmf.log file for more details. You may
remote: need configuration options.
remote:
remote: Provided configuration options:
remote: --with-opt-dir
remote: --without-opt-dir
remote: --with-opt-include
remote: --without-opt-include=${opt-dir}/include
remote: --with-opt-lib
remote: --without-opt-lib=${opt-dir}/lib
remote: --with-make-prog
remote: --without-make-prog
remote: --srcdir=.
remote: --curdir
remote: --ruby=/tmp/build_daf23ee4fa4c8c6a8730a0961ca27bb4/vendor/ruby-2.5.1/bin/$(RUBY_BASE_NAME)
remote: --with-sqlite3-config
remote: --without-sqlite3-config
remote: --with-pkg-config
remote: --without-pkg-config
remote: --with-sqlite3-dir
remote: --without-sqlite3-dir
remote: --with-sqlite3-include
remote: --without-sqlite3-include=${sqlite3-dir}/include
remote: --with-sqlite3-lib
remote: --without-sqlite3-lib=${sqlite3-dir}/lib
remote:
remote: To see why this extension failed to compile, please check the mkmf.log which can
remote: be found here:
remote:
remote: /tmp/build_daf23ee4fa4c8c6a8730a0961ca27bb4/vendor/bundle/ruby/2.5.0/extensions/x86_64-linux/2.5.0/sqlite3-1.3.13/mkmf.log
remote:
remote: extconf failed, exit code 1
remote:
remote: Gem files will remain installed in
remote: /tmp/build_daf23ee4fa4c8c6a8730a0961ca27bb4/vendor/bundle/ruby/2.5.0/gems/sqlite3-1.3.13
remote: for inspection.
remote: Results logged to
remote: /tmp/build_daf23ee4fa4c8c6a8730a0961ca27bb4/vendor/bundle/ruby/2.5.0/extensions/x86_64-linux/2.5.0/sqlite3-1.3.13/gem_make.out
remote:
remote: An error occurred while installing sqlite3 (1.3.13), and Bundler cannot
remote: continue.
remote: Make sure that gem install sqlite3 -v '1.3.13' succeeds before bundling.
remote:
remote: In Gemfile:
remote: sqlite3
remote: Bundler Output: Warning: the running version of Bundler (1.15.2) is older than the version that created the lockfile (1.16.3). We suggest you upgrade to the latest version of Bundler by running gem install bundler.
remote: Fetching gem metadata from https://rubygems.org/
remote: Fetching version metadata from https://rubygems.org/
remote: Fetching dependency metadata from https://rubygems.org/.
remote: Fetching rake 12.3.1
remote: Fetching concurrent-ruby 1.0.5
remote: Fetching minitest 5.11.3
remote: Installing rake 12.3.1
remote: Installing minitest 5.11.3
remote: Installing concurrent-ruby 1.0.5
remote: Fetching thread_safe 0.3.6
remote: Installing thread_safe 0.3.6
remote: Fetching builder 3.2.3
remote: Installing builder 3.2.3
remote: Fetching erubi 1.7.1
remote: Installing erubi 1.7.1
remote: Fetching mini_portile2 2.3.0
remote: Installing mini_portile2 2.3.0
remote: Fetching crass 1.0.4
remote: Installing crass 1.0.4
remote: Fetching rack 2.0.5
remote: Fetching nio4r 2.3.1
remote: Installing rack 2.0.5
remote: Installing nio4r 2.3.1 with native extensions
remote: Fetching websocket-extensions 0.1.3
remote: Installing websocket-extensions 0.1.3
remote: Fetching mini_mime 1.0.0
remote: Installing mini_mime 1.0.0
remote: Fetching arel 9.0.0
remote: Installing arel 9.0.0
remote: Fetching mimemagic 0.3.2
remote: Fetching msgpack 1.2.4
remote: Installing msgpack 1.2.4 with native extensions
remote: Installing mimemagic 0.3.2
remote: Using bundler 1.15.2
remote: Fetching coffee-script-source 1.12.2
remote: Installing coffee-script-source 1.12.2
remote: Fetching execjs 2.7.0
remote: Installing execjs 2.7.0
remote: Fetching method_source 0.9.0
remote: Installing method_source 0.9.0
remote: Fetching thor 0.20.0
remote: Installing thor 0.20.0
remote: Fetching ffi 1.9.25
remote: Installing ffi 1.9.25 with native extensions
remote: Fetching multi_json 1.13.1
remote: Installing multi_json 1.13.1
remote: Fetching puma 3.12.0
remote: Installing puma 3.12.0 with native extensions
remote: Fetching rb-fsevent 0.10.3
remote: Installing rb-fsevent 0.10.3
remote: Fetching tilt 2.0.8
remote: Installing tilt 2.0.8
remote: Fetching sqlite3 1.3.13
remote: Installing sqlite3 1.3.13 with native extensions
remote: Fetching turbolinks-source 5.1.0
remote: Installing turbolinks-source 5.1.0
remote: Fetching tzinfo 1.2.5
remote: Installing tzinfo 1.2.5
remote: Fetching nokogiri 1.8.4
remote: Installing nokogiri 1.8.4 with native extensions
remote: Fetching i18n 1.0.1
remote: Installing i18n 1.0.1
remote: Fetching websocket-driver 0.7.0
remote: Installing websocket-driver 0.7.0 with native extensions
remote: Fetching mail 2.7.0
remote: Installing mail 2.7.0
remote: Fetching rack-test 1.1.0
remote: Installing rack-test 1.1.0
remote: Fetching sprockets 3.7.2
remote: Installing sprockets 3.7.2
remote: Fetching marcel 0.3.2
remote: Installing marcel 0.3.2
remote: Fetching coffee-script 2.4.1
remote: Installing coffee-script 2.4.1
remote: Fetching uglifier 4.1.16
remote: Installing uglifier 4.1.16
remote: Fetching bootsnap 1.3.1
remote: Installing bootsnap 1.3.1 with native extensions
remote: Fetching rb-inotify 0.9.10
remote: Installing rb-inotify 0.9.10
remote: Fetching turbolinks 5.1.1
remote: Installing turbolinks 5.1.1
remote: Fetching activesupport 5.2.0
remote: Installing activesupport 5.2.0
remote: Gem::Ext::BuildError: ERROR: Failed to build gem native extension.
remote:
remote: current directory:
remote: /tmp/build_daf23ee4fa4c8c6a8730a0961ca27bb4/vendor/bundle/ruby/2.5.0/gems/sqlite3-1.3.13/ext/sqlite3
remote: /tmp/build_daf23ee4fa4c8c6a8730a0961ca27bb4/vendor/ruby-2.5.1/bin/ruby -r
remote: ./siteconf20180724-232-19lz89i.rb extconf.rb
remote: checking for sqlite3.h… no
remote: sqlite3.h is missing. Try ‘brew install sqlite3’,
remote: ‘yum install sqlite-devel’ or ‘apt-get install libsqlite3-dev’
remote: and check your shared library search path (the
remote: location where your sqlite3 shared library is located).
remote: *** extconf.rb failed ***
remote: Could not create Makefile due to some reason, probably lack of necessary
remote: libraries and/or headers. Check the mkmf.log file for more details. You may
remote: need configuration options.
remote:
remote: Provided configuration options:
remote: --with-opt-dir
remote: --without-opt-dir
remote: --with-opt-include
remote: --without-opt-include=${opt-dir}/include
remote: --with-opt-lib
remote: --without-opt-lib=${opt-dir}/lib
remote: --with-make-prog
remote: --without-make-prog
remote: --srcdir=.
remote: --curdir
remote: --ruby=/tmp/build_daf23ee4fa4c8c6a8730a0961ca27bb4/vendor/ruby-2.5.1/bin/$(RUBY_BASE_NAME)
remote: --with-sqlite3-config
remote: --without-sqlite3-config
remote: --with-pkg-config
remote: --without-pkg-config
remote: --with-sqlite3-dir
remote: --without-sqlite3-dir
remote: --with-sqlite3-include
remote: --without-sqlite3-include=${sqlite3-dir}/include
remote: --with-sqlite3-lib
remote: --without-sqlite3-lib=${sqlite3-dir}/lib
remote:
remote: To see why this extension failed to compile, please check the mkmf.log which can
remote: be found here:
remote:
remote: /tmp/build_daf23ee4fa4c8c6a8730a0961ca27bb4/vendor/bundle/ruby/2.5.0/extensions/x86_64-linux/2.5.0/sqlite3-1.3.13/mkmf.log
remote:
remote: extconf failed, exit code 1
remote:
remote: Gem files will remain installed in
remote: /tmp/build_daf23ee4fa4c8c6a8730a0961ca27bb4/vendor/bundle/ruby/2.5.0/gems/sqlite3-1.3.13
remote: for inspection.
remote: Results logged to
remote: /tmp/build_daf23ee4fa4c8c6a8730a0961ca27bb4/vendor/bundle/ruby/2.5.0/extensions/x86_64-linux/2.5.0/sqlite3-1.3.13/gem_make.out
remote:
remote: An error occurred while installing sqlite3 (1.3.13), and Bundler cannot
remote: continue.
remote: Make sure that gem install sqlite3 -v '1.3.13' succeeds before bundling.
remote:
remote: In Gemfile:
remote: sqlite3
remote:
remote: !
remote: ! Failed to install gems via Bundler.
remote: ! Detected sqlite3 gem which is not supported on Heroku:
remote: ! https://devcenter.heroku.com/articles/sqlite3
remote: !
remote: ! Push rejected, failed to compile Ruby app.
remote:
remote: ! Push failed
remote: Verifying deploy…
remote:
remote: ! Push rejected to powerful-stream-97483.
remote:
To https://git.heroku.com/powerful-stream-97483.git
! [remote rejected] master -> master (pre-receive hook declined)
error: failed to push some refs to ‘https://git.heroku.com/powerful-stream-97483.git

Hello guys

I encountered with this error. I checked on heroku and it didnot wokr - upload failed from git.

Could anyone help in this case ?


Gem Sqlite3 Failing when Pushed to Heroku
#2

remote: ! Failed to install gems via Bundler.
remote: ! Detected sqlite3 gem which is not supported on Heroku:
remote: ! https://devcenter.heroku.com/articles/sqlite3
remote: !
remote: ! Push rejected, failed to compile Ruby app.
remote:
remote: ! Push failed
remote: Verifying deploy…
remote:
remote: ! Push rejected to powerful-stream-97483.


#3

Could anyone help in this?

Once I read on the forum that may the Gemfile.lock should be deleted from here.
Any guess ?


#4

The issue is resolved.


#6

Hey there,
I’m running into this issue also:

remote: In Gemfile:
remote: sqlite3
remote:
remote: !
remote: ! Failed to install gems via Bundler.
remote: ! Detected sqlite3 gem which is not supported on Heroku:
remote: ! https://devcenter.heroku.com/articles/sqlite3
remote: !
remote: ! Push rejected, failed to compile Ruby app.
remote:
remote: ! Push failed
remote: Verifying deploy…
remote:
remote: ! Push rejected to immense-everglades-92863.

What was your solution??
Thanks in advance


#7

Hi @2manyhats

Did you update your gemfile as per the instructions and commit it to git before pushing?


#8

Yes I did. It was a little confusing at first b/c I made the changes through VS but when I tried to save it kept saying ‘pending changes’. I went back and fiddled around and managed to get it to save proper but still couldn’t get it to push. Originally I wrote it out as per instruction:

group :development, :test do
  gem 'sqlite3'
end

group :production do
  gem 'pg'
end

…and it still wouldn’t work. I ended up finding a thread and a guy had it written:

group :development do 
  gem 'sqlite3'    #gem to use in development environment
end

group :production do 
 gem 'pg'         #gem to use in production environment
end

…So for S&G I decided to try that way and it worked :man_shrugging:

I gotta say this is quite the learning curve this stuff to figure this all out I feel like I’m retaining very little haha but I have faith in the process… I think. lol.


#9

Glad you got it sorted.


#10

Was gonna ask, maybe the tutorial needs to be updated? Because it has

group :development, :test do
  gem 'sqlite3'
end

group :production do
  gem 'pg'
end

And it wouldn’t work for me until I came across this thread and used

group :development do 
  gem 'sqlite3'    #gem to use in development environment
end

group :production do 
 gem 'pg'         #gem to use in production environment
end

Then it worked


#11

Either should work. It’s difficult to diagnose with the limited information provided.


#12

I just hit this same error and the work around

group :development do 
  gem 'sqlite3'    #gem to use in development environment
end

group :production do 
 gem 'pg'         #gem to use in production environment
end

worked for me as well.