Oh, looks like you're trying to drop a table that doesn't exist. Do you have a migration that does this? Could be you made a migration in dev to add the table, then made another migration to remove it, but never ran the first one in production. Hard to know without looking at the code, but maybe you just want to remove that migration.
On Wed, Feb 5, 2014 at 7:54 PM, Samuel Sosina <samsos...@gmail.com> wrote: > Yes sir. > > > On Thu, Feb 6, 2014 at 3:51 AM, Robert Fletcher <lobatifri...@gmail.com>wrote: > >> You ran `heroku run rake db:migrate`? >> >> >> On Wed, Feb 5, 2014 at 7:42 PM, Samuel Sosina <samsos...@gmail.com>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 >>> 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. >>> >> >> -- >> -- >> 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 a topic in the >> Google Groups "Heroku Community" group. >> To unsubscribe from this topic, visit >> https://groups.google.com/d/topic/heroku/q9uTupapGzs/unsubscribe. >> To unsubscribe from this group and all its topics, send an email to >> heroku+unsubscr...@googlegroups.com. >> >> 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 > 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. > -- -- 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.
