Problem: For one of our proxies we have an error on OrphanCleanup. We have an error with a postgres table. Others SmartProxy are OK
Foreman and Proxy versions: foreman 3.5.2 a katello 4.7.4
Distribution and version: AlmaLinux release 8.7
Other relevant data:
avril 24 14:26:05 pulpcore-api[2176]: pulp [05dd1b6d8c0545e7a053ea0924d238eb]: django.request:ERROR: Internal Server Error: /pulp/api/v3/distributions/rpm/rpm/
avril 24 14:26:05 pulpcore-api[2176]: Traceback (most recent call last):
avril 24 14:26:05 pulpcore-api[2176]: File "/usr/lib/python3.9/site-packages/django/db/models/fields/related_descriptors.py", line 402, in __get__
avril 24 14:26:05 pulpcore-api[2176]: rel_obj = self.related.get_cached_value(instance)
avril 24 14:26:05 pulpcore-api[2176]: File "/usr/lib/python3.9/site-packages/django/db/models/fields/mixins.py", line 15, in get_cached_value
avril 24 14:26:05 pulpcore-api[2176]: return instance._state.fields_cache[cache_name]
avril 24 14:26:05 pulpcore-api[2176]: KeyError: 'container_contentredirectcontentguard'
avril 24 14:26:05 pulpcore-api[2176]: During handling of the above exception, another exception occurred:
avril 24 14:26:05 pulpcore-api[2176]: Traceback (most recent call last):
avril 24 14:26:05 pulpcore-api[2176]: File "/usr/lib/python3.9/site-packages/django/db/backends/utils.py", line 84, in _execute
avril 24 14:26:05 pulpcore-api[2176]: return self.cursor.execute(sql, params)
avril 24 14:26:05 pulpcore-api[2176]: psycopg2.errors.UndefinedTable: ERREUR: la relation « container_contentredirectcontentguard » n'existe pas
avril 24 14:26:05 pulpcore-api[2176]: LINE 1: ...contentredirectcontentguard"."shared_secret" FROM "container...
avril 24 14:26:05 pulpcore-api[2176]: ^
avril 24 14:26:05 pulpcore-api[2176]: The above exception was the direct cause of the following exception:
avril 24 14:26:05 pulpcore-api[2176]: Traceback (most recent call last):
avril 24 14:26:05 pulpcore-api[2176]: File "/usr/lib/python3.9/site-packages/django/core/handlers/exception.py", line 47, in inner
avril 24 14:26:05 pulpcore-api[2176]: response = get_response(request)
avril 24 14:26:05 pulpcore-api[2176]: File "/usr/lib/python3.9/site-packages/django/core/handlers/base.py", line 181, in _get_response
avril 24 14:26:05 pulpcore-api[2176]: response = wrapped_callback(request, *callback_args, **callback_kwargs)
avril 24 14:26:05 pulpcore-api[2176]: File "/usr/lib/python3.9/site-packages/django/views/decorators/csrf.py", line 54, in wrapped_view
avril 24 14:26:05 pulpcore-api[2176]: return view_func(*args, **kwargs)
avril 24 14:26:05 pulpcore-api[2176]: File "/usr/lib/python3.9/site-packages/rest_framework/viewsets.py", line 125, in view
avril 24 14:26:05 pulpcore-api[2176]: return self.dispatch(request, *args, **kwargs)
avril 24 14:26:05 pulpcore-api[2176]: File "/usr/lib/python3.9/site-packages/rest_framework/views.py", line 509, in dispatch
avril 24 14:26:05 pulpcore-api[2176]: response = self.handle_exception(exc)
avril 24 14:26:05 pulpcore-api[2176]: File "/usr/lib/python3.9/site-packages/rest_framework/views.py", line 469, in handle_exception
avril 24 14:26:05 pulpcore-api[2176]: self.raise_uncaught_exception(exc)
avril 24 14:26:05 pulpcore-api[2176]: File "/usr/lib/python3.9/site-packages/rest_framework/views.py", line 480, in raise_uncaught_exception
avril 24 14:26:05 pulpcore-api[2176]: raise exc
avril 24 14:26:05 pulpcore-api[2176]: File "/usr/lib/python3.9/site-packages/rest_framework/views.py", line 506, in dispatch
avril 24 14:26:05 pulpcore-api[2176]: response = handler(request, *args, **kwargs)
avril 24 14:26:05 pulpcore-api[2176]: File "/usr/lib/python3.9/site-packages/rest_framework/mixins.py", line 43, in list
avril 24 14:26:05 pulpcore-api[2176]: return self.get_paginated_response(serializer.data)
avril 24 14:26:05 pulpcore-api[2176]: File "/usr/lib/python3.9/site-packages/rest_framework/serializers.py", line 768, in data
avril 24 14:26:05 pulpcore-api[2176]: ret = super().data
avril 24 14:26:05 pulpcore-api[2176]: File "/usr/lib/python3.9/site-packages/rest_framework/serializers.py", line 253, in data
avril 24 14:26:05 pulpcore-api[2176]: self._data = self.to_representation(self.instance)
avril 24 14:26:05 pulpcore-api[2176]: File "/usr/lib/python3.9/site-packages/rest_framework/serializers.py", line 686, in to_representation
avril 24 14:26:05 pulpcore-api[2176]: return [
avril 24 14:26:05 pulpcore-api[2176]: File "/usr/lib/python3.9/site-packages/rest_framework/serializers.py", line 687, in <listcomp>
avril 24 14:26:05 pulpcore-api[2176]: self.child.to_representation(item) for item in iterable
avril 24 14:26:05 pulpcore-api[2176]: File "/usr/lib/python3.9/site-packages/rest_framework/serializers.py", line 522, in to_representation
avril 24 14:26:05 pulpcore-api[2176]: ret[field.field_name] = field.to_representation(attribute)
avril 24 14:26:05 pulpcore-api[2176]: File "/usr/lib/python3.9/site-packages/rest_framework/relations.py", line 401, in to_representation
avril 24 14:26:05 pulpcore-api[2176]: url = self.get_url(value, self.view_name, request, format)
avril 24 14:26:05 pulpcore-api[2176]: File "/usr/lib/python3.9/site-packages/pulpcore/app/serializers/base.py", line 263, in get_url
avril 24 14:26:05 pulpcore-api[2176]: view_name = self._view_name(obj)
avril 24 14:26:05 pulpcore-api[2176]: File "/usr/lib/python3.9/site-packages/pulpcore/app/serializers/base.py", line 249, in _view_name
avril 24 14:26:05 pulpcore-api[2176]: obj = obj.cast()
avril 24 14:26:05 pulpcore-api[2176]: File "/usr/lib/python3.9/site-packages/pulpcore/app/models/base.py", line 194, in cast
avril 24 14:26:05 pulpcore-api[2176]: """
avril 24 14:26:05 pulpcore-api[2176]: File "/usr/lib/python3.9/site-packages/django/db/models/fields/related_descriptors.py", line 410, in __get__
avril 24 14:26:05 pulpcore-api[2176]: rel_obj = self.get_queryset(instance=instance).get(**filter_args)
avril 24 14:26:05 pulpcore-api[2176]: File "/usr/lib/python3.9/site-packages/django/db/models/query.py", line 431, in get
avril 24 14:26:05 pulpcore-api[2176]: num = len(clone)
avril 24 14:26:05 pulpcore-api[2176]: File "/usr/lib/python3.9/site-packages/django/db/models/query.py", line 262, in __len__
avril 24 14:26:05 pulpcore-api[2176]: self._fetch_all()
avril 24 14:26:05 pulpcore-api[2176]: File "/usr/lib/python3.9/site-packages/django/db/models/query.py", line 1324, in _fetch_all
avril 24 14:26:05 pulpcore-api[2176]: self._result_cache = list(self._iterable_class(self))
avril 24 14:26:05 pulpcore-api[2176]: File "/usr/lib/python3.9/site-packages/django/db/models/query.py", line 51, in __iter__
avril 24 14:26:05 pulpcore-api[2176]: results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
avril 24 14:26:05 pulpcore-api[2176]: File "/usr/lib/python3.9/site-packages/django/db/models/sql/compiler.py", line 1175, in execute_sql
avril 24 14:26:05 pulpcore-api[2176]: cursor.execute(sql, params)
avril 24 14:26:05 pulpcore-api[2176]: File "/usr/lib/python3.9/site-packages/django/db/backends/utils.py", line 66, in execute
avril 24 14:26:05 pulpcore-api[2176]: return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
avril 24 14:26:05 pulpcore-api[2176]: File "/usr/lib/python3.9/site-packages/django/db/backends/utils.py", line 75, in _execute_with_wrappers
avril 24 14:26:05 pulpcore-api[2176]: return executor(sql, params, many, context)
avril 24 14:26:05 pulpcore-api[2176]: File "/usr/lib/python3.9/site-packages/django/db/backends/utils.py", line 84, in _execute
avril 24 14:26:05 pulpcore-api[2176]: return self.cursor.execute(sql, params)
avril 24 14:26:05 pulpcore-api[2176]: File "/usr/lib/python3.9/site-packages/django/db/utils.py", line 90, in __exit__
avril 24 14:26:05 pulpcore-api[2176]: raise dj_exc_value.with_traceback(traceback) from exc_value
avril 24 14:26:05 pulpcore-api[2176]: File "/usr/lib/python3.9/site-packages/django/db/backends/utils.py", line 84, in _execute
avril 24 14:26:05 pulpcore-api[2176]: return self.cursor.execute(sql, params)
avril 24 14:26:05 pulpcore-api[2176]: django.db.utils.ProgrammingError: ERREUR: la relation « container_contentredirectcontentguard » n'existe pas
avril 24 14:26:05 pulpcore-api[2176]: LINE 1: ...contentredirectcontentguard"."shared_secret" FROM "container...
avril 24 14:26:05 pulpcore-api[2176]: ^
avril 24 14:26:05 pulpcore-api[2176]: pulp [05dd1b6d8c0545e7a053ea0924d238eb]: - - [24/Apr/2023:12:26:05 +0000] "GET /pulp/api/v3/distributions/rpm/rpm/?limit=2000&offset=0 HTTP/1.1" 500 145 "-" "OpenAPI-Generator/3.18.7/ruby"