832362 - Provide some way to get topcrash lists per single B2G_OS_Version

Status: RESOLVED FIXED

(Socorro :: General, task, P1)

Description

[Robert Kaiser]

In the longer run, we'll need some way to display a topcrash list for a single B2G_OS_Version, possibly even a single release-* channel at the same time (see also bug 703018).

This probably can be provided via a search, i.e. it doesn't need a matview aggregation (as long we don't have huge amounts of data), this can be generated on a by-need basis. (As a side note, I think a number of topcrash-style reports could actually go that route.)

Comment 1

[Laura Thomson :laura]

Adrian: can we do this via ES?

Comment 2

[[DEACTIVATED] Adrian Gaudebert]

The problem is doing topcrashes (see bug 703018), if we can then doing it for each OS version of B2G is a less complicated problem.

Comment 3

[[DEACTIVATED] Adrian Gaudebert]

I'm not sure what a B2G_OS_Version is, KaiRo could you please explain? In what form is that data stored in our databases? 

It sounds like adding a way to filter by release channel in search would solve the other part of this job, if so that sounds reasonable to do. I'd rather focus on the new search UI, but I will need to do the middleware work on release channels anyway, and hacking the UI to support release channels doesn't sound complex. 

Definitely won't be in this week's release though.

Comment 4

[Robert Helmer [:rhelmer]]

(In reply to Adrian Gaudebert [:adrian] from comment #3)
> I'm not sure what a B2G_OS_Version is, KaiRo could you please explain? In
> what form is that data stored in our databases? 
> 
> It sounds like adding a way to filter by release channel in search would
> solve the other part of this job, if so that sounds reasonable to do. I'd
> rather focus on the new search UI, but I will need to do the middleware work
> on release channels anyway, and hacking the UI to support release channels
> doesn't sound complex. 
> 
> Definitely won't be in this week's release though.

B2G_OS_Versions is only in the raw JSON right now AFAIK (we recently started exposing it on the /report/index page)

Comment 5

[Robert Kaiser]

As Rob says, it's a custom field in the raw JSON.

Comment 6

[[DEACTIVATED] Adrian Gaudebert]

If it's not in Postgres, it's not possible to use it in search sadly. I can do the release_channel part now, and keep the OS version for when we switch to elasticsearch and the new search UI?

Btw we will need that data to be either in the reports table and/or in the processed JSON to be able to use it in search. Any plan to do that?

Comment 7

[Robert Kaiser]

(In reply to Adrian Gaudebert [:adrian] from comment #6)
> If it's not in Postgres, it's not possible to use it in search sadly. I can
> do the release_channel part now, and keep the OS version for when we switch
> to elasticsearch and the new search UI?
> 
> Btw we will need that data to be either in the reports table and/or in the
> processed JSON to be able to use it in search. Any plan to do that?

We'll need to do whatever you need for getting this into search, either in here or in a dependency. Having this bug solved is a requirement for us around the shipping time of FxOS, so we'll need to see that we do whatever it takes to get it done on some way.

Comment 8

[Robert Helmer [:rhelmer]]

Does bug 847939 make this doable now?

Comment 9

[Robert Kaiser]

(In reply to Robert Helmer [:rhelmer] from comment #8)
> Does bug 847939 make this doable now?

Would be great if we could search in those, as with a more flexible future search implementation we'd hope we can query all kinds of additional annotations. :)

Comment 10

[[DEACTIVATED] Adrian Gaudebert]

The part about release channels is done, moving this to future as it depends on the new search UI.

Comment 11

[Robert Kaiser]

Bug 928051 will probably solve the core issue of this bug in a different way (by elevating the B2G_OS_Version to the main version in B2G).

Comment 12

[[DEACTIVATED] Adrian Gaudebert]

This is now possible with Super Search: https://crash-stats.mozilla.com/search/?product=B2G&b2g_os_version=1.0.1.0