542296 - Performance report for editor loads a blank page

Status: RESOLVED WONTFIX

(addons.mozilla.org Graveyard :: Admin/Editor Tools, defect, P4)

Description

[krupa raj[:krupa]]

steps to reproduce:
1.Log into your admin account
2.Navigate to https://preview.addons.mozilla.org/en-US/editors/performance
3.Select any editor
4.view entries between 2009-01-01 and 2010-01-01
5.Click Filter

Expected result:
Appropriate entries are displayed OR the filter fails gracefully with some useful error message.

Actual result:
blank page loads

screencast:
http://screencast.com/t/ZDJhNDc0M

Comment 1

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

It's our old friend, 500 - Internal Server Error:

HTTP/1.x 500 Internal Server Error
Server: Apache
Cache-Control: no-cache
Content-Type: text/html; charset=UTF-8
P3P: CP="NOI ADM DEV PSAi COM NAV OUR OTRo STP IND DEM"
Date: Tue, 26 Jan 2010 19:31:05 GMT
X-AMO-ServedBy: pm-app-amo24.mozilla.org
Via: Moz-Cache-zlb01
Connection: close
X-Powered-By: PHP/5.2.9
Content-Length: 0

Comment 2

[Wil Clouser [:clouserw]]

Yeah, probably out of memory.  A year is a lot of data to load, but wouldn't hurt to double check the code for easy fixes.

Comment 3

[Wil Clouser [:clouserw]]

This is caused by the query on line 699 of the editors_controller.  That whole loop is really inefficient, but it's not something I want to dig into in remora.  CCing mccammos to make sure this doesn't repeat in [z].

In the mean time, don't try to do a year of data at a time.