Project

General

Profile

Bug #9171

Can't migrate clean database if foreman_tasks present

Added by Eric Helms over 7 years ago. Updated over 7 years ago.

Status:
Closed
Priority:
Normal
Assignee:
-
Category:
-
Target version:
-
Difficulty:
Triaged:
No
Bugzilla link:
Fixed in Releases:
Found in Releases:

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>'
}}}


Related issues

Has duplicate Katello - Bug #9172: katello-installer failed with /Stage[main]/Foreman_proxy::Register/Foreman_smartproxy[FQDN]: Could not evaluate: Could not load data from https://FQDN Duplicate2015-01-30

Associated revisions

Revision 092e9733 (diff)
Added by Eric Helms over 7 years ago

Fixes #9171: Move anonymous role setup to seeds.

Revision 30bd2b2e (diff)
Added by Ivan Necas over 7 years ago

Refs #9171: fix seeds tests

History

#1 Updated by The Foreman Bot over 7 years ago

  • Status changed from New to Ready For Testing
  • Pull request https://github.com/theforeman/foreman-tasks/pull/97 added
  • Pull request deleted ()

#2 Updated by Eric Helms over 7 years ago

  • Status changed from Ready For Testing to Closed
  • % Done changed from 0 to 100

#3 Updated by Eric Helms over 7 years ago

  • Has duplicate Bug #9172: katello-installer failed with /Stage[main]/Foreman_proxy::Register/Foreman_smartproxy[FQDN]: Could not evaluate: Could not load data from https://FQDN added

Also available in: Atom PDF