Repository sync fails with error "Katello::Errors::Pulp3Error: relation "pulp_2to3_migration_pulp2repository" does not exist" after upgrading to Red Hat Satellite 6.10

Solution Unverified - Updated

Environment

  • Red Hat Satellite 6.10

Issue

  • After the Satellite 6.10 upgrade, repository sync or deletion fails with following error
Task c299-4433-a6c8-4cbd559c7444: Katello::Errors::Pulp3Error: relation "pulp_2to3_migration_pulp2repository" does not exist LINE 1: ...ation_pulp2repository"."pulp3_repository_id" FROM "pulp_2to3... ^
  • Pulp 2 to Pulp 3 migration has been completed successfully and the Pulp 2 content was deleted after the cleanup command was executed.
[root@satellite ~]# satellite-maintain content migration-stats
Running Retrieve Pulp 2 to Pulp 3 migration statistics
================================================================================
Retrieve Pulp 2 to Pulp 3 migration statistics: 
============Migration Summary================
Migrated/Total RPMs: 246548/246548
Migrated/Total errata: 85404/85404
Migrated/Total repositories: 109/109
Estimated migration time based on yum content: 0 hours, 5 minutes.

Resolution

 # satellite-maintain service restart

For more KB articles/solutions related to Red Hat Satellite 6.x Repository Issues, please refer to the Red Hat Satellite Consolidated Troubleshooting Article for Red Hat Satellite 6.x Repository Issues.

Diagnostic Steps

  • Error output from hammer repository synchronize command
[root@satellite ~]# hammer repository synchronize --id=5
[.............................................................................................................................................................................................] [100%]
No content added.
Waiting to start.
--------------------------------
Error: relation "pulp_2to3_migration_pulp2repository" does not exist
LINE 1: ...ation_pulp2repository"."pulp3_repository_id" FROM "pulp_2to3...
SBR
Product(s)
Category
Tags

This solution is part of Red Hat’s fast-track publication program, providing a huge library of solutions that Red Hat engineers have created while supporting our customers. To give you the knowledge you need the instant it becomes available, these articles may be presented in a raw and unedited form.