Yeah it sounds like your migrations don't apply cleanly from scratch. You could track down the errant one, or `heroku run rake db:schema:load` might bypass the problem.
On Wed, Feb 5, 2014 at 7:56 PM, Robert Fletcher <[email protected]>wrote: > 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 <[email protected]> wrote: > >> Yes sir. >> >> >> On Thu, Feb 6, 2014 at 3:51 AM, Robert Fletcher >> <[email protected]>wrote: >> >>> 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 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 >>> [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. >> > > -- > -- > 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.
