Error when trying to alias test without testcases

[Alan Bennett]

when trying to chart lava actions I hit an error trying to alias lava actions.

re: https://validation.linaro.org/dashboard/image-charts/linux-linaro-lsk

Resulting in an "error: Data could not be loaded, try again" when trying to set an alias.

LAVA Has emailed the DJANGO error report: 15 April 2014 15:13

 'PATH_INFO': u'/dashboard/image-charts/+get-chart-test',
 'REQUEST_URI': '/dashboard/image-charts/+get-chart-test?chart_filter_id=650&chart_test_id=1716',
 'SERVER_NAME': 'validation.linaro.org',

[Stevan Radaković (stevanr)]

Traceback:

ERROR:django.request:Internal Server Error: /dashboard/image-charts/+get-chart-test
Traceback (most recent call last):
  File "/srv/lava/.cache/eggs/Django-1.4.2-py2.7.egg/django/core/handlers/base.py", line 111, in get_response
    response = callback(request, *callback_args, **callback_kwargs)
  File "/srv/lava/.cache/eggs/Django-1.4.2-py2.7.egg/django/contrib/auth/decorators.py", line 20, in _wrapped_view
    return view_func(request, *args, **kwargs)
  File "/srv/lava/.cache/git-cache/exports/lava-server/2014.03-5-g7a2537b/dashboard_app/views/image_reports/views.py", line 446, in ge
t_chart_test_data
    data["all_attributes"] = chart_test.get_available_attributes()
  File "/srv/lava/.cache/git-cache/exports/lava-server/2014.03-5-g7a2537b/dashboard_app/models.py", line 2359, in get_available_attrib
utes
    attributes = [str(name) for name in result]
  File "/srv/lava/.cache/eggs/Django-1.4.2-py2.7.egg/django/db/models/query.py", line 118, in _result_iter
    self._fill_cache()
  File "/srv/lava/.cache/eggs/Django-1.4.2-py2.7.egg/django/db/models/query.py", line 892, in _fill_cache
    self._result_cache.append(self._iter.next())
  File "/srv/lava/.cache/eggs/Django-1.4.2-py2.7.egg/django/db/models/query.py", line 1078, in iterator
    for row in self.query.get_compiler(self.db).results_iter():
  File "/srv/lava/.cache/eggs/Django-1.4.2-py2.7.egg/django/db/models/sql/compiler.py", line 763, in results_iter
    for rows in self.execute_sql(MULTI):
  File "/srv/lava/.cache/eggs/Django-1.4.2-py2.7.egg/django/db/models/sql/compiler.py", line 818, in execute_sql
    cursor.execute(sql, params)
  File "/srv/lava/.cache/eggs/Django-1.4.2-py2.7.egg/django/db/backends/postgresql_psycopg2/base.py", line 52, in execute
    return self.cursor.execute(query, args)
DatabaseError: canceling statement due to statement timeout

[Stevan Radaković (stevanr)]

Patch: https://review.linaro.org/#/c/1655/

[Alan Bennett (akbennett)]

Confirmed in Staging

[Stevan Radaković (stevanr)]

Unfortunately this can be only reproduced on production due to the number of records.
The only way we're gonna find out if the fix optimizes the data fetching enough is when we deploy it on production.

[Alan Bennett (akbennett)]

After hotfixing in production there is no longer an error being thrown on the backend, however the page still fails to load.

"error: Data could not be loaded, try again"

As a side-anomaly: on Firefox, the screen goes gray and shows a horizontal progress bar. On Chrome neither of these behaviors occur.

GET https://validation.linaro.org/dashboard/image-charts/+get-chart-test?chart_filter_id=653&chart_test_id=1722 500 (INTERNAL SERVER ERROR)
jquery-1.5.1.min.js:16
send jquery-1.5.1.min.js:16
d.extend.ajax jquery-1.5.1.min.js:16
open_test_edit image-report-editor.js:250
onclick 653:360

[Stevan Radaković (stevanr)]

What do you mean by 'there's no error in the backend'? Did you have a chance to look in the logs?
I lost my validation.l.o access so I cannot check (https://pastebin.linaro.org/view/07c26725)

ps. still not sure how I missed the hotfix :(

[Stevan Radaković (stevanr)]

Second patch: https://review.linaro.org/1754