730965 - Get data for bug 711656

Status: RESOLVED FIXED

(Socorro :: Data request, task)

Description

[[:Cww]]

We're going to need to send emails to all users with crashes listed in bug 711656:

That is the following signatures:

[@ __entry_from_strcat_in_strcpy]
[@ memcpy | TextStageManager::AddStagesForSubrect(IDWritePrivateGlyphRunAnalysis*, SubRectInfo const*)]
[@ memset | TextStageManager::AddStagesForSubrect(IDWritePrivateGlyphRunAnalysis*, SubRectInfo const*)]
[@ _VEC_memzero]
[@ _VEC_memzero | TextStageManager::MapTextureTransferSurface(D2D_RECT_U const&, unsigned char**, unsigned int*)]
[@ msvcrt.dll@0x9cc6]

I'd like to get a CSV with email,uuid,signature for everyone with one of these crashes in the past week.

Thanks!

Comment 1

[Joe Drew (not getting mail)]

We're only interested in crashes on Windows, so we're clear. (There aren't many/any on non-Windows, so it's not that important anyways, but better to not waste anyone's time.)

Comment 2

[Robert Helmer [:rhelmer]]

Emailed to cww.
Query used:

COPY (
  SELECT email,uuid,signature 
  FROM reports 
  WHERE date_processed >= '2012-02-20' 
  AND os_name = 'Windows NT' 
  AND email != '' 
  AND signature IN 
    ('__entry_from_strcat_in_strcpy', 
     'memcpy | TextStageManager::AddStagesForSubrect(IDWritePrivateGlyphRunAnalysis*, SubRectInfo const*)',
     'memset | TextStageManager::AddStagesForSubrect(IDWritePrivateGlyphRunAnalysis*, SubRectInfo const*)', 
    '_VEC_memzero', '_VEC_memzero | TextStageManager::MapTextureTransferSurface(D2D_RECT_U const&, unsigned char**, unsigned int*)', 
    'msvcrt.dll@0x9cc6')
    ) TO STDOUT WITH CSV HEADER