2418: MultipleObjectsReturned: get() returned more than one LocalSiteProfile

pre***@apige***** (Google Code) (Is this you? Claim this profile.)
Feb. 8, 2012
What version are you running?
1.6.3

What's the URL of the page containing the problem?
http://codereviews/dashboard/

What steps will reproduce the problem?
1.http://codereviews/dashboard/ shows Something broke! (Error 500)
2.This happens only for few users
3.Authentication method used is NIS

What is the expected output? What do you see instead?
Expected to display dashboard page

What operating system are you using? What browser?
Mac LionOS

Please provide any additional information below.
MultipleObjectsReturned: get() returned more than one LocalSiteProfile -- it returned 2! Lookup parameters were {'profile': <Profile: srinathc>, 'user': <User: srinathc>, 'local_site': None}
438 2011-12-12 09:58:33,850 - ERROR - Internal Server Error: /dashboard/
439 Traceback (most recent call last):
440   File "/usr/local/lib/python2.6/dist-packages/Django-1.3.1-py2.6.egg/django/core/handlers/base.py", line 111, in get_response
441     response = callback(request, *callback_args, **callback_kwargs)
442   File "/usr/local/lib/python2.6/dist-packages/Djblets-0.6.14-py2.6.egg/djblets/auth/util.py", line 46, in _checklogin
443     return view_func(request, *args, **kwargs)
444   File "/usr/local/lib/python2.6/dist-packages/ReviewBoard-1.6.3-py2.6.egg/reviewboard/accounts/decorators.py", line 41, in _check_valid_prefs
445     return view_func(request, *args, **kwargs)
446   File "/usr/local/lib/python2.6/dist-packages/ReviewBoard-1.6.3-py2.6.egg/reviewboard/reviews/views.py", line 587, in dashboard
447     return grid.render_to_response(template_name)
448   File "/usr/local/lib/python2.6/dist-packages/Djblets-0.6.14-py2.6.egg/djblets/datagrid/grids.py", line 710, in render_to_response
449     self.load_state()
450   File "/usr/local/lib/python2.6/dist-packages/Djblets-0.6.14-py2.6.egg/djblets/datagrid/grids.py", line 523, in load_state
451     if self.load_extra_state(profile):
452   File "/usr/local/lib/python2.6/dist-packages/ReviewBoard-1.6.3-py2.6.egg/reviewboard/reviews/datagrids.py", line 579, in load_extra_state
453     self.counts = get_sidebar_counts(user, self.local_site)
454   File "/usr/local/lib/python2.6/dist-packages/ReviewBoard-1.6.3-py2.6.egg/reviewboard/reviews/datagrids.py", line 680, in get_sidebar_counts
455     profile=profile)
456   File "/usr/local/lib/python2.6/dist-packages/Django-1.3.1-py2.6.egg/django/db/models/fields/related.py", line 444, in get_or_create
457     return super(RelatedManager, self.db_manager(db)).get_or_create(**kwargs)
458   File "/usr/local/lib/python2.6/dist-packages/Django-1.3.1-py2.6.egg/django/db/models/manager.py", line 135, in get_or_create
459     return self.get_query_set().get_or_create(**kwargs)
460   File "/usr/local/lib/python2.6/dist-packages/Django-1.3.1-py2.6.egg/django/db/models/query.py", line 378, in get_or_create
461     return self.get(**lookup), False
462   File "/usr/local/lib/python2.6/dist-packages/Django-1.3.1-py2.6.egg/django/db/models/query.py", line 351, in get
463     % (self.model._meta.object_name, num, kwargs))
#1 pre***@apige***** (Google Code) (Is this you? Claim this profile.)
This issued started showing up after upgrading ReviewBoard to 1.6.3(from 1.5.4)
david
#2 david
Can you delete the offending objects using the admin UI and see if that resolves the issue? We had a few bugs in this code.
  • +NeedInfo
david
#3 david
  • -NeedInfo
    +Incomplete