Verify missing GUID in Database

VERIFIED FIXED

Status

mozilla.org Graveyard
Server Operations
VERIFIED FIXED
10 years ago
3 years ago

People

(Reporter: abillings, Unassigned)

Tracking

Details

(URL)

(Reporter)

Description

10 years ago
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?
Lars: Can you provide some SQL here?
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)
Status: NEW → RESOLVED
Last Resolved: 10 years ago
Resolution: --- → FIXED
Al actually meant the GUID (the user ID) not the ID of the crash report.
Status: RESOLVED → REOPENED
Resolution: FIXED → ---
Summary: Verify missing UUID in Database → Verify missing GUID in Database
breakpad=# select uuid,user_id from reports where uuid = '9659a7cb-f5ce-4470-acf2-098b02090116';
                 uuid                 | user_id 
--------------------------------------+---------
 9659a7cb-f5ce-4470-acf2-098b02090116 | 
(1 row)
Status: REOPENED → RESOLVED
Last Resolved: 10 years ago10 years ago
Resolution: --- → FIXED
(Reporter)

Comment 5

10 years ago
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?
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.
(Reporter)

Updated

10 years ago
Status: RESOLVED → VERIFIED
Blocks: 444351
Product: mozilla.org → mozilla.org Graveyard
You need to log in before you can comment on or make changes to this bug.