Recently moved from sqlite to Postgresql and successfully moved database over. However when I migrate over to Heroku, the migration doesn't take effect. heres my log file. One notable thing is that my schema.rb has this line of code that I never added in - *enable_extension "plpgsql" . * I've even done a Heroku restart but the problem still seems to persist :(
2014-02-06T03:26:29.836017+00:00 app[web.1]: /app/vendor/ruby-2.0.0/lib/ruby/2.0.0/webrick/server.rb:170:in `select' 2014-02-06T03:26:29.836017+00:00 app[web.1]: /app/vendor/ruby-2.0.0/lib/ruby/2.0.0/webrick/server.rb:170:in `block in start' 2014-02-06T03:26:29.836017+00:00 app[web.1]: /app/vendor/ruby-2.0.0/lib/ruby/2.0.0/webrick/server.rb:160:in `start' 2014-02-06T03:26:29.836017+00:00 app[web.1]: /app/vendor/bundle/ruby/2.0.0/gems/rack-1.5.2/lib/rack/server.rb:264:in `start' 2014-02-06T03:26:29.836017+00:00 app[web.1]: /app/vendor/bundle/ruby/2.0.0/gems/railties-4.0.1/lib/rails/commands.rb:76:in `block in <top (required)>' 2014-02-06T03:26:29.836017+00:00 app[web.1]: /app/vendor/bundle/ruby/2.0.0/gems/railties-4.0.1/lib/rails/commands/server.rb:84:in `start' 2014-02-06T03:26:29.836017+00:00 app[web.1]: /app/vendor/bundle/ruby/2.0.0/gems/rack-1.5.2/lib/rack/handler/webrick.rb:14:in `run' 2014-02-06T03:26:29.836017+00:00 app[web.1]: /app/vendor/bundle/ruby/2.0.0/gems/railties-4.0.1/lib/rails/commands.rb:71:in `tap' 2014-02-06T03:26:29.836213+00:00 app[web.1]: /app/vendor/bundle/ruby/2.0.0/gems/railties-4.0.1/lib/rails/commands.rb:71:in `<top (required)>' 2014-02-06T03:26:29.836213+00:00 app[web.1]: bin/rails:4:in `<main>' 2014-02-06T03:26:29.836213+00:00 app[web.1]: => Rails 4.0.1 application starting in production on http://0.0.0.0:46315 2014-02-06T03:26:29.836213+00:00 app[web.1]: bin/rails:4:in `require' 2014-02-06T03:26:29.836213+00:00 app[web.1]: => Booting WEBrick 2014-02-06T03:26:29.836213+00:00 app[web.1]: => Run `rails server -h` for more startup options 2014-02-06T03:26:29.836213+00:00 app[web.1]: [2014-02-06 03:26:29] INFO going to shutdown ... 2014-02-06T03:26:29.836213+00:00 app[web.1]: [2014-02-06 03:26:29] INFO WEBrick::HTTPServer#start done. 2014-02-06T03:26:29.836213+00:00 app[web.1]: => Ctrl-C to shutdown server 2014-02-06T03:26:29.836213+00:00 app[web.1]: Exiting 2014-02-06T03:26:30.808671+00:00 heroku[web.1]: Starting process with command `bin/rails server -p 40427 -e $RAILS_ENV` 2014-02-06T03:26:31.162930+00:00 heroku[web.1]: Process exited with status 143 2014-02-06T03:26:36.418954+00:00 app[web.1]: [2014-02-06 03:26:36] INFO WEBrick 1.3.1 2014-02-06T03:26:36.419398+00:00 app[web.1]: [2014-02-06 03:26:36] INFO WEBrick::HTTPServer#start: pid=2 port=40427 2014-02-06T03:26:36.418954+00:00 app[web.1]: [2014-02-06 03:26:36] INFO ruby 2.0.0 (2013-11-22) [x86_64-linux] 2014-02-06T03:26:36.474403+00:00 heroku[web.1]: State changed from starting to up 2014-02-06T03:26:27.125598+00:00 heroku[web.1]: State changed from up to starting 2014-02-06T03:26:54.502447+00:00 heroku[run.6996]: State changed from starting to up 2014-02-06T03:26:58.958706+00:00 heroku[run.6996]: State changed from up to complete 2014-02-06T03:26:53.883054+00:00 heroku[run.6996]: Starting process with command `bundle exec rake db:migrate` 2014-02-06T03:26:57.342294+00:00 app[run.6996]: == DropTable: migrating ====================================================== 2014-02-06T03:26:57.351167+00:00 app[run.6996]:/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.1/lib/active_record/connection_adapters/postgresql/database_statements.rb:128:in `block in execute' 2014-02-06T03:26:57.340045+00:00 app[run.6996]: Migrating to DropTable (20140203112352) 2014-02-06T03:26:57.351167+00:00 app[run.6996]:/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.1/lib/active_record/migration.rb:625:in `block in method_missing' 2014-02-06T03:26:57.351167+00:00 app[run.6996]:/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.1/lib/active_record/migration.rb:597:in `block in say_with_time' 2014-02-06T03:26:57.342576+00:00 app[run.6996]: -- drop_table(:meal_cards) 2014-02-06T03:26:57.350656+00:00 app[run.6996]: rake aborted! 2014-02-06T03:26:57.346259+00:00 app[run.6996]: PG::UndefinedTable: ERROR: table "meal_cards" does not exist 2014-02-06T03:26:57.350656+00:00 app[run.6996]: 2014-02-06T03:26:57.350656+00:00 app[run.6996]: PG::UndefinedTable: ERROR: table "meal_cards" does not exist 2014-02-06T03:26:57.351167+00:00 app[run.6996]: : DROP TABLE "meal_cards"/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.1/lib/active_record/connection_adapters/postgresql/database_statements.rb:128:in `async_exec' 2014-02-06T03:26:57.350656+00:00 app[run.6996]: An error has occurred, this and all later migrations canceled: 2014-02-06T03:26:57.346259+00:00 app[run.6996]: : DROP TABLE "meal_cards" 2014-02-06T03:26:57.351167+00:00 app[run.6996]:/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.1/lib/active_record/migration.rb:597:in `say_with_time' 2014-02-06T03:26:57.351346+00:00 app[run.6996]:/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:294:in `with_connection' 2014-02-06T03:26:57.351346+00:00 app[run.6996]:/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.1/lib/active_record/migration.rb:553:in `migrate' 2014-02-06T03:26:57.351346+00:00 app[run.6996]:/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.1/lib/active_record/migration.rb:709:in `migrate' 2014-02-06T03:26:57.351346+00:00 app[run.6996]:/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.1/lib/active_record/migration.rb:959:in `block in execute_migration_in_transaction' 2014-02-06T03:26:57.351167+00:00 app[run.6996]:/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.1/lib/active_record/connection_adapters/abstract_adapter.rb:435:in `block in log' 2014-02-06T03:26:57.351167+00:00 app[run.6996]:/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.1/lib/active_record/connection_adapters/abstract_adapter.rb:430:in `log' 2014-02-06T03:26:57.351167+00:00 app[run.6996]:/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.1/lib/active_record/connection_adapters/postgresql/database_statements.rb:127:in `execute' 2014-02-06T03:26:57.351167+00:00 app[run.6996]:/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.1/lib/active_record/connection_adapters/abstract/schema_statements.rb:352:in `drop_table' 2014-02-06T03:26:57.3 51167+00:00 app[run.6996]:/app/vendor/bundle/ruby/2.0.0/gems/activesupport-4.0.1/lib/active_support/notifications/instrumenter.rb:20:in `instrument' 2014-02-06T03:26:57.351515+00:00 app[run.6996]:/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.1/lib/active_record/migration.rb:764:in `up' 2014-02-06T03:26:57.351515+00:00 app[run.6996]:/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.1/lib/active_record/migration.rb:916:in `migrate' 2014-02-06T03:26:57.351983+00:00 app[run.6996]:/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.1/lib/active_record/railties/databases.rake:42:in `block (2 levels) in <top (required)>' 2014-02-06T03:26:57.351983+00:00 app[run.6996]:/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.1/lib/active_record/migration.rb:742:in `migrate' 2014-02-06T03:26:57.351983+00:00 app[run.6996]: Tasks: TOP => db:migrate 2014-02-06T03:26:57.351346+00:00 app[run.6996]:/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.1/lib/active_record/migration.rb:617:in `method_missing' 2014-02-06T03:26:57.351346+00:00 app[run.6996]:/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.1/lib/active_record/migration.rb:571:in `exec_migration' 2014-02-06T03:26:57.351346+00:00 app[run.6996]:/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.1/lib/active_record/migration.rb:555:in `block (2 levels) in migrate' 2014-02-06T03:26:57.351346+00:00 app[run.6996]:/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.1/lib/active_record/migration.rb:554:in `block in migrate' 2014-02-06T03:26:57.351346+00:00 app[run.6996]:/app/db/migrate/20140203112352_drop_table.rb:3:in `change' 2014-02-06T03:26:57.351983+00:00 app[run.6996]: (See full trace by running task with --trace) 2014-02-06T03:26:57.351346+00:00 app[run.6996]:/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.1/lib/active_record/migration.rb:1005:in `block in ddl_transaction' 2014-02-06T03:26:57.351515+00:00 app[run.6996]:/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.1/lib/active_record/migration.rb:920:in `block in migrate' 2014-02-06T03:26:57.351515+00:00 app[run.6996]:/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.1/lib/active_record/connection_adapters/abstract/database_statements.rb:202:in `block in transaction' 2014-02-06T03:26:57.351515+00:00 app[run.6996]:/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.1/lib/active_record/connection_adapters/abstract/database_statements.rb:210:in `within_new_transaction' 2014-02-06T03:26:57.351515+00:00 app[run.6996]:/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.1/lib/active_record/connection_adapters/abstract/database_statements.rb:202:in `transaction' 2014-02-06T03:26:57.351515+00:00 app[run.6996]:/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.1/lib/active_record/transactions.rb:209:in `transaction' 2014-02-06T03:26:57.351515+00:00 app[run.6996]:/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.1/lib/active_record/migration.rb:1005:in `ddl_transaction' 2014-02-06T03:26:57.351515+00:00 app[run.6996]:/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.1/lib/active_record/migration.rb:958:in `execute_migration_in_transaction' 2014-02-06T03:26:57.351515+00:00 app[run.6996]:/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.1/lib/active_record/migration.rb:916:in `each' 2014-02-06T03:26:58.946381+00:00 heroku[run.6996]: Process exited with status 1 2014-02-06T03:27:02.875489+00:00 heroku[web.1]: Starting process with command `bin/rails server -p 46292 -e $RAILS_ENV` 2014-02-06T03:27:04.109493+00:00 heroku[web.1]: Stopping all processes with SIGTERM 2014-02-06T03:26:59.593290+00:00 heroku[web.1]: State changed from up to starting 2014-02-06T03:27:05.210875+00:00 app[web.1]: [2014-02-06 03:27:05] FATAL SignalException: SIGTERM 2014-02-06T03:27:05.210875+00:00 app[web.1]: /app/vendor/ruby-2.0.0/lib/ruby/2.0.0/webrick/server.rb:170:in `select' 2014-02-06T03:27:05.210875+00:00 app[web.1]: /app/vendor/ruby-2.0.0/lib/ruby/2.0.0/webrick/server.rb:170:in `block in start' 2014-02-06T03:27:05.210875+00:00 app[web.1]: /app/vendor/bundle/ruby/2.0.0/gems/rack-1.5.2/lib/rack/handler/webrick.rb:14:in `run' 2014-02-06T03:27:05.210875+00:00 app[web.1]: /app/vendor/bundle/ruby/2.0.0/gems/rack-1.5.2/lib/rack/server.rb:264:in `start' 2014-02-06T03:27:05.210875+00:00 app[web.1]: /app/vendor/ruby-2.0.0/lib/ruby/2.0.0/webrick/server.rb:32:in `star t' 2014-02-06T03:27:05.210875+00:00 app[web.1]: /app/vendor/ruby-2.0.0/lib/ruby/2.0.0/webrick/server.rb:160:in `start' 2014-02-06T03:27:05.210875+00:00 app[web.1]: /app/vendor/bundle/ruby/2.0.0/gems/railties-4.0.1/lib/rails/commands.rb:76:in `block in <top (required)>' 2014-02-06T03:27:05.210875+00:00 app[web.1]: /app/vendor/bundle/ruby/2.0.0/gems/railties-4.0.1/lib/rails/commands.rb:71:in `tap' 2014-02-06T03:27:05.211074+00:00 app[web.1]: /app/vendor/bundle/ruby/2.0.0/gems/railties-4.0.1/lib/rails/commands.rb:71:in `<top (required)>' 2014-02-06T03:27:05.210875+00:00 app[web.1]: /app/vendor/bundle/ruby/2.0.0/gems/railties-4.0.1/lib/rails/commands/server.rb:84:in `start' 2014-02-06T03:27:05.211074+00:00 app[web.1]: [2014-02-06 03:27:05] INFO going to shutdown ... 2014-02-06T03:27:05.211074+00:00 app[web.1]: bin/rails:4:in `require' 2014-02-06T03:27:05.211074+00:00 app[web.1]: bin/rails:4:in `<main>' 2014-02-06T03:27:05.211074+00:00 app[web.1]: => Rails 4.0.1 application starting in production on http://0.0.0.0:40427 2014-02-06T03:27:05.211074+00:00 app[web.1]: => Run `rails server -h` for more startup options 2014-02-06T03:27:05.211074+00:00 app[web.1]: => Ctrl-C to shutdown server 2014-02-06T03:27:05.211074+00:00 app[web.1]: Exiting 2014-02-06T03:27:05.211074+00:00 app[web.1]: [2014-02-06 03:27:05] INFO WEBrick::HTTPServer#start done. 2014-02-06T03:27:05.211074+00:00 app[web.1]: => Booting WEBrick 2014-02-06T03:27:06.651226+00:00 heroku[web.1]: Process exited with status 143 2014-02-06T03:27:07.360529+00:00 app[web.1]: [2014-02-06 03:27:07] INFO WEBrick::HTTPServer#start: pid=2 port=46292 2014-02-06T03:27:07.360373+00:00 app[web.1]: [2014-02-06 03:27:07] INFO WEBrick 1.3.1 2014-02-06T03:27:07.360373+00:00 app[web.1]: [2014-02-06 03:27:07] INFO ruby 2.0.0 (2013-11-22) [x86_64-linux] 2014-02-06T03:27:07.791236+00:00 heroku[web.1]: State changed from starting to up -- -- You received this message because you are subscribed to the Google Groups "Heroku" group. To unsubscribe from this group, send email to heroku+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/heroku?hl=en_US?hl=en --- You received this message because you are subscribed to the Google Groups "Heroku Community" group. To unsubscribe from this group and stop receiving emails from it, send an email to heroku+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
