Project

General

Profile

Actions
Copy link

Bug #15679

closed

"some interfaces are invalid" during host status db:migrate

Added by Anthony De La Rosa almost 8 years ago. Updated almost 8 years ago.

Status:
Duplicate
Priority:
Normal
Assignee:
-
Category:
DB migrations
Target version:
-
Difficulty:
Triaged:
Bugzilla link:
Pull request:
Fixed in Releases:
Found in Releases:
Red Hat JIRA:

Description

Hello,

I followed the https://theforeman.org/manuals/1.12/index.html#3.6Upgrade instructions but I am having a bit of an issue.
OS: Ubuntu 14.04

The issue is in Step 3 - Post-upgrade steps

It tells me I have to run these commands to confirm there are no errors:

$ foreman-rake db:migrate
$ foreman-rake db:seed

However I get these errors and I am not sure what to do:

  • Invoke db:migrate (first_time)
  • Invoke environment (first_time)
  • Execute environment
  • Invoke db:load_config (first_time)
  • Execute db:load_config
  • Execute db:migrate
    20150612135546 CreateHostStatus: migrating ===============================
    -- create_table(:host_status)
    > 0.0056s
    -     add_index(:host_status, :host_id)
    > 0.0037s
    -     add_foreign_key("host_status", "hosts", {:name=>"host_status_hosts_host_id_fk", :column=>"host_id"})
    > 0.0022s
    -     add_column(:hosts, :global_status, :integer, {:default=>0, :null=>false})
    -> 0.1935s
    rake aborted!
    StandardError: An error has occurred, this and all later migrations canceled:

