You ran `heroku run rake db:migrate`?
On Wed, Feb 5, 2014 at 7:42 PM, Samuel Sosina <[email protected]> wrote: > 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. > -- -- 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.
