activerecord - Heroku Invalid DATABASE_URL when pushing - Heroku bug, fixed now -

edits:

this temporary bug heroku have fixed.

---

my push / deploy heroku failing when working last week. it's sinatra app using activerecord on cedar stack.

i able app deployed , running several times in heroku. i'm using postgres , cedar stack.

i have made 1 whitespace change app.rb , pushed , push not accepted.

the app working on server code last week. using database, can see it.

heroku info , heroku config lists database_url correctly.

i have created new database, , promoted didn't (the running instance used new database okay).

i created new dyno running on cedar stack, set new db , provisioned unable push code same error.

the following error message: in case i'm trying use latest version of sinatra activerecord see if there bug (it didn't help)

git push heroku heroku_bug_before:master counting objects: 20, done. delta compression using 4 threads. compressing objects: 100% (14/14), done. writing objects: 100% (14/14), 1.60 kib, done. total 14 (delta 9), reused 0 (delta 0)  -----> ruby/rack app detected -----> using ruby version: ruby-1.9.2 -----> installing dependencies using bundler version 1.3.2        running: bundle install --without development:test --path vendor/bundle --binstubs vendor/bundle/bin --deployment        fetching gem metadata https://rubygems.org/.........        fetching gem metadata https://rubygems.org/..        using i18n (0.6.1)        using multi_json (1.7.7)        using activesupport (3.2.13)        using builder (3.0.4)        using activemodel (3.2.13)        using arel (3.0.2)        using tzinfo (0.3.37)        using activerecord (3.2.13)        using backports (3.3.3)        using bond (0.4.3)        using eventmachine (1.0.3)        using kgio (2.8.0)        using libxml-ruby (2.6.0)        using mime-types (1.23)        using oj (2.1.4)        using pg (0.15.1)        using r18n-core (1.1.5)        using rack (1.5.2)        using rack-protection (1.5.0)        using rack-test (0.6.2)        using raindrops (0.11.0)        using rest-client (1.6.7)        using ripl (0.7.0)        using ripl-multi_line (0.3.1)        using ripl-rack (0.2.0)        using tilt (1.4.1)        using sinatra (1.3.2)        installing sinatra-activerecord (1.2.3)        using sinatra-contrib (1.3.2)        using sinatra-flash (0.3.0)        using sinatra-r18n (1.1.5)        using tux (0.3.0)        using unicorn (4.6.3)        using bundler (1.3.2)        bundle complete! installed ./vendor/bundle        cleaning bundler cache.        removing sinatra-activerecord (1.2.2) -----> writing config/database.yml read database_url  !  !     rake aborted!  !     invalid database_url  !     (erb):9:in `rescue in <main>'  !     (erb):6:in `<main>'  !     /tmp/ruby-1.9.2/lib/ruby/1.9.1/erb.rb:753:in `eval'  !     /tmp/ruby-1.9.2/lib/ruby/1.9.1/erb.rb:753:in `result'  !     /tmp/build_2b0q7ep6511dz/vendor/bundle/ruby/1.9.1/gems/sinatra-activerecord-1.2.3/lib/sinatra/activerecord.rb:39:in `database_file='  !     /tmp/build_2b0q7ep6511dz/vendor/bundle/ruby/1.9.1/gems/sinatra-1.3.2/lib/sinatra/base.rb:983:in `set'  !     /tmp/build_2b0q7ep6511dz/vendor/bundle/ruby/1.9.1/gems/sinatra-activerecord-1.2.3/lib/sinatra/activerecord.rb:50:in `registered'  !     /tmp/build_2b0q7ep6511dz/vendor/bundle/ruby/1.9.1/gems/sinatra-1.3.2/lib/sinatra/base.rb:1262:in `block in register'  !     /tmp/build_2b0q7ep6511dz/vendor/bundle/ruby/1.9.1/gems/sinatra-1.3.2/lib/sinatra/base.rb:1260:in `each'  !     /tmp/build_2b0q7ep6511dz/vendor/bundle/ruby/1.9.1/gems/sinatra-1.3.2/lib/sinatra/base.rb:1260:in `register'  !     /tmp/build_2b0q7ep6511dz/vendor/bundle/ruby/1.9.1/gems/sinatra-1.3.2/lib/sinatra/base.rb:1590:in `register'  !     /tmp/build_2b0q7ep6511dz/vendor/bundle/ruby/1.9.1/gems/sinatra-1.3.2/lib/sinatra/base.rb:1630:in `register'  !     /tmp/build_2b0q7ep6511dz/vendor/bundle/ruby/1.9.1/gems/sinatra-activerecord-1.2.3/lib/sinatra/activerecord.rb:76:in `<module:sinatra>'  !     /tmp/build_2b0q7ep6511dz/vendor/bundle/ruby/1.9.1/gems/sinatra-activerecord-1.2.3/lib/sinatra/activerecord.rb:6:in `<top (required)>'  !     /tmp/build_2b0q7ep6511dz/app.rb:2:in `require'  !     /tmp/build_2b0q7ep6511dz/app.rb:2:in `<top (required)>'  !     /tmp/build_2b0q7ep6511dz/rakefile:1:in `require'  !     /tmp/build_2b0q7ep6511dz/rakefile:1:in `<top (required)>'  !     /tmp/ruby-1.9.2/lib/ruby/1.9.1/rake.rb:2373:in `load'  !     /tmp/ruby-1.9.2/lib/ruby/1.9.1/rake.rb:2373:in `raw_load_rakefile'  !     /tmp/ruby-1.9.2/lib/ruby/1.9.1/rake.rb:2007:in `block in load_rakefile'  !     /tmp/ruby-1.9.2/lib/ruby/1.9.1/rake.rb:2058:in `standard_exception_handling'  !     /tmp/ruby-1.9.2/lib/ruby/1.9.1/rake.rb:2006:in `load_rakefile'  !     (eval):1:in `block in standard_rake_options'  !     /tmp/ruby-1.9.2/lib/ruby/1.9.1/rake.rb:2213:in `eval'  !     /tmp/ruby-1.9.2/lib/ruby/1.9.1/rake.rb:2213:in `block in standard_rake_options'  !     /tmp/ruby-1.9.2/lib/ruby/1.9.1/optparse.rb:1308:in `call'  !     /tmp/ruby-1.9.2/lib/ruby/1.9.1/optparse.rb:1308:in `block in parse_in_order'  !     /tmp/ruby-1.9.2/lib/ruby/1.9.1/optparse.rb:1264:in `catch'  !     /tmp/ruby-1.9.2/lib/ruby/1.9.1/optparse.rb:1264:in `parse_in_order'  !     /tmp/ruby-1.9.2/lib/ruby/1.9.1/optparse.rb:1258:in `order!'  !     /tmp/ruby-1.9.2/lib/ruby/1.9.1/optparse.rb:1349:in `permute!'  !     /tmp/ruby-1.9.2/lib/ruby/1.9.1/optparse.rb:1370:in `parse!'  !     /tmp/ruby-1.9.2/lib/ruby/1.9.1/rake.rb:2303:in `handle_options'  !     /tmp/ruby-1.9.2/lib/ruby/1.9.1/rake.rb:1999:in `block in init'  !     /tmp/ruby-1.9.2/lib/ruby/1.9.1/rake.rb:2058:in `standard_exception_handling'  !     /tmp/ruby-1.9.2/lib/ruby/1.9.1/rake.rb:1997:in `init'  !     /tmp/ruby-1.9.2/lib/ruby/1.9.1/rake.rb:1990:in `run'  !     /tmp/ruby-1.9.2/bin/rake:31:in `<main>'  !     (in /tmp/build_2b0q7ep6511dz)  ! sh: syntax error: unterminated quoted string   !     push rejected, failed compile ruby/rack app 

