424952 - Queries can be too slow for stack searches

Status: RESOLVED FIXED

(Socorro :: General, task)

Description

[Dave Townsend [:mossop]]

This seems to vary pretty wildly but mostly when I am searchng through the topcrashers, looking at particular stacks etc. it can take minutes for socorro to respond with results. I can literally go make a cup of tea while I am waiting for my data to arrive.

Comment 1

[(not currently active) Ted Mielczarek]

Dunno if this is a webapp issue or a server ops issue. I'm sure the webapp could use some work.

Comment 2

[Michael Morgan [:morgamic]]

We should take a look at top 10 crashes:
13:03 < bent> http://crash-stats.mozilla.com/?do_query=1&query_search=stack&query_type=contains&query=nsNavHistoryResult%3A%3AOnClearHistory&date=&range_value=1&range_unit=weeks
13:05 < bent> oh, actually, oops
13:05 < bent> http://crash-stats.mozilla.com/?do_query=1&query_search=stack&query_type=contains&query=nsNavHistoryResult%3A%3AOnClearHistory&date=&range_value=1&range_unit=months
13:05 < bent> the 1 week timed out for me a few times, but now seems to work
13:05 < bent> the 1 month keeps timing out
13:05 < bent> well, 'server reset connection'

Things to look at:
1) create another partition 
2) double check date constraints on parent reports table 
3) ensure that SA is using literal dates not computed dates for the query used for top-10-stack-frames

Comment 3

[Wayne Mery (:wsmwk)]

dupe?