Skip to content

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