745363 - Check for jump in unresolved stacks for nightlies between April 9 and 12

Status: RESOLVED FIXED

(Socorro :: Data request, task)

Description

[Nick Thomas [:nthomas] (UTC+12)]

The last steps in moving the symbol store for sjc1 to phx1 have potentially left us without the files to resolve stacks for nightlies between April 9 and 12. It might just be we're missing the txt files which list out the files for each nightly/release, but please check if we have a lot of crashes that we can't resolve since April 9.

Comment 1

[Robert Helmer [:rhelmer]]

It does not look like there is a significant change in the number of overall process failures for the equivalent days of the previous week:

breakpad=> select count(*) from reports where date_processed >= '2012-04-02' and date_processed <= '2012-04-05' and success is false and release_channel = 'nightly';
 count 
-------
   413
(1 row)

breakpad=> select count(*) from reports where date_processed >= '2012-04-09' and date_processed <= '2012-04-12' and success is false and release_channel = 'nightly';
 count 
-------
   377
(1 row)

Comment 2

[Robert Helmer [:rhelmer]]

Actually it looks like minidump_stackwalk doesn't return an error if there are no symbols - it just returns unresolved symbols.

Not sure of the best way to check for this, I tried it this way and see nothing significant as well:

breakpad=> select count(*) from reports where date_processed >= '2012-04-02' and date_processed <= '2012-04-05' and signature like '%dll@%' and release_channel = 'nightly' ;
 count 
-------
  1788
(1 row)

breakpad=> select count(*) from reports where date_processed >= '2012-04-09' and date_processed <= '2012-04-12' and signature like '%dll@%' and release_channel = 'nightly';
 count 
-------
  1466
(1 row)


Oh, and to make this meaningful, I should include the totals for the date ranges used:

breakpad=> select count(*) from reports where date_processed >= '2012-04-02' and date_processed <= '2012-04-05' and release_channel = 'nightly'; count 
-------
  9939
(1 row)

breakpad=> select count(*) from reports where date_processed >= '2012-04-09' and date_processed <= '2012-04-12' and release_channel = 'nightly';
 count 
-------
  6524
(1 row)

Comment 3

[Robert Helmer [:rhelmer]]

Just unresolved xul.dll, at nthomas' request:

breakpad=> select count(*) from reports where date_processed >= '2012-04-02' and date_processed <= '2012-04-05' and signature like '%xul.dll@%' and release_channel = 'nightly';
 count 
-------
   690
(1 row)

breakpad=> select count(*) from reports where date_processed >= '2012-04-09' and date_processed <= '2012-04-12' and signature like '%xul.dll@%' and release_channel = 'nightly';
 count 
-------
   601
(1 row)

Comment 4

[Nick Thomas [:nthomas] (UTC+12)]

Thanks Rob!