[katello-devel] Katello install on f18 - PG error

Fyi I've hit the same issue in RHEL as well.

– Ivan

··· ----- Original Message ----- > FYI - The F18 installs are still in flux. That being said, my testing over > the weekend didn't hit this particular error (I was hitting other oddities > with katello-configure itself). > > > On Mon, Apr 8, 2013 at 8:44 AM, Garik Khachikyan < gkhachik@redhat.com > > wrote: > > > hi all, > > Not sure if anyone else experiencing the following on foreman DB migration? > > It happens recently on my try making install on F18. > > thanks > Garik > > --- > == AddSparcInfoToModel: migrating ============================== > ============== > -- add_column(:models, :vendor_class, :string, {:limit=>32}) > -> 0.0007s > -- add_column(:models, :hardware_model, :string, {:limit=>16})NOTICE: CREATE > TABLE will create implicit sequence "settings_id_seq" for serial column " > settings.id " > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "settings_pkey" > for table "settings" > NOTICE: ALTER TABLE will create implicit sequence "host_classes_id_seq" for > serial column " host_classes.id " > NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index > "host_classes_pkey" for table "host_classes" > 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 DISTINCT(attr.attname) > FROM pg_attribute attr > INNER JOIN pg_depend dep ON attr.attrelid = dep.refobjid AND attr.attnum = > dep.refobjsubid > INNER JOIN pg_constraint cons ON attr.attrelid = cons.conrelid AND > attr.attnum = cons.conkey[1] > WHERE cons.contype = 'p' > AND dep.refobjid = $1::regclass > /usr/share/gems/gems/ activerecord-3.2.8/lib/active_ > record/connection_adapters/ postgresql_adapter.rb:1171:in `get_last_result' > /usr/share/gems/gems/ activerecord-3.2.8/lib/active_ > record/connection_adapters/ postgresql_adapter.rb:1171:in `exec_cache' > /usr/share/gems/gems/ activerecord-3.2.8/lib/active_ > record/connection_adapters/ postgresql_adapter.rb:665:in `block in > exec_query' > /usr/share/gems/gems/ activerecord-3.2.8/lib/active_ > record/connection_adapters/ abstract_adapter.rb:280:in `block in log' > /usr/share/gems/gems/ activesupport-3.2.8/lib/ active_support/notifications/ > instrumenter.rb:20:in `instrument' > /usr/share/gems/gems/ activerecord-3.2.8/lib/active_ > record/connection_adapters/ abstract_adapter.rb:275:in `log' > /usr/share/gems/gems/ activerecord-3.2.8/lib/active_ > record/connection_adapters/ postgresql_adapter.rb:663:in `exec_query' > /usr/share/gems/gems/ activerecord-3.2.8/lib/active_ > record/connection_adapters/ postgresql_adapter.rb:995:in `primary_key' > /usr/share/gems/gems/ activerecord-3.2.8/lib/active_ > record/connection_adapters/ postgresql_adapter.rb:688:in `sql_for_insert' > /usr/share/gems/gems/ activerecord-3.2.8/lib/active_ > record/connection_adapters/ abstract/database_statements. rb:89:in `insert' > /usr/share/gems/gems/ activerecord-3.2.8/lib/active_ > record/connection_adapters/ abstract/query_cache.rb:14:in `insert' > /usr/share/gems/gems/ activerecord-3.2.8/lib/active_ > record/migration.rb:760:in `record_version_state_after_ migrating' > /usr/share/gems/gems/ activerecord-3.2.8/lib/active_ > record/migration.rb:721:in `block (2 levels) in migrate' > /usr/share/gems/gems/ activerecord-3.2.8/lib/active_ > record/migration.rb:775:in `call' > /usr/share/gems/gems/ activerecord-3.2.8/lib/active_ > record/migration.rb:775:in `block in ddl_transaction' > /usr/share/gems/gems/ activerecord-3.2.8/lib/active_ > record/connection_adapters/ abstract/database_statements. rb:192:in > `transaction' > /usr/share/gems/gems/ activerecord-3.2.8/lib/active_ > record/transactions.rb:208:in `transaction' > /usr/share/gems/gems/ activerecord-3.2.8/lib/active_ > record/migration.rb:775:in `ddl_transaction' > /usr/share/gems/gems/ activerecord-3.2.8/lib/active_ > record/migration.rb:719:in `block in migrate' > /usr/share/gems/gems/ activerecord-3.2.8/lib/active_ > record/migration.rb:700:in `each' > /usr/share/gems/gems/ activerecord-3.2.8/lib/active_ > record/migration.rb:700:in `migrate' > /usr/share/gems/gems/ activerecord-3.2.8/lib/active_ > record/migration.rb:570:in `up' > /usr/share/gems/gems/ activerecord-3.2.8/lib/active_ > record/migration.rb:551:in `migrate' > /usr/share/gems/gems/ activerecord-3.2.8/lib/active_ > record/railties/databases. rake:153:in `block (2 levels) in (required)>' > /usr/share/gems/gems/rake-0.9. 6/lib/rake/task.rb:228:in `call' > /usr/share/gems/gems/rake-0.9. 6/lib/rake/task.rb:228:in `block in execute' > /usr/share/gems/gems/rake-0.9. 6/lib/rake/task.rb:223:in `each' > /usr/share/gems/gems/rake-0.9. 6/lib/rake/task.rb:223:in `execute' > /usr/share/gems/gems/rake-0.9. 6/lib/rake/task.rb:166:in `block in > invoke_with_call_chain' > /usr/share/ruby/monitor.rb: 211:in `mon_synchronize' > /usr/share/gems/gems/rake-0.9. 6/lib/rake/task.rb:159:in > `invoke_with_call_chain' > /usr/share/gems/gems/rake-0.9. 6/lib/rake/task.rb:152:in `invoke' > /usr/share/gems/gems/rake-0.9. 6/lib/rake/application.rb:143: in > `invoke_task' > /usr/share/gems/gems/rake-0.9. 6/lib/rake/application.rb:101: in `block (2 > levels) in top_level' > /usr/share/gems/gems/rake-0.9. 6/lib/rake/application.rb:101: in `each' > /usr/share/gems/gems/rake-0.9. 6/lib/rake/application.rb:101: in `block in > top_level' > /usr/share/gems/gems/rake-0.9. 6/lib/rake/application.rb:110: in > `run_with_threads' > /usr/share/gems/gems/rake-0.9. 6/lib/rake/application.rb:95: in `top_level' > /usr/share/gems/gems/rake-0.9. 6/lib/rake/application.rb:73: in `block in > run' > /usr/share/gems/gems/rake-0.9. 6/lib/rake/application.rb:160: in > `standard_exception_handling' > /usr/share/gems/gems/rake-0.9. 6/lib/rake/application.rb:70: in `run' > /usr/share/gems/gems/rake-0.9. 6/bin/rake:37:in `' > /bin/rake:23:in `load' > /bin/rake:23:in `' > > ______________________________ _________________ > katello-devel mailing list > katello-devel@redhat.com > https://www.redhat.com/ mailman/listinfo/katello-devel > > > _______________________________________________ > katello-devel mailing list > katello-devel@redhat.com > https://www.redhat.com/mailman/listinfo/katello-devel