Bug #26412
closedmanifest upload duplicate key value violates unique constraint
Description
Description of problem:
Manifest upload duplicates key value violates unique constraint.
Case can be seen in report portal.
Actual results:
Failed uploading manifest
Expected results:
Successfully uploads manifest
Additional info:
E nailgun.entity_mixins.TaskFailedError: Task fc7b8f24-c40a-4651-8364-065b296f8363 did not succeed. Task information: {'id': 'fc7b8f24-c40a-4651-8364-065b296f8363', 'label': 'Actions::Katello::Organization::ManifestImport', 'pending': False, 'action': "Import Manifest organization 'zgiNat'", 'username': 'admin', 'started_at': '2019-03-03 23:07:39 UTC', 'ended_at': '2019-03-03 23:07:53 UTC', 'state': 'stopped', 'result': 'warning', 'progress': 1.0, 'input': {'organization': {'id': 12, 'name': 'zgiNat', 'label': 'zgiNat'}, 'remote_user': 'admin', 'remote_cp_user': 'admin', 'current_timezone': 'UTC', 'current_user_id': 4, 'current_organization_id': 12, 'current_location_id': None}, 'output': {}, 'humanized': {'action': 'Import Manifest', 'input': [['organization', {'text': "organization 'zgiNat'", 'link': '/organizations/12/edit'}]], 'output': '', 'errors': ['PG::UniqueViolation: ERROR: duplicate key value violates unique constraint "index_katello_pools_on_cp_id"\nDETAIL: Key (cp_id)=(8a88400369450d7b016945d026080c79) already exists.\n: INSERT INTO "katello_pools" ("cp_id", "created_at", "updated_at", "organization_id") VALUES ($1, $2, $3, $4) RETURNING "id"']}, 'cli_example': None}