heroku config (you can see db added, , promoted)

=== visualtags config vars database_url:                 postgres://changed1:changed@ec2-54-217-215-81.eu-west-1.compute.amazonaws.com:5432/changed1 heroku_postgresql_cobalt_url: postgres://changed2:changed@ec2-54-217-215-81.eu-west-1.compute.amazonaws.com:5432/changed2 heroku_postgresql_cyan_url:   postgres://changed3:changed@ec2-54-217-215-96.eu-west-1.compute.amazonaws.com:5432/changed3 

heroku pg:info

=== heroku_postgresql_cobalt_url (database_url) plan:        dev status:      available connections: 4 pg version:  9.2.4 created:     2013-07-23 17:49 utc data size:   6.4 mb tables:      2 rows:        4/10000 (in compliance) - refreshing fork/follow: unsupported region:      europe 

heroku info

=== herokuapp addons:        heroku-postgresql:dev                heroku-postgresql:dev  git url:       xxx owner email:   mine@example.com region:        eu repo size:     8m slug size:     17m stack:         cedar tier:          legacy web url:       http://xxx.herokuapp.com/ 

i've spent hours on - working last week, no longer works. i'm using unicorn , activerecord , following advice in docs also...

any ideas?

same issue here padrino/datamapper , heroku postgre basic plan, haven't been able deploy since morning.

the database_url config var seem correctly set when run 'heroku config' , can access padrino console env['database_url'] not sure what's causing problem.

this guy configuring heroku database connection in padrino - database_url fails has been able use heroku_postgresql_color_url directly , fixed not app.

looks problem heroku deploy script, best thing raise ticket them https://help.heroku.com/tickets/new?query=postgre

(sorry that's more comment actual answer, apparently don't have enough rep commenting)

---

edit: heroku replied ticket saying problem fixed , can deploy apps again.