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

[Ivan Necas]

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 at 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 <top
> (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 `<top (required)>'
> /bin/rake:23:in `load'
> /bin/rake:23:in `<main>'
> 
> ______________________________ _________________
> katello-devel mailing list
> katello-devel at redhat.com
> https://www.redhat.com/ mailman/listinfo/katello-devel
> 
> 
> _______________________________________________
> katello-devel mailing list
> katello-devel at redhat.com
> https://www.redhat.com/mailman/listinfo/katello-devel