duplicate lab/user entry when setting lab/group associations on oauth login
Tried digging into this one but nothing seemed to stand out as possible cause.
Lab 27 is iric-bioinformatique and the bit of code itself is the part where we wipe iric-* memberships and readd them with .add(*groups) call.
Contemplated groups having dups but tested add() with dups and end result doesnt seem duplicated / no errors.
Naive solution would be to iterate through list and add one by one with try/catch block.
Internal Server Error: /secure/login-success/
IntegrityError at /secure/login-success/
duplicate key value violates unique constraint "portal_profile_labs_profile_id_lab_id_81a897dd_uniq"
DETAIL: Key (profile_id, lab_id)=(11, 27) already exists.
Request Method: GET
Request URL: https://thepond.bioinfo.iric.ca/secure/login-success/
Django Version: 2.0.13
Python Executable: /usr/bin/python3
Python Version: 3.6.8
Python Path: ['/opt/apps/iric-data', '/opt/apps/iric-data/.venv/lib64/python3.6/site-packages', '/usr/lib64/python36.zip', '/usr/lib64/python3.6', '/usr/lib64/python3.6/lib-dynload', '/u/adsoft/.local/lib/python3.6/site-packages', '/usr/lib64/python3.6/site-packages', '/usr/lib/python3.6/site-packages']
Server time: mar, 2 Fév 2021 08:44:13 -0500
Installed Applications:
['django.contrib.admin',
'django.contrib.auth',
'django.contrib.contenttypes',
'django.contrib.sessions',
'django.contrib.messages',
'django.contrib.staticfiles',
'django.contrib.postgres',
'social_django',
'crispy_forms',
'chartjs',
'private_storage',
'loginas',
'portal']
Installed Middleware:
['django.middleware.security.SecurityMiddleware',
'django.contrib.sessions.middleware.SessionMiddleware',
'django.middleware.locale.LocaleMiddleware',
'django.middleware.common.CommonMiddleware',
'django.middleware.csrf.CsrfViewMiddleware',
'django.contrib.auth.middleware.AuthenticationMiddleware',
'django.contrib.messages.middleware.MessageMiddleware',
'django.middleware.clickjacking.XFrameOptionsMiddleware',
'social_django.middleware.SocialAuthExceptionMiddleware']
Traceback:
File "/opt/apps/iric-data/.venv/lib64/python3.6/site-packages/django/db/backends/utils.py" in _execute
85. return self.cursor.execute(sql, params)
The above exception (duplicate key value violates unique constraint "portal_profile_labs_profile_id_lab_id_81a897dd_uniq"
DETAIL: Key (profile_id, lab_id)=(11, 27) already exists.
) was the direct cause of the following exception:
File "/opt/apps/iric-data/.venv/lib64/python3.6/site-packages/django/core/handlers/exception.py" in inner
35. response = get_response(request)
File "/opt/apps/iric-data/.venv/lib64/python3.6/site-packages/django/core/handlers/base.py" in _get_response
128. response = self.process_exception_by_middleware(e, request)
File "/opt/apps/iric-data/.venv/lib64/python3.6/site-packages/django/core/handlers/base.py" in _get_response
126. response = wrapped_callback(request, *callback_args, **callback_kwargs)
File "/opt/apps/iric-data/.venv/lib64/python3.6/site-packages/django/views/generic/base.py" in view
69. return self.dispatch(request, *args, **kwargs)
File "/opt/apps/iric-data/.venv/lib64/python3.6/site-packages/django/views/generic/base.py" in dispatch
89. return handler(request, *args, **kwargs)
File "/opt/apps/iric-data/portal/views/secure/login_success.py" in get
34. user.profile.labs.add(*Lab.objects.filter(ldap__in=azuread_groups))
File "/opt/apps/iric-data/.venv/lib64/python3.6/site-packages/django/db/models/fields/related_descriptors.py" in add
898. self._add_items(self.source_field_name, self.target_field_name, *objs)
File "/opt/apps/iric-data/.venv/lib64/python3.6/site-packages/django/db/models/fields/related_descriptors.py" in _add_items
1065. for obj_id in new_ids
File "/opt/apps/iric-data/.venv/lib64/python3.6/site-packages/django/db/models/query.py" in bulk_create
466. ids = self._batched_insert(objs_without_pk, fields, batch_size)
File "/opt/apps/iric-data/.venv/lib64/python3.6/site-packages/django/db/models/query.py" in _batched_insert
1145. inserted_id = self._insert(item, fields=fields, using=self.db, return_id=True)
File "/opt/apps/iric-data/.venv/lib64/python3.6/site-packages/django/db/models/query.py" in _insert
1128. return query.get_compiler(using=using).execute_sql(return_id)
File "/opt/apps/iric-data/.venv/lib64/python3.6/site-packages/django/db/models/sql/compiler.py" in execute_sql
1285. cursor.execute(sql, params)
File "/opt/apps/iric-data/.venv/lib64/python3.6/site-packages/django/db/backends/utils.py" in execute
68. return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
File "/opt/apps/iric-data/.venv/lib64/python3.6/site-packages/django/db/backends/utils.py" in _execute_with_wrappers
77. return executor(sql, params, many, context)
File "/opt/apps/iric-data/.venv/lib64/python3.6/site-packages/django/db/backends/utils.py" in _execute
85. return self.cursor.execute(sql, params)
File "/opt/apps/iric-data/.venv/lib64/python3.6/site-packages/django/db/utils.py" in __exit__
89. raise dj_exc_value.with_traceback(traceback) from exc_value
File "/opt/apps/iric-data/.venv/lib64/python3.6/site-packages/django/db/backends/utils.py" in _execute
85. return self.cursor.execute(sql, params)
Exception Type: IntegrityError at /secure/login-success/
Exception Value: duplicate key value violates unique constraint "portal_profile_labs_profile_id_lab_id_81a897dd_uniq"
DETAIL: Key (profile_id, lab_id)=(11, 27) already exists.
Request information:
USER: xiao.ju@umontreal.ca
GET: No GET data
POST: No POST data
FILES: No FILES data
Edited by Jonathan Séguin