Bug 2044631

Summary:

duplicate key value violates unique constraint "core_repositorycontent_repository_id_content_id_df902e11_uniq"

Product:

Red Hat Satellite

Reporter:

Joniel Pasqualetto <jpasqual>

Component:

Pulp

Assignee:

satellite6-bugs <satellite6-bugs>

Status:

CLOSED ERRATA

QA Contact:

Lai <ltran>

Severity:

medium

Docs Contact:

Priority:

high

Version:

6.10.1

CC:

ahumbe, ajambhul, ankulkar, bbuckingham, brstephe, dalley, djoo, dkliban, dmule, egolov, fgrosjea, ggainey, hyu, jalviso, jbhatia, JONATHAN.SATTELBERGER, jpasqual, kkeane, matthew.lesieur, mdellweg, msunil, onerleka, pmoravec, pwallend, ramsingh, rchan, sadas, satellite6-bugs, saydas, smajumda, snemeth, stanislav.moravec, sussen, vdeshpan, wclark, wpinheir

Target Milestone:

6.11.0

Keywords:

PrioBumpGSS, Triaged

Target Release:

Unused

Hardware:

Unspecified

OS:

Unspecified

Whiteboard:

Fixed In Version:

pulpcore-3.16.5

Doc Type:

If docs needed, set a value

Doc Text:

Story Points:

---

Clone Of:

Clones:

2080336 (view as bug list)

Environment:

Last Closed:

2022-07-05 14:32:22 UTC

Type:

Bug

Regression:

---

Mount Type:

---

Documentation:

---

CRM:

Verified Versions:

Category:

---

oVirt Team:

---

RHEL 7.3 requirements from Atomic Host:

Cloudforms Team:

---

Target Upstream Version:

Embargoed:

Attachments:

Description	Flags
HOTFIX RPM for Satellite 6.10.4	none

Description Joniel Pasqualetto 2022-01-24 20:49:56 UTC

Description of problem:
When publishing new CV version, task fails with error from $subject

Here's the pulp traceback:

~~~
Jan 24 15:39:23 nodename pulpcore-worker-6: pulp [7ee38a97-151c-47a7-8739-0ff4e44f2973]: pulpcore.tasking.pulpcore_worker:INFO: Starting task cd1693d0-8a15-4b95-a6f6-c431fb376865
Jan 24 15:39:23 nodename pulpcore-api: pulp [7ee38a97-151c-47a7-8739-0ff4e44f2973]:  - - [24/Jan/2022:20:39:23 +0000] "POST /pulp/api/v3/repositories/rpm/rpm/376c26da-1fd7-41ef-b33e-071908c17d1f/modify/ HTTP/1.1" 202 67 "-" "OpenAPI-Generator/3.13.3/ruby"
Jan 24 15:39:23 nodename pulpcore-worker-8: pulp [7ee38a97-151c-47a7-8739-0ff4e44f2973]: pulpcore.tasking.pulpcore_worker:INFO: Task 3f572446-f9c4-440b-94cb-3bc4f39db952 failed (duplicate key value violates unique constraint "core_repositorycontent_repository_id_content_id_df902e11_uniq"
Jan 24 15:39:23 nodename pulpcore-worker-8: DETAIL:  Key (repository_id, content_id, version_removed_id)=(efb0eb39-f02f-4493-a1af-bf6fb2b462de, 2b6f6ef7-3382-4b7c-a8a1-f088db1bb581, 61dfdd1f-46d1-49b7-89bc-44adb55769ec) already exists.
Jan 24 15:39:23 nodename pulpcore-worker-8: )
Jan 24 15:39:23 nodename pulpcore-worker-8: pulp [7ee38a97-151c-47a7-8739-0ff4e44f2973]: pulpcore.tasking.pulpcore_worker:INFO:   File "/usr/lib/python3.6/site-packages/pulpcore/tasking/pulpcore_worker.py", line 317, in _perform_task
Jan 24 15:39:23 nodename pulpcore-worker-8: result = func(*args, **kwargs)
Jan 24 15:39:23 nodename pulpcore-worker-8: File "/usr/lib/python3.6/site-packages/pulpcore/app/tasks/repository.py", line 218, in add_and_remove
Jan 24 15:39:23 nodename pulpcore-worker-8: new_version.remove_content(models.Content.objects.filter(pk__in=remove_content_units))
Jan 24 15:39:23 nodename pulpcore-worker-8: File "/usr/lib/python3.6/site-packages/pulpcore/app/models/repository.py", line 796, in remove_content
Jan 24 15:39:23 nodename pulpcore-worker-8: q_set.update(version_removed=self)
Jan 24 15:39:23 nodename pulpcore-worker-8: File "/usr/lib/python3.6/site-packages/django/db/models/query.py", line 741, in update
Jan 24 15:39:23 nodename pulpcore-worker-8: rows = query.get_compiler(self.db).execute_sql(CURSOR)
Jan 24 15:39:23 nodename pulpcore-worker-8: File "/usr/lib/python3.6/site-packages/django/db/models/sql/compiler.py", line 1471, in execute_sql
Jan 24 15:39:23 nodename pulpcore-worker-8: cursor = super().execute_sql(result_type)
Jan 24 15:39:23 nodename pulpcore-worker-8: File "/usr/lib/python3.6/site-packages/django/db/models/sql/compiler.py", line 1142, in execute_sql
Jan 24 15:39:23 nodename pulpcore-worker-8: cursor.execute(sql, params)
Jan 24 15:39:23 nodename pulpcore-worker-8: File "/usr/lib/python3.6/site-packages/django/db/backends/utils.py", line 67, in execute
Jan 24 15:39:23 nodename pulpcore-worker-8: return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
Jan 24 15:39:23 nodename pulpcore-worker-8: File "/usr/lib/python3.6/site-packages/django/db/backends/utils.py", line 76, in _execute_with_wrappers
Jan 24 15:39:23 nodename pulpcore-worker-8: return executor(sql, params, many, context)
Jan 24 15:39:23 nodename pulpcore-worker-8: File "/usr/lib/python3.6/site-packages/django/db/backends/utils.py", line 84, in _execute
Jan 24 15:39:23 nodename pulpcore-worker-8: return self.cursor.execute(sql, params) 
Jan 24 15:39:23 nodename pulpcore-worker-8: File "/usr/lib/python3.6/site-packages/django/db/utils.py", line 89, in __exit__
Jan 24 15:39:23 nodename pulpcore-worker-8: raise dj_exc_value.with_traceback(traceback) from exc_value
Jan 24 15:39:23 nodename pulpcore-worker-8: File "/usr/lib/python3.6/site-packages/django/db/backends/utils.py", line 84, in _execute
Jan 24 15:39:23 nodename pulpcore-worker-8: return self.cursor.execute(sql, params)
Jan 24 15:39:23 nodename pulpcore-worker-2: pulp [7ee38a97-151c-47a7-8739-0ff4e44f2973]: pulpcore.tasking.pulpcore_worker:INFO: Starting task 69e703e8-c06c-4bc0-a5a9-48a8f3bc2539
Jan 24 15:39:24 nodename pulpcore-api: pulp [7ee38a97-151c-47a7-8739-0ff4e44f2973]:  - - [24/Jan/2022:20:39:24 +0000] "POST /pulp/api/v3/rpm/copy/ HTTP/1.1" 202 67 "-" "OpenAPI-Generator/3.13.3/ruby"
Jan 24 15:39:24 nodename pulpcore-worker-6: pulp [7ee38a97-151c-47a7-8739-0ff4e44f2973]: pulpcore.tasking.pulpcore_worker:INFO: Task completed cd1693d0-8a15-4b95-a6f6-c431fb376865
Jan 24 15:39:24 nodename pulpcore-worker-4: pulp [7ee38a97-151c-47a7-8739-0ff4e44f2973]: pulpcore.tasking.pulpcore_worker:INFO: Starting task f1214a86-b613-475a-98bb-7d8c60669ace
Jan 24 15:39:24 nodename pulpcore-worker-2: pulp [7ee38a97-151c-47a7-8739-0ff4e44f2973]: pulpcore.tasking.pulpcore_worker:INFO: Task completed 69e703e8-c06c-4bc0-a5a9-48a8f3bc2539
Jan 24 15:39:25 nodename pulpcore-worker-4: pulp [7ee38a97-151c-47a7-8739-0ff4e44f2973]: pulpcore.tasking.pulpcore_worker:INFO: Task completed f1214a86-b613-475a-98bb-7d8c60669ace
Jan 24 15:39:25 nodename pulpcore-worker-1: pulp [7ee38a97-151c-47a7-8739-0ff4e44f2973]: pulpcore.tasking.pulpcore_worker:INFO: Starting task b520da49-d523-4f2a-a9d7-c10c6abbd23c
Jan 24 15:39:25 nodename pulpcore-api: pulp [7ee38a97-151c-47a7-8739-0ff4e44f2973]:  - - [24/Jan/2022:20:39:25 +0000] "POST /pulp/api/v3/rpm/copy/ HTTP/1.1" 202 67 "-" "OpenAPI-Generator/3.13.3/ruby"
~~~

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


How to Reproduce:

Steps:
1) Create a content view and attach "Red Hat Satellite Tools 6.10 for RHEL 7 Server RPMs x86_64" repo.
2) Create a package include filter.
3) In the package filter:
   a) Add 2 rules to include 'foreman-cli' and 'katello-agent' rpms.

4) Publish the content view. CV version 1.0 should have the following 2 rpms:

  - foreman-cli
  - katello-agent

5) Amend the package filter:
  a) Add 1 rule to include 'katello-host-tools' rpm.

6) Publish the content view again. CV version 2.0 should have the following 3 rpms:

  - foreman-cli
  - katello-agent
  - katello-host-tools

7) Amend the package filter:
   a) Remove 2 rules that included 'foreman-cli' and 'katello-agent'.
   b) Add 1 rule to include 'katello-host-tools-fact-plugin' rpm.

8) Publish the content view again. CV version 3.0 should have the following 2 rpms:

  - katello-host-tools
  - katello-host-tools-fact-plugin

9) Amend the package filter:
  a) Add 2 rules to include 'foreman-cli' and 'katello-agent' rpms. 

10) Publish the content view again. CV version 4.0 should have the following 4 rpms:

  - foreman-cli
  - katello-agent
  - katello-host-tools
  - katello-host-tools-fact-plugin


11) Manually trigger a clean orphan task. Wait until the task is finished in Web UI -> Monitor -> Task page.

foreman-rake katello:delete_orphaned_content

12) Amend the package filter:
  a) Remove 2 rules that included 'foreman-cli' and 'katello-agent'.


13) Tail the /var/log/messages file

tail -f /var/log/messages


14) Publish the content view again.


Actual results:
Foreman task didn't raise error but content view still containing the same packages as the previous version. Excluded rpms are not removed.


Observe the following Pulp task error in the /var/log/messages
-----------------------------------------
pulpcore.tasking.pulpcore_worker:INFO: Task d325195f-1ab8-4699-a6b2-11218c86686b failed (duplicate key value violates unique constraint "core_repositorycontent_repository_id_content_id_df902e11_uniq"
pulpcore-worker-3: DETAIL:  Key (repository_id, content_id, version_removed_id)=(73390261-c8e8-4f35-af62-e06b186ba7d1, 829b918a-f070-48d4-af09-f688f9f9e4c2, cbcf1dc4-fa8f-46b9-8348-d432ecde3958) already exists.
pulpcore-worker-3: )
pulpcore-worker-3: pulp [4bfaf4e2-64c9-4277-b2dd-8d2b7b303511]: pulpcore.tasking.pulpcore_worker:INFO:   File "/usr/lib/python3.6/site-packages/pulpcore/tasking/pulpcore_worker.py", line 317, in _perform_task
pulpcore-worker-3: result = func(*args, **kwargs)
pulpcore-worker-3: File "/usr/lib/python3.6/site-packages/pulpcore/app/tasks/repository.py", line 218, in add_and_remove
<snip>
-----------------------------------------


