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
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 
···
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
>
> 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.
