Created attachment 1146447 [details]
Error found in log

Description of problem:

Looks like synchronizing more than one kickstart tree repositories at the same time causes a race condition which leads to one of the tasks to show a warning in the Sync Status page. @jsherill thinks that this is related to the sync of both x86_64 and i386 kickstart tree repos and their process finishing at the same time.


Version-Release number of selected component (if applicable):

* Satellite 6.2.0 SNAP 7.1

How reproducible:


Steps to Reproduce:

* Enabled the following repositories for synchronization (through the UI):
  * Red Hat Enterprise Linux 6 Server RPMs x86_64 6Server
  * Red Hat Enterprise Linux 6 Server RPMs i386 6Server
  * Red Hat Enterprise Linux 6 Server Kickstart x86_64 6.7
  * Red Hat Enterprise Linux 6 Server Kickstart i386 6.7
  * Red Hat Enterprise Linux 5 Server RPMs x86_64 5Server
  * Red Hat Enterprise Linux 5 Server RPMs i386 5Server
  * Red Hat Enterprise Linux 5 Server Kickstart x86_64 5.11
  * Red Hat Enterprise Linux 5 Server Kickstart i386 5.11
* Synchronized them (Sync Status page)
* Sync status page for "Red Hat Enterprise Linux 6 Server Kickstart x86_64 6.7" shows that something went wrong (yellow warning icon)
* Clicking the warning icon takes me to the task status page and the following error is shown:
    PG::Error: ERROR:  duplicate key value violates unique constraint "index_operatingsystems_on_title"
DETAIL:  Key (title)=(RedHat 6.7) already exists.
: INSERT INTO "operatingsystems" ("created_at", "major", "minor", "name", "title", "type", "updated_at") VALUES ($1, $2, $3, $4, $5, $6, $7) RETURNING "id"

Actual results:


Expected results:


Additional info:

Action:

Actions::Katello::Foreman::ContentUpdate

Input:

{"environment_id"=>1,
 "content_view_id"=>1,
 "repository_id"=>31,
 "remote_user"=>"admin",
 "remote_cp_user"=>"admin",
 "locale"=>"en"}

Output:

{}

Exception:

ActiveRecord::RecordNotUnique: PG::Error: ERROR:  duplicate key value violates unique constraint "index_operatingsystems_on_title"
DETAIL:  Key (title)=(RedHat 6.7) already exists.
: INSERT INTO "operatingsystems" ("created_at", "major", "minor", "name", "title", "type", "updated_at") VALUES ($1, $2, $3, $4, $5, $6, $7) RETURNING "id"