Closed Bug 474084 Opened 11 years ago Closed 11 years ago

Verify missing GUID in Database

Categories

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

x86
macOS
task
Not set

Tracking

(Not tracked)

VERIFIED FIXED

People

(Reporter: abillings, Unassigned)

References

()

Details

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
Closed: 11 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
Closed: 11 years ago11 years ago
Resolution: --- → FIXED
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.
Status: RESOLVED → VERIFIED
Product: mozilla.org → mozilla.org Graveyard
You need to log in before you can comment on or make changes to this bug.