684109 - [adbe] query returns blank page...

Status: VERIFIED FIXED

(Socorro :: General, task)

Description

[smadayag]

i'm attempting to run a query to report all plugin/hangs in all betas/release firefox builds.  every time i run it, i receive a blank page.  here is an example query:

https://crash-stats.mozilla.com/query/query?product=Firefox&version=Firefox%3A7.0%28beta%29&version=Firefox%3A7.0b4&version=Firefox%3A7.0b3&version=Firefox%3A7.0b2&version=Firefox%3A7.0b1&version=Firefox%3A6.0%28beta%29&version=Firefox%3A6.0b5&version=Firefox%3A6.0b4&version=Firefox%3A6.0b3&version=Firefox%3A6.0b2&version=Firefox%3A6.0b1&version=Firefox%3A6.0.2%28beta%29&version=Firefox%3A6.0.2&version=Firefox%3A6.0.1%28beta%29&version=Firefox%3A6.0.1&version=Firefox%3A6.0&version=Firefox%3A5.0.1%28beta%29&version=Firefox%3A5.0.1&version=Firefox%3A5.0&version=Firefox%3A4.0.1&version=Firefox%3A3.6.3&version=Firefox%3A3.6.22&version=Firefox%3A3.6.21&version=Firefox%3A3.6.20&version=Firefox%3A3.6.19&version=Firefox%3A3.6.18&version=Firefox%3A3.6&version=Firefox%3A3.5.13&platform=windows&range_value=1&range_unit=weeks&date=09%2F01%2F2011&query_search=signature&query_type=contains&query=&reason=&build_id=&process_type=plugin&hang_type=any&plugin_field=filename&plugin_query_type=exact&plugin_query=&do_query=1

Comment 1

[Robert Helmer [:rhelmer]]

This is going to be a massive query and the PHP execution timeout is going to kill it.

Can you tell me more about what you're looking for? I can run the SQL query and send you the output, or perhaps you could use our CSV drops in crash-analysis.mozilla.com/crash_analysis/ ?

Comment 2

[smadayag]

i'm looking for the output of the top 100 plugin issues (betas and release), including totals, for the following dates 8/1, 8/15 and 9/1.  these queries ran well before.  thanks...

Comment 3

[[DEACTIVATED] Adrian Gaudebert]

This should work now that we use elasticsearch as a back-end for search.

Comment 4

[Matt Brandt [:mbrandt]]

QA verified on prod - :smadayag thank you for reporting! ES ftw. 

Complex queries that return massive data sets no longer timeout - bumping to verified