Hi Ina, The error was not from migration. I see the error when I try to create a new repo. My pulp_installer is on the latest version. Rerun the installer doesn't solve the issue. What should I do to fix this? We cannot reset database from scratch since we already have a lot data.
From: ipan...@redhat.com At: 05/13/20 09:43:45To: Bin Li (BLOOMBERG/ 120 PARK ) Cc: ttere...@redhat.com, pulp-list@redhat.com Subject: Re: [Pulp-list] pulp 3.3.1 server error This issue was fixed in the 3.3.1 release [0][1] [0] https://pulp-rpm.readthedocs.io/en/latest/changes.html#bugfixes [1] https://pulp.plan.io/issues/6662 -------- Regards, Ina Panova Senior Software Engineer| Pulp| Red Hat Inc. "Do not go where the path may lead, go instead where there is no path and leave a trail." On Tue, May 12, 2020 at 11:30 PM Bin Li (BLOOMBERG/ 120 PARK) <bli...@bloomberg.net> wrote: I removed the 0009_auto.. and rerun the installer. The upgrade was successful. Below is error log. May 12 17:25:05 myhost gunicorn[55426]: pulp: django.request:ERROR: Internal Server Error: /pulp/api/v3/repositories/rpm/rpm/ May 12 17:25:05 myhost gunicorn[55426]: Traceback (most recent call last): May 12 17:25:05 myhost gunicorn[55426]: File "/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/django/db/backends/utils.py", line 84, in _execute May 12 17:25:05 myhost gunicorn[55426]: return self.cursor.execute(sql, params) May 12 17:25:05 myhost gunicorn[55426]: psycopg2.errors.NotNullViolation: null value in column "last_sync_revision_number" violates not-null constraint May 12 17:25:05 myhost gunicorn[55426]: DETAIL: Failing row contains (0053634d-d0ca-46de-81d4-b8acf19d592e, f, null, null, 0, null, {}). May 12 17:25:05 myhost gunicorn[55426]: The above exception was the direct cause of the following exception: May 12 17:25:05 myhost gunicorn[55426]: Traceback (most recent call last): May 12 17:25:05 myhost gunicorn[55426]: File "/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/django/core/handlers/exception.py", line 34, in inner May 12 17:25:05 myhost gunicorn[55426]: response = get_response(request) May 12 17:25:05 myhost gunicorn[55426]: File "/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/django/core/handlers/base.py", line 115, in _get_response May 12 17:25:05 myhost gunicorn[55426]: response = self.process_exception_by_middleware(e, request) May 12 17:25:05 myhost gunicorn[55426]: File "/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/django/core/handlers/base.py", line 113, in _get_response May 12 17:25:05 myhost gunicorn[55426]: response = wrapped_callback(request, *callback_args, **callback_kwargs) May 12 17:25:05 myhost gunicorn[55426]: File "/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/django/views/decorators/csrf.py", line 54, in wrapped_view May 12 17:25:05 myhost gunicorn[55426]: return view_func(*args, **kwargs) May 12 17:25:05 myhost gunicorn[55426]: File "/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/rest_framework/viewsets.py", line 114, in view May 12 17:25:05 myhost gunicorn[55426]: return self.dispatch(request, *args, **kwargs) May 12 17:25:05 myhost gunicorn[55426]: File "/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/rest_framework/views.py", line 505, in dispatch May 12 17:25:05 myhost gunicorn[55426]: response = self.handle_exception(exc) May 12 17:25:05 myhost gunicorn[55426]: File "/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/rest_framework/views.py", line 465, in handle_exception May 12 17:25:05 myhost gunicorn[55426]: self.raise_uncaught_exception(exc) May 12 17:25:05 myhost gunicorn[55426]: File "/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/rest_framework/views.py", line 476, in raise_uncaught_exception May 12 17:25:05 myhost gunicorn[55426]: raise exc May 12 17:25:05 myhost gunicorn[55426]: File "/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/rest_framework/views.py", line 502, in dispatch May 12 17:25:05 myhost gunicorn[55426]: response = handler(request, *args, **kwargs) May 12 17:25:05 myhost gunicorn[55426]: File "/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/rest_framework/mixins.py", line 19, in create May 12 17:25:05 myhost gunicorn[55426]: self.perform_create(serializer) May 12 17:25:05 myhost gunicorn[55426]: File "/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/rest_framework/mixins.py", line 24, in perform_create May 12 17:25:05 myhost gunicorn[55426]: serializer.save() May 12 17:25:05 myhost gunicorn[55426]: File "/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/rest_framework/serializers.py", line 213, in save May 12 17:25:05 myhost gunicorn[55426]: self.instance = self.create(validated_data) May 12 17:25:05 myhost gunicorn[55426]: File "/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/rest_framework/serializers.py", line 932, in create May 12 17:25:05 myhost gunicorn[55426]: instance = ModelClass._default_manager.create(**validated_data) May 12 17:25:05 myhost gunicorn[55426]: File "/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/django/db/models/manager.py", line 82, in manager_method May 12 17:25:05 myhost gunicorn[55426]: return getattr(self.get_queryset(), name)(*args, **kwargs) May 12 17:25:05 myhost gunicorn[55426]: File "/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/django/db/models/query.py", line 422, in create May 12 17:25:05 myhost gunicorn[55426]: obj.save(force_insert=True, using=self.db) May 12 17:25:05 myhost gunicorn[55426]: File "/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/pulpcore/app/models/repository.py", line 62, in save May 12 17:25:05 myhost gunicorn[55426]: super().save(*args, **kwargs) May 12 17:25:05 myhost gunicorn[55426]: File "/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/pulpcore/app/models/base.py", line 107, in save May 12 17:25:05 myhost gunicorn[55426]: return super().save(*args, **kwargs) May 12 17:25:05 myhost gunicorn[55426]: File "/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/django/db/models/base.py", line 741, in save May 12 17:25:05 myhost gunicorn[55426]: force_update=force_update, update_fields=update_fields) May 12 17:25:05 myhost gunicorn[55426]: File "/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/django/db/models/base.py", line 779, in save_base May 12 17:25:05 myhost gunicorn[55426]: force_update, using, update_fields, May 12 17:25:05 myhost gunicorn[55426]: File "/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/django/db/models/base.py", line 870, in _save_table May 12 17:25:05 myhost gunicorn[55426]: result = self._do_insert(cls._base_manager, using, fields, update_pk, raw) May 12 17:25:05 myhost gunicorn[55426]: File "/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/django/db/models/base.py", line 908, in _do_insert May 12 17:25:05 myhost gunicorn[55426]: using=using, raw=raw) May 12 17:25:05 myhost gunicorn[55426]: File "/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/django/db/models/manager.py", line 82, in manager_method May 12 17:25:05 myhost gunicorn[55426]: return getattr(self.get_queryset(), name)(*args, **kwargs) May 12 17:25:05 myhost gunicorn[55426]: File "/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/django/db/models/query.py", line 1186, in _insert May 12 17:25:05 myhost gunicorn[55426]: return query.get_compiler(using=using).execute_sql(return_id) May 12 17:25:05 myhost gunicorn[55426]: File "/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/django/db/models/sql/compiler.py", line 1368, in execute_sql May 12 17:25:05 myhost gunicorn[55426]: cursor.execute(sql, params) May 12 17:25:05 myhost gunicorn[55426]: File "/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/django/db/backends/utils.py", line 67, in execute May 12 17:25:05 myhost gunicorn[55426]: return self._execute_with_wrappers(sql, params, many=False, executor=self._execute) May 12 17:25:05 myhost gunicorn[55426]: File "/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/django/db/backends/utils.py", line 76, in _execute_with_wrappers May 12 17:25:05 myhost gunicorn[55426]: return executor(sql, params, many, context) May 12 17:25:05 myhost gunicorn[55426]: File "/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/django/db/backends/utils.py", line 84, in _execute May 12 17:25:05 myhost gunicorn[55426]: return self.cursor.execute(sql, params) May 12 17:25:05 myhost gunicorn[55426]: File "/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/django/db/utils.py", line 89, in __exit__ May 12 17:25:05 myhost gunicorn[55426]: raise dj_exc_value.with_traceback(traceback) from exc_value May 12 17:25:05 myhost gunicorn[55426]: File "/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/django/db/backends/utils.py", line 84, in _execute May 12 17:25:05 myhost gunicorn[55426]: return self.cursor.execute(sql, params) May 12 17:25:05 myhost gunicorn[55426]: django.db.utils.IntegrityError: null value in column "last_sync_revision_number" violates not-null constraint May 12 17:25:05 myhost gunicorn[55426]: DETAIL: Failing row contains (0053634d-d0ca-46de-81d4-b8acf19d592e, f, null, null, 0, null, {}). May 12 17:25:05 myhost gunicorn[55426]: 127.0.0.1 - admin [12/May/2020:21:25:05 +0000] "POST /pulp/api/v3/repositories/rpm/rpm/ HTTP/1.1" 500 27 "-" "HTTPie/0.9.4" From: ttere...@redhat.com At: 05/12/20 16:19:31To: Bin Li (BLOOMBERG/ 120 PARK ) Cc: pulp-list@redhat.com Subject: Re: [Pulp-list] pulp 3.3.1 server error Was the upgrade successful after you removed the 0009_auto...? Did you run the installer again? If no, please do so. If yes, could you share logs? There will be some traceback showing why 500 error happened. Thank you, Tanya _______________________________________________ Pulp-list mailing list Pulp-list@redhat.com https://www.redhat.com/mailman/listinfo/pulp-list
_______________________________________________ Pulp-list mailing list Pulp-list@redhat.com https://www.redhat.com/mailman/listinfo/pulp-list