589265 - Add fields for AdapterDeviceID and AdapterVendorID

Status: RESOLVED FIXED

(Socorro :: General, task)

Description

[Jeff Muizelaar [:jrmuizel]]

With bug 586048 we'll start sending AdapterDeviceID and AdapterVendorID annotations with our crash reports. We'll need to record these in the database. I don't think we need any UI for it now.

Comment 1

[Jeff Muizelaar [:jrmuizel]]

When can we expect to see these fields added?

Comment 2

[Jeff Muizelaar [:jrmuizel]]

Laura, any chance we can get an estimate on when we can get these fields?

Comment 3

[Laura Thomson :laura]

How urgently is this needed?

I ask because in Q4 we'll roll out full text search of dumps, so if we do something before that it will be temporary.  If it's urgent to have it sooner we can probably work it into our 1.8.1 or 1.9 releases.

Comment 4

[Jeff Muizelaar [:jrmuizel]]

Bengamin, 

Is it possible to get a report of the App Notes like you did for SSE2? If so, this isn't super urgent.

Comment 5

[Benjamin Smedberg]

It looks like I can, according to the schema: app_notes character varying(1024)

Although boy, that's shorter than I expected, I thought it would be type TEXT. I hope we don't end up with truncations as more people use that API.

Comment 6

[Benjamin Smedberg]

Yes, a query against the staging mirror turned up http://crash-stats.mozilla.com/report/index/21f36ae4-dcdd-45d5-95bf-c1f412100901

Comment 7

[(not currently active) Ted Mielczarek]

We shouldn't be using it on a permanent basis for things that need to be queryable anyway.

Comment 8

[Jeff Muizelaar [:jrmuizel]]

Benjamin,

This report would be very useful for trying to determine the correlation between crashes and particular devices. So it's higher priority than I originally thought.

Comment 9

[Jeff Muizelaar [:jrmuizel]]

Laura,

Benjamin tells me that he can't easily do this kind of report anymore so I'll redirect my request to you. Can I get a report that contains counts for all of the unique App Note strings from the last 3 weeks of crashes on the 2.0 branch. It would be nice to get this in the next few days if possible.

Comment 10

[Laura Thomson :laura]

This (comment 9) is a job for Metrics -> Anurag?

Comment 11

[Anurag Phadke[:[e-mail]]]

Jeff - I am almost done writing the code that shall give you counts based on "App Note" strings. Find counts specific to 2.0 branch is bit tricky, that data is a combination of Product & Version and needs to be mapped externally.

Ryan (from Socorro) team pointed me to a SQL query that will make this happen, however, according to him, the data might not be consistent.

Let me know if this is okay with you or feel free to suggest any other option....

-Anurag

Comment 12

[Ryan Snyder [:ryansnyder] [:rsnyder] [:rysny]]

The data on the Socorro side is managed in the admin panel at:
https://crash-stats.mozilla.com/admin/branch_data_sources

Like Anurag mentioned, the data is maintained regularly to ensure that correct products and versions are in there. But the correct branch associated with that product / version combination is not always correct from what I've seen.

Comment 13

[Anurag Phadke[:[e-mail]]]

Attachment: data for 2010-10-17 to 2010-10-18 attached. This does not filter on a specific branch.

Comment 14

[Anurag Phadke[:[e-mail]]]

Jeff - can you please reply to comment on #11/13?

Comment 15

[Jeff Muizelaar [:jrmuizel]]

(In reply to comment #14)
> Jeff - can you please reply to comment on #11/13?

Ah sorry. I didn't see this sooner. 

Being able to get reports for a product/version combination is probably sufficient.

Thanks for the current data.

Comment 16

[Anurag Phadke[:[e-mail]]]

Attachment: Counts by Product+Version for AdapterVendorID, AdapterDeviceID combo attached. Date range: 10/01 to 10/14