MultipleObjectsReturned: get() returned more than one EmailAddress -- it returned 2!
Hi,
We've encountered the error in Postorius on logging in:
ERROR 2021-09-13 10:06:22,915 1782 django.request Internal Server Error: /accounts/login/
Traceback (most recent call last):
File "/usr/lib/python3.8/site-packages/django/core/handlers/exception.py", line 47, in inner
response = get_response(request)
File "/usr/lib/python3.8/site-packages/django/core/handlers/base.py", line 181, in _get_response
response = wrapped_callback(request, *callback_args, **callback_kwargs)
File "/usr/lib/python3.8/site-packages/django/views/generic/base.py", line 70, in view
return self.dispatch(request, *args, **kwargs)
File "/usr/lib/python3.8/site-packages/django/utils/decorators.py", line 43, in _wrapper
return bound_method(*args, **kwargs)
File "/usr/lib/python3.8/site-packages/django/views/decorators/debug.py", line 89, in sensitive_post_parameters_wrapper
return view(request, *args, **kwargs)
File "/usr/lib/python3.8/site-packages/allauth/account/views.py", line 146, in dispatch
return super(LoginView, self).dispatch(request, *args, **kwargs)
File "/usr/lib/python3.8/site-packages/allauth/account/views.py", line 74, in dispatch
response = super(RedirectAuthenticatedUserMixin, self).dispatch(
File "/usr/lib/python3.8/site-packages/django/views/generic/base.py", line 98, in dispatch
return handler(request, *args, **kwargs)
File "/usr/lib/python3.8/site-packages/allauth/account/views.py", line 102, in post
response = self.form_valid(form)
File "/usr/lib/python3.8/site-packages/allauth/account/views.py", line 159, in form_valid
return form.login(self.request, redirect_url=success_url)
File "/usr/lib/python3.8/site-packages/allauth/account/forms.py", line 195, in login
ret = perform_login(
File "/usr/lib/python3.8/site-packages/allauth/account/utils.py", line 174, in perform_login
if not _has_verified_for_login(user, email):
File "/usr/lib/python3.8/site-packages/allauth/account/utils.py", line 134, in _has_verified_for_login
emailaddress = EmailAddress.objects.get_for_user(user, email)
File "/usr/lib/python3.8/site-packages/allauth/account/managers.py", line 54, in get_for_user
ret = self.get(user=user, email__iexact=email)
File "/usr/lib/python3.8/site-packages/django/db/models/manager.py", line 85, in manager_method
return getattr(self.get_queryset(), name)(*args, **kwargs)
File "/usr/lib/python3.8/site-packages/django/db/models/query.py", line 433, in get
raise self.model.MultipleObjectsReturned(
allauth.account.models.EmailAddress.MultipleObjectsReturned: get() returned more than one EmailAddress -- it returned 2!
It might be similar to the TooManyMembersError and we'd like to understand how to identify the corrupted user and fix the inconsistency.
Thanks