Expected results:
No error and filter should work correctly.

Comment 2 Pavel Moravec 2022-02-20 17:26:25 UTC

I played with CVs a lot and monitored impact to various pulpcore DB tables in detail. I see improbable to reach a situation, when two different RepositoryVersions do contain a record "I am adding a content C", same for both versions.

Typical use case of creating records in that table:
- a repo gets a new content after sync from CDN or elsewhere (while CV points to some previous / older content)
- CV uses filters - then *everytime* a *new* pulp repo is created, and a new CV publish *usually* creates a new *pair* of repo versions: first version removes all content, the next adds all expected content.

I was unable to break the later "remove everything in V+1, add all expected in V+2" observation so far.

I rather suspect something bad happened during pulp2to3 migration. That would be more tricky to reproduce (as the reproducer might require some specific pre-upgrade content *and* some specific actions after the upgrade).

(or I missed some scenario/idea during my reproducer attempts and there is a simpler reproducer, of course)

Comment 3 Pavel Moravec 2022-02-22 08:01:44 UTC

I *did* reproduce the problem .

So far on a Sat6.9 with CV with filters, that I migrated to 6.10 and then randomly (via a script) played with the CVs, by:
- adding or removing a filter (to include/exclude a package)
- publishing new version
- promoting some version to some LE
- deleting a version
- purging CV versions


Each CV had just one unique repo with few packages, though the packages were identical among the repos.

Doing so in a cycle and printing some core_repositorycontent content ended up in:

Mon Feb 21 23:06:21 CET 2022: deleting version 41.0
Task ad72864c-069d-4071-b422-d77cd1c4db6a running: 0.38/1, 38%, elapsed: 00:00:00
Task ad72864c-069d-4071-b422-d77cd1c4db6a error: 0.38/1, 38%, elapsed: 00:00:02
Task ad72864c-069d-4071-b422-d77cd1c4db6a error: 0.38/1, 38%, elapsed: 00:00:02
Error: duplicate key value violates unique constraint "core_repositorycontent_repository_id_content_id_df902e11_uniq"
DETAIL:  Key (repository_id, content_id, version_removed_id)=(875e42ce-d649-45c7-a443-2dc7345e815b, 1b2eaeaf-ffee-4f79-9a92-adb3d3a8b033, 6ff5daf8-7779-45b5-b19d-b350ea0a7609) already exists.

#	su - postgres -c "psql pulpcore -c \"select crv.pulp_id,crv.number,cr.name from core_repositoryversion as crv inner join core_repository as cr on cr.pulp_id = crv.repository_id where cr.name ilike '%${reponame}%' order by (cr.name, number);\""
               pulp_id                | number |        name
--------------------------------------+--------+--------------------
 eb57beba-2765-4ccc-9e4c-ebbc8e64dabe |      0 | cv_animals-animals
 215b2d60-991d-409a-aec7-f4c074f8b4f3 |      1 | cv_animals-animals
 e1e67711-630a-49c0-942f-7214b09508de |      2 | cv_animals-animals
 e0f2d1e4-f92e-43f5-ae96-629c117d1597 |      4 | cv_animals-animals
 b0106670-da3b-4f51-9719-c9efc97e99d4 |      8 | cv_animals-animals
 e819b4e8-2d39-4465-8ad8-e7b942491ec2 |      9 | cv_animals-animals
 bb5c496c-6b0f-4f96-ba46-b616b1134930 |     11 | cv_animals-animals
 d3b4342f-67a5-4256-bc89-2a935b84302f |     14 | cv_animals-animals
 8f0c16f8-6f9f-49d7-bd40-1b14ae1349af |     15 | cv_animals-animals
 b9cc7503-22e2-44e4-8b44-e24f42136ef1 |     16 | cv_animals-animals
 58817a11-deef-4417-a76e-f9afa4b95068 |     18 | cv_animals-animals
 432b5d6f-beaf-4309-be7f-26e0ece3e38c |     19 | cv_animals-animals
 ef510065-cfe1-44e2-9dfa-da98543b1a77 |     20 | cv_animals-animals
 45cc4d7f-ee6f-422f-bd7a-d9078c475b8b |     21 | cv_animals-animals
 ca5e778e-f14d-4bd7-ab87-17422d040a72 |     22 | cv_animals-animals
 efdb72c3-257b-45b5-9ecb-e8eb25c62cab |     23 | cv_animals-animals
 d454daf7-a0cb-49d5-8ae2-6490f707eca0 |     24 | cv_animals-animals
 7eff0f68-cd8c-40b1-8f2b-8b0898cd465b |     25 | cv_animals-animals
 9408e8b1-80ab-49f8-9b60-f43882b90276 |     26 | cv_animals-animals
 35acddd2-7d9c-4f47-a71b-e9fe600b7734 |     28 | cv_animals-animals
 0b0856a3-688d-4c05-827c-dc5bf32cd508 |     29 | cv_animals-animals
 2d36d471-6d78-4a74-8f17-43a3fd5cfdd4 |     30 | cv_animals-animals
 534450cc-53d2-4daa-a3dd-459989da2d93 |     32 | cv_animals-animals
 d9cc966c-72dc-4d46-bfcf-6ac5072777f0 |     34 | cv_animals-animals
 6b5f68a9-0833-48d6-b526-e85ce78096c6 |     35 | cv_animals-animals
 9a28c1c3-19b8-4ba7-91f7-9ee435644d81 |     36 | cv_animals-animals
 cfcdc60e-36ec-4cfb-96a5-85fb0dfc5428 |     38 | cv_animals-animals
 0e8812da-1f16-4061-9664-14bd0c2b5e1d |     40 | cv_animals-animals
 eed76362-09b9-405f-a4fa-b9e95e7265a6 |     41 | cv_animals-animals
 c6e38ad6-380f-4b31-8c2d-6e290286d3ad |     42 | cv_animals-animals
 b6bb4e63-1d71-44b8-a34f-8d91054f781d |     44 | cv_animals-animals
 97dda375-892a-43ac-8b40-556eb7f01fdb |     45 | cv_animals-animals
 5185d7c3-00cb-4bb5-9f7c-a41d50015bb9 |     46 | cv_animals-animals
 b7c192ac-98db-4c6f-aa35-4f46fc69deeb |     48 | cv_animals-animals
 613f338a-e3a0-4f25-906c-047dc362dacb |     49 | cv_animals-animals
 ae7f268c-617b-492e-b13d-a85ae70d24b3 |     50 | cv_animals-animals
 e4a7a74e-7e39-48cc-aa9a-3f4f2547977e |     51 | cv_animals-animals
 0a62305e-c0e4-478f-ac36-80ebbd164745 |     52 | cv_animals-animals
 9274cc26-5e9b-4e93-a9c4-62e61209a6df |     54 | cv_animals-animals
 06bc5cd7-48f6-4766-9a1e-b16d6c04b7d1 |     56 | cv_animals-animals
 09f72f62-dab8-47b0-9a23-8b97daa316d1 |     57 | cv_animals-animals
 5a8b9eb8-0c4d-4ca2-b654-4f0a562e8189 |     58 | cv_animals-animals
 3c94a6e6-0140-46b7-bda6-ad9fd49bfa0b |     59 | cv_animals-animals
 cc3097db-4ad7-4bc5-ad3b-278966ebb6d0 |     60 | cv_animals-animals
 2ac8e501-8045-4611-8168-cd0d73384801 |     61 | cv_animals-animals
 af231539-0458-437c-a671-d7c2df3ebb17 |     62 | cv_animals-animals
 2f8a99c8-7768-479d-b18f-40536a89b0d8 |     63 | cv_animals-animals
 705e3e54-0826-4b67-b66e-249f05d385e6 |     64 | cv_animals-animals
 2105bb1b-820d-4c50-afaa-04cfd4553741 |     65 | cv_animals-animals
 2241fbeb-368f-4ae5-a515-91b164d6df42 |     66 | cv_animals-animals
 41edfce0-212b-4376-8528-2b0f93e113ec |     67 | cv_animals-animals
 162224fa-8ffd-44a9-9264-94e683595772 |     68 | cv_animals-animals
 6ff5daf8-7779-45b5-b19d-b350ea0a7609 |     69 | cv_animals-animals
(53 rows)


#	su - postgres -c "psql pulpcore -c \"SELECT cr.name,crc.repository_id,crc.version_added_id,crc.version_removed_id,replace(rp.location_href,'Packages/j/','') AS filename FROM core_repositorycontent AS crc INNER JOIN core_repository AS cr ON cr.pulp_id = crc.repository_id INNER JOIN rpm_package AS rp ON rp.content_ptr_id = crc.content_id WHERE cr.name ILIKE '%${reponame}%' ORDER BY repository_id, version_added_id, version_removed_id;\""
        name        |            repository_id             |           version_added_id           |          version_removed_id          |                filename
