1957556 - Internal server error when sorting the `last_error_value` column

Status: NEW

(Socorro :: Webapp, defect, P3)

Description

[Gabriele Svelto [:gsvelto]]

Attachment: Screenshot 2025-04-01 at 09-19-00 mozilla Variant T as mozilla layers AnimatedValue SetOpacity - Signature report - Mozilla Crash Stats.png

STR:

1. I ran this query
2. Switched to the "Reports" tab
3. Added last_error_value to the list of fields and clicked "Update"
4. Tried to sort the last_error_value column by clicking on the column header

At this point I hit the internal server error, see the screenshot.

Comment 1

[Sven Marnach :sven]

Thanks for the report! I can't reproduce the error. Sorting by a column happens on the client side and doesn't cause any requests to the server when I try it, so I don't know what's causing the internal server error.

Shortly before you filed this bug, we received this traceback in Sentry which is potentially related:

KeyError: 'caused_by'
  File "elasticsearch_dsl/utils.py", line 205, in __getattr__
    return self.__getitem__(attr_name)
  File "elasticsearch_dsl/utils.py", line 220, in __getitem__
    return _wrap(self._d_[key])

AttributeError: 'AttrDict' object has no attribute 'caused_by'
  File "django/core/handlers/exception.py", line 55, in inner
    response = get_response(request)
  File "django/core/handlers/base.py", line 197, in _get_response
    response = wrapped_callback(request, *callback_args, **callback_kwargs)
  File "crashstats/crashstats/decorators.py", line 149, in inner
    response = view(request, *args, **kwargs)
  File "crashstats/signature/views.py", line 69, in inner
    return view(request, *args, **kwargs)
  File "crashstats/signature/views.py", line 211, in signature_reports
    search_results = api.get(**params)
  File "crashstats/supersearch/models.py", line 239, in get
    return super(SuperSearch, self).get(**kwargs)
  File "crashstats/crashstats/models.py", line 377, in get
    return self._get(expect_json=expect_json, **kwargs)
  File "crashstats/crashstats/models.py", line 430, in _get
    return self.fetch(
  File "crashstats/crashstats/models.py", line 318, in fetch
    result = implementation_method(**params)
  File "socorro/external/es/supersearch.py", line 500, in get
    and failure.reason.caused_by.type == "illegal_argument_exception"
  File "elasticsearch_dsl/utils.py", line 207, in __getattr__
    raise AttributeError(

Comment 2

[Gabriele Svelto [:gsvelto]]

It could be that this happens only if there are mutliple pages of crashes involved, I couldn't reproduce with one week work of crashes, but I do with 6 months. Try the STR in comment 0 but search for the past 6 months worth of crashes before attempting to sort the column.

Comment 3

[Sven Marnach :sven]

Thanks for the update – I can reproduce the error now, and I'll look into it.