962056 - [dev] Internal server error returned when selecting "Crashes per User" report for any product

Status: RESOLVED WONTFIX

(Socorro :: General, task)

Description

[Robert Chira [:RobertC]]

Steps:

1. Got to https://crash-stats-dev.allizom.org
2. Select "Crashes per User" in the report drop-down

Expected result:
Page loads without any issues:

Actual result:
Internal Server Error is returned.
link: https://crash-stats-dev.allizom.org/daily?p=Firefox

Note: This issue happens for any product selected.

Comment 1

[Stephen Donner [:stephend] Not actively reading bugmail]

https://errormill.mozilla.org/webtools/socorro-dev/group/163749/

BadStatusCodeError: 500: on: http://socorro-api-dev-internal/bpapi//crashes/daily/product/Firefox/versions/29.0a1%2B28.0a2%2B27.0b%2B26.0/from_date/2014-01-07/to_date/2014-01-21/os/Windows%2BMac%20OS%20X%2BLinux/

Stacktrace (most recent call last):

  File "django/core/handlers/base.py", line 111, in get_response
    response = callback(request, *callback_args, **callback_kwargs)
  File "crashstats/crashstats/decorators.py", line 48, in inner
    return view(request, *args, **kwargs)
  File "crashstats/crashstats/views.py", line 631, in daily
    report_type=hang_type
  File "crashstats/crashstats/models.py", line 596, in get
    return super(CrashesPerAdu, self).get(**kwargs)
  File "crashstats/crashstats/models.py", line 274, in get
    expect_json=expect_json)
  File "crashstats/crashstats/models.py", line 175, in fetch
    raise BadStatusCodeError('%s: on: %s' % (resp.status_code, url))

Comment 2

[Stephen Donner [:stephend] Not actively reading bugmail]

Selena, Rob, do you know what's going on, here?

Comment 3

[Robert Helmer [:rhelmer]]

Relation missing on devdb:

https://errormill.mozilla.org/webtools/socorro-dev/group/60034/
DatabaseError: Failed to retrieve daily crashes data from PostgreSQL - relation "crashes_by_user_view" does not exist
LINE 1: ..., MAX(adu) as adu, AVG(throttle) as throttle FROM crashes_by...
                                                             ^

Comment 4

[Will Kahn-Greene [:willkg] ET needinfo? me]

Amongst other things, we no longer have a -dev server infrastructure. Closing as WONTFIX.