--------------------+--------------------------------------+--------------------------------------+--------------------------------------+-----------------------------------------
 cv_animals-animals | 875e42ce-d649-45c7-a443-2dc7345e815b | 09f72f62-dab8-47b0-9a23-8b97daa316d1 | 5a8b9eb8-0c4d-4ca2-b654-4f0a562e8189 | Packages/c/crow-0.8-1.noarch.rpm
 cv_animals-animals | 875e42ce-d649-45c7-a443-2dc7345e815b | 0b0856a3-688d-4c05-827c-dc5bf32cd508 | 2d36d471-6d78-4a74-8f17-43a3fd5cfdd4 | Packages/b/bear-4.1-1.noarch.rpm
 cv_animals-animals | 875e42ce-d649-45c7-a443-2dc7345e815b | 0b0856a3-688d-4c05-827c-dc5bf32cd508 | 2d36d471-6d78-4a74-8f17-43a3fd5cfdd4 | Packages/c/crow-0.8-1.noarch.rpm
 cv_animals-animals | 875e42ce-d649-45c7-a443-2dc7345e815b | 0b0856a3-688d-4c05-827c-dc5bf32cd508 | 2d36d471-6d78-4a74-8f17-43a3fd5cfdd4 | Packages/c/chimpanzee-0.21-1.noarch.rpm
 cv_animals-animals | 875e42ce-d649-45c7-a443-2dc7345e815b | 0b0856a3-688d-4c05-827c-dc5bf32cd508 | 2d36d471-6d78-4a74-8f17-43a3fd5cfdd4 | Packages/c/cockateel-3.1-1.noarch.rpm
 cv_animals-animals | 875e42ce-d649-45c7-a443-2dc7345e815b | 2105bb1b-820d-4c50-afaa-04cfd4553741 | 2241fbeb-368f-4ae5-a515-91b164d6df42 | Packages/c/cow-2.2-3.noarch.rpm
 cv_animals-animals | 875e42ce-d649-45c7-a443-2dc7345e815b | 2105bb1b-820d-4c50-afaa-04cfd4553741 | 2241fbeb-368f-4ae5-a515-91b164d6df42 | Packages/b/bear-4.1-1.noarch.rpm
 cv_animals-animals | 875e42ce-d649-45c7-a443-2dc7345e815b | 2105bb1b-820d-4c50-afaa-04cfd4553741 | 2241fbeb-368f-4ae5-a515-91b164d6df42 | Packages/c/crow-0.8-1.noarch.rpm
 cv_animals-animals | 875e42ce-d649-45c7-a443-2dc7345e815b | 2105bb1b-820d-4c50-afaa-04cfd4553741 | 2241fbeb-368f-4ae5-a515-91b164d6df42 | Packages/c/cockateel-3.1-1.noarch.rpm
 cv_animals-animals | 875e42ce-d649-45c7-a443-2dc7345e815b | 215b2d60-991d-409a-aec7-f4c074f8b4f3 | 6ff5daf8-7779-45b5-b19d-b350ea0a7609 | Packages/c/cat-1.0-1.noarch.rpm
 cv_animals-animals | 875e42ce-d649-45c7-a443-2dc7345e815b | 215b2d60-991d-409a-aec7-f4c074f8b4f3 | 6ff5daf8-7779-45b5-b19d-b350ea0a7609 | Packages/c/cockateel-3.1-1.noarch.rpm
 cv_animals-animals | 875e42ce-d649-45c7-a443-2dc7345e815b | 215b2d60-991d-409a-aec7-f4c074f8b4f3 | e0f2d1e4-f92e-43f5-ae96-629c117d1597 | Packages/c/cow-2.2-3.noarch.rpm
 cv_animals-animals | 875e42ce-d649-45c7-a443-2dc7345e815b | 215b2d60-991d-409a-aec7-f4c074f8b4f3 | e0f2d1e4-f92e-43f5-ae96-629c117d1597 | Packages/c/crow-0.8-1.noarch.rpm
 cv_animals-animals | 875e42ce-d649-45c7-a443-2dc7345e815b | 215b2d60-991d-409a-aec7-f4c074f8b4f3 | e0f2d1e4-f92e-43f5-ae96-629c117d1597 | Packages/c/cheetah-1.25.3-5.noarch.rpm
 cv_animals-animals | 875e42ce-d649-45c7-a443-2dc7345e815b | 215b2d60-991d-409a-aec7-f4c074f8b4f3 | e0f2d1e4-f92e-43f5-ae96-629c117d1597 | Packages/c/chimpanzee-0.21-1.noarch.rpm
 cv_animals-animals | 875e42ce-d649-45c7-a443-2dc7345e815b | 215b2d60-991d-409a-aec7-f4c074f8b4f3 | e1e67711-630a-49c0-942f-7214b09508de | Packages/b/bear-4.1-1.noarch.rpm
 cv_animals-animals | 875e42ce-d649-45c7-a443-2dc7345e815b | 215b2d60-991d-409a-aec7-f4c074f8b4f3 | e1e67711-630a-49c0-942f-7214b09508de | Packages/c/camel-0.1-1.noarch.rpm
 cv_animals-animals | 875e42ce-d649-45c7-a443-2dc7345e815b | 2ac8e501-8045-4611-8168-cd0d73384801 | af231539-0458-437c-a671-d7c2df3ebb17 | Packages/c/crow-0.8-1.noarch.rpm
 cv_animals-animals | 875e42ce-d649-45c7-a443-2dc7345e815b | 2ac8e501-8045-4611-8168-cd0d73384801 | af231539-0458-437c-a671-d7c2df3ebb17 | Packages/c/cow-2.2-3.noarch.rpm
 cv_animals-animals | 875e42ce-d649-45c7-a443-2dc7345e815b | 2ac8e501-8045-4611-8168-cd0d73384801 | af231539-0458-437c-a671-d7c2df3ebb17 | Packages/c/cockateel-3.1-1.noarch.rpm
 cv_animals-animals | 875e42ce-d649-45c7-a443-2dc7345e815b | 2ac8e501-8045-4611-8168-cd0d73384801 | af231539-0458-437c-a671-d7c2df3ebb17 | Packages/b/bear-4.1-1.noarch.rpm
 cv_animals-animals | 875e42ce-d649-45c7-a443-2dc7345e815b | 2f8a99c8-7768-479d-b18f-40536a89b0d8 | 705e3e54-0826-4b67-b66e-249f05d385e6 | Packages/c/cockateel-3.1-1.noarch.rpm
 cv_animals-animals | 875e42ce-d649-45c7-a443-2dc7345e815b | 2f8a99c8-7768-479d-b18f-40536a89b0d8 | 705e3e54-0826-4b67-b66e-249f05d385e6 | Packages/b/bear-4.1-1.noarch.rpm
 cv_animals-animals | 875e42ce-d649-45c7-a443-2dc7345e815b | 2f8a99c8-7768-479d-b18f-40536a89b0d8 | 705e3e54-0826-4b67-b66e-249f05d385e6 | Packages/c/crow-0.8-1.noarch.rpm
 cv_animals-animals | 875e42ce-d649-45c7-a443-2dc7345e815b | 2f8a99c8-7768-479d-b18f-40536a89b0d8 | 705e3e54-0826-4b67-b66e-249f05d385e6 | Packages/c/cow-2.2-3.noarch.rpm
 cv_animals-animals | 875e42ce-d649-45c7-a443-2dc7345e815b | 3c94a6e6-0140-46b7-bda6-ad9fd49bfa0b | cc3097db-4ad7-4bc5-ad3b-278966ebb6d0 | Packages/b/bear-4.1-1.noarch.rpm
 cv_animals-animals | 875e42ce-d649-45c7-a443-2dc7345e815b | 3c94a6e6-0140-46b7-bda6-ad9fd49bfa0b | cc3097db-4ad7-4bc5-ad3b-278966ebb6d0 | Packages/c/crow-0.8-1.noarch.rpm
 cv_animals-animals | 875e42ce-d649-45c7-a443-2dc7345e815b | 41edfce0-212b-4376-8528-2b0f93e113ec | 162224fa-8ffd-44a9-9264-94e683595772 | Packages/b/bear-4.1-1.noarch.rpm
 cv_animals-animals | 875e42ce-d649-45c7-a443-2dc7345e815b | 41edfce0-212b-4376-8528-2b0f93e113ec | 162224fa-8ffd-44a9-9264-94e683595772 | Packages/c/cow-2.2-3.noarch.rpm
 cv_animals-animals | 875e42ce-d649-45c7-a443-2dc7345e815b | 41edfce0-212b-4376-8528-2b0f93e113ec | 162224fa-8ffd-44a9-9264-94e683595772 | Packages/c/cockateel-3.1-1.noarch.rpm
 cv_animals-animals | 875e42ce-d649-45c7-a443-2dc7345e815b | 41edfce0-212b-4376-8528-2b0f93e113ec | 162224fa-8ffd-44a9-9264-94e683595772 | Packages/c/crow-0.8-1.noarch.rpm
 cv_animals-animals | 875e42ce-d649-45c7-a443-2dc7345e815b | 432b5d6f-beaf-4309-be7f-26e0ece3e38c | ef510065-cfe1-44e2-9dfa-da98543b1a77 | Packages/c/cat-1.0-1.noarch.rpm
 cv_animals-animals | 875e42ce-d649-45c7-a443-2dc7345e815b | 432b5d6f-beaf-4309-be7f-26e0ece3e38c | ef510065-cfe1-44e2-9dfa-da98543b1a77 | Packages/c/cheetah-1.25.3-5.noarch.rpm
 cv_animals-animals | 875e42ce-d649-45c7-a443-2dc7345e815b | 45cc4d7f-ee6f-422f-bd7a-d9078c475b8b | ca5e778e-f14d-4bd7-ab87-17422d040a72 | Packages/b/bear-4.1-1.noarch.rpm
 cv_animals-animals | 875e42ce-d649-45c7-a443-2dc7345e815b | 613f338a-e3a0-4f25-906c-047dc362dacb | ae7f268c-617b-492e-b13d-a85ae70d24b3 | Packages/b/bear-4.1-1.noarch.rpm
 cv_animals-animals | 875e42ce-d649-45c7-a443-2dc7345e815b | 613f338a-e3a0-4f25-906c-047dc362dacb | ae7f268c-617b-492e-b13d-a85ae70d24b3 | Packages/c/camel-0.1-1.noarch.rpm
 cv_animals-animals | 875e42ce-d649-45c7-a443-2dc7345e815b | 613f338a-e3a0-4f25-906c-047dc362dacb | ae7f268c-617b-492e-b13d-a85ae70d24b3 | Packages/c/crow-0.8-1.noarch.rpm
 cv_animals-animals | 875e42ce-d649-45c7-a443-2dc7345e815b | 613f338a-e3a0-4f25-906c-047dc362dacb | ae7f268c-617b-492e-b13d-a85ae70d24b3 | Packages/c/cockateel-3.1-1.noarch.rpm
 cv_animals-animals | 875e42ce-d649-45c7-a443-2dc7345e815b | 613f338a-e3a0-4f25-906c-047dc362dacb | ae7f268c-617b-492e-b13d-a85ae70d24b3 | Packages/c/chimpanzee-0.21-1.noarch.rpm
 cv_animals-animals | 875e42ce-d649-45c7-a443-2dc7345e815b | 613f338a-e3a0-4f25-906c-047dc362dacb | ae7f268c-617b-492e-b13d-a85ae70d24b3 | Packages/c/cow-2.2-3.noarch.rpm
 cv_animals-animals | 875e42ce-d649-45c7-a443-2dc7345e815b | 6b5f68a9-0833-48d6-b526-e85ce78096c6 | 9a28c1c3-19b8-4ba7-91f7-9ee435644d81 | Packages/c/cockateel-3.1-1.noarch.rpm
 cv_animals-animals | 875e42ce-d649-45c7-a443-2dc7345e815b | 6b5f68a9-0833-48d6-b526-e85ce78096c6 | 9a28c1c3-19b8-4ba7-91f7-9ee435644d81 | Packages/c/cat-1.0-1.noarch.rpm
 cv_animals-animals | 875e42ce-d649-45c7-a443-2dc7345e815b | 6b5f68a9-0833-48d6-b526-e85ce78096c6 | 9a28c1c3-19b8-4ba7-91f7-9ee435644d81 | Packages/c/chimpanzee-0.21-1.noarch.rpm
 cv_animals-animals | 875e42ce-d649-45c7-a443-2dc7345e815b | 6b5f68a9-0833-48d6-b526-e85ce78096c6 | 9a28c1c3-19b8-4ba7-91f7-9ee435644d81 | Packages/c/crow-0.8-1.noarch.rpm
 cv_animals-animals | 875e42ce-d649-45c7-a443-2dc7345e815b | 7eff0f68-cd8c-40b1-8f2b-8b0898cd465b | 9408e8b1-80ab-49f8-9b60-f43882b90276 | Packages/b/bear-4.1-1.noarch.rpm
 cv_animals-animals | 875e42ce-d649-45c7-a443-2dc7345e815b | 7eff0f68-cd8c-40b1-8f2b-8b0898cd465b | 9408e8b1-80ab-49f8-9b60-f43882b90276 | Packages/c/crow-0.8-1.noarch.rpm
 cv_animals-animals | 875e42ce-d649-45c7-a443-2dc7345e815b | 8f0c16f8-6f9f-49d7-bd40-1b14ae1349af | b9cc7503-22e2-44e4-8b44-e24f42136ef1 | Packages/c/cat-1.0-1.noarch.rpm
 cv_animals-animals | 875e42ce-d649-45c7-a443-2dc7345e815b | 8f0c16f8-6f9f-49d7-bd40-1b14ae1349af | b9cc7503-22e2-44e4-8b44-e24f42136ef1 | Packages/c/cockateel-3.1-1.noarch.rpm
 cv_animals-animals | 875e42ce-d649-45c7-a443-2dc7345e815b | 8f0c16f8-6f9f-49d7-bd40-1b14ae1349af | b9cc7503-22e2-44e4-8b44-e24f42136ef1 | Packages/c/cheetah-1.25.3-5.noarch.rpm
 cv_animals-animals | 875e42ce-d649-45c7-a443-2dc7345e815b | 97dda375-892a-43ac-8b40-556eb7f01fdb | 5185d7c3-00cb-4bb5-9f7c-a41d50015bb9 | Packages/c/chimpanzee-0.21-1.noarch.rpm
 cv_animals-animals | 875e42ce-d649-45c7-a443-2dc7345e815b | 97dda375-892a-43ac-8b40-556eb7f01fdb | 5185d7c3-00cb-4bb5-9f7c-a41d50015bb9 | Packages/c/camel-0.1-1.noarch.rpm
 cv_animals-animals | 875e42ce-d649-45c7-a443-2dc7345e815b | 97dda375-892a-43ac-8b40-556eb7f01fdb | 5185d7c3-00cb-4bb5-9f7c-a41d50015bb9 | Packages/c/crow-0.8-1.noarch.rpm
 cv_animals-animals | 875e42ce-d649-45c7-a443-2dc7345e815b | 97dda375-892a-43ac-8b40-556eb7f01fdb | 5185d7c3-00cb-4bb5-9f7c-a41d50015bb9 | Packages/c/cockateel-3.1-1.noarch.rpm
 cv_animals-animals | 875e42ce-d649-45c7-a443-2dc7345e815b | b0106670-da3b-4f51-9719-c9efc97e99d4 | bb5c496c-6b0f-4f96-ba46-b616b1134930 | Packages/c/camel-0.1-1.noarch.rpm
 cv_animals-animals | 875e42ce-d649-45c7-a443-2dc7345e815b | b0106670-da3b-4f51-9719-c9efc97e99d4 | bb5c496c-6b0f-4f96-ba46-b616b1134930 | Packages/b/bear-4.1-1.noarch.rpm
 cv_animals-animals | 875e42ce-d649-45c7-a443-2dc7345e815b | b0106670-da3b-4f51-9719-c9efc97e99d4 | bb5c496c-6b0f-4f96-ba46-b616b1134930 | Packages/c/cheetah-1.25.3-5.noarch.rpm
 cv_animals-animals | 875e42ce-d649-45c7-a443-2dc7345e815b | b0106670-da3b-4f51-9719-c9efc97e99d4 | d3b4342f-67a5-4256-bc89-2a935b84302f | Packages/c/crow-0.8-1.noarch.rpm
 cv_animals-animals | 875e42ce-d649-45c7-a443-2dc7345e815b | b0106670-da3b-4f51-9719-c9efc97e99d4 | d3b4342f-67a5-4256-bc89-2a935b84302f | Packages/c/cow-2.2-3.noarch.rpm
 cv_animals-animals | 875e42ce-d649-45c7-a443-2dc7345e815b | b0106670-da3b-4f51-9719-c9efc97e99d4 | e819b4e8-2d39-4465-8ad8-e7b942491ec2 | Packages/c/chimpanzee-0.21-1.noarch.rpm
 cv_animals-animals | 875e42ce-d649-45c7-a443-2dc7345e815b | e4a7a74e-7e39-48cc-aa9a-3f4f2547977e | 0a62305e-c0e4-478f-ac36-80ebbd164745 | Packages/c/crow-0.8-1.noarch.rpm
 cv_animals-animals | 875e42ce-d649-45c7-a443-2dc7345e815b | e4a7a74e-7e39-48cc-aa9a-3f4f2547977e | 0a62305e-c0e4-478f-ac36-80ebbd164745 | Packages/c/cow-2.2-3.noarch.rpm
 cv_animals-animals | 875e42ce-d649-45c7-a443-2dc7345e815b | e4a7a74e-7e39-48cc-aa9a-3f4f2547977e | 0a62305e-c0e4-478f-ac36-80ebbd164745 | Packages/c/chimpanzee-0.21-1.noarch.rpm
 cv_animals-animals | 875e42ce-d649-45c7-a443-2dc7345e815b | e4a7a74e-7e39-48cc-aa9a-3f4f2547977e | 0a62305e-c0e4-478f-ac36-80ebbd164745 | Packages/c/cockateel-3.1-1.noarch.rpm
 cv_animals-animals | 875e42ce-d649-45c7-a443-2dc7345e815b | eed76362-09b9-405f-a4fa-b9e95e7265a6 | c6e38ad6-380f-4b31-8c2d-6e290286d3ad | Packages/c/camel-0.1-1.noarch.rpm
 cv_animals-animals | 875e42ce-d649-45c7-a443-2dc7345e815b | eed76362-09b9-405f-a4fa-b9e95e7265a6 | c6e38ad6-380f-4b31-8c2d-6e290286d3ad | Packages/c/chimpanzee-0.21-1.noarch.rpm
 cv_animals-animals | 875e42ce-d649-45c7-a443-2dc7345e815b | eed76362-09b9-405f-a4fa-b9e95e7265a6 | c6e38ad6-380f-4b31-8c2d-6e290286d3ad | Packages/c/crow-0.8-1.noarch.rpm
 cv_animals-animals | 875e42ce-d649-45c7-a443-2dc7345e815b | eed76362-09b9-405f-a4fa-b9e95e7265a6 | c6e38ad6-380f-4b31-8c2d-6e290286d3ad | Packages/c/cheetah-1.25.3-5.noarch.rpm
 cv_animals-animals | 875e42ce-d649-45c7-a443-2dc7345e815b | efdb72c3-257b-45b5-9ecb-e8eb25c62cab | d454daf7-a0cb-49d5-8ae2-6490f707eca0 | Packages/b/bear-4.1-1.noarch.rpm