Validation failed: Interfaces some interfaces are invalid
/usr/share/foreman/vendor/ruby/2.0.0/gems/activerecord-4.2.6/lib/active_record/validations.rb:79:in `raise_record_invalid'
/usr/share/foreman/vendor/ruby/2.0.0/gems/activerecord-4.2.6/lib/active_record/validations.rb:43:in `save!'
/usr/share/foreman/vendor/ruby/2.0.0/gems/activerecord-4.2.6/lib/active_record/attribute_methods/dirty.rb:29:in `save!'
/usr/share/foreman/vendor/ruby/2.0.0/gems/activerecord-4.2.6/lib/active_record/transactions.rb:291:in `block in save!'
/usr/share/foreman/vendor/ruby/2.0.0/gems/activerecord-4.2.6/lib/active_record/transactions.rb:351:in `block in with_transaction_returning_status'
/usr/share/foreman/vendor/ruby/2.0.0/gems/activerecord-4.2.6/lib/active_record/connection_adapters/abstract/database_statements.rb:211:in `transaction'
/usr/share/foreman/vendor/ruby/2.0.0/gems/activerecord-4.2.6/lib/active_record/transactions.rb:220:in `transaction'
/usr/share/foreman/vendor/ruby/2.0.0/gems/activerecord-4.2.6/lib/active_record/transactions.rb:348:in `with_transaction_returning_status'
/usr/share/foreman/vendor/ruby/2.0.0/gems/activerecord-4.2.6/lib/active_record/transactions.rb:291:in `save!'
/usr/share/foreman/app/models/host/managed.rb:850:in `refresh_global_status!'
/usr/share/foreman/app/models/host/managed.rb:859:in `refresh_statuses'
/usr/share/foreman/db/migrate/20150612135546_create_host_status.rb:14:in `block in up'
/usr/share/foreman/vendor/ruby/2.0.0/gems/activerecord-4.2.6/lib/active_record/relation/batches.rb:51:in `block (2 levels) in find_each'
/usr/share/foreman/vendor/ruby/2.0.0/gems/activerecord-4.2.6/lib/active_record/relation/batches.rb:51:in `each'
/usr/share/foreman/vendor/ruby/2.0.0/gems/activerecord-4.2.6/lib/active_record/relation/batches.rb:51:in `block in find_each'
/usr/share/foreman/vendor/ruby/2.0.0/gems/activerecord-4.2.6/lib/active_record/relation/batches.rb:124:in `find_in_batches'
/usr/share/foreman/vendor/ruby/2.0.0/gems/activerecord-4.2.6/lib/active_record/relation/batches.rb:50:in `find_each'
/usr/share/foreman/db/migrate/20150612135546_create_host_status.rb:13:in `up'
/usr/share/foreman/vendor/ruby/2.0.0/gems/activerecord-4.2.6/lib/active_record/migration.rb:611:in `exec_migration'
/usr/share/foreman/vendor/ruby/2.0.0/gems/activerecord-4.2.6/lib/active_record/migration.rb:592:in `block (2 levels) in migrate'
/usr/lib/ruby/2.0.0/benchmark.rb:281:in `measure'
/usr/share/foreman/vendor/ruby/2.0.0/gems/activerecord-4.2.6/lib/active_record/migration.rb:591:in `block in migrate'
/usr/share/foreman/vendor/ruby/2.0.0/gems/activerecord-4.2.6/lib/active_record/connection_adapters/abstract/connection_pool.rb:292:in `with_connection'
/usr/share/foreman/vendor/ruby/2.0.0/gems/activerecord-4.2.6/lib/active_record/migration.rb:590:in `migrate'
/usr/share/foreman/vendor/ruby/2.0.0/gems/activerecord-4.2.6/lib/active_record/migration.rb:768:in `migrate'
/usr/share/foreman/vendor/ruby/2.0.0/gems/activerecord-4.2.6/lib/active_record/migration.rb:998:in `block in execute_migration_in_transaction'
/usr/share/foreman/vendor/ruby/2.0.0/gems/activerecord-4.2.6/lib/active_record/migration.rb:1044:in `block in ddl_transaction'
/usr/share/foreman/vendor/ruby/2.0.0/gems/activerecord-4.2.6/lib/active_record/connection_adapters/abstract/database_statements.rb:213:in `block in transaction'
/usr/share/foreman/vendor/ruby/2.0.0/gems/activerecord-4.2.6/lib/active_record/connection_adapters/abstract/transaction.rb:184:in `within_new_transaction'
/usr/share/foreman/vendor/ruby/2.0.0/gems/activerecord-4.2.6/lib/active_record/connection_adapters/abstract/database_statements.rb:213:in `transaction'
/usr/share/foreman/vendor/ruby/2.0.0/gems/activerecord-4.2.6/lib/active_record/transactions.rb:220:in `transaction'
/usr/share/foreman/vendor/ruby/2.0.0/gems/activerecord-4.2.6/lib/active_record/migration.rb:1044:in `ddl_transaction'
/usr/share/foreman/vendor/ruby/2.0.0/gems/activerecord-4.2.6/lib/active_record/migration.rb:997:in `execute_migration_in_transaction'
/usr/share/foreman/vendor/ruby/2.0.0/gems/activerecord-4.2.6/lib/active_record/migration.rb:959:in `block in migrate'
/usr/share/foreman/vendor/ruby/2.0.0/gems/activerecord-4.2.6/lib/active_record/migration.rb:955:in `each'
/usr/share/foreman/vendor/ruby/2.0.0/gems/activerecord-4.2.6/lib/active_record/migration.rb:955:in `migrate'
/usr/share/foreman/vendor/ruby/2.0.0/gems/activerecord-4.2.6/lib/active_record/migration.rb:823:in `up'
/usr/share/foreman/vendor/ruby/2.0.0/gems/activerecord-4.2.6/lib/active_record/migration.rb:801:in `migrate'
/usr/share/foreman/vendor/ruby/2.0.0/gems/activerecord-4.2.6/lib/active_record/tasks/database_tasks.rb:137:in `migrate'
/usr/share/foreman/vendor/ruby/2.0.0/gems/activerecord-4.2.6/lib/active_record/railties/databases.rake:44:in `block (2 levels) in <top (required)>'
/usr/share/foreman/vendor/ruby/2.0.0/gems/rake-11.2.2/lib/rake/task.rb:248:in `call'
/usr/share/foreman/vendor/ruby/2.0.0/gems/rake-11.2.2/lib/rake/task.rb:248:in `block in execute'
/usr/share/foreman/vendor/ruby/2.0.0/gems/rake-11.2.2/lib/rake/task.rb:243:in `each'
/usr/share/foreman/vendor/ruby/2.0.0/gems/rake-11.2.2/lib/rake/task.rb:243:in `execute'
/usr/share/foreman/vendor/ruby/2.0.0/gems/rake-11.2.2/lib/rake/task.rb:187:in `block in invoke_with_call_chain'
/usr/lib/ruby/2.0.0/monitor.rb:211:in `mon_synchronize'
/usr/share/foreman/vendor/ruby/2.0.0/gems/rake-11.2.2/lib/rake/task.rb:180:in `invoke_with_call_chain'
/usr/share/foreman/vendor/ruby/2.0.0/gems/rake-11.2.2/lib/rake/task.rb:173:in `invoke'
/usr/share/foreman/vendor/ruby/2.0.0/gems/rake-11.2.2/lib/rake/application.rb:152:in `invoke_task'
/usr/share/foreman/vendor/ruby/2.0.0/gems/rake-11.2.2/lib/rake/application.rb:108:in `block (2 levels) in top_level'
/usr/share/foreman/vendor/ruby/2.0.0/gems/rake-11.2.2/lib/rake/application.rb:108:in `each'
/usr/share/foreman/vendor/ruby/2.0.0/gems/rake-11.2.2/lib/rake/application.rb:108:in `block in top_level'
/usr/share/foreman/vendor/ruby/2.0.0/gems/rake-11.2.2/lib/rake/application.rb:117:in `run_with_threads'
/usr/share/foreman/vendor/ruby/2.0.0/gems/rake-11.2.2/lib/rake/application.rb:102:in `top_level'
/usr/share/foreman/vendor/ruby/2.0.0/gems/rake-11.2.2/lib/rake/application.rb:80:in `block in run'
/usr/share/foreman/vendor/ruby/2.0.0/gems/rake-11.2.2/lib/rake/application.rb:178:in `standard_exception_handling'
/usr/share/foreman/vendor/ruby/2.0.0/gems/rake-11.2.2/lib/rake/application.rb:77:in `run'
/usr/bin/rake2.0:37:in `<main>'
Tasks: TOP => db:migrate

