[heroku] Error H10 (App crashed)

Hi i am developing an application which is working perfectly in development server ... but it is crashing when deploy it to heroku .. these are the logs related to my app.... i am using rails 3.1.0 .... is it compulsory to install postgresql adapter gem in localhost... Please help me out with this...

2011-10-06T19:11:06+00:00 heroku[web.1]: State changed from crashed to created 2011-10-06T19:11:06+00:00 heroku[web.1]: State changed from created to starting 2011-10-06T19:11:07+00:00 heroku[web.1]: Starting process with command `thin -p 47915 -e production -R /home/heroku_rack/heroku.ru start` 2011-10-06T19:11:11+00:00 app[web.1]: /app/.bundle/gems/ruby/1.9.1/ gems/activerecord-3.1.0/lib/active_record/connection_adapters/abstract/ connection_specification.rb:71:in `rescue in establish_connection': Please install the postgresql adapter: `gem install activerecord- postgresql-adapter` (pg is not part of the bundle. Add it to Gemfile.) (RuntimeError) 2011-10-06T19:11:11+00:00 app[web.1]: from /app/.bundle/gems/ruby/ 1.9.1/gems/activerecord-3.1.0/lib/active_record/connection_adapters/ abstract/connection_specification.rb:68:in `establish_connection' 2011-10-06T19:11:11+00:00 app[web.1]: from /app/.bundle/gems/ruby/ 1.9.1/gems/activerecord-3.1.0/lib/active_record/connection_adapters/ abstract/connection_specification.rb:60:in `establish_connection' 2011-10-06T19:11:11+00:00 app[web.1]: from /app/.bundle/gems/ruby/ 1.9.1/gems/activerecord-3.1.0/lib/active_record/connection_adapters/ abstract/connection_specification.rb:55:in `establish_connection' 2011-10-06T19:11:11+00:00 app[web.1]: from /app/.bundle/gems/ruby/ 1.9.1/gems/activerecord-3.1.0/lib/active_record/railtie.rb:69:in `block (2 levels) in <class:Railtie>' 2011-10-06T19:11:11+00:00 app[web.1]: from /app/.bundle/gems/ruby/ 1.9.1/gems/activesupport-3.1.0/lib/active_support/lazy_load_hooks.rb: 36:in `instance_eval' 2011-10-06T19:11:11+00:00 app[web.1]: from /app/.bundle/gems/ruby/ 1.9.1/gems/activesupport-3.1.0/lib/active_support/lazy_load_hooks.rb: 36:in `execute_hook' 2011-10-06T19:11:11+00:00 app[web.1]: from /app/.bundle/gems/ruby/ 1.9.1/gems/activesupport-3.1.0/lib/active_support/lazy_load_hooks.rb: 26:in `on_load' 2011-10-06T19:11:11+00:00 app[web.1]: from /app/.bundle/gems/ruby/ 1.9.1/gems/activerecord-3.1.0/lib/active_record/railtie.rb:67:in `block in <class:Railtie>' 2011-10-06T19:11:11+00:00 app[web.1]: from /app/.bundle/gems/ruby/ 1.9.1/gems/railties-3.1.0/lib/rails/initializable.rb:25:in `instance_exec' 2011-10-06T19:11:11+00:00 app[web.1]: from /app/.bundle/gems/ruby/ 1.9.1/gems/railties-3.1.0/lib/rails/initializable.rb:25:in `run' 2011-10-06T19:11:11+00:00 app[web.1]: from /app/.bundle/gems/ruby/ 1.9.1/gems/railties-3.1.0/lib/rails/initializable.rb:50:in `block in run_initializers' 2011-10-06T19:11:11+00:00 app[web.1]: from /app/.bundle/gems/ruby/ 1.9.1/gems/railties-3.1.0/lib/rails/initializable.rb:49:in `each' 2011-10-06T19:11:11+00:00 app[web.1]: from /app/.bundle/gems/ruby/ 1.9.1/gems/railties-3.1.0/lib/rails/initializable.rb:49:in `run_initializers' 2011-10-06T19:11:11+00:00 app[web.1]: from /app/.bundle/gems/ruby/ 1.9.1/gems/railties-3.1.0/lib/rails/application.rb:92:in `initialize!' 2011-10-06T19:11:11+00:00 app[web.1]: from /app/.bundle/gems/ruby/ 1.9.1/gems/railties-3.1.0/lib/rails/railtie/configurable.rb:30:in `method_missing' 2011-10-06T19:11:11+00:00 app[web.1]: from /app/config/environment.rb: 5:in `<top (required)>' 2011-10-06T19:11:11+00:00 app[web.1]: from <internal:lib/rubygems/ custom_require>:29:in `require' 2011-10-06T19:11:11+00:00 app[web.1]: from <internal:lib/rubygems/ custom_require>:29:in `require' 2011-10-06T19:11:11+00:00 app[web.1]: from config.ru:3:in `block (3 levels) in <main>' 2011-10-06T19:11:11+00:00 app[web.1]: from /home/heroku_rack/ heroku.ru:23:in `eval' 2011-10-06T19:11:11+00:00 app[web.1]: from /home/heroku_rack/ heroku.ru:23:in `block (3 levels) in <main>' 2011-10-06T19:11:11+00:00 app[web.1]: from /app/.bundle/gems/ruby/ 1.9.1/gems/rack-1.3.3/lib/rack/builder.rb:51:in `instance_eval' 2011-10-06T19:11:11+00:00 app[web.1]: from /app/.bundle/gems/ruby/ 1.9.1/gems/rack-1.3.3/lib/rack/builder.rb:51:in `initialize' 2011-10-06T19:11:11+00:00 heroku[web.1]: Process exited 2011-10-06T19:11:12+00:00 heroku[web.1]: State changed from starting to crashed 2011-10-06T19:21:36+00:00 heroku[web.1]: State changed from crashed to created 2011-10-06T19:21:36+00:00 heroku[web.1]: State changed from created to starting 2011-10-06T19:21:38+00:00 heroku[web.1]: Starting process with command `thin -p 3383 -e production -R /home/heroku_rack/heroku.ru start` 2011-10-06T19:21:41+00:00 app[web.1]: /app/.bundle/gems/ruby/1.9.1/ gems/activerecord-3.1.0/lib/active_record/connection_adapters/abstract/ connection_specification.rb:71:in `rescue in establish_connection': Please install the postgresql adapter: `gem install activerecord- postgresql-adapter` (pg is not part of the bundle. Add it to Gemfile.) (RuntimeError) 2011-10-06T19:21:41+00:00 app[web.1]: from /app/.bundle/gems/ruby/ 1.9.1/gems/activerecord-3.1.0/lib/active_record/connection_adapters/ abstract/connection_specification.rb:68:in `establish_connection' 2011-10-06T19:21:41+00:00 app[web.1]: from /app/.bundle/gems/ruby/ 1.9.1/gems/activerecord-3.1.0/lib/active_record/connection_adapters/ abstract/connection_specification.rb:60:in `establish_connection' 2011-10-06T19:21:41+00:00 app[web.1]: from /app/.bundle/gems/ruby/ 1.9.1/gems/activerecord-3.1.0/lib/active_record/connection_adapters/ abstract/connection_specification.rb:55:in `establish_connection' 2011-10-06T19:21:41+00:00 app[web.1]: from /app/.bundle/gems/ruby/ 1.9.1/gems/activerecord-3.1.0/lib/active_record/railtie.rb:69:in `block (2 levels) in <class:Railtie>' 2011-10-06T19:21:41+00:00 app[web.1]: from /app/.bundle/gems/ruby/ 1.9.1/gems/activesupport-3.1.0/lib/active_support/lazy_load_hooks.rb: 36:in `instance_eval' 2011-10-06T19:21:41+00:00 app[web.1]: from /app/.bundle/gems/ruby/ 1.9.1/gems/activesupport-3.1.0/lib/active_support/lazy_load_hooks.rb: 36:in `execute_hook' 2011-10-06T19:21:41+00:00 app[web.1]: from /app/.bundle/gems/ruby/ 1.9.1/gems/activesupport-3.1.0/lib/active_support/lazy_load_hooks.rb: 26:in `on_load' 2011-10-06T19:21:41+00:00 app[web.1]: from /app/.bundle/gems/ruby/ 1.9.1/gems/activerecord-3.1.0/lib/active_record/railtie.rb:67:in `block in <class:Railtie>' 2011-10-06T19:21:41+00:00 app[web.1]: from /app/.bundle/gems/ruby/ 1.9.1/gems/railties-3.1.0/lib/rails/initializable.rb:25:in `instance_exec' 2011-10-06T19:21:41+00:00 app[web.1]: from /app/.bundle/gems/ruby/ 1.9.1/gems/railties-3.1.0/lib/rails/initializable.rb:25:in `run' 2011-10-06T19:21:41+00:00 app[web.1]: from /app/.bundle/gems/ruby/ 1.9.1/gems/railties-3.1.0/lib/rails/initializable.rb:50:in `block in run_initializers' 2011-10-06T19:21:41+00:00 app[web.1]: from /app/.bundle/gems/ruby/ 1.9.1/gems/railties-3.1.0/lib/rails/initializable.rb:49:in `each' 2011-10-06T19:21:41+00:00 app[web.1]: from /app/.bundle/gems/ruby/ 1.9.1/gems/railties-3.1.0/lib/rails/initializable.rb:49:in `run_initializers' 2011-10-06T19:21:41+00:00 app[web.1]: from /app/.bundle/gems/ruby/ 1.9.1/gems/railties-3.1.0/lib/rails/application.rb:92:in `initialize!' 2011-10-06T19:21:41+00:00 app[web.1]: from /app/.bundle/gems/ruby/ 1.9.1/gems/railties-3.1.0/lib/rails/railtie/configurable.rb:30:in `method_missing' 2011-10-06T19:21:41+00:00 app[web.1]: from /app/config/environment.rb: 5:in `<top (required)>' 2011-10-06T19:21:41+00:00 app[web.1]: from <internal:lib/rubygems/ custom_require>:29:in `require' 2011-10-06T19:21:41+00:00 app[web.1]: from <internal:lib/rubygems/ custom_require>:29:in `require' 2011-10-06T19:21:41+00:00 app[web.1]: from config.ru:3:in `block (3 levels) in <main>' 2011-10-06T19:21:41+00:00 app[web.1]: from /home/heroku_rack/ heroku.ru:23:in `eval' 2011-10-06T19:21:41+00:00 app[web.1]: from /home/heroku_rack/ heroku.ru:23:in `block (3 levels) in <main>' 2011-10-06T19:21:41+00:00 app[web.1]: from /app/.bundle/gems/ruby/ 1.9.1/gems/rack-1.3.3/lib/rack/builder.rb:51:in `instance_eval' 2011-10-06T19:21:41+00:00 app[web.1]: from /app/.bundle/gems/ruby/ 1.9.1/gems/rack-1.3.3/lib/rack/builder.rb:51:in `initialize' 2011-10-06T19:21:41+00:00 app[web.1]: from /app/.bundle/gems/ruby/ 1.9.1/gems/rack-1.3.3/lib/rack/builder.rb:120:in `new' 2011-10-06T19:21:41+00:00 app[web.1]: from /app/.bundle/gems/ruby/ 1.9.1/gems/rack-1.3.3/lib/rack/builder.rb:120:in `map' 2011-10-06T19:21:41+00:00 app[web.1]: from /home/heroku_rack/ heroku.ru:18:in `block (2 levels) in <main>' 2011-10-06T19:21:41+00:00 app[web.1]: from /app/.bundle/gems/ruby/ 1.9.1/gems/rack-1.3.3/lib/rack/builder.rb:51:in `instance_eval' 2011-10-06T19:21:41+00:00 app[web.1]: from /app/.bundle/gems/ruby/ 1.9.1/gems/rack-1.3.3/lib/rack/builder.rb:51:in `initialize' 2011-10-06T19:21:41+00:00 app[web.1]: from /home/heroku_rack/ heroku.ru:11:in `new' 2011-10-06T19:21:41+00:00 app[web.1]: from /home/heroku_rack/ heroku.ru:11:in `block in <main>' 2011-10-06T19:21:41+00:00 app[web.1]: from /app/.bundle/gems/ruby/ 1.9.1/gems/rack-1.3.3/lib/rack/builder.rb:51:in `instance_eval' 2011-10-06T19:21:41+00:00 app[web.1]: from /app/.bundle/gems/ruby/ 1.9.1/gems/rack-1.3.3/lib/rack/builder.rb:51:in `initialize' 2011-10-06T19:21:41+00:00 app[web.1]: from /home/heroku_rack/ heroku.ru:1:in `new' 2011-10-06T19:21:41+00:00 app[web.1]: from /home/heroku_rack/ heroku.ru:1:in `<main>' 2011-10-06T19:21:41+00:00 app[web.1]: from /usr/ruby1.9.2/lib/ruby/ gems/1.9.1/gems/thin-1.2.6/lib/rack/adapter/loader.rb:36:in `eval' 2011-10-06T19:21:41+00:00 app[web.1]: from /usr/ruby1.9.2/lib/ruby/ gems/1.9.1/gems/thin-1.2.6/lib/rack/adapter/loader.rb:36:in `load' 2011-10-06T19:21:41+00:00 app[web.1]: from /usr/ruby1.9.2/lib/ruby/ gems/1.9.1/gems/thin-1.2.6/lib/thin/controllers/controller.rb:175:in `load_rackup_config' 2011-10-06T19:21:41+00:00 app[web.1]: from /usr/ruby1.9.2/lib/ruby/ gems/1.9.1/gems/thin-1.2.6/lib/thin/controllers/controller.rb:65:in `start' 2011-10-06T19:21:41+00:00 app[web.1]: from /usr/ruby1.9.2/lib/ruby/ gems/1.9.1/gems/thin-1.2.6/lib/thin/runner.rb:177:in `run_command' 2011-10-06T19:21:41+00:00 app[web.1]: from /usr/ruby1.9.2/lib/ruby/ gems/1.9.1/gems/thin-1.2.6/lib/thin/runner.rb:143:in `run!' 2011-10-06T19:21:41+00:00 app[web.1]: from /usr/ruby1.9.2/lib/ruby/ gems/1.9.1/gems/thin-1.2.6/bin/thin:6:in `<top (required)>' 2011-10-06T19:21:41+00:00 app[web.1]: from /usr/ruby1.9.2/bin/thin: 19:in `load' 2011-10-06T19:21:41+00:00 app[web.1]: from /usr/ruby1.9.2/bin/thin: 19:in `<main>' 2011-10-06T19:21:41+00:00 heroku[web.1]: Process exited 2011-10-06T19:21:42+00:00 heroku[web.1]: State changed from starting to crashed 2011-10-06T19:21:59+00:00 heroku[router]: Error H10 (App crashed) -> GET my_app_ name.heroku.com/ dyno= queue= wait= service= status=503 bytes= 2011-10-06T19:21:59+00:00 heroku[nginx]: 103.246.106.9 - - [06/Oct/ 2011:12:21:59 -0700] "GET / HTTP/1.1" 503 607 "-" "Mozilla/5.0 (X11; Linux i686) AppleWebKit/535.1 (KHTML, like Gecko) Chrome/14.0.835.202 Safari/535.1" my_app_ name.heroku.com 2011-10-06T19:22:00+00:00 heroku[nginx]: 103.246.106.9 - - [06/Oct/ 2011:12:22:00 -0700] "GET / HTTP/1.1" 503 607 "-" "Mozilla/5.0 (X11; Linux i686) AppleWebKit/535.1 (KHTML, like Gecko) Chrome/14.0.835.202 Safari/535.1" my_app_ name.heroku.com 2011-10-06T19:22:00+00:00 heroku[router]: Error H10 (App crashed) -> GET my_app_ name.heroku.com/ dyno= queue= wait= service= status=503 bytes= 2011-10-06T19:22:00+00:00 heroku[nginx]: 103.246.106.9 - - [06/Oct/ 2011:12:22:00 -0700] "GET / HTTP/1.1" 503 607 "-" "Mozilla/5.0 (X11; Linux i686) AppleWebKit/535.1 (KHTML, like Gecko) Chrome/14.0.835.202 Safari/535.1" my_app_ name.heroku.com 2011-10-06T19:22:01+00:00 heroku[router]: Error H10 (App crashed) -> GET my_app_ name.heroku.com/favicon.ico dyno= queue= wait= service= status=503 bytes= 2011-10-06T19:22:01+00:00 heroku[nginx]: 103.246.106.9 - - [06/Oct/ 2011:12:22:01 -0700] "GET /favicon.ico HTTP/1.1" 503 607 "-" "Mozilla/ 5.0 (X11; Linux i686) AppleWebKit/535.1 (KHTML, like Gecko) Chrome/ 14.0.835.202 Safari/535.1" my_app_ name.heroku.com 2011-10-06T19:22:01+00:00 heroku[router]: Error H10 (App crashed) -> GET my_app_ name.heroku.com/ dyno= queue= wait= service= status=503 bytes= 2011-10-06T19:22:01+00:00 heroku[nginx]: 103.246.106.9 - - [06/Oct/ 2011:12:22:01 -0700] "GET / HTTP/1.1" 503 607 "-" "Mozilla/5.0 (X11; Linux i686) AppleWebKit/535.1 (KHTML, like Gecko) Chrome/14.0.835.202 Safari/535.1" my_app_ name.heroku.com 2011-10-06T19:22:01+00:00 heroku[nginx]: 103.246.106.9 - - [06/Oct/ 2011:12:22:01 -0700] "GET /favicon.ico HTTP/1.1" 503 607 "-" "Mozilla/ 5.0 (X11; Linux i686) AppleWebKit/535.1 (KHTML, like Gecko) Chrome/ 14.0.835.202 Safari/535.1" my_app_ name.heroku.com 2011-10-06T19:22:02+00:00 heroku[router]: Error H10 (App crashed) -> GET my_app_ name.heroku.com/favicon.ico dyno= queue= wait= service= status=503 bytes= 2011-10-06T19:22:02+00:00 heroku[nginx]: 103.246.106.9 - - [06/Oct/ 2011:12:22:02 -0700] "GET /favicon.ico HTTP/1.1" 503 607 "-" "Mozilla/ 5.0 (X11; Linux i686) AppleWebKit/535.1 (KHTML, like Gecko) Chrome/ 14.0.835.202 Safari/535.1" my_app_ name.heroku.com 2011-10-06T19:22:02+00:00 heroku[router]: Error H10 (App crashed) -> GET my_app_ name.heroku.com/favicon.ico dyno= queue= wait= service= status=503 bytes= 2011-10-06T19:22:03+00:00 heroku[nginx]: 103.246.106.9 - - [06/Oct/ 2011:12:22:03 -0700] "GET /favicon.ico HTTP/1.1" 503 607 "-" "Mozilla/ 5.0 (X11; Linux i686) AppleWebKit/535.1 (KHTML, like Gecko) Chrome/ 14.0.835.202 Safari/535.1" my_app_ name.heroku.com 2011-10-06T19:22:04+00:00 heroku[router]: Error H10 (App crashed) -> GET my_app_ name.heroku.com/ dyno= queue= wait= service= status=503 bytes= 2011-10-06T19:22:04+00:00 heroku[nginx]: 103.246.106.9 - - [06/Oct/ 2011:12:22:04 -0700] "GET / HTTP/1.1" 503 607 "-" "Mozilla/5.0 (X11; Linux i686) AppleWebKit/535.1 (KHTML, like Gecko) Chrome/14.0.835.202 Safari/535.1" my_app_ name.heroku.com 2011-10-06T19:22:04+00:00 heroku[router]: Error H10 (App crashed) -> GET my_app_ name.heroku.com/ dyno= queue= wait= service= status=503 bytes= 2011-10-06T19:22:04+00:00 heroku[nginx]: 103.246.106.9 - - [06/Oct/ 2011:12:22:04 -0700] "GET / HTTP/1.1" 503 607 "-" "Mozilla/5.0 (X11; Linux i686) AppleWebKit/535.1 (KHTML, like Gecko) Chrome/14.0.835.202 Safari/535.1" my_app_ name.heroku.com 2011-10-06T19:22:05+00:00 heroku[router]: Error H10 (App crashed) -> GET my_app_ name.heroku.com/favicon.ico dyno= queue= wait= service= status=503 bytes= 2011-10-06T19:22:05+00:00 heroku[nginx]: 103.246.106.9 - - [06/Oct/ 2011:12:22:05 -0700] "GET /favicon.ico HTTP/1.1" 503 607 "-" "Mozilla/ 5.0 (X11; Linux i686) AppleWebKit/535.1 (KHTML, like Gecko) Chrome/ 14.0.835.202 Safari/535.1" my_app_ name.heroku.com 2011-10-06T19:22:06+00:00 heroku[router]: Error H10 (App crashed) -> GET my_app_ name.heroku.com/favicon.ico dyno= queue= wait= service= status=503 bytes= 2011-10-06T19:22:06+00:00 heroku[nginx]: 103.246.106.9 - - [06/Oct/ 2011:12:22:06 -0700] "GET /favicon.ico HTTP/1.1" 503 607 "-" "Mozilla/ 5.0 (X11; Linux i686) AppleWebKit/535.1 (KHTML, like Gecko) Chrome/ 14.0.835.202 Safari/535.1" my_app_ name.heroku.com

From your error message (a little bit buried):

Please install the postgresql adapter: `gem install activerecord-

postgresql-adapter` (pg is not part of the bundle. Add it to Gemfile.)

which means that you need to add

gem ‘pg’

to your gemfile

The log says:

(pg is not part of the bundle. Add it to Gemfile.)

You made this?