(68 rows)


or another CV:
Mon Feb 21 23:42:49 CET 2022: publishing new version
Task 07623be4-0d27-4f18-9931-4b99883192d8 running: 0.0/1, 0%, elapsed: 00:00:00
Task 07623be4-0d27-4f18-9931-4b99883192d8 error: 0.18/1, 18%, 0.1/s, elapsed: 00:00:02, ETA: 00:00:10
Task 07623be4-0d27-4f18-9931-4b99883192d8 error: 0.18/1, 18%, 0.1/s, elapsed: 00:00:02, ETA: 00:00:10
Error: duplicate key value violates unique constraint "core_repositorycontent_repository_id_content_id_df902e11_uniq"
DETAIL:  Key (repository_id, content_id, version_removed_id)=(70c91ebf-312d-4496-84f5-4666587209e8, 85360d13-bbcc-447b-a7f9-79a9d2bab7a8, bb6e222c-6931-4358-81a3-2ad6103d731c) already exists.

#	su - postgres -c "psql pulpcore -c \"select crv.pulp_id,crv.number,cr.name from core_repositoryversion as crv inner join core_repository as cr on cr.pulp_id = crv.repository_id where cr.name ilike '%${reponame}%' order by (cr.name, number);\""
               pulp_id                | number |      name
--------------------------------------+--------+----------------
 93e78eb9-6c1e-4412-9cf7-4ee992ae4c08 |      0 | cv_fauna-fauna
 d4d7bf98-a3ec-40bf-bff1-7b5ecf0bc6cc |      2 | cv_fauna-fauna
 2f05cfc3-226a-4207-9dc5-28fe7a3abda2 |      5 | cv_fauna-fauna
 4e31f640-7c0e-44a6-8d1c-9f246abf2eff |      6 | cv_fauna-fauna
 e2d40587-421e-4de7-9ca1-c3eb75bfe862 |     13 | cv_fauna-fauna
 2bef98e7-6b39-405e-8ede-f1c4b1bb8c50 |     15 | cv_fauna-fauna
 9f7a6f85-7205-469a-9391-c87f5158f53d |     17 | cv_fauna-fauna
 d3b898b5-8384-4e58-814d-bcfa60a728a5 |     19 | cv_fauna-fauna
 a8e32ca0-0cb4-4074-a89d-3a7fb32a7884 |     21 | cv_fauna-fauna
 e8a23961-83c7-4422-b312-8d55b7c77085 |     23 | cv_fauna-fauna
 ca7da67c-74b7-4c79-9444-8cbffaf6e949 |     25 | cv_fauna-fauna
 cc2f8d17-512e-48e0-b6b7-236cd601107f |     29 | cv_fauna-fauna
 e5be519a-7306-4964-b824-9d50b5eaa32a |     31 | cv_fauna-fauna
 d79f5e18-b1fd-4040-a38f-eea74d189d16 |     33 | cv_fauna-fauna
 71a4dd06-d374-4ae7-82b1-95677df9c531 |     35 | cv_fauna-fauna
 ac375d05-543d-4f44-a307-b25228682529 |     37 | cv_fauna-fauna
 e82627fd-51d2-4359-bc2a-2750f0e2aa7e |     38 | cv_fauna-fauna
 431334ca-8629-4903-be45-6ca660071540 |     39 | cv_fauna-fauna
 e17757b4-769f-428e-9586-549507affeee |     41 | cv_fauna-fauna
 a3f1a49c-1c00-4fa1-ad3c-5547f11ffc34 |     43 | cv_fauna-fauna
 df004a6c-a259-401b-b9ae-de2e9cdc9e77 |     45 | cv_fauna-fauna
 8606e6ca-f79a-488f-83e8-a907086d4f90 |     47 | cv_fauna-fauna
 35f9ab4d-c147-41fe-ac13-fd852645932e |     49 | cv_fauna-fauna
 fb3b1d55-005c-4685-9103-c01f1e71664a |     51 | cv_fauna-fauna
 9c93da05-7460-4ce0-bfc9-6f5f5f099e87 |     53 | cv_fauna-fauna
 099d37cd-b435-46a3-aa1a-70956a6ceace |     55 | cv_fauna-fauna
 3e66b864-f095-4dda-8fc5-ea5a125c4e04 |     57 | cv_fauna-fauna
 388b5c31-dcdd-459d-9caf-fd72e05ed73a |     59 | cv_fauna-fauna
 225744cb-f939-4c40-bb11-f2178d82d398 |     61 | cv_fauna-fauna
 9fb56487-aebe-4f58-a834-d4d4dca858d5 |     63 | cv_fauna-fauna
 825364d7-9874-47ff-97c4-e720a4b7bb01 |     64 | cv_fauna-fauna
 b1087686-ec45-47db-97ef-896869251fa4 |     67 | cv_fauna-fauna
 8d9a53de-9111-448e-b889-a0d17dd72e5c |     69 | cv_fauna-fauna
 d40cb17e-8f95-4395-b9d7-123f757a91fd |     71 | cv_fauna-fauna
 64d4ae70-f8ef-41c0-8349-72a4c55ad216 |     76 | cv_fauna-fauna
 db4c4058-7d4c-4890-a24a-49104a4377a8 |     80 | cv_fauna-fauna
 021631be-3c62-49f5-afac-494b370b9035 |     82 | cv_fauna-fauna
 69e763bc-eb0a-44eb-97f4-59d5e73207ea |     84 | cv_fauna-fauna
 75152775-b749-4206-b307-724a3c2003d2 |     86 | cv_fauna-fauna
 45ab35d1-2c2b-4000-ac81-563cf7fe4130 |     87 | cv_fauna-fauna
 e3079c79-c848-47d4-80a3-ed8e4b337520 |     88 | cv_fauna-fauna
 c0932c20-20f7-42a0-8f41-5fb4e0af3fb2 |     90 | cv_fauna-fauna
 5f43ce2c-86f7-4700-8244-ed1867ded3ce |     91 | cv_fauna-fauna
 d1e00471-69e8-46b6-b7a1-0192a680ee2a |     92 | cv_fauna-fauna
 47259257-8de5-49a5-bc6f-791adc03a0ee |     93 | cv_fauna-fauna
 9c586583-35d8-4ee2-9e76-2d5cecc1ef8b |     94 | cv_fauna-fauna
 7b9cea8b-9008-462d-bd2a-75b172a81ef4 |     95 | cv_fauna-fauna
 3db55107-cb28-46a9-bc7d-b6dd2d290584 |     96 | cv_fauna-fauna
 78cd61ea-6d26-477a-bd71-82db587bbbcd |     97 | cv_fauna-fauna
 c3aa316e-6424-4bc0-8a16-7f78dc511fff |     98 | cv_fauna-fauna
 dc7bcde2-8059-4fe6-af12-efc95e661479 |     99 | cv_fauna-fauna
 ae32af13-09cf-435e-804c-b997b26c8a25 |    100 | cv_fauna-fauna
 adccd3d5-ec1b-4078-b20d-f1a9ddf77399 |    101 | cv_fauna-fauna
 d7482ad5-711a-4217-b5ef-96f20b4e03c6 |    102 | cv_fauna-fauna
 d5757447-3f26-472d-8d8b-f29d974ddf92 |    104 | cv_fauna-fauna
 2e27df43-e1e9-49f0-a0d7-2e964d671571 |    105 | cv_fauna-fauna
 0e79e9f2-2d4d-4b5f-ab7b-195292364bcd |    106 | cv_fauna-fauna
 efad5e94-99d4-400a-9da4-d6bcad6e7692 |    107 | cv_fauna-fauna
