|
Mysql2::Error: Error on rename of './foreman/#sql-49a_3' to './foreman/katello_content_view_filters_repositories' (errno: 150): ALTER TABLE `katello_content_view_filters_repositories` CHANGE `filter_id` `content_view_filter_id` int(11) DEFAULT NULL/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:303:in `query'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:303:in `block in execute'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/connection_adapters/abstract_adapter.rb:378:in `block in log'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activesupport-4.1.14.2/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/connection_adapters/abstract_adapter.rb:372:in `log'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:303:in `execute'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/connection_adapters/mysql2_adapter.rb:228:in `execute'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:519:in `rename_column'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:656:in `block in method_missing'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:628:in `block in say_with_time'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:628:in `say_with_time'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:648:in `method_missing'
|
|
/home/user/katello/db/migrate/20140117160939_refactor_content_views.rb:37:in `up'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:605:in `exec_migration'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:586:in `block (2 levels) in migrate'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:585:in `block in migrate'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:294:in `with_connection'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:584:in `migrate'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:759:in `migrate'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:998:in `block in execute_migration_in_transaction'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:1046:in `ddl_transaction'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:997:in `execute_migration_in_transaction'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:959:in `block in migrate'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:955:in `each'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:955:in `migrate'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:814:in `up'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:792:in `migrate'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/railties/databases.rake:34:in `block (2 levels) in <top (required)>'
|
|
/home/user/.rvm/gems/ruby-2.1.8/bin/ruby_executable_hooks:15:in `eval'
|
|
/home/user/.rvm/gems/ruby-2.1.8/bin/ruby_executable_hooks:15:in `<main>'
|
|
|
|
------------------------
|
|
LATEST FOREIGN KEY ERROR
|
|
------------------------
|
|
160331 2:38:56 Error in foreign key constraint of table foreman/katello_content_view_filters_repositories:
|
|
there is no index in the table which would contain
|
|
the columns as the first columns, or the data types in the
|
|
table do not match the ones in the referenced table
|
|
or one of the ON ... SET NULL columns is declared NOT NULL. Constraint:
|
|
,
|
|
CONSTRAINT "filters_repositories_filter_id_fk" FOREIGN KEY ("filter_id") REFERENCES "katello_content_view_filters" ("id")
|
|
|
|
###
|
|
|
|
== 20140222022712 RemoveProviderDiscovery: migrating ==========================
|
|
-- remove_column(:katello_providers, :discovery_url)
|
|
-> 0.0202s
|
|
-- remove_column(:katello_providers, :discovery_task_id)
|
|
rake aborted!
|
|
StandardError: An error has occurred, all later migrations canceled:
|
|
Mysql2::Error: Error on rename of './foreman/#sql-49a_10' to './foreman/katello_providers' (errno: 150): ALTER TABLE `katello_providers` DROP `discovery_task_id`/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:303:in `query'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:303:in `block in execute'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/connection_adapters/abstract_adapter.rb:378:in `block in log'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activesupport-4.1.14.2/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/connection_adapters/abstract_adapter.rb:372:in `log'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:303:in `execute'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/connection_adapters/mysql2_adapter.rb:228:in `execute'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/connection_adapters/abstract/schema_statements.rb:397:in `remove_column'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:656:in `block in method_missing'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:628:in `block in say_with_time'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:628:in `say_with_time'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:648:in `method_missing'
|
|
/home/user/katello/db/migrate/20140222022712_remove_provider_discovery.rb:4:in `up'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:605:in `exec_migration'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:586:in `block (2 levels) in migrate'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:585:in `block in migrate'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:294:in `with_connection'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:584:in `migrate'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:759:in `migrate'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:998:in `block in execute_migration_in_transaction'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:1046:in `ddl_transaction'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:997:in `execute_migration_in_transaction'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:959:in `block in migrate'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:955:in `each'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:955:in `migrate'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:814:in `up'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:792:in `migrate'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/railties/databases.rake:34:in `block (2 levels) in <top (required)>'
|
|
/home/user/.rvm/gems/ruby-2.1.8/bin/ruby_executable_hooks:15:in `eval'
|
|
/home/user/.rvm/gems/ruby-2.1.8/bin/ruby_executable_hooks:15:in `<main>'
|
|
------------------------
|
|
LATEST FOREIGN KEY ERROR
|
|
------------------------
|
|
160331 3:15:19 Error in foreign key constraint of table foreman/katello_providers:
|
|
there is no index in the table which would contain
|
|
the columns as the first columns, or the data types in the
|
|
table do not match the ones in the referenced table
|
|
or one of the ON ... SET NULL columns is declared NOT NULL. Constraint:
|
|
,
|
|
CONSTRAINT "providers_discovery_task_id_fk" FOREIGN KEY ("discovery_task_id") REFERENCES "katello_task_statuses" ("id")
|
|
|
|
###
|
|
|
|
Mysql2::Error: Error on rename of './foreman/#sql-49a_14' to './foreman/katello_key_system_groups' (errno: 150): ALTER TABLE `katello_key_system_groups` CHANGE `system_group_id` `host_collection_id` int(11) DEFAULT NULL/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:303:in `query'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:303:in `block in execute'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/connection_adapters/abstract_adapter.rb:378:in `block in log'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activesupport-4.1.14.2/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/connection_adapters/abstract_adapter.rb:372:in `log'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:303:in `execute'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/connection_adapters/mysql2_adapter.rb:228:in `execute'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:519:in `rename_column'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:656:in `block in method_missing'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:628:in `block in say_with_time'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:628:in `say_with_time'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:648:in `method_missing'
|
|
/home/user/katello/db/migrate/20140502164009_rename_system_groups_to_host_collections.rb:5:in `change'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:602:in `exec_migration'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:586:in `block (2 levels) in migrate'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:585:in `block in migrate'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:294:in `with_connection'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:584:in `migrate'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:759:in `migrate'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:998:in `block in execute_migration_in_transaction'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:1046:in `ddl_transaction'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:997:in `execute_migration_in_transaction'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:959:in `block in migrate'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:955:in `each'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:955:in `migrate'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:814:in `up'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:792:in `migrate'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/railties/databases.rake:34:in `block (2 levels) in <top (required)>'
|
|
/home/user/.rvm/gems/ruby-2.1.8/bin/ruby_executable_hooks:15:in `eval'
|
|
/home/user/.rvm/gems/ruby-2.1.8/bin/ruby_executable_hooks:15:in `<main>'
|
|
------------------------
|
|
LATEST FOREIGN KEY ERROR
|
|
------------------------
|
|
160331 3:34:04 Error in foreign key constraint of table foreman/katello_key_system_groups:
|
|
there is no index in the table which would contain
|
|
the columns as the first columns, or the data types in the
|
|
table do not match the ones in the referenced table
|
|
or one of the ON ... SET NULL columns is declared NOT NULL. Constraint:
|
|
,
|
|
CONSTRAINT "key_system_groups_system_group_id_fk" FOREIGN KEY ("system_group_id") REFERENCES "katello_system_groups" ("id")
|
|
|
|
###
|
|
|
|
Mysql2::Error: Error on rename of './foreman/#sql-49a_18' to './foreman/katello_system_system_groups' (errno: 150): ALTER TABLE `katello_system_system_groups` CHANGE `system_group_id` `host_collection_id` int(11) DEFAULT NULL/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:303:in `query'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:303:in `block in execute'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/connection_adapters/abstract_adapter.rb:378:in `block in log'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activesupport-4.1.14.2/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/connection_adapters/abstract_adapter.rb:372:in `log'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:303:in `execute'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/connection_adapters/mysql2_adapter.rb:228:in `execute'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:519:in `rename_column'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:656:in `block in method_missing'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:628:in `block in say_with_time'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:628:in `say_with_time'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:648:in `method_missing'
|
|
/home/user/katello/db/migrate/20140502164009_rename_system_groups_to_host_collections.rb:21:in `change'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:602:in `exec_migration'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:586:in `block (2 levels) in migrate'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:585:in `block in migrate'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:294:in `with_connection'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:584:in `migrate'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:759:in `migrate'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:998:in `block in execute_migration_in_transaction'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:1046:in `ddl_transaction'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:997:in `execute_migration_in_transaction'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:959:in `block in migrate'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:955:in `each'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:955:in `migrate'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:814:in `up'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:792:in `migrate'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/railties/databases.rake:34:in `block (2 levels) in <top (required)>'
|
|
/home/user/.rvm/gems/ruby-2.1.8/bin/ruby_executable_hooks:15:in `eval'
|
|
/home/user/.rvm/gems/ruby-2.1.8/bin/ruby_executable_hooks:15:in `<main>'
|
|
|
|
------------------------
|
|
LATEST FOREIGN KEY ERROR
|
|
------------------------
|
|
160331 3:56:42 Error in foreign key constraint of table foreman/katello_system_system_groups:
|
|
there is no index in the table which would contain
|
|
the columns as the first columns, or the data types in the
|
|
table do not match the ones in the referenced table
|
|
or one of the ON ... SET NULL columns is declared NOT NULL. Constraint:
|
|
,
|
|
CONSTRAINT "system_system_groups_system_group_id_fk" FOREIGN KEY ("system_group_id") REFERENCES "katello_host_collections" ("id")
|
|
|
|
###
|
|
|
|
Mysql2::Error: Can't create table 'foreman.#sql-49a_1d' (errno: 121): ALTER TABLE `katello_repository_docker_images` ADD CONSTRAINT `katello_repository_docker_images_docker_image_id_fk` FOREIGN KEY (`docker_image_id`) REFERENCES `katello_docker_images`(id)/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:303:in `query'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:303:in `block in execute'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/connection_adapters/abstract_adapter.rb:378:in `block in log'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activesupport-4.1.14.2/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/connection_adapters/abstract_adapter.rb:372:in `log'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:303:in `execute'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/connection_adapters/mysql2_adapter.rb:228:in `execute'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/foreigner-1.7.4/lib/foreigner/connection_adapters/sql2003.rb:24:in `add_foreign_key'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:656:in `block in method_missing'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:628:in `block in say_with_time'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:628:in `say_with_time'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:648:in `method_missing'
|
|
/home/user/katello/db/migrate/20141210173220_create_docker_tables.rb:22:in `up'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:605:in `exec_migration'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:586:in `block (2 levels) in migrate'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:585:in `block in migrate'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:294:in `with_connection'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:584:in `migrate'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:759:in `migrate'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:998:in `block in execute_migration_in_transaction'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:1046:in `ddl_transaction'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:997:in `execute_migration_in_transaction'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:959:in `block in migrate'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:955:in `each'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:955:in `migrate'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:814:in `up'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:792:in `migrate'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/railties/databases.rake:34:in `block (2 levels) in <top (required)>'
|
|
/home/user/.rvm/gems/ruby-2.1.8/bin/ruby_executable_hooks:15:in `eval'
|
|
/home/user/.rvm/gems/ruby-2.1.8/bin/ruby_executable_hooks:15:in `<main>'
|
|
|
|
------------------------
|
|
LATEST FOREIGN KEY ERROR
|
|
------------------------
|
|
160331 4:23:51 Error in foreign key constraint creation for table `foreman`.`#sql-49a_1d`.
|
|
A foreign key constraint of name `foreman`.`katello_repository_docker_images_docker_image_id_fk`
|
|
already exists. (Note that internally InnoDB adds 'databasename'
|
|
in front of the user-defined constraint name.)
|
|
Note that InnoDB's FOREIGN KEY system tables store
|
|
constraint names as case-insensitive, with the
|
|
MySQL standard latin1_swedish_ci collation. If you
|
|
create tables or databases whose names differ only in
|
|
the character case, then collisions in constraint
|
|
names can occur. Workaround: name your constraints
|
|
explicitly with unique names.
|
|
|
|
###
|
|
|
|
Mysql2::Error: Table 'foreman.katello_repository_puppet_module' doesn't exist: SHOW KEYS FROM `katello_repository_puppet_module`/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:303:in `query'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:303:in `block in execute'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/connection_adapters/abstract_adapter.rb:378:in `block in log'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activesupport-4.1.14.2/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/connection_adapters/abstract_adapter.rb:372:in `log'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:303:in `execute'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/connection_adapters/mysql2_adapter.rb:228:in `execute'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:310:in `execute_and_free'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:428:in `indexes'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/connection_adapters/abstract/schema_statements.rb:51:in `index_exists?'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:656:in `block in method_missing'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:628:in `block in say_with_time'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:628:in `say_with_time'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:648:in `method_missing'
|
|
/home/user/katello/db/migrate/20151219203225_rename_index_repository_puppet_module.rb:6:in `change'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:602:in `exec_migration'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:586:in `block (2 levels) in migrate'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:585:in `block in migrate'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:294:in `with_connection'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:584:in `migrate'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:759:in `migrate'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:998:in `block in execute_migration_in_transaction'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:1046:in `ddl_transaction'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:997:in `execute_migration_in_transaction'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:959:in `block in migrate'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:955:in `each'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:955:in `migrate'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:814:in `up'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:792:in `migrate'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/railties/databases.rake:34:in `block (2 levels) in <top (required)>'
|
|
/home/user/.rvm/gems/ruby-2.1.8/bin/ruby_executable_hooks:15:in `eval'
|
|
/home/user/.rvm/gems/ruby-2.1.8/bin/ruby_executable_hooks:15:in `<main>'
|
|
|
|
###
|
|
|
|
Mysql2::Error: Error on rename of './foreman/#sql-49a_21' to './foreman/katello_docker_tags' (errno: 150): ALTER TABLE `katello_docker_tags` DROP `docker_image_id`/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:303:in `query'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:303:in `block in execute'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/connection_adapters/abstract_adapter.rb:378:in `block in log'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activesupport-4.1.14.2/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/connection_adapters/abstract_adapter.rb:372:in `log'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:303:in `execute'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/connection_adapters/mysql2_adapter.rb:228:in `execute'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/connection_adapters/abstract/schema_statements.rb:397:in `remove_column'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:656:in `block in method_missing'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:628:in `block in say_with_time'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:628:in `say_with_time'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:648:in `method_missing'
|
|
/home/user/katello/db/migrate/20160203195736_remove_docker_image_schema.rb:3:in `up'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:605:in `exec_migration'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:586:in `block (2 levels) in migrate'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:585:in `block in migrate'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:294:in `with_connection'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:584:in `migrate'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:759:in `migrate'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:998:in `block in execute_migration_in_transaction'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:1046:in `ddl_transaction'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:997:in `execute_migration_in_transaction'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:959:in `block in migrate'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:955:in `each'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:955:in `migrate'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:814:in `up'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:792:in `migrate'
|
|
/home/user/.rvm/gems/ruby-2.1.8/gems/activerecord-4.1.14.2/lib/active_record/railties/databases.rake:34:in `block (2 levels) in <top (required)>'
|
|
/home/user/.rvm/gems/ruby-2.1.8/bin/ruby_executable_hooks:15:in `eval'
|
|
/home/user/.rvm/gems/ruby-2.1.8/bin/ruby_executable_hooks:15:in `<main>'
|
|
|
|
------------------------
|
|
LATEST FOREIGN KEY ERROR
|
|
------------------------
|
|
160331 4:41:17 Error in foreign key constraint of table foreman/katello_docker_tags:
|
|
there is no index in the table which would contain
|
|
the columns as the first columns, or the data types in the
|
|
table do not match the ones in the referenced table
|
|
or one of the ON ... SET NULL columns is declared NOT NULL. Constraint:
|
|
,
|
|
CONSTRAINT "katello_docker_tags_docker_image_id_fk" FOREIGN KEY ("docker_image_id") REFERENCES "katello_docker_images" ("id")
|
|
|
|
###
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
