Posted by roderyk on Fri 12th Aug 19:30 (modification of post by view diff)
download | new post

rake db:rollback --trace
** Invoke db:rollback (first_time)
** Invoke environment (first_time)
** Execute environment
** Invoke db:load_config (first_time)
** Invoke rails_env (first_time)
** Execute rails_env
** Execute db:load_config
** Execute db:rollback
==  CreateAddresses: reverting ================================================
-- drop_table("addresses")
rake aborted!
An error has occurred, this and all later migrations canceled:

PGError: ERROR:  current transaction is aborted, commands ignored until end of transaction block
:           SELECT tablename
          FROM pg_tables
          WHERE schemaname = ANY (current_schemas(false))
/Users/norbert/.rvm/gems/ruby-1.9.2-p290@wallstickers/gems/activerecord-3.1.0.rc5/lib/active_record/connection_adapters/postgresql_adapter.rb:529:in `async_exec'
/Users/norbert/.rvm/gems/ruby-1.9.2-p290@wallstickers/gems/activerecord-3.1.0.rc5/lib/active_record/connection_adapters/postgresql_adapter.rb:529:in `block in query'
/Users/norbert/.rvm/gems/ruby-1.9.2-p290@wallstickers/gems/activerecord-3.1.0.rc5/lib/active_record/connection_adapters/abstract_adapter.rb:222:in `block in log'
/Users/norbert/.rvm/gems/ruby-1.9.2-p290@wallstickers/gems/activesupport-3.1.0.rc5/lib/active_support/notifications/instrumenter.rb:21:in `instrument'
/Users/norbert/.rvm/gems/ruby-1.9.2-p290@wallstickers/gems/activerecord-3.1.0.rc5/lib/active_record/connection_adapters/abstract_adapter.rb:217:in `log'
/Users/norbert/.rvm/gems/ruby-1.9.2-p290@wallstickers/gems/activerecord-3.1.0.rc5/lib/active_record/connection_adapters/postgresql_adapter.rb:528:in `query'
/Users/norbert/.rvm/gems/ruby-1.9.2-p290@wallstickers/gems/activerecord-3.1.0.rc5/lib/active_record/connection_adapters/postgresql_adapter.rb:662:in `tables'
/Users/norbert/.rvm/gems/ruby-1.9.2-p290@wallstickers/gems/activerecord-3.1.0.rc5/lib/active_record/connection_adapters/postgresql_adapter.rb:456:in `ensure in disable_referential_integrity'
/Users/norbert/.rvm/gems/ruby-1.9.2-p290@wallstickers/gems/activerecord-3.1.0.rc5/lib/active_record/connection_adapters/postgresql_adapter.rb:456:in `disable_referential_integrity'
/Users/norbert/.rvm/gems/ruby-1.9.2-p290@wallstickers/gems/foreigner-1.1.1/lib/foreigner/connection_adapters/sql2003.rb:9:in `drop_table'
/Users/norbert/.rvm/gems/ruby-1.9.2-p290@wallstickers/gems/activerecord-3.1.0.rc5/lib/active_record/migration.rb:443:in `block in method_missing'
/Users/norbert/.rvm/gems/ruby-1.9.2-p290@wallstickers/gems/activerecord-3.1.0.rc5/lib/active_record/migration.rb:418:in `block in say_with_time'
/Users/norbert/.rvm/rubies/ruby-1.9.2-p290/lib/ruby/1.9.1/benchmark.rb:295:in `measure'
/Users/norbert/.rvm/gems/ruby-1.9.2-p290@wallstickers/gems/activerecord-3.1.0.rc5/lib/active_record/migration.rb:418:in `say_with_time'
/Users/norbert/.rvm/gems/ruby-1.9.2-p290@wallstickers/gems/activerecord-3.1.0.rc5/lib/active_record/migration.rb:438:in `method_missing'
/Users/norbert/.rvm/gems/ruby-1.9.2-p290@wallstickers/gems/activerecord-3.1.0.rc5/lib/active_record/migration.rb:383:in `block (3 levels) in migrate'
/Users/norbert/.rvm/gems/ruby-1.9.2-p290@wallstickers/gems/activerecord-3.1.0.rc5/lib/active_record/migration.rb:382:in `each'
/Users/norbert/.rvm/gems/ruby-1.9.2-p290@wallstickers/gems/activerecord-3.1.0.rc5/lib/active_record/migration.rb:382:in `block (2 levels) in migrate'
/Users/norbert/.rvm/rubies/ruby-1.9.2-p290/lib/ruby/1.9.1/benchmark.rb:295:in `measure'
/Users/norbert/.rvm/gems/ruby-1.9.2-p290@wallstickers/gems/activerecord-3.1.0.rc5/lib/active_record/migration.rb:381:in `block in migrate'
/Users/norbert/.rvm/gems/ruby-1.9.2-p290@wallstickers/gems/activerecord-3.1.0.rc5/lib/active_record/connection_adapters/abstract/connection_pool.rb:184:in `with_connection'
/Users/norbert/.rvm/gems/ruby-1.9.2-p290@wallstickers/gems/activerecord-3.1.0.rc5/lib/active_record/migration.rb:371:in `migrate'
/Users/norbert/.rvm/gems/ruby-1.9.2-p290@wallstickers/gems/activerecord-3.1.0.rc5/lib/active_record/migration.rb:499:in `migrate'
/Users/norbert/.rvm/gems/ruby-1.9.2-p290@wallstickers/gems/activerecord-3.1.0.rc5/lib/active_record/migration.rb:683:in `block (2 levels) in migrate'
/Users/norbert/.rvm/gems/ruby-1.9.2-p290@wallstickers/gems/activerecord-3.1.0.rc5/lib/active_record/migration.rb:738:in `call'
/Users/norbert/.rvm/gems/ruby-1.9.2-p290@wallstickers/gems/activerecord-3.1.0.rc5/lib/active_record/migration.rb:738:in `block in ddl_transaction'
/Users/norbert/.rvm/gems/ruby-1.9.2-p290@wallstickers/gems/activerecord-3.1.0.rc5/lib/active_record/connection_adapters/abstract/database_statements.rb:183:in `transaction'
/Users/norbert/.rvm/gems/ruby-1.9.2-p290@wallstickers/gems/activerecord-3.1.0.rc5/lib/active_record/transactions.rb:208:in `transaction'
/Users/norbert/.rvm/gems/ruby-1.9.2-p290@wallstickers/gems/activerecord-3.1.0.rc5/lib/active_record/migration.rb:738:in `ddl_transaction'
/Users/norbert/.rvm/gems/ruby-1.9.2-p290@wallstickers/gems/activerecord-3.1.0.rc5/lib/active_record/migration.rb:682:in `block in migrate'
/Users/norbert/.rvm/gems/ruby-1.9.2-p290@wallstickers/gems/activerecord-3.1.0.rc5/lib/active_record/migration.rb:667:in `each'
/Users/norbert/.rvm/gems/ruby-1.9.2-p290@wallstickers/gems/activerecord-3.1.0.rc5/lib/active_record/migration.rb:667:in `migrate'
/Users/norbert/.rvm/gems/ruby-1.9.2-p290@wallstickers/gems/activerecord-3.1.0.rc5/lib/active_record/migration.rb:549:in `down'
/Users/norbert/.rvm/gems/ruby-1.9.2-p290@wallstickers/gems/activerecord-3.1.0.rc5/lib/active_record/migration.rb:623:in `move'
/Users/norbert/.rvm/gems/ruby-1.9.2-p290@wallstickers/gems/activerecord-3.1.0.rc5/lib/active_record/migration.rb:537:in `rollback'
/Users/norbert/.rvm/gems/ruby-1.9.2-p290@wallstickers/gems/activerecord-3.1.0.rc5/lib/active_record/railties/databases.rake:230:in `block (2 levels) in <top (required)>'
/Users/norbert/.rvm/gems/ruby-1.9.2-p290@global/gems/rake-0.9.2/lib/rake/task.rb:205:in `call'
/Users/norbert/.rvm/gems/ruby-1.9.2-p290@global/gems/rake-0.9.2/lib/rake/task.rb:205:in `block in execute'
/Users/norbert/.rvm/gems/ruby-1.9.2-p290@global/gems/rake-0.9.2/lib/rake/task.rb:200:in `each'
/Users/norbert/.rvm/gems/ruby-1.9.2-p290@global/gems/rake-0.9.2/lib/rake/task.rb:200:in `execute'
/Users/norbert/.rvm/gems/ruby-1.9.2-p290@global/gems/rake-0.9.2/lib/rake/task.rb:158:in `block in invoke_with_call_chain'
/Users/norbert/.rvm/rubies/ruby-1.9.2-p290/lib/ruby/1.9.1/monitor.rb:201:in `mon_synchronize'
/Users/norbert/.rvm/gems/ruby-1.9.2-p290@global/gems/rake-0.9.2/lib/rake/task.rb:151:in `invoke_with_call_chain'
/Users/norbert/.rvm/gems/ruby-1.9.2-p290@global/gems/rake-0.9.2/lib/rake/task.rb:144:in `invoke'
/Users/norbert/.rvm/gems/ruby-1.9.2-p290@global/gems/rake-0.9.2/lib/rake/application.rb:112:in `invoke_task'
/Users/norbert/.rvm/gems/ruby-1.9.2-p290@global/gems/rake-0.9.2/lib/rake/application.rb:90:in `block (2 levels) in top_level'
/Users/norbert/.rvm/gems/ruby-1.9.2-p290@global/gems/rake-0.9.2/lib/rake/application.rb:90:in `each'
/Users/norbert/.rvm/gems/ruby-1.9.2-p290@global/gems/rake-0.9.2/lib/rake/application.rb:90:in `block in top_level'
/Users/norbert/.rvm/gems/ruby-1.9.2-p290@global/gems/rake-0.9.2/lib/rake/application.rb:129:in `standard_exception_handling'
/Users/norbert/.rvm/gems/ruby-1.9.2-p290@global/gems/rake-0.9.2/lib/rake/application.rb:84:in `top_level'
/Users/norbert/.rvm/gems/ruby-1.9.2-p290@global/gems/rake-0.9.2/lib/rake/application.rb:62:in `block in run'
/Users/norbert/.rvm/gems/ruby-1.9.2-p290@global/gems/rake-0.9.2/lib/rake/application.rb:129:in `standard_exception_handling'
/Users/norbert/.rvm/gems/ruby-1.9.2-p290@global/gems/rake-0.9.2/lib/rake/application.rb:59:in `run'
/Users/norbert/.rvm/gems/ruby-1.9.2-p290@global/gems/rake-0.9.2/bin/rake:32:in `<top (required)>'
/Users/norbert/.rvm/gems/ruby-1.9.2-p290@global/bin/rake:19:in `load'
/Users/norbert/.rvm/gems/ruby-1.9.2-p290@global/bin/rake:19:in `<main>'
Tasks: TOP => db:rollback


The migration in question:

class CreateAddresses < ActiveRecord::Migration
  def change
    create_table :addresses do |t|
      t.string :street_line,  :null => false
      t.string :street_line2
      t.string :city,         :null => false
      t.string :zipcode,      :null => false

      t.timestamps
    end
  end
end

Note that "rake db:migrate" works fine; but "rake db:migrate:redo" and "rake db:rollback" fail.