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 <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
>
> --
> 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 [email protected].
> To post to this group, send email to [email protected].
> 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

-- 
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 [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/foreman-users.
For more options, visit https://groups.google.com/d/optout.

Attachment: signature.asc
Description: PGP signature

Reply via email to