Plugins » Katello

Cloned from https://bugzilla.redhat.com/show_bug.cgi?id=1585408

Description of problem:
SQL error when adding some puppet modules to CV: PG::UniqueViolation: ERROR: duplicate key value violates unique constraint "katello_cv_puppet_modules_name"

Version-Release number of selected component (if applicable):
satellite-6.4.0-9.beta.el7sat.noarch
tfm-rubygem-hammer_cli-0.13.0-1.el7sat.noarch

How reproducible:
happens for about 20% of modules

Steps to Reproduce:
1. Sync whole PuppetForge, create content view "MyCV"
2. # hammer --csv -u admin -p changeme puppet-module list \
> puppet-module-list.csv
3. # for u in $( cut -d ',' -f 5 puppet-module-list.csv ); do
hammer -u admin -p changeme content-view puppet-module add \
--content-view "MyCV" --organization "Default Organization" \
--uuid "$u"
done

Actual results:
Could not add the puppet module:
PG::UniqueViolation: ERROR: duplicate key value violates unique constraint "katello_cv_puppet_modules_name"
DETAIL: Key (name, content_view_id)=(sumo, 7) already exists.
: INSERT INTO "katello_content_view_puppet_modules" ("content_view_id", "name", "author", "uuid", "created_at", "updated_at") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id"

Expected results:
Either should work or should provide some user friendly message