Description of problem: upgrade from 5.5.2 to 5.6.0 fails due to duplicated entry Version-Release number of selected component (if applicable): 5.5.2 How reproducible: all the time in customer environement Steps to Reproduce: 1. import the db and start a db migrat(ion 2. 3. Actual results: For a menu, please type: appliance_console [root@wat-cf4-db ~]# systemctl evmserverd stop Unknown operation 'evmserverd'. [root@wat-cf4-db ~]# systemctl stop evmserverd [root@wat-cf4-db ~]# vmdb [root@wat-cf4-db vmdb]# rake db:migrate DEPRECATION WARNING: `config.serve_static_files` is deprecated and will be removed in Rails 5.1. Please use `config.public_file_server.enabled = false` instead. (called from serve_static_files= at /opt/rh/cfme-gemset/gems/railties-5.0.0.rc2/lib/rails/application/configuration.rb:81) == 20160106214719 AddCompositePrimaryKeysToJoinTables: migrating ============== -- execute("ALTER TABLE cloud_tenants_vms ADD PRIMARY KEY (cloud_tenant_id, vm_id)") -> 0.5488s -- execute("ALTER TABLE conditions_miq_policies ADD PRIMARY KEY (miq_policy_id, condition_id)") -> 0.1965s -- execute("ALTER TABLE configuration_locations_configuration_profiles ADD PRIMARY KEY (configuration_location_id, configuration_profile_id)") -> 0.0047s -- execute("ALTER TABLE configuration_organizations_configuration_profiles ADD PRIMARY KEY (configuration_organization_id, configuration_profile_id)") -> 0.0594s -- execute("ALTER TABLE configuration_profiles_configuration_tags ADD PRIMARY KEY (configuration_profile_id, configuration_tag_id)") -> 0.0039s -- execute("ALTER TABLE configuration_tags_configured_systems ADD PRIMARY KEY (configured_system_id, configuration_tag_id)") -> 0.1637s -- execute("ALTER TABLE container_groups_container_services ADD PRIMARY KEY (container_service_id, container_group_id)") -> 0.0149s -- execute("ALTER TABLE customization_scripts_operating_system_flavors ADD PRIMARY KEY (customization_script_id, operating_system_flavor_id)") -> 0.0207s -- execute("ALTER TABLE direct_configuration_profiles_configuration_tags ADD PRIMARY KEY (configuration_profile_id, configuration_tag_id)") -> 0.0172s -- execute("ALTER TABLE direct_configuration_tags_configured_systems ADD PRIMARY KEY (configured_system_id, configuration_tag_id)") -> 0.0044s -- execute("ALTER TABLE key_pairs_vms ADD PRIMARY KEY (authentication_id, vm_id)") -> 0.0621s -- execute("ALTER TABLE miq_groups_users ADD PRIMARY KEY (miq_group_id, user_id)") -> 0.1136s -- execute("ALTER TABLE miq_roles_features ADD PRIMARY KEY (miq_user_role_id, miq_product_feature_id)") -> 0.0444s -- execute("ALTER TABLE miq_servers_product_updates ADD PRIMARY KEY (product_update_id, miq_server_id)") rake aborted! StandardError: An error has occurred, this and all later migrations canceled: PG::UniqueViolation: ERROR: could not create unique index "miq_servers_product_updates_pkey" DETAIL: Key (product_update_id, miq_server_id)=(1000000000050, 1000000000005) is duplicated. : ALTER TABLE miq_servers_product_updates ADD PRIMARY KEY (product_update_id, miq_server_id)/opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/connection_adapters/postgresql/database_statements.rb:98:in `async_exec' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/connection_adapters/postgresql/database_statements.rb:98:in `block in execute' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:566:in `block in log' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activesupport/lib/active_support/notifications/instrumenter.rb:21:in `instrument' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:560:in `log' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/connection_adapters/postgresql/database_statements.rb:97:in `execute' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/migration.rb:845:in `block in method_missing' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/migration.rb:814:in `block in say_with_time' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/migration.rb:814:in `say_with_time' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/migration.rb:834:in `method_missing' /var/www/miq/vmdb/db/migrate/20160106214719_add_composite_primary_keys_to_join_tables.rb:24:in `block in up' /var/www/miq/vmdb/db/migrate/20160106214719_add_composite_primary_keys_to_join_tables.rb:23:in `each' /var/www/miq/vmdb/db/migrate/20160106214719_add_composite_primary_keys_to_join_tables.rb:23:in `up' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/migration.rb:791:in `exec_migration' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/migration.rb:772:in `block (2 levels) in migrate' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/migration.rb:771:in `block in migrate' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:398:in `with_connection' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/migration.rb:770:in `migrate' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/migration/compatibility.rb:121:in `migrate' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/migration.rb:950:in `migrate' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/migration.rb:1211:in `block in execute_migration_in_transaction' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/migration.rb:1279:in `block in ddl_transaction' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:232:in `block in transaction' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/connection_adapters/abstract/transaction.rb:189:in `within_new_transaction' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:232:in `transaction' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/transactions.rb:211:in `transaction' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/migration.rb:1279:in `ddl_transaction' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/migration.rb:1210:in `execute_migration_in_transaction' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/migration.rb:1183:in `block in migrate_without_lock' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/migration.rb:1182:in `each' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/migration.rb:1182:in `migrate_without_lock' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/migration.rb:1131:in `block in migrate' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/migration.rb:1298:in `with_advisory_lock' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/migration.rb:1131:in `migrate' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/migration.rb:1005:in `up' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/migration.rb:983:in `migrate' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/tasks/database_tasks.rb:161:in `migrate' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/railties/databases.rake:58:in `block (2 levels) in <top (required)>' ActiveRecord::RecordNotUnique: PG::UniqueViolation: ERROR: could not create unique index "miq_servers_product_updates_pkey" DETAIL: Key (product_update_id, miq_server_id)=(1000000000050, 1000000000005) is duplicated. : ALTER TABLE miq_servers_product_updates ADD PRIMARY KEY (product_update_id, miq_server_id) /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/connection_adapters/postgresql/database_statements.rb:98:in `async_exec' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/connection_adapters/postgresql/database_statements.rb:98:in `block in execute' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:566:in `block in log' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activesupport/lib/active_support/notifications/instrumenter.rb:21:in `instrument' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:560:in `log' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/connection_adapters/postgresql/database_statements.rb:97:in `execute' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/migration.rb:845:in `block in method_missing' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/migration.rb:814:in `block in say_with_time' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/migration.rb:814:in `say_with_time' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/migration.rb:834:in `method_missing' /var/www/miq/vmdb/db/migrate/20160106214719_add_composite_primary_keys_to_join_tables.rb:24:in `block in up' /var/www/miq/vmdb/db/migrate/20160106214719_add_composite_primary_keys_to_join_tables.rb:23:in `each' /var/www/miq/vmdb/db/migrate/20160106214719_add_composite_primary_keys_to_join_tables.rb:23:in `up' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/migration.rb:791:in `exec_migration' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/migration.rb:772:in `block (2 levels) in migrate' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/migration.rb:771:in `block in migrate' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:398:in `with_connection' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/migration.rb:770:in `migrate' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/migration/compatibility.rb:121:in `migrate' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/migration.rb:950:in `migrate' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/migration.rb:1211:in `block in execute_migration_in_transaction' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/migration.rb:1279:in `block in ddl_transaction' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:232:in `block in transaction' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/connection_adapters/abstract/transaction.rb:189:in `within_new_transaction' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:232:in `transaction' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/transactions.rb:211:in `transaction' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/migration.rb:1279:in `ddl_transaction' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/migration.rb:1210:in `execute_migration_in_transaction' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/migration.rb:1183:in `block in migrate_without_lock' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/migration.rb:1182:in `each' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/migration.rb:1182:in `migrate_without_lock' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/migration.rb:1131:in `block in migrate' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/migration.rb:1298:in `with_advisory_lock' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/migration.rb:1131:in `migrate' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/migration.rb:1005:in `up' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/migration.rb:983:in `migrate' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/tasks/database_tasks.rb:161:in `migrate' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/railties/databases.rake:58:in `block (2 levels) in <top (required)>' PG::UniqueViolation: ERROR: could not create unique index "miq_servers_product_updates_pkey" DETAIL: Key (product_update_id, miq_server_id)=(1000000000050, 1000000000005) is duplicated. /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/connection_adapters/postgresql/database_statements.rb:98:in `async_exec' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/connection_adapters/postgresql/database_statements.rb:98:in `block in execute' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:566:in `block in log' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activesupport/lib/active_support/notifications/instrumenter.rb:21:in `instrument' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:560:in `log' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/connection_adapters/postgresql/database_statements.rb:97:in `execute' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/migration.rb:845:in `block in method_missing' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/migration.rb:814:in `block in say_with_time' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/migration.rb:814:in `say_with_time' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/migration.rb:834:in `method_missing' /var/www/miq/vmdb/db/migrate/20160106214719_add_composite_primary_keys_to_join_tables.rb:24:in `block in up' /var/www/miq/vmdb/db/migrate/20160106214719_add_composite_primary_keys_to_join_tables.rb:23:in `each' /var/www/miq/vmdb/db/migrate/20160106214719_add_composite_primary_keys_to_join_tables.rb:23:in `up' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/migration.rb:791:in `exec_migration' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/migration.rb:772:in `block (2 levels) in migrate' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/migration.rb:771:in `block in migrate' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:398:in `with_connection' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/migration.rb:770:in `migrate' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/migration/compatibility.rb:121:in `migrate' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/migration.rb:950:in `migrate' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/migration.rb:1211:in `block in execute_migration_in_transaction' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/migration.rb:1279:in `block in ddl_transaction' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:232:in `block in transaction' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/connection_adapters/abstract/transaction.rb:189:in `within_new_transaction' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:232:in `transaction' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/transactions.rb:211:in `transaction' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/migration.rb:1279:in `ddl_transaction' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/migration.rb:1210:in `execute_migration_in_transaction' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/migration.rb:1183:in `block in migrate_without_lock' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/migration.rb:1182:in `each' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/migration.rb:1182:in `migrate_without_lock' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/migration.rb:1131:in `block in migrate' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/migration.rb:1298:in `with_advisory_lock' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/migration.rb:1131:in `migrate' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/migration.rb:1005:in `up' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/migration.rb:983:in `migrate' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/tasks/database_tasks.rb:161:in `migrate' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/railties/databases.rake:58:in `block (2 levels) in <top (required)>' Tasks: TOP => db:migrate (See full trace by running task with --trace) [root@wat-cf4-db vmdb]# Expected results: db migration passes with no error Additional info: reproducer being built , see internal notes
Please *never* TRUNCATE a table to fix an issue. This deletes all the data from the table and will surely remove data that was required for normal operation of the application. Luckily that table was removed so no harm was done in this case. *** This bug has been marked as a duplicate of bug 1375029 ***
(In reply to Nick Carboni from comment #3) > Please *never* TRUNCATE a table to fix an issue. This deletes all the data > from the table and will surely remove data that was required for normal > operation of the application. Luckily that table was removed so no harm was > done in this case. > > *** This bug has been marked as a duplicate of bug 1375029 *** that's why it was truncated :)