[Pulp-list] pulp 3.3.1 server error

Wed May 13 14:09:12 UTC 2020

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: ipanova at redhat.com At: 05/13/20 09:43:45To:  Bin Li (BLOOMBERG/ 120 PARK ) 
Cc:  ttereshc at redhat.com,  pulp-list at 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) <bli111 at 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: ttereshc at redhat.com At: 05/12/20 16:19:31To:  Bin Li (BLOOMBERG/ 120 PARK ) 
Cc:  pulp-list at 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 at redhat.com
https://www.redhat.com/mailman/listinfo/pulp-list

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/pulp-list/attachments/20200513/fc25e2ab/attachment.htm>