Problem:
After some foreman component updates (katello-common-3.18.2-1.el7.noarch, python3-pulp-rpm-3.9.0-2.el7.noarch, etc.) I receive the following error in /var/log/messages when trying to sync some specific repos:
django.db.utils.ProgrammingError: column rpm_rpmrepository.last_sync_repomd_checksum does not exist
Expected outcome:
Foreman and Proxy versions:
foreman-2.3.3-1.el7.noarch
foreman-proxy-2.3.3-1.el7.noarch
Foreman and Proxy plugin versions:
Foreman is installed with katello scenario. It has the following plugins:
-
Ansible
-
Dynflow
-
Logs
-
Openscap
-
Pulp
-
Pulpcore
-
Puppet
-
Puppet CA
-
Registration
-
SSH
Distribution and version:
Red Hat Enterprise Linux Server release 7.9 (Maipo)
Other relevant data:
When trying to sync the problematic repos, the sync job would get stuck in pending, and there would be an error like this in /var/log/messages:
linux-satellite pulpcore-api[15842]: pulp: django.request:ERROR: Internal Server Error: /pulp/api/v3/repositories/rpm/rpm/0dd3dbeb-78bf-48d4-87bc-
204fecf43961/versions/11/repair/
linux-satellite pulpcore-api[15842]: Traceback (most recent call last):
pulpcore-api[15842]: File "/usr/lib/python3.6/site-packages/django/db/backends/utils.py", line 84, in _execute
pulpcore-api[15842]: return self.cursor.execute(sql, params)
pulpcore-api[15842]: psycopg2.errors.UndefinedColumn: column rpm_rpmrepository.last_sync_repomd_checksum does not exist
Is there a way to fix this problem, besides deleting and recreating the repos? Thanks!