Bug #9171
closedCan't migrate clean database if foreman_tasks present
Description
An example case is when Foreman and Katello are installed, database created, and migrated the following output appears:
{{{
INE 5: WHERE a.attrelid = '"permissions"'::regclass
16:55:40 ^
16:55:40 : SELECT a.attname, format_type(a.atttypid, a.atttypmod),
16:55:40 pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod
16:55:40 FROM pg_attribute a LEFT JOIN pg_attrdef d
16:55:40 ON a.attrelid = d.adrelid AND a.attnum = d.adnum
16:55:40 WHERE a.attrelid = '"permissions"'::regclass
16:55:40 AND a.attnum > 0 AND NOT a.attisdropped
16:55:40 ORDER BY a.attnum
16:55:40 /usr/local/rvm/gems/ruby-1.9.3-p392@test_katello_core-0/gems/activerecord-3.2.21/lib/active_record/connection_adapters/postgresql_adapter.rb:1163:in `async_exec'
16:55:40 /usr/local/rvm/gems/ruby-1.9.3-p392@test_katello_core-0/gems/activerecord-3.2.21/lib/active_record/connection_adapters/postgresql_adapter.rb:1163:in `exec_no_cache'
16:55:40 /usr/local/rvm/gems/ruby-1.9.3-p392@test_katello_core-0/gems/activerecord-3.2.21/lib/active_record/connection_adapters/postgresql_adapter.rb:660:in `block in exec_query'
16:55:40 /usr/local/rvm/gems/ruby-1.9.3-p392@test_katello_core-0/gems/activerecord-3.2.21/lib/active_record/connection_adapters/abstract_adapter.rb:280:in `block in log'
16:55:40 /usr/local/rvm/gems/ruby-1.9.3-p392@test_katello_core-0/gems/activesupport-3.2.21/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
16:55:40 /usr/local/rvm/gems/ruby-1.9.3-p392@test_katello_core-0/gems/activerecord-3.2.21/lib/active_record/connection_adapters/abstract_adapter.rb:275:in `log'
16:55:40 /usr/local/rvm/gems/ruby-1.9.3-p392@test_katello_core-0/gems/activerecord-3.2.21/lib/active_record/connection_adapters/postgresql_adapter.rb:659:in `exec_query'
16:55:40 /usr/local/rvm/gems/ruby-1.9.3-p392@test_katello_core-0/gems/activerecord-3.2.21/lib/active_record/connection_adapters/postgresql_adapter.rb:1292:in `column_definitions'
16:55:40 /usr/local/rvm/gems/ruby-1.9.3-p392@test_katello_core-0/gems/activerecord-3.2.21/lib/active_record/connection_adapters/postgresql_adapter.rb:855:in `columns'
16:55:40 /usr/local/rvm/gems/ruby-1.9.3-p392@test_katello_core-0/gems/activerecord-3.2.21/lib/active_record/connection_adapters/schema_cache.rb:12:in `block in initialize'
16:55:40 /usr/local/rvm/gems/ruby-1.9.3-p392@test_katello_core-0/gems/activerecord-3.2.21/lib/active_record/model_schema.rb:229:in `yield'
16:55:40 /usr/local/rvm/gems/ruby-1.9.3-p392@test_katello_core-0/gems/activerecord-3.2.21/lib/active_record/model_schema.rb:229:in `default'
16:55:40 /usr/local/rvm/gems/ruby-1.9.3-p392@test_katello_core-0/gems/activerecord-3.2.21/lib/active_record/model_schema.rb:229:in `columns'
16:55:40 /usr/local/rvm/gems/ruby-1.9.3-p392@test_katello_core-0/gems/activerecord-3.2.21/lib/active_record/model_schema.rb:238:in `columns_hash'
16:55:40 /usr/local/rvm/gems/ruby-1.9.3-p392@test_katello_core-0/gems/activerecord-3.2.21/lib/active_record/locking/optimistic.rb:131:in `locking_enabled?'
16:55:40 /usr/local/rvm/gems/ruby-1.9.3-p392@test_katello_core-0/gems/activerecord-3.2.21/lib/active_record/relation.rb:170:in `exec_queries'
16:55:40 /usr/local/rvm/gems/ruby-1.9.3-p392@test_katello_core-0/gems/activerecord-3.2.21/lib/active_record/relation.rb:160:in `block in to_a'
16:55:40 /usr/local/rvm/gems/ruby-1.9.3-p392@test_katello_core-0/gems/activerecord-3.2.21/lib/active_record/explain.rb:34:in `logging_query_plan'
16:55:40 /usr/local/rvm/gems/ruby-1.9.3-p392@test_katello_core-0/gems/activerecord-3.2.21/lib/active_record/relation.rb:159:in `to_a'
16:55:40 /usr/local/rvm/gems/ruby-1.9.3-p392@test_katello_core-0/gems/activerecord-3.2.21/lib/active_record/relation/finder_methods.rb:381:in `find_first'
16:55:40 /usr/local/rvm/gems/ruby-1.9.3-p392@test_katello_core-0/gems/activerecord-3.2.21/lib/active_record/relation/finder_methods.rb:122:in `first'
16:55:40 /usr/local/rvm/gems/ruby-1.9.3-p392@test_katello_core-0/gems/foreman-tasks-0.6.11/lib/foreman_tasks/engine.rb:24:in `block (2 levels) in <class:Engine>'
16:55:40 /var/lib/workspace/workspace/test_katello_core/database/postgresql/ruby/1.9.3/foreman/app/services/foreman/plugin.rb:64:in `instance_eval'
16:55:40 /var/lib/workspace/workspace/test_katello_core/database/postgresql/ruby/1.9.3/foreman/app/services/foreman/plugin.rb:64:in `register'
16:55:40 /usr/local/rvm/gems/ruby-1.9.3-p392@test_katello_core-0/gems/foreman-tasks-0.6.11/lib/foreman_tasks/engine.rb:10:in `block in <class:Engine>'
}}}