617421 - Please run a custom query: signatures of hang-pairs matching UpdateWindow

Status: RESOLVED FIXED

(Socorro :: General, task)

Description

[Benjamin Smedberg]

In bug 564298, there's a common hang-signature which defies easy categorization. In order to get more information, I need to get a report of the mplugin reports which match the hangs. The following is pseudocode for the query I want: I'm not familiar with the current Socorro DB schema, so I don't know exactly how you'd construct queries for this:

* Take the set of reports matching something like the following URL:
http://crash-stats.mozilla.com/report/list?product=Firefox&branch=2.0&query_search=signature&query_type=exact&query=hang%20|%20mozilla%3A%3Aplugins%3A%3APPluginInstanceParent%3A%3ACallUpdateWindow%28%29&date=12%2F07%2F2010%2012%3A40%3A17&range_value=1&range_unit=weeks&hang_type=any&process_type=any&plugin_field=&plugin_query_type=&plugin_query=&do_query=1&admin=&signature=hang%20|%20mozilla%3A%3Aplugins%3A%3APPluginInstanceParent%3A%3ACallUpdateWindow%28%29
** Firefox, signature is exactly "hang | mozilla::plugins::PPluginInstanceParent::CallUpdateWindow()" branch is 2.0, in the past week

For each of these reports, find the matching hang report. e.g. for http://crash-stats.mozilla.com/report/index/c29c12f6-018e-443e-a613-87e592101206 you'd look up http://crash-stats.mozilla.com/report/index/7d923b57-566d-47da-bd2d-bd5e12101206

Include the following information in some tabular report format:
* the ID of the UpateWindow report
* the ID of the plugin report
* the signature of the plugin crash
* The plugin filename of the plugin report

Comment 1

[Benjamin Smedberg]

ping! I need this soon please.

Comment 2

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

Attachment: output of query

select 
  r1.uuid as process_ooid,
  r2.uuid as plugin_crash_ooid,
  r2.signature as plugin_crash_signature,
  p.filename as plugin_file_name
from 
  reports_20101213 r1 join branches b on r1.product = b.product
                                         and r1.version = b.version
                                         and r1.product = 'Firefox'
                                         and r1.process_type is NULL
                                         and b.branch = '2.0'
    join reports_20101213 r2 on r1.hangid = r2.hangid
                                and r2.process_type = 'plugin'
      join plugins_reports pr on r2.id = pr.report_id
        join plugins p on pr.plugin_id = p.id
where 
  r1.signature = 'hang | mozilla::plugins::PPluginInstanceParent::CallUpdateWindow()'
;

Comment 3

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

the selected date range was for the week of December 13, 2010.  If you want more recent data, I'll have to get my devdb updated to a more recent snapshot.

Comment 4

[Benjamin Smedberg]

Thanks. This is good for now, I'll reopen if I need more recent data from b8.