(58 rows)

#	su - postgres -c "psql pulpcore -c \"SELECT cr.name,crc.repository_id,crc.version_added_id,crc.version_removed_id,replace(rp.location_href,'Packages/j/','') AS filename FROM core_repositorycontent AS crc INNER JOIN core_repository AS cr ON cr.pulp_id = crc.repository_id INNER JOIN rpm_package AS rp ON rp.content_ptr_id = crc.content_id WHERE cr.name ILIKE '%${reponame}%' ORDER BY repository_id, version_added_id, version_removed_id;\""
      name      |            repository_id             |           version_added_id           |          version_removed_id          |                filename
----------------+--------------------------------------+--------------------------------------+--------------------------------------+-----------------------------------------
 cv_fauna-fauna | 70c91ebf-312d-4496-84f5-4666587209e8 | 0e79e9f2-2d4d-4b5f-ab7b-195292364bcd |                                      | Packages/c/chimpanzee-0.21-1.noarch.rpm
 cv_fauna-fauna | 70c91ebf-312d-4496-84f5-4666587209e8 | 2e27df43-e1e9-49f0-a0d7-2e964d671571 |                                      | Packages/c/crow-0.8-1.noarch.rpm
 cv_fauna-fauna | 70c91ebf-312d-4496-84f5-4666587209e8 | 2e27df43-e1e9-49f0-a0d7-2e964d671571 |                                      | Packages/c/cat-1.0-1.noarch.rpm
 cv_fauna-fauna | 70c91ebf-312d-4496-84f5-4666587209e8 | 2e27df43-e1e9-49f0-a0d7-2e964d671571 |                                      | Packages/b/bear-4.1-1.noarch.rpm
 cv_fauna-fauna | 70c91ebf-312d-4496-84f5-4666587209e8 | 2e27df43-e1e9-49f0-a0d7-2e964d671571 |                                      | Packages/c/cow-2.2-3.noarch.rpm
 cv_fauna-fauna | 70c91ebf-312d-4496-84f5-4666587209e8 | 2f05cfc3-226a-4207-9dc5-28fe7a3abda2 | d3b898b5-8384-4e58-814d-bcfa60a728a5 | Packages/c/cow-2.2-3.noarch.rpm
 cv_fauna-fauna | 70c91ebf-312d-4496-84f5-4666587209e8 | 2f05cfc3-226a-4207-9dc5-28fe7a3abda2 | e2d40587-421e-4de7-9ca1-c3eb75bfe862 | Packages/c/crow-0.8-1.noarch.rpm
 cv_fauna-fauna | 70c91ebf-312d-4496-84f5-4666587209e8 | 2f05cfc3-226a-4207-9dc5-28fe7a3abda2 | e2d40587-421e-4de7-9ca1-c3eb75bfe862 | Packages/c/chimpanzee-0.21-1.noarch.rpm
 cv_fauna-fauna | 70c91ebf-312d-4496-84f5-4666587209e8 | 2f05cfc3-226a-4207-9dc5-28fe7a3abda2 |                                      | Packages/c/cheetah-1.25.3-5.noarch.rpm
 cv_fauna-fauna | 70c91ebf-312d-4496-84f5-4666587209e8 | 2f05cfc3-226a-4207-9dc5-28fe7a3abda2 |                                      | Packages/b/bear-4.1-1.noarch.rpm
 cv_fauna-fauna | 70c91ebf-312d-4496-84f5-4666587209e8 | 2f05cfc3-226a-4207-9dc5-28fe7a3abda2 |                                      | Packages/c/cat-1.0-1.noarch.rpm
 cv_fauna-fauna | 70c91ebf-312d-4496-84f5-4666587209e8 | 45ab35d1-2c2b-4000-ac81-563cf7fe4130 | e3079c79-c848-47d4-80a3-ed8e4b337520 | Packages/b/bear-4.1-1.noarch.rpm
 cv_fauna-fauna | 70c91ebf-312d-4496-84f5-4666587209e8 | 47259257-8de5-49a5-bc6f-791adc03a0ee | 9c586583-35d8-4ee2-9e76-2d5cecc1ef8b | Packages/b/bear-4.1-1.noarch.rpm
 cv_fauna-fauna | 70c91ebf-312d-4496-84f5-4666587209e8 | 47259257-8de5-49a5-bc6f-791adc03a0ee | 9c586583-35d8-4ee2-9e76-2d5cecc1ef8b | Packages/c/cheetah-1.25.3-5.noarch.rpm
 cv_fauna-fauna | 70c91ebf-312d-4496-84f5-4666587209e8 | 47259257-8de5-49a5-bc6f-791adc03a0ee | 9c586583-35d8-4ee2-9e76-2d5cecc1ef8b | Packages/c/crow-0.8-1.noarch.rpm
 cv_fauna-fauna | 70c91ebf-312d-4496-84f5-4666587209e8 | 4e31f640-7c0e-44a6-8d1c-9f246abf2eff | d40cb17e-8f95-4395-b9d7-123f757a91fd | Packages/c/cockateel-3.1-1.noarch.rpm
 cv_fauna-fauna | 70c91ebf-312d-4496-84f5-4666587209e8 | 4e31f640-7c0e-44a6-8d1c-9f246abf2eff |                                      | Packages/c/camel-0.1-1.noarch.rpm
 cv_fauna-fauna | 70c91ebf-312d-4496-84f5-4666587209e8 | 5f43ce2c-86f7-4700-8244-ed1867ded3ce | d1e00471-69e8-46b6-b7a1-0192a680ee2a | Packages/c/crow-0.8-1.noarch.rpm
 cv_fauna-fauna | 70c91ebf-312d-4496-84f5-4666587209e8 | 5f43ce2c-86f7-4700-8244-ed1867ded3ce | d1e00471-69e8-46b6-b7a1-0192a680ee2a | Packages/c/chimpanzee-0.21-1.noarch.rpm
 cv_fauna-fauna | 70c91ebf-312d-4496-84f5-4666587209e8 | 5f43ce2c-86f7-4700-8244-ed1867ded3ce | d1e00471-69e8-46b6-b7a1-0192a680ee2a | Packages/b/bear-4.1-1.noarch.rpm
 cv_fauna-fauna | 70c91ebf-312d-4496-84f5-4666587209e8 | 78cd61ea-6d26-477a-bd71-82db587bbbcd | c3aa316e-6424-4bc0-8a16-7f78dc511fff | Packages/c/crow-0.8-1.noarch.rpm
 cv_fauna-fauna | 70c91ebf-312d-4496-84f5-4666587209e8 | 78cd61ea-6d26-477a-bd71-82db587bbbcd | c3aa316e-6424-4bc0-8a16-7f78dc511fff | Packages/c/cheetah-1.25.3-5.noarch.rpm
 cv_fauna-fauna | 70c91ebf-312d-4496-84f5-4666587209e8 | 78cd61ea-6d26-477a-bd71-82db587bbbcd | c3aa316e-6424-4bc0-8a16-7f78dc511fff | Packages/b/bear-4.1-1.noarch.rpm
 cv_fauna-fauna | 70c91ebf-312d-4496-84f5-4666587209e8 | 78cd61ea-6d26-477a-bd71-82db587bbbcd | c3aa316e-6424-4bc0-8a16-7f78dc511fff | Packages/c/cat-1.0-1.noarch.rpm
 cv_fauna-fauna | 70c91ebf-312d-4496-84f5-4666587209e8 | 7b9cea8b-9008-462d-bd2a-75b172a81ef4 | 3db55107-cb28-46a9-bc7d-b6dd2d290584 | Packages/c/crow-0.8-1.noarch.rpm
 cv_fauna-fauna | 70c91ebf-312d-4496-84f5-4666587209e8 | 7b9cea8b-9008-462d-bd2a-75b172a81ef4 | 3db55107-cb28-46a9-bc7d-b6dd2d290584 | Packages/c/cheetah-1.25.3-5.noarch.rpm
 cv_fauna-fauna | 70c91ebf-312d-4496-84f5-4666587209e8 | 7b9cea8b-9008-462d-bd2a-75b172a81ef4 | 3db55107-cb28-46a9-bc7d-b6dd2d290584 | Packages/b/bear-4.1-1.noarch.rpm
 cv_fauna-fauna | 70c91ebf-312d-4496-84f5-4666587209e8 | 825364d7-9874-47ff-97c4-e720a4b7bb01 |                                      | Packages/c/chimpanzee-0.21-1.noarch.rpm
 cv_fauna-fauna | 70c91ebf-312d-4496-84f5-4666587209e8 | adccd3d5-ec1b-4078-b20d-f1a9ddf77399 | d7482ad5-711a-4217-b5ef-96f20b4e03c6 | Packages/c/chimpanzee-0.21-1.noarch.rpm
 cv_fauna-fauna | 70c91ebf-312d-4496-84f5-4666587209e8 | adccd3d5-ec1b-4078-b20d-f1a9ddf77399 | d7482ad5-711a-4217-b5ef-96f20b4e03c6 | Packages/c/crow-0.8-1.noarch.rpm
 cv_fauna-fauna | 70c91ebf-312d-4496-84f5-4666587209e8 | adccd3d5-ec1b-4078-b20d-f1a9ddf77399 | d7482ad5-711a-4217-b5ef-96f20b4e03c6 | Packages/c/cow-2.2-3.noarch.rpm
 cv_fauna-fauna | 70c91ebf-312d-4496-84f5-4666587209e8 | adccd3d5-ec1b-4078-b20d-f1a9ddf77399 | d7482ad5-711a-4217-b5ef-96f20b4e03c6 | Packages/b/bear-4.1-1.noarch.rpm
 cv_fauna-fauna | 70c91ebf-312d-4496-84f5-4666587209e8 | adccd3d5-ec1b-4078-b20d-f1a9ddf77399 | d7482ad5-711a-4217-b5ef-96f20b4e03c6 | Packages/c/cat-1.0-1.noarch.rpm
 cv_fauna-fauna | 70c91ebf-312d-4496-84f5-4666587209e8 | dc7bcde2-8059-4fe6-af12-efc95e661479 | ae32af13-09cf-435e-804c-b997b26c8a25 | Packages/c/cow-2.2-3.noarch.rpm
 cv_fauna-fauna | 70c91ebf-312d-4496-84f5-4666587209e8 | dc7bcde2-8059-4fe6-af12-efc95e661479 | ae32af13-09cf-435e-804c-b997b26c8a25 | Packages/b/bear-4.1-1.noarch.rpm
 cv_fauna-fauna | 70c91ebf-312d-4496-84f5-4666587209e8 | dc7bcde2-8059-4fe6-af12-efc95e661479 | ae32af13-09cf-435e-804c-b997b26c8a25 | Packages/c/crow-0.8-1.noarch.rpm
 cv_fauna-fauna | 70c91ebf-312d-4496-84f5-4666587209e8 | dc7bcde2-8059-4fe6-af12-efc95e661479 | ae32af13-09cf-435e-804c-b997b26c8a25 | Packages/c/cat-1.0-1.noarch.rpm
 cv_fauna-fauna | 70c91ebf-312d-4496-84f5-4666587209e8 | dc7bcde2-8059-4fe6-af12-efc95e661479 | ae32af13-09cf-435e-804c-b997b26c8a25 | Packages/c/chimpanzee-0.21-1.noarch.rpm
 cv_fauna-fauna | 70c91ebf-312d-4496-84f5-4666587209e8 | e82627fd-51d2-4359-bc2a-2750f0e2aa7e | 431334ca-8629-4903-be45-6ca660071540 | Packages/c/cheetah-1.25.3-5.noarch.rpm
 cv_fauna-fauna | 70c91ebf-312d-4496-84f5-4666587209e8 | e82627fd-51d2-4359-bc2a-2750f0e2aa7e | 431334ca-8629-4903-be45-6ca660071540 | Packages/c/chimpanzee-0.21-1.noarch.rpm
 cv_fauna-fauna | 70c91ebf-312d-4496-84f5-4666587209e8 | e82627fd-51d2-4359-bc2a-2750f0e2aa7e | 431334ca-8629-4903-be45-6ca660071540 | Packages/c/cockateel-3.1-1.noarch.rpm
 cv_fauna-fauna | 70c91ebf-312d-4496-84f5-4666587209e8 | e82627fd-51d2-4359-bc2a-2750f0e2aa7e | 431334ca-8629-4903-be45-6ca660071540 | Packages/c/cat-1.0-1.noarch.rpm
 cv_fauna-fauna | 70c91ebf-312d-4496-84f5-4666587209e8 | e82627fd-51d2-4359-bc2a-2750f0e2aa7e | 431334ca-8629-4903-be45-6ca660071540 | Packages/c/camel-0.1-1.noarch.rpm
 cv_fauna-fauna | 70c91ebf-312d-4496-84f5-4666587209e8 | efad5e94-99d4-400a-9da4-d6bcad6e7692 |                                      | Packages/c/cockateel-3.1-1.noarch.rpm
