912239 - https://marketplace.allizom.org/comm/ returns a 500

Status: VERIFIED FIXED

(Marketplace Graveyard :: Developer Pages, defect, P1)

Description

[krupa raj[:krupa]]

steps to reproduce:
1. Loading https://marketplace.allizom.org/comm/ returns a 500

sentry: http://sentry.dmz.phx1.mozilla.com/addons/marketplace-stage/group/16696/

traceback:


EmptyResultSet

Stacktrace (most recent call last):

  File "django/core/handlers/base.py", line 111, in get_response
    response = callback(request, *callback_args, **callback_kwargs)
  File "newrelic/api/object_wrapper.py", line 216, in __call__
    self._nr_instance, args, kwargs)
  File "newrelic/hooks/framework_django.py", line 475, in wrapper
    return wrapped(*args, **kwargs)
  File "rest_framework/viewsets.py", line 78, in view
    return self.dispatch(request, *args, **kwargs)
  File "django/views/decorators/csrf.py", line 77, in wrapped_view
    return view_func(*args, **kwargs)
  File "rest_framework/views.py", line 399, in dispatch
    response = self.handle_exception(exc)
  File "rest_framework/views.py", line 396, in dispatch
    response = handler(request, *args, **kwargs)
  File "mkt/comm/api.py", line 239, in list
    return ListModelMixin.list(self, request)
  File "rest_framework/mixins.py", line 90, in list
    page = self.paginate_queryset(self.object_list)
  File "rest_framework/generics.py", line 157, in paginate_queryset
    page = paginator.page(page_number)
  File "django/core/paginator.py", line 37, in page
    number = self.validate_number(number)
  File "django/core/paginator.py", line 28, in validate_number
    if number > self.num_pages:
  File "django/core/paginator.py", line 60, in _get_num_pages
    if self.count == 0 and not self.allow_empty_first_page:
  File "django/core/paginator.py", line 48, in _get_count
    self._count = self.object_list.count()
  File "caching/base.py", line 193, in count
    query_string = 'count:%s' % self.query_key()
  File "caching/base.py", line 129, in query_key
    sql, params = self.query.get_compiler(using=self.db).as_sql()
  File "django/db/models/sql/compiler.py", line 82, in as_sql
    where, w_params = self.query.where.as_sql(qn=qn, connection=self.connection)
  File "django/db/models/sql/where.py", line 91, in as_sql
    sql, params = child.as_sql(qn=qn, connection=connection)
  File "django/db/models/sql/where.py", line 119, in as_sql
    raise EmptyResultSet

Comment 1

[Kevin Ngo [:ngoke]]

https://github.com/mozilla/zamboni/pull/1092

Comment 2

[Victor Carciu]

Verified as fixed. The 500 is not returned anymore : http://screencast.com/t/NqydBmiCgAiu