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.
