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.