(44 rows)



or third CV:
Tue Feb 22 02:55:44 CET 2022: publishing new version
Task fed73a48-5232-4426-ace7-552cb936c467 running: 0.05/1, 5%, elapsed: 00:00:00
Task fed73a48-5232-4426-ace7-552cb936c467 error: 0.18/1, 18%, elapsed: 00:00:02
Task fed73a48-5232-4426-ace7-552cb936c467 error: 0.18/1, 18%, elapsed: 00:00:02
Error: duplicate key value violates unique constraint "core_repositorycontent_repository_id_content_id_df902e11_uniq"
DETAIL:  Key (repository_id, content_id, version_removed_id)=(bec7db55-97e6-421a-ba0f-d862c92b95b2, 953ef86d-96ba-42d7-99c7-b9e494f3dc2c, 4dbf14dc-7f01-4565-8530-73a2d179361f) already exists.

#	su - postgres -c "psql pulpcore -c \"select crv.pulp_id,crv.number,cr.name from core_repositoryversion as crv inner join core_repository as cr on cr.pulp_id = crv.repository_id where cr.name ilike '%${reponame}%' order by (cr.name, number);\""
               pulp_id                | number |      name
--------------------------------------+--------+-----------------
 5f615709-f0fc-4c8e-b403-6f1ed61ee9d2 |      0 | cv_zoo-zoo_repo
 37d4aa68-2a70-47b1-9aa8-c9afef446376 |      1 | cv_zoo-zoo_repo
 c0f44e5b-ea95-484c-b97d-e4dbe219df87 |      2 | cv_zoo-zoo_repo
 ea874ff0-84e7-41e0-8155-f8bb024b7a89 |      3 | cv_zoo-zoo_repo
 ec797939-4eee-411b-8d8a-dcb30987cc79 |      4 | cv_zoo-zoo_repo
 65a88008-80f7-4f2f-8146-eaf30d47ffeb |      6 | cv_zoo-zoo_repo
 a26f2c01-dd86-4086-a3e4-cde234ce9163 |      8 | cv_zoo-zoo_repo
 7cb6066e-c95f-4705-bc4b-66e83e0fdd41 |     10 | cv_zoo-zoo_repo
 3910bfed-9db1-4528-9938-e0b041b7ac5c |     12 | cv_zoo-zoo_repo
 2d80b41c-d949-4689-951a-ec45bd24d523 |     14 | cv_zoo-zoo_repo
 24c82c4f-b63f-42cc-86bb-5a397db2ee13 |     18 | cv_zoo-zoo_repo
 699751e2-93ad-4650-ba93-6d24dbc4aec5 |     20 | cv_zoo-zoo_repo
 125b0a7a-7b19-4582-be92-cc1feb774499 |     22 | cv_zoo-zoo_repo
 94935f69-6f41-4fbf-be69-8e72ca18e5ae |     24 | cv_zoo-zoo_repo
 c268565f-0b03-488a-96ef-2890ddb565ab |     26 | cv_zoo-zoo_repo
 dec7debb-ea74-4311-822f-e2bf2fb1bc7c |     28 | cv_zoo-zoo_repo
 c72b20fd-728e-450b-8251-9e9d82d7c5b3 |     30 | cv_zoo-zoo_repo
 79c63c16-69d5-432c-89fe-e0cfe5335f9c |     32 | cv_zoo-zoo_repo
 e11eb6d7-8c3b-4e5d-b321-44f4390f3c75 |     34 | cv_zoo-zoo_repo
 690137cf-0085-4e01-805a-c6801e71e76c |     36 | cv_zoo-zoo_repo
 4fcd7e45-9142-455d-92cb-9c4131e4baaa |     38 | cv_zoo-zoo_repo
 64e1748d-9b9a-4468-bee9-4cef6362a7f6 |     40 | cv_zoo-zoo_repo
 2e22310d-e9c2-49d2-84f0-cd0a9eea30b1 |     42 | cv_zoo-zoo_repo
 f26cb1d5-eb89-4042-b885-24a4865514a7 |     44 | cv_zoo-zoo_repo
 3854c665-238f-47bd-b99f-1cd18d2e84de |     46 | cv_zoo-zoo_repo
 d0a78e63-f91c-43a0-a19a-84ad082a6b98 |     48 | cv_zoo-zoo_repo
 5ccfcccd-b907-4a94-97d4-22dd37850b16 |     50 | cv_zoo-zoo_repo
 719f2046-a87e-46a4-956b-3dd9a36ec876 |     52 | cv_zoo-zoo_repo
 d601db22-8661-4e76-8ced-339a85db6214 |     54 | cv_zoo-zoo_repo
 382d66b3-57fb-4126-b96d-90d100f7ad0a |     56 | cv_zoo-zoo_repo
 d595eff2-8d95-459b-ac37-3abe3cb30baa |     58 | cv_zoo-zoo_repo
 19bb0265-657d-46a0-873f-c742a1aed2d2 |     60 | cv_zoo-zoo_repo
 98485cd2-f01f-4535-a5e6-37cf91969679 |     62 | cv_zoo-zoo_repo
 80ddbe32-2db5-4bd4-8713-0c9099964ba0 |     64 | cv_zoo-zoo_repo
 48da02cc-21b1-41cd-98af-82b3515143c6 |     66 | cv_zoo-zoo_repo
 3b55d354-2e5a-478f-84a0-8dad33fc68ae |     68 | cv_zoo-zoo_repo
 007c9267-2da6-4a36-9937-8d29d9a76237 |     70 | cv_zoo-zoo_repo
 b226d599-23fc-4c94-8193-5b455408bb13 |     72 | cv_zoo-zoo_repo
 ad5f8988-bc78-437c-b09e-e2032a38624a |     74 | cv_zoo-zoo_repo
 187ae66c-07ae-4df9-a8bc-5dcb15df4107 |     77 | cv_zoo-zoo_repo
 e54e6089-cd8d-4f7d-9056-26314b6888f3 |     79 | cv_zoo-zoo_repo
 1616f77a-b25d-4d7e-8038-6dbeb1ee2bb5 |     81 | cv_zoo-zoo_repo
 160eac82-96cb-4bdd-bca5-a33179e49c11 |     83 | cv_zoo-zoo_repo
 2481ae10-d119-47f3-9e1b-32c9be4053c0 |     86 | cv_zoo-zoo_repo
 55a50e1d-e405-4b3d-82c1-73b0e3f37d5f |     88 | cv_zoo-zoo_repo
..
(few hundreds of versions)


#	su - postgres -c "psql pulpcore -c \"SELECT cr.name,crc.repository_id,crc.version_added_id,crc.version_removed_id,replace(rp.location_href,'Packages/j/','') AS filename FROM core_repositorycontent AS crc INNER JOIN core_repository AS cr ON cr.pulp_id = crc.repository_id INNER JOIN rpm_package AS rp ON rp.content_ptr_id = crc.content_id WHERE cr.name ILIKE '%${reponame}%' ORDER BY repository_id, version_added_id, version_removed_id;\""
      name       |            repository_id             |           version_added_id           |          version_removed_id          |                filename
