Upgrade to Foreman 1.12

Support
1

Hello,

I followed the Foreman :: Manual
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:insave!’
/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:inblock 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:intransaction’
/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:inwith_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:inrefresh_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:inblock 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:ineach’
/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:infind_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:inup’
/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:inblock (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:inblock 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:inmigrate’
/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:inblock 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:inblock 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:intransaction’
/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:inddl_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:inblock 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:inmigrate’
/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:inmigrate’
/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:inblock (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:inblock 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:inexecute’
/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:inmon_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:ininvoke’
/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:inblock (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:inblock 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:intop_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:instandard_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’
Tasks: TOP => db:migrate

Any help would be greatly appreciated. Thank You

2

I think you're facing the problem in https://github.com/theforeman/foreman/pull/3447
We're still discussing whether to introduce the patch or not, but if it
helps, you can apply that patch in your installation and I think that
will get the migration running.

Let us know how it goes :slight_smile:

··· On 07/13, Joey Jojo wrote: > 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 ' > /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 `' > Tasks: TOP => db:migrate > > > Any help would be greatly appreciated. Thank You > > -- > You received this message because you are subscribed to the Google Groups "Foreman users" group. > To unsubscribe from this group and stop receiving emails from it, send an email to foreman-users+unsubscribe@googlegroups.com. > To post to this group, send email to foreman-users@googlegroups.com. > Visit this group at https://groups.google.com/group/foreman-users. > For more options, visit https://groups.google.com/d/optout.

–
Daniel Lobato Garcia

@dLobatog
blog.daniellobato.me
daniellobato.me

GPG: http://keys.gnupg.net/pks/lookup?op=get&search=0x7A92D6DD38D6DE30
Keybase: https://keybase.io/elobato

3

>
> Hey Daniel!

Success!! I added the :validate => false in the manged.rb file and
everything went smoothly! Thank you! I'll monitor it to see if there are
any issues going fwd.