753692 - Long-running query times out after 30 seconds, and throws a 500 Internal Server Error

Status: VERIFIED FIXED

(Socorro :: Webapp, task, P5)

Description

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

Attachment: Screenshot

https://crash-stats.mozilla.com/query/query?product=Firefox&version=ALL%3AALL&range_value=3&range_unit=weeks&date=05%2F10%2F2012+09%3A34%3A59&query_search=signature&query_type=contains&query=&reason=&build_id=&process_type=any&hang_type=any&do_query=1 throws a 500, and takes the default 30 seconds-timeout to do so.

Comment 1

[Robert Kaiser]

I think that's well-known and only thought to go away with ElasticSearch.

Comment 2

[[DEACTIVATED] Adrian Gaudebert]

Stephen, did you get to that page from the search UI? The "ALL%3AALL" in the version parameter seems weird, and that may be causing the problem. I'll verify if there's a bug when I have a working env.

Comment 3

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

(In reply to Adrian Gaudebert [:adrian] from comment #2)
> Stephen, did you get to that page from the search UI? The "ALL%3AALL" in the
> version parameter seems weird, and that may be causing the problem. I'll
> verify if there's a bug when I have a working env.

Can't remember if I got it from our test, or from espressive, sorry!

Comment 6

[[DEACTIVATED] Adrian Gaudebert]

This was resolved when we switched to elasticsearch.

Comment 7

[Matt Brandt [:mbrandt]]

QA verified on stage and prod - yay for ElasticSearch!