-----------------+--------------------------------------+--------------------------------------+--------------------------------------+-----------------------------------------
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | 085dd97f-f3ea-46a0-92c7-56e683f132ae | 84d06b42-337d-45d7-a075-183b2d797c56 | Packages/c/cheetah-1.25.3-5.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | 09ec7e8a-ef8a-426b-b097-0dcf7b7d487e | 290456cc-7793-41e6-bd63-2c017a2974cf | Packages/b/bear-4.1-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | 09ec7e8a-ef8a-426b-b097-0dcf7b7d487e | 290456cc-7793-41e6-bd63-2c017a2974cf | Packages/c/camel-0.1-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | 09ec7e8a-ef8a-426b-b097-0dcf7b7d487e | 290456cc-7793-41e6-bd63-2c017a2974cf | Packages/c/cheetah-1.25.3-5.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | 0e28bf3b-a2f5-40ac-a8cb-30748af7b049 | d07ff9e2-3be7-414e-bc8f-3e7ecb87ce3e | Packages/c/camel-0.1-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | 0e28bf3b-a2f5-40ac-a8cb-30748af7b049 | d07ff9e2-3be7-414e-bc8f-3e7ecb87ce3e | Packages/c/cat-1.0-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | 0e28bf3b-a2f5-40ac-a8cb-30748af7b049 | d07ff9e2-3be7-414e-bc8f-3e7ecb87ce3e | Packages/c/cow-2.2-3.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | 0e28bf3b-a2f5-40ac-a8cb-30748af7b049 | d07ff9e2-3be7-414e-bc8f-3e7ecb87ce3e | Packages/c/cheetah-1.25.3-5.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | 15be7db3-a6e6-4f17-8828-81dc3e23bd12 |                                      | Packages/b/bear-4.1-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | 15be7db3-a6e6-4f17-8828-81dc3e23bd12 |                                      | Packages/c/cow-2.2-3.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | 15be7db3-a6e6-4f17-8828-81dc3e23bd12 |                                      | Packages/c/cat-1.0-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | 15be7db3-a6e6-4f17-8828-81dc3e23bd12 |                                      | Packages/c/cockateel-3.1-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | 223f4581-95b3-40ae-a9a3-51b37022bc6e | dbf1374e-cc94-424f-87df-51cf3dee41b2 | Packages/c/crow-0.8-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | 223f4581-95b3-40ae-a9a3-51b37022bc6e | dbf1374e-cc94-424f-87df-51cf3dee41b2 | Packages/c/cow-2.2-3.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | 223f4581-95b3-40ae-a9a3-51b37022bc6e | dbf1374e-cc94-424f-87df-51cf3dee41b2 | Packages/c/cheetah-1.25.3-5.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | 26281ef8-35c7-4e0e-94b1-41cf997ed694 | 23a48d8d-5661-4968-a0e9-3543fef05d6d | Packages/c/cheetah-1.25.3-5.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | 26281ef8-35c7-4e0e-94b1-41cf997ed694 | 23a48d8d-5661-4968-a0e9-3543fef05d6d | Packages/c/camel-0.1-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | 26281ef8-35c7-4e0e-94b1-41cf997ed694 | 23a48d8d-5661-4968-a0e9-3543fef05d6d | Packages/c/cat-1.0-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | 26281ef8-35c7-4e0e-94b1-41cf997ed694 | 23a48d8d-5661-4968-a0e9-3543fef05d6d | Packages/c/cockateel-3.1-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | 37d4aa68-2a70-47b1-9aa8-c9afef446376 | ec797939-4eee-411b-8d8a-dcb30987cc79 | Packages/b/bear-4.1-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | 39f7c023-1a66-43c1-b08a-8be5c39fcd5c |                                      | Packages/c/cheetah-1.25.3-5.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | 3f473b91-d1d3-4aeb-bd7d-b03811e5c3a2 | 23286f68-c874-47c3-b418-271039cb205c | Packages/c/chimpanzee-0.21-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | 3f473b91-d1d3-4aeb-bd7d-b03811e5c3a2 | 23286f68-c874-47c3-b418-271039cb205c | Packages/c/cheetah-1.25.3-5.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | 3f473b91-d1d3-4aeb-bd7d-b03811e5c3a2 | 23286f68-c874-47c3-b418-271039cb205c | Packages/b/bear-4.1-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | 3f473b91-d1d3-4aeb-bd7d-b03811e5c3a2 | 23286f68-c874-47c3-b418-271039cb205c | Packages/c/camel-0.1-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | 3f473b91-d1d3-4aeb-bd7d-b03811e5c3a2 | 23286f68-c874-47c3-b418-271039cb205c | Packages/c/cat-1.0-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | 40585c87-fbe5-4d6e-8821-fef1aa27562b |                                      | Packages/c/cat-1.0-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | 40585c87-fbe5-4d6e-8821-fef1aa27562b |                                      | Packages/c/camel-0.1-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | 43a8aa5d-e459-4474-b782-ff5483e80c41 | 6a20f8f0-f410-41b5-af8e-c19bed55b579 | Packages/c/camel-0.1-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | 4578d0e8-895a-4ea5-9c62-8be5de68db0b | f95ad8bf-578a-43c2-a051-4aaa0da5e0c7 | Packages/c/cat-1.0-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | 4578d0e8-895a-4ea5-9c62-8be5de68db0b | f95ad8bf-578a-43c2-a051-4aaa0da5e0c7 | Packages/b/bear-4.1-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | 4578d0e8-895a-4ea5-9c62-8be5de68db0b | f95ad8bf-578a-43c2-a051-4aaa0da5e0c7 | Packages/c/crow-0.8-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | 459641fc-a6f6-42e7-b846-e7eec694928e | 3e1113bb-fb42-4e32-af98-6d19d981d940 | Packages/c/cow-2.2-3.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | 459641fc-a6f6-42e7-b846-e7eec694928e | 3e1113bb-fb42-4e32-af98-6d19d981d940 | Packages/c/cheetah-1.25.3-5.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | 459641fc-a6f6-42e7-b846-e7eec694928e | 3e1113bb-fb42-4e32-af98-6d19d981d940 | Packages/c/cockateel-3.1-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | 61ae7cd2-a642-4598-972b-09db29ba75fc | 12e00be0-6e08-45b8-babd-40523767fde2 | Packages/c/cat-1.0-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | 61ae7cd2-a642-4598-972b-09db29ba75fc | 12e00be0-6e08-45b8-babd-40523767fde2 | Packages/c/crow-0.8-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | 61ae7cd2-a642-4598-972b-09db29ba75fc | 12e00be0-6e08-45b8-babd-40523767fde2 | Packages/c/cheetah-1.25.3-5.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | 620eff7e-b783-46d7-8a60-b5df943f6044 | 26c8c7a6-67c9-437c-81c2-4322a64af7ff | Packages/c/cheetah-1.25.3-5.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | 620eff7e-b783-46d7-8a60-b5df943f6044 | 26c8c7a6-67c9-437c-81c2-4322a64af7ff | Packages/c/chimpanzee-0.21-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | 620eff7e-b783-46d7-8a60-b5df943f6044 | 26c8c7a6-67c9-437c-81c2-4322a64af7ff | Packages/c/cockateel-3.1-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | 620eff7e-b783-46d7-8a60-b5df943f6044 | 26c8c7a6-67c9-437c-81c2-4322a64af7ff | Packages/c/cat-1.0-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | 620eff7e-b783-46d7-8a60-b5df943f6044 | 26c8c7a6-67c9-437c-81c2-4322a64af7ff | Packages/c/camel-0.1-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | 620eff7e-b783-46d7-8a60-b5df943f6044 | 26c8c7a6-67c9-437c-81c2-4322a64af7ff | Packages/b/bear-4.1-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | 64cf9ca3-0a38-440e-9981-d31e9143ad7e | 8a425063-f1b5-4c78-8041-f3f7019b9e14 | Packages/c/camel-0.1-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | 64cf9ca3-0a38-440e-9981-d31e9143ad7e | 8a425063-f1b5-4c78-8041-f3f7019b9e14 | Packages/b/bear-4.1-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | 64cf9ca3-0a38-440e-9981-d31e9143ad7e | 8a425063-f1b5-4c78-8041-f3f7019b9e14 | Packages/c/cockateel-3.1-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | 64cf9ca3-0a38-440e-9981-d31e9143ad7e | 8a425063-f1b5-4c78-8041-f3f7019b9e14 | Packages/c/cow-2.2-3.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | 64cf9ca3-0a38-440e-9981-d31e9143ad7e | 8a425063-f1b5-4c78-8041-f3f7019b9e14 | Packages/c/cat-1.0-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | 6b1b0ebb-ef67-4ada-a26f-712260262f3b | 28057c7f-df96-4d72-81aa-dba7c515d258 | Packages/c/camel-0.1-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | 6b1b0ebb-ef67-4ada-a26f-712260262f3b | 28057c7f-df96-4d72-81aa-dba7c515d258 | Packages/c/chimpanzee-0.21-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | 6b1b0ebb-ef67-4ada-a26f-712260262f3b | 28057c7f-df96-4d72-81aa-dba7c515d258 | Packages/c/crow-0.8-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | 6b1b0ebb-ef67-4ada-a26f-712260262f3b | 28057c7f-df96-4d72-81aa-dba7c515d258 | Packages/c/cheetah-1.25.3-5.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | 6d52f179-ff91-4047-aaa9-b5e8400385a4 | f2ea7fec-b566-4484-ac35-204f50a8324b | Packages/c/crow-0.8-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | 6d52f179-ff91-4047-aaa9-b5e8400385a4 | f2ea7fec-b566-4484-ac35-204f50a8324b | Packages/c/camel-0.1-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | 6d52f179-ff91-4047-aaa9-b5e8400385a4 | f2ea7fec-b566-4484-ac35-204f50a8324b | Packages/c/cockateel-3.1-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | 80b431e1-5bd3-4af1-bae0-4d3f87151880 |                                      | Packages/c/chimpanzee-0.21-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | 84d06b42-337d-45d7-a075-183b2d797c56 | f19dcfbe-81d1-443e-afbd-25ba66dca8ab | Packages/c/cow-2.2-3.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | 86252a25-da9c-4a0b-a011-1220c518f938 | 189b086f-1df8-41fa-bacd-0b86b3b33635 | Packages/c/camel-0.1-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | 86252a25-da9c-4a0b-a011-1220c518f938 | 189b086f-1df8-41fa-bacd-0b86b3b33635 | Packages/c/cow-2.2-3.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | 86252a25-da9c-4a0b-a011-1220c518f938 | 189b086f-1df8-41fa-bacd-0b86b3b33635 | Packages/c/cat-1.0-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | 86252a25-da9c-4a0b-a011-1220c518f938 | 189b086f-1df8-41fa-bacd-0b86b3b33635 | Packages/c/chimpanzee-0.21-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | 925a4ccf-a6e0-4cc7-bed5-3f61ba21fc86 | d935b4d8-82ba-4c10-b582-e58af782a440 | Packages/c/cheetah-1.25.3-5.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | 9c4c60be-468f-4e47-9aaa-b785f4a044ca | 5163c1be-705d-47ef-8b49-0a171fe93d4a | Packages/c/cow-2.2-3.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | 9de8c948-3c23-48c1-a314-16abbcb6b0ed | fa9c5d25-6dc6-40f4-86c8-133ea2cc87ad | Packages/b/bear-4.1-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | 9de8c948-3c23-48c1-a314-16abbcb6b0ed | fa9c5d25-6dc6-40f4-86c8-133ea2cc87ad | Packages/c/camel-0.1-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | 9e19d66b-a344-4b10-a6b5-d9a1ad5afed7 | 60a4f760-797e-47e1-ac39-565032d1c6a3 | Packages/c/camel-0.1-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | 9e19d66b-a344-4b10-a6b5-d9a1ad5afed7 | 60a4f760-797e-47e1-ac39-565032d1c6a3 | Packages/c/cockateel-3.1-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | 9e19d66b-a344-4b10-a6b5-d9a1ad5afed7 | 60a4f760-797e-47e1-ac39-565032d1c6a3 | Packages/c/crow-0.8-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | 9e19d66b-a344-4b10-a6b5-d9a1ad5afed7 | 60a4f760-797e-47e1-ac39-565032d1c6a3 | Packages/b/bear-4.1-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | 9e19d66b-a344-4b10-a6b5-d9a1ad5afed7 | 60a4f760-797e-47e1-ac39-565032d1c6a3 | Packages/c/cow-2.2-3.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | b094b44b-3dc3-4c8e-a02c-b21c35e04934 | b2a0113e-58cc-4aea-98b3-73a0dc7df889 | Packages/c/camel-0.1-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | b094b44b-3dc3-4c8e-a02c-b21c35e04934 | b2a0113e-58cc-4aea-98b3-73a0dc7df889 | Packages/c/cockateel-3.1-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | b094b44b-3dc3-4c8e-a02c-b21c35e04934 | b2a0113e-58cc-4aea-98b3-73a0dc7df889 | Packages/c/cat-1.0-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | b094b44b-3dc3-4c8e-a02c-b21c35e04934 | b2a0113e-58cc-4aea-98b3-73a0dc7df889 | Packages/c/cheetah-1.25.3-5.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | babc4ce7-4112-4443-8e46-9003393ae3e1 | 135b954c-9cc0-4b66-8fce-051a4e0862d3 | Packages/c/crow-0.8-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | babc4ce7-4112-4443-8e46-9003393ae3e1 | 135b954c-9cc0-4b66-8fce-051a4e0862d3 | Packages/c/chimpanzee-0.21-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | babc4ce7-4112-4443-8e46-9003393ae3e1 | 135b954c-9cc0-4b66-8fce-051a4e0862d3 | Packages/c/cockateel-3.1-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | babc4ce7-4112-4443-8e46-9003393ae3e1 | 135b954c-9cc0-4b66-8fce-051a4e0862d3 | Packages/c/cheetah-1.25.3-5.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | babc4ce7-4112-4443-8e46-9003393ae3e1 | 135b954c-9cc0-4b66-8fce-051a4e0862d3 | Packages/c/cat-1.0-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | babc4ce7-4112-4443-8e46-9003393ae3e1 | 135b954c-9cc0-4b66-8fce-051a4e0862d3 | Packages/c/camel-0.1-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | bc95ac11-46ce-4751-8974-d667c3563cdb | f2c75c3a-c191-41f9-98c7-9159653a1461 | Packages/c/crow-0.8-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | c0552652-fca1-45a4-bbf0-3a5166ce5f12 | 7cdd72ed-5b55-4f43-99d7-8dacdb821bea | Packages/c/cheetah-1.25.3-5.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | c0f44e5b-ea95-484c-b97d-e4dbe219df87 | ea874ff0-84e7-41e0-8155-f8bb024b7a89 | Packages/c/camel-0.1-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | c0f44e5b-ea95-484c-b97d-e4dbe219df87 | ec797939-4eee-411b-8d8a-dcb30987cc79 | Packages/c/cat-1.0-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | c3bd0a92-e952-4cd2-9303-f8999ea17ed3 | edd8c5cf-6947-42d4-b478-34ddd01dda02 | Packages/c/cockateel-3.1-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | c3bd0a92-e952-4cd2-9303-f8999ea17ed3 | edd8c5cf-6947-42d4-b478-34ddd01dda02 | Packages/c/chimpanzee-0.21-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | c3bd0a92-e952-4cd2-9303-f8999ea17ed3 | edd8c5cf-6947-42d4-b478-34ddd01dda02 | Packages/c/cheetah-1.25.3-5.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | c3bd0a92-e952-4cd2-9303-f8999ea17ed3 | edd8c5cf-6947-42d4-b478-34ddd01dda02 | Packages/b/bear-4.1-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | c3bd0a92-e952-4cd2-9303-f8999ea17ed3 | edd8c5cf-6947-42d4-b478-34ddd01dda02 | Packages/c/cat-1.0-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | c3bd0a92-e952-4cd2-9303-f8999ea17ed3 | edd8c5cf-6947-42d4-b478-34ddd01dda02 | Packages/c/crow-0.8-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | c46c4185-5538-4efb-af91-840f2acf9247 | d324f32a-f9b1-4164-90b8-f847da35e721 | Packages/c/cow-2.2-3.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | c46c4185-5538-4efb-af91-840f2acf9247 | d324f32a-f9b1-4164-90b8-f847da35e721 | Packages/c/chimpanzee-0.21-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | c46c4185-5538-4efb-af91-840f2acf9247 | d324f32a-f9b1-4164-90b8-f847da35e721 | Packages/c/crow-0.8-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | c56906bd-219a-4733-95ce-825f80f2476d | 5e4096b4-0122-4d35-becf-8a900475579f | Packages/c/cat-1.0-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | c56906bd-219a-4733-95ce-825f80f2476d | 5e4096b4-0122-4d35-becf-8a900475579f | Packages/c/chimpanzee-0.21-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | c56906bd-219a-4733-95ce-825f80f2476d | 5e4096b4-0122-4d35-becf-8a900475579f | Packages/b/bear-4.1-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | c56906bd-219a-4733-95ce-825f80f2476d | 5e4096b4-0122-4d35-becf-8a900475579f | Packages/c/cow-2.2-3.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | d1ef46d2-7be6-4e98-ab64-944bbd39d970 | 776c4a03-cf22-4e9e-86d6-096e7a2bd612 | Packages/c/cheetah-1.25.3-5.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | d1ef46d2-7be6-4e98-ab64-944bbd39d970 | 776c4a03-cf22-4e9e-86d6-096e7a2bd612 | Packages/c/chimpanzee-0.21-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | d1ef46d2-7be6-4e98-ab64-944bbd39d970 | 776c4a03-cf22-4e9e-86d6-096e7a2bd612 | Packages/c/cockateel-3.1-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | d1ef46d2-7be6-4e98-ab64-944bbd39d970 | 776c4a03-cf22-4e9e-86d6-096e7a2bd612 | Packages/c/crow-0.8-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | d1ef46d2-7be6-4e98-ab64-944bbd39d970 | 776c4a03-cf22-4e9e-86d6-096e7a2bd612 | Packages/c/cat-1.0-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | d7677197-b4cb-4ee0-9972-0c55c21daf3a | cf9ba537-c560-446d-a28f-a8601df3d77e | Packages/c/cat-1.0-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | d7677197-b4cb-4ee0-9972-0c55c21daf3a | cf9ba537-c560-446d-a28f-a8601df3d77e | Packages/c/chimpanzee-0.21-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | d7677197-b4cb-4ee0-9972-0c55c21daf3a | cf9ba537-c560-446d-a28f-a8601df3d77e | Packages/c/cockateel-3.1-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | d7677197-b4cb-4ee0-9972-0c55c21daf3a | cf9ba537-c560-446d-a28f-a8601df3d77e | Packages/c/cheetah-1.25.3-5.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | d7677197-b4cb-4ee0-9972-0c55c21daf3a | cf9ba537-c560-446d-a28f-a8601df3d77e | Packages/b/bear-4.1-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | d7677197-b4cb-4ee0-9972-0c55c21daf3a | cf9ba537-c560-446d-a28f-a8601df3d77e | Packages/c/crow-0.8-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | d8074ab7-55c5-4c6a-a0aa-cfa667f6a4e8 |                                      | Packages/c/crow-0.8-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | dd25f4a3-5b4e-4654-b8cc-6dbf655c61fa | f253a9fc-0858-4788-a683-0765a9d85785 | Packages/b/bear-4.1-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | dd25f4a3-5b4e-4654-b8cc-6dbf655c61fa | f253a9fc-0858-4788-a683-0765a9d85785 | Packages/c/camel-0.1-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | f2197fcf-d1fc-408f-98f0-4c4f849a1803 | be7a83f9-0a21-44f6-8771-511ca738f060 | Packages/c/cat-1.0-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | f2197fcf-d1fc-408f-98f0-4c4f849a1803 | be7a83f9-0a21-44f6-8771-511ca738f060 | Packages/c/camel-0.1-1.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | f2197fcf-d1fc-408f-98f0-4c4f849a1803 | be7a83f9-0a21-44f6-8771-511ca738f060 | Packages/c/cheetah-1.25.3-5.noarch.rpm
 cv_zoo-zoo_repo | bec7db55-97e6-421a-ba0f-d862c92b95b2 | f2197fcf-d1fc-408f-98f0-4c4f849a1803 | be7a83f9-0a21-44f6-8771-511ca738f060 | Packages/c/cockateel-3.1-1.noarch.rpm


