I have just upgrade my main foreman server from 3.18.3 via 4.0 to 4.1. As I had a lot of problems with upgrading my content proxy (see Katello 4.0 content proxy upgrade disaster) I have installed a new server with the 4.1 content proxy.
My initial optimized sync of the new content proxy shows a couple of error messages:
deadlock detected
DETAIL: Process 12693 waits for ShareLock on transaction 27951; blocked by process 12680.
Process 12680 waits for ShareLock on transaction 27986; blocked by process 12693.
HINT: See server log for query details.
CONTEXT: while inserting index tuple (10,1) in relation "rpm_package_pkgId_key"
duplicate key value violates unique constraint "rpm_variant_variant_id_uid_name_type_764da894_uniq"
DETAIL: Key (variant_id, uid, name, type, packages, distribution_tree_id)=(plus, plus, plus, variant, Packages, 0d20a02b-d3a6-42cd-b333-d99e91d0e482) already exists.
duplicate key value violates unique constraint "rpm_variant_variant_id_uid_name_type_764da894_uniq"
DETAIL: Key (variant_id, uid, name, type, packages, distribution_tree_id)=(plus, plus, plus, variant, Packages, 0d20a02b-d3a6-42cd-b333-d99e91d0e482) already exists.
duplicate key value violates unique constraint "rpm_variant_variant_id_uid_name_type_764da894_uniq"
DETAIL: Key (variant_id, uid, name, type, packages, distribution_tree_id)=(plus, plus, plus, variant, Packages, 0d20a02b-d3a6-42cd-b333-d99e91d0e482) already exists.
duplicate key value violates unique constraint "rpm_variant_variant_id_uid_name_type_764da894_uniq"
DETAIL: Key (variant_id, uid, name, type, packages, distribution_tree_id)=(extras, extras, extras, variant, Packages, ca24473d-b2d7-4535-b2a2-f76db58868ac) already exists.
duplicate key value violates unique constraint "rpm_variant_variant_id_uid_name_type_764da894_uniq"
DETAIL: Key (variant_id, uid, name, type, packages, distribution_tree_id)=(HighAvailability, HighAvailability, High Availability, variant, Packages, e1520ccf-aa2c-42af-bcee-c785ed7feba4) already exists.
duplicate key value violates unique constraint "rpm_variant_variant_id_uid_name_type_764da894_uniq"
DETAIL: Key (variant_id, uid, name, type, packages, distribution_tree_id)=(HighAvailability, HighAvailability, High Availability, variant, Packages, e1520ccf-aa2c-42af-bcee-c785ed7feba4) already exists.
duplicate key value violates unique constraint "rpm_variant_variant_id_uid_name_type_764da894_uniq"
DETAIL: Key (variant_id, uid, name, type, packages, distribution_tree_id)=(HighAvailability, HighAvailability, High Availability, variant, Packages, e1520ccf-aa2c-42af-bcee-c785ed7feba4) already exists.
deadlock detected
DETAIL: Process 16562 waits for ShareLock on transaction 44181; blocked by process 16589.
Process 16589 waits for ShareLock on transaction 43893; blocked by process 16562.
HINT: See server log for query details.
CONTEXT: while inserting index tuple (871,1) in relation "rpm_package_pkgId_key"
deadlock detected
DETAIL: Process 16576 waits for ShareLock on transaction 43893; blocked by process 16562.
Process 16562 waits for ShareLock on transaction 44085; blocked by process 16576.
HINT: See server log for query details.
CONTEXT: while inserting index tuple (863,2) in relation "rpm_package_pkgId_key"
deadlock detected
DETAIL: Process 16614 waits for ShareLock on transaction 44181; blocked by process 16589.
Process 16589 waits for ShareLock on transaction 44312; blocked by process 16614.
HINT: See server log for query details.
CONTEXT: while inserting index tuple (914,3) in relation "rpm_package_pkgId_key"
deadlock detected
DETAIL: Process 17857 waits for ShareLock on transaction 50756; blocked by process 17902.
Process 17902 waits for ShareLock on transaction 50064; blocked by process 17857.
HINT: See server log for query details.
CONTEXT: while inserting index tuple (1503,3) in relation "rpm_package_pkgId_key"
deadlock detected
DETAIL: Process 17872 waits for ShareLock on transaction 50064; blocked by process 17857.
Process 17857 waits for ShareLock on transaction 50339; blocked by process 17872.
HINT: See server log for query details.
CONTEXT: while inserting index tuple (1482,2) in relation "rpm_package_pkgId_key"
deadlock detected
DETAIL: Process 17902 waits for ShareLock on transaction 50539; blocked by process 17885.
Process 17885 waits for ShareLock on transaction 50756; blocked by process 17902.
HINT: See server log for query details.
CONTEXT: while inserting index tuple (1637,4) in relation "rpm_package_pkgId_key"
deadlock detected
DETAIL: Process 21733 waits for ShareLock on transaction 62564; blocked by process 21742.
Process 21742 waits for ShareLock on transaction 62458; blocked by process 21733.
HINT: See server log for query details.
CONTEXT: while inserting index tuple (987,4) in relation "rpm_package_pkgId_key"
deadlock detected
DETAIL: Process 21742 waits for ShareLock on transaction 62719; blocked by process 21784.
Process 21784 waits for ShareLock on transaction 62564; blocked by process 21742.
HINT: See server log for query details.
CONTEXT: while inserting index tuple (1046,2) in relation "rpm_package_pkgId_key"
deadlock detected
DETAIL: Process 21784 waits for ShareLock on transaction 62647; blocked by process 21760.
Process 21760 waits for ShareLock on transaction 62719; blocked by process 21784.
HINT: See server log for query details.
CONTEXT: while inserting index tuple (1156,2) in relation "rpm_package_pkgId_key"
deadlock detected
DETAIL: Process 21810 waits for ShareLock on transaction 62744; blocked by process 21796.
Process 21796 waits for ShareLock on transaction 62870; blocked by process 21810.
HINT: See server log for query details.
CONTEXT: while inserting index tuple (1058,2) in relation "rpm_package_pkgId_key"
duplicate key value violates unique constraint "rpm_checksum_path_checksum_distribution_tree_id_fd3fe409_uniq"
DETAIL: Key (path, checksum, distribution_tree_id)=(images/boot.iso, sha256:c79921e24d472144d8f36a0d5f409b12bd016d9d7d022fd703563973ca9c375c, 49e4d7b9-e692-4336-82e6-8b2ba84656b8) already exists.
duplicate key value violates unique constraint "rpm_checksum_path_checksum_distribution_tree_id_fd3fe409_uniq"
DETAIL: Key (path, checksum, distribution_tree_id)=(images/boot.iso, sha256:c79921e24d472144d8f36a0d5f409b12bd016d9d7d022fd703563973ca9c375c, 49e4d7b9-e692-4336-82e6-8b2ba84656b8) already exists.
duplicate key value violates unique constraint "rpm_checksum_path_checksum_distribution_tree_id_fd3fe409_uniq"
DETAIL: Key (path, checksum, distribution_tree_id)=(images/boot.iso, sha256:c79921e24d472144d8f36a0d5f409b12bd016d9d7d022fd703563973ca9c375c, 49e4d7b9-e692-4336-82e6-8b2ba84656b8) already exists.
duplicate key value violates unique constraint "rpm_variant_variant_id_uid_name_type_764da894_uniq"
DETAIL: Key (variant_id, uid, name, type, packages, distribution_tree_id)=(PowerTools, PowerTools, PowerTools, variant, Packages, 6900b8f3-6f5f-4460-9f9f-f30d1213c8ff) already exists.
duplicate key value violates unique constraint "rpm_variant_variant_id_uid_name_type_764da894_uniq"
DETAIL: Key (variant_id, uid, name, type, packages, distribution_tree_id)=(PowerTools, PowerTools, PowerTools, variant, Packages, 6900b8f3-6f5f-4460-9f9f-f30d1213c8ff) already exists.
duplicate key value violates unique constraint "rpm_variant_variant_id_uid_name_type_764da894_uniq"
DETAIL: Key (variant_id, uid, name, type, packages, distribution_tree_id)=(PowerTools, PowerTools, PowerTools, variant, Packages, 6900b8f3-6f5f-4460-9f9f-f30d1213c8ff) already exists.
duplicate key value violates unique constraint "rpm_variant_variant_id_uid_name_type_764da894_uniq"
DETAIL: Key (variant_id, uid, name, type, packages, distribution_tree_id)=(AppStream, AppStream, AppStream, variant, Packages, 862cdb92-f315-4cd7-9dd7-5014eecc8abe) already exists.
duplicate key value violates unique constraint "rpm_variant_variant_id_uid_name_type_764da894_uniq"
DETAIL: Key (variant_id, uid, name, type, packages, distribution_tree_id)=(AppStream, AppStream, AppStream, variant, Packages, 862cdb92-f315-4cd7-9dd7-5014eecc8abe) already exists.
duplicate key value violates unique constraint "rpm_variant_variant_id_uid_name_type_764da894_uniq"
DETAIL: Key (variant_id, uid, name, type, packages, distribution_tree_id)=(AppStream, AppStream, AppStream, variant, Packages, 862cdb92-f315-4cd7-9dd7-5014eecc8abe) already exists.