474084 - Verify missing GUID in Database

Status: VERIFIED FIXED

(mozilla.org Graveyard :: Server Operations, task)

Description

[Al Billings [:abillings - ex-MoCo]]

For the crash report 9659a7cb-f5ce-4470-acf2-098b02090116, I need to have it verified that a UUID was not submitted and preserved in the DB. See bug https://bugzilla.mozilla.org/show_bug.cgi?id=444351 for details.

Can someone please confirm that the UUID is not present?

Comment 1

[Samuel Sidler (old account; do not CC)]

Lars: Can you provide some SQL here?

Comment 2

[Aravind Gottipati [:aravind]]

Nope, its present..

breakpad=# select uuid,date_processed,product,version,build,signature from reports where uuid = '9659a7cb-f5ce-4470-acf2-098b02090116';
                 uuid                 |      date_processed       | product | version  |   build    |     signature      
--------------------------------------+---------------------------+---------+----------+------------+--------------------
 9659a7cb-f5ce-4470-acf2-098b02090116 | 2009-01-16 17:52:49.62101 | Firefox | 3.0.6pre | 2009011604 | nsCrasher::Crash()
(1 row)

Comment 3

[Samuel Sidler (old account; do not CC)]

Al actually meant the GUID (the user ID) not the ID of the crash report.

Comment 4

[Reed Loden [:reed]]

breakpad=# select uuid,user_id from reports where uuid = '9659a7cb-f5ce-4470-acf2-098b02090116';
                 uuid                 | user_id 
--------------------------------------+---------
 9659a7cb-f5ce-4470-acf2-098b02090116 | 
(1 row)

Comment 5

[Al Billings [:abillings - ex-MoCo]]

That's the crash ID as reported to me by the crash reporter. I believe that's what we changed things to, isn't it Sam?

Comment 6

[Samuel Sidler (old account; do not CC)]

Yeah, Reed posted the UUID (which is fine) and the "user_id", which is blank. We wanted to check and be sure the user_id field in the DB (sometimes called the GUID) is blank or null, which it is.