I will prepare such CVs on fresh install Sat6.10 and run the reproducer there, to chekc if the pulp2to3 migration is a crucial step in reproducer or not.

Comment 5 Pavel Moravec 2022-02-22 21:04:02 UTC

Small update:

I *am* able to reproduce on a clean install of 6.10, *without* pulp2to3migration. Just the nondeterministic reproducer took 30 minutes on a migrated system, but 8 hours on clean install 6.10 /o\ (no idea why, or if the migration does anyhow matter or not).

Comment 10 Daniel Alley 2022-03-10 16:48:46 UTC

Working on the backport for this now.

Comment 11 Daniel Alley 2022-03-10 16:54:18 UTC

Should be fixed in pulpcore 3.14.15, when that becomes available.

Comment 12 Daniel Alley 2022-03-26 01:49:42 UTC

3.14.15 is available with the fix.

Comment 14 Vedashree Deshpande 2022-04-07 12:45:18 UTC

Hello, 

I was not able to find the pulpcore 3.14.15 package in  rhel-7-server-satellite-6.10-rpms. 

Is it even available yet?

Comment 15 Grant Gainey 2022-04-07 13:02:19 UTC

(In reply to Vedashree Deshpande from comment #14)
> Hello, 
> 
> I was not able to find the pulpcore 3.14.15 package in 
> rhel-7-server-satellite-6.10-rpms. 
> 
> Is it even available yet?

MODIFIED means "upstream release happened" : https://github.com/pulp/pulpcore/releases/tag/3.14.15

Build team hasn't built RPMs yet.

Comment 24 wclark 2022-04-27 18:31:59 UTC

Created attachment 1875432 [details]
HOTFIX RPM for Satellite 6.10.4

A hotfix for this issue is available for Satellite 6.10.4

INSTALLATION INSTRUCTIONS

1. Make a complete backup or snapshot of Satellite server

2. Download the attached hotfix rpm and copy it to Satellite server

3. # yum install ./python3-pulpcore-3.14.14-2.HOTFIXRHBZ2044631.el7pc.noarch.rpm --disableplugin=foreman-protector

4. # satellite-maintain service restart

Comment 34 wclark 2022-05-06 10:58:37 UTC

Note that both Satellite 6.10.4 and Satellite 6.10.5 include Pulpcore 3.14.14.

Therefore, the same hotfix which was previously posted for Satellite 6.10.4, is also usable with Satellite 6.10.5.

Furthermore, customers who have installed the hotfix on Satellite 6.10.4 will not be blocked on updating to Satellite 6.10.5.

Comment 35 Lai 2022-05-12 18:51:35 UTC

Followed the reproduction steps on comment #0 to retest this bz.

Expected result:
There should not be an error message on violating unique constraint and the filter worked correctly and should only show the 2 include packages after publishing for version 5.0 (katello-host-tools & katello-host-tools-fact-plugin)

Actual:
There is not an error message on violating unique constraint and the filter worked correctly and only showed the 2 include packages after publishing for version 5.0 (katello-host-tools & katello-host-tools-fact-plugin)


Verified on 6.11 snap 20 with rhel7 and rhel8 and tfm-pulpcore-python3-pulpcore-3.16.7-1.el7pc.noarch

Comment 37 kkeane 2022-05-16 02:43:30 UTC

I am still seeing this problem even after applying the hotfix.

It happened with Satellite 6.10.4 as well as after updating to 6.10.5-1

This started happening this week; up to last week, the same CV could be published successfully. The only change in the meantime was synchronizing repositories (plus today, updating to 6.10.5-1).

My content view setup is fairly complex, making it hard to isolate the problem. Content View includes the usual RHEL 8 repositories, EPEL, Docker CE, and a number of other repositories.

What I observed so far:

- The CV can be published successfully without a filter.
- Adding any filter will trigger the problem - it doesn't seem to matter whether it is a filter for one repository, for all repositories, for specific versions or all versions, for one RPM or for RPMs with wildcards.

Comment 38 Pavel Moravec 2022-05-18 10:10:44 UTC

(In reply to kkeane from comment #37)
> I am still seeing this problem even after applying the hotfix.
> 
> It happened with Satellite 6.10.4 as well as after updating to 6.10.5-1
> 
> This started happening this week; up to last week, the same CV could be
> published successfully. The only change in the meantime was synchronizing
> repositories (plus today, updating to 6.10.5-1).
> 
> My content view setup is fairly complex, making it hard to isolate the
> problem. Content View includes the usual RHEL 8 repositories, EPEL, Docker
> CE, and a number of other repositories.
> 
> What I observed so far:
> 
> - The CV can be published successfully without a filter.
> - Adding any filter will trigger the problem - it doesn't seem to matter
> whether it is a filter for one repository, for all repositories, for
> specific versions or all versions, for one RPM or for RPMs with wildcards.

Hello,
this sounds like a different problem (or maybe unfixed specific scenario) as also CV filters do work well for me.

To investigate more, please open a support case as the right mean for such investigation. Ideally, provide there sosreport and html task export and name of a failing CV

Comment 39 Daniel Alley 2022-05-18 12:58:37 UTC

@mdell The patch which we merged ought to prevent this going forwards, but is there any cleanup necessary for users who have already ended up in this situation?

Comment 45 errata-xmlrpc 2022-07-05 14:32:22 UTC

Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory (Moderate: Satellite 6.11 Release), and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

https://access.redhat.com/errata/RHSA-2022:5498

Comment 57 Red Hat Bugzilla 2023-09-18 04:30:41 UTC

The needinfo request[s] on this closed bug have been removed as they have been unresolved for 120 days