Any help would be greatly appreciated. Thank You

Related issues 1 (0 open — 1 closed)

Related to Foreman - Bug #14518: unable to save report due to a host os misconfigurationClosedMarek Hulán04/07/2016Actions
Actions
Copy link
 #1

Updated by Dominic Cleal almost 8 years ago

  • Subject changed from Upgrade Foreman to 1.12 to "some interfaces are invalid" during host status db:migrate
  • Category set to DB migrations

There's an error with one of your existing hosts, the network interfaces listed are invalid.

You could perhaps edit /usr/share/foreman/db/migrate/20150612135546_create_host_status.rb and insert after line 14: say "Migrating host #{host.name}" to see which host is failing, then edit it in the UI before upgrading, or delete the host.

Actions
Copy link
 #2

Updated by Anthony De La Rosa almost 8 years ago

Hey Domninic

Thanks for getting back to me. I found the answer in this issue https://github.com/theforeman/foreman/pull/3447
Seems like applying the patch to /app/models/host/manged.rb fixed my issue.

I hope others who are experiencing this issue can get the same results.

Anthony

Actions
Copy link
 #3

Updated by Dominic Cleal almost 8 years ago

  • Related to Bug #14518: unable to save report due to a host os misconfiguration added
Actions
Copy link
 #4

Updated by Dominic Cleal almost 8 years ago

  • Status changed from New to Duplicate

Thanks for testing it, we'll continue tracking it under #14518 then.

Actions
Copy link

Also available in: Atom PDF