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 [email protected] 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 [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
