475015 - Would like to get a list of urls that a crash happens at

Status: RESOLVED FIXED

(mozilla.org Graveyard :: Server Operations, task)

Description

[Boris Zbarsky [:bzbarsky]]

We now appararently have breakpad data for a random crash we've been trying to hunt down on tinderbox.  See http://crash-stats.mozilla.com/report/list?product=Firefox&branch=1.9.2&version=Firefox%3A3.2a1pre&query_search=signature&query_type=contains&query=&date=&range_value=7&range_unit=days&do_query=1&signature=nsCSSFrameConstructor%3A%3AFindInputData%28nsIContent*%2C%20nsStyleContext*%29

Unfortunately, the web UI doesn't show the URIs involved. Would it be possible to get them all, so that I can try looping over them and seeing what happens?

If you can only get me a few URIs, I guess I'd like the ones for http://crash-stats.mozilla.com/report/index/39371ebc-e31c-47d5-9cb7-db0402090123 and http://crash-stats.mozilla.com/report/index/bf11c658-610d-43dd-b6e8-db79c2090122

Comment 1

[Aravind Gottipati [:aravind]]

Adding lars for the magic queries.

Comment 2

[Aravind Gottipati [:aravind]]

For those last two, I have them.  For a more general list of urls matching stuff in that first link, I will need Lar's help.

breakpad=# select uuid,url from reports where uuid = '39371ebc-e31c-47d5-9cb7-db0402090123';
                 uuid                 |                    url                     
--------------------------------------+--------------------------------------------
 39371ebc-e31c-47d5-9cb7-db0402090123 | https://developer.mozilla.org/En/Mercurial
(1 row)

breakpad=# select uuid,url from reports where uuid = 'bf11c658-610d-43dd-b6e8-db79c2090122';
                 uuid                 | url 
--------------------------------------+-----
 bf11c658-610d-43dd-b6e8-db79c2090122 | 
(1 row)

Comment 3

[K Lars Lohn [:lars] [:klohn]]

select 
  uuid, 
  url 
from 
  reports
where
  product = 'Firefox'
  and branch = '1.9.2'
  and version = '3.2a1pre'
  and signature = 'nsCSSFrameConstructor::FindInputData(nsIContent*, nsStyleContext*)'

There's a bit of oddity in the format of the data in the version part of the URL given in the description: 'Firefox:3.2a1pre'  I'm not sure if that's an artifact of the PHP Web App or what.  In my query, I've stripped off the prefix of 'Firefox:'.  If my query gives no results, try putting it back in.

Comment 4

[Aravind Gottipati [:aravind]]

Sent bz an e